chaley92
Jun 12, 2014, 03:06 PM
I need help preparing a flexible budget with the info below:
Budget Actual (over) under Budget
Number of heavy storms 10 12
Cubic miles of sand restored 1,250 1,500
Drivers $18,000 $24,675
Supplies 1,125 1,875
Fuel 1,750 2,500
Maintenance 1,375 2,200
Supervisor salary 15,000 18,000
Allocated Admin. 4,000 5,000
Equipment Depreciation 1,250 1,250
Total $42,500 $55,500
Average driver rate $18 $21
Avg # min. to plow 1 cubic mile 48 47
Total minutes drivers plowed 70,500
(a) Drivers are hourly employees. They are paid time and a half for hours over 8 per day.
(b) Administrative costs are allocated for all general and administrative departments, such as legal, accounting, etc.
Budget Actual (over) under Budget
Number of heavy storms 10 12
Cubic miles of sand restored 1,250 1,500
Drivers $18,000 $24,675
Supplies 1,125 1,875
Fuel 1,750 2,500
Maintenance 1,375 2,200
Supervisor salary 15,000 18,000
Allocated Admin. 4,000 5,000
Equipment Depreciation 1,250 1,250
Total $42,500 $55,500
Average driver rate $18 $21
Avg # min. to plow 1 cubic mile 48 47
Total minutes drivers plowed 70,500
(a) Drivers are hourly employees. They are paid time and a half for hours over 8 per day.
(b) Administrative costs are allocated for all general and administrative departments, such as legal, accounting, etc.