ACC6010 WK6 Operating Budget Template_2106

Sheet 1: DMaterials

	Month #1	Month #2	Month #3	Month #4
Projected Sales $
Projected Quantity (Calculated)
Beginning FG Inventory Units
Desired FG Inventory Units
Items Produced
Material Quantity Needed (Total #)
Material Cost $

Sheet 2: DLabor

	Month #1	Month #2	Month #3	Month #4
Projected Sales $
Projected Quantity (Calculated)
Beginning FG Inventory Units
Desired FG Inventory Units
Items Produced
Direct Labor $

Sheet 3: Overhead

	Month #1	Month #2	Month #3	Month #4
Projected Sales $
Projected Quantity (Calculated)
Beginning FG Inventory Units
Desired FG Inventory Units
Items Produced
Variable Manufacturing Overhead
Supplies
Inspection
Maintenance & Repair
Utilities
Fixed Overhead

Sheet 4: S&A

	Month #1	Month #2	Month #3	Month #4
Projected Sales $
Projected Quantity (Calculated)
Beginning FG Inventory Units
Desired FG Inventory Units
Items Produced
Variable S & A
Commission
Delivery
Office Supplies
Fixed S & A

Sheet 5: Budgeted Income Statement

				Sum of Months 1-3
	Month #1	Month #2	Month #3	First Quarter
Sales
Material Cost
Direct Labor Cost
Gross Margin (Sales Less Costs)
Manufacturing Overhead
Supplies
Inspection
Maintenance & Repair
Utilities
Fixed Overhead
S & A
Commission
Delivery
Office Supplies
Fixed S & A
Total Overhead and S & A
Net Income