[chaley92]

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]

Well, what have you come up with? We don't do the work for you but will help your work.

[chaley92]

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]

Layout looks like this:
http://www.docstoc.com/docs/526731/Flexible-Budget---Excel