Chapter 8: Using Excel® to Make Decisions at Current Designs Part 1
Data
Budgeted cost data
Repair technician wages $30,000
Fringe benefits $10,000
Required
Follow the step-by-step directions to determine the price of a repair for Current Designs.
Part 1 Total Cost Total Hours
Per Hour
Charge
Repair technician wages $30,000 2,000 $15.00
Job: Composite kayak repair
Labor charges $135
Part 2
Selling price $285
Cost and profit components:
Labor wages cost 45
Labor wages
cost
materials
35%
Kayak Repair Job Components
Chapter 8: Using Excel® to Make Decisions at Current Designs Part 2
Data
Budgeted cost data
Repair technician wages $30,000
Fringe benefits $10,000
Required
Follow the step-by-step directions to determine the price of a repair for Current Designs.
Part 2 Total Cost Total Hours
Per Hour
Charge
Repair technician wages $30,000 2,000 $15
Job: Composite kayak repair
Labor charges $165
Materials charges
Part 2
Selling price $315
Cost and profit components:
Labor wages cost 45
Labor
wages
Fringe
benefits cost
Repair Job with $30 Profit Margin