Excel Intermediate
Shavone05
ex_k-2.xlsxLawn Mower Repair
| Lawn Mower Repair Model | |
| Labor cost per hour | $85.00 |
| Parts cost per job | $70.00 |
| Hours per job | 2.00 |
| Cost to complete job: | $240.00 |
Vehicle Repair
| Rear Brake Pad Replacement Model | |||
| Van | Sedan | Compact | |
| Labor Cost Per Repair | $110.00 | $100.00 | $85.00 |
| Parts Cost Per Repair | $175.00 | $130.00 | $100.00 |
| Repairs Scheduled | 25 | 35 | 15 |
| Labor Cost Per Model | $2,750.00 | $3,500.00 | $1,275.00 |
| Parts Cost Per Model | $4,375.00 | $4,550.00 | $1,500.00 |
| Total Repair Cost Per Model | $7,125.00 | $8,050.00 | $2,775.00 |
| Total Labor Cost | $7,525.00 | ||
| Total Parts Cost | $10,425.00 | ||
| Total Repair Costs | $17,950.00 | ||
