Chapter 2: Using Excel to Make Decisions at Current Designs Part 1
Data
Resources required for each kayak
Polyethylene powder 54 pounds
Finishing kit 1 each
Required
Follow the instructions to enter a formula into each cell shaded in yellow below.
Cost for one kayak:
Direct materials
Cost for kayak order 8,320$
Polyethylene powder 81$
Finishing kit 170
Number of kayaks ordered 20
Chapter 2: Using Excel to Make Decisions at Current Designs Part 2a
Data
Number of kayaks ordered 25
Resources required for each kayak
Polyethylene powder 54 pounds
Finishing kit 1 each
Required
Follow the instructions to perform what-if analysis.
Cost for one kayak:
Direct materials
Cost for kayak order 10,400$
Polyethylene powder 81$
Finishing kit 170
Direct labor
Chapter 2: Using Excel to Make Decisions at Current Designs Part 2b
Data
Number of kayaks ordered 20
Resources required for each kayak
Polyethylene powder 54 pounds
Finishing kit 1 each
Required
Follow the instructions to perform what-if analysis.
Cost for one kayak:
Direct materials
Cost for kayak order 7,732$
Polyethylene powder 89$
Finishing kit 170
Direct labor
Type I 15
Type II 36
Manufacturing overhead 77