PDA

View Full Version : Cost accounting help! Preparing a flexible budget!


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.

ma0641
Jun 12, 2014, 04:44 PM
Well, what have you come up with? We don't do the work for you but will help your work.

chaley92
Jun 12, 2014, 04:46 PM
Finding the cost driver. I can do the calculatings just fine, I just don't know how the layout will look out, and which numbers to use to compute revenues

believemeu
Jun 12, 2014, 07:10 PM
Layout looks like this:
http://www.docstoc.com/docs/526731/Flexible-Budget---Excel