Excel 2010 Help 1) create sales budget 2) operating budget 3) production budget 4) material req budget 5) direct labor budget 6) manuf overhead budget 7) production per unit 8) projected income statement AB ales Projections In Units January February March April 20,609 26,521 27,815 49,644 47,350 Projected Sales Price/Unit $ 198.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs $5.00 $5,854 Production: 22.4% Desired Ending Inventory Beginning Inventory (new business) Materials 12.2% 14.0 Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) $16.00 26 Direct Labor Time per Unit (in hours) Cost per Hour 2.00 $11.00 30 Manufacturing Overhead Variable Cost/Unit Fixed Costs $5.00 $5,386