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.

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

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

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