Requirements: Done (x) 1) The numbers will automatically fill-in the Data Sheet. 2) TYPE the numbers from the Data Sheet that you printed into your project's Data Sheet 3) a) You may not type any numbers on the budget worksheets. b) Utilize cell references to transfer numbers from the data sheet to the worksheets. Use formula to perform calculations. 4 5 6 3 Unit Sales Projections January February March 18,544 7 April 8 May 9 10 Sales Price Per Unit 24,738 43,364 47,529 39,353 $ 321.00 11 12 Monthly Projected Operating Expenses 13 Variable Selling & Administrative Expenses Per Unit $5.00 14 15 Fixed Selling & Administrative Expenses $2,889 15 16 Production: 17 18 19 Desired Ending Inventory Beginning Inventory (new business) 56.5% 0 220 20 Materials Desired Ending Inventory 20.1% 22 22 Quantity of Direct Materials Needed per Unit. 6.0 23 Projected Cost Per Direct Material $6.00 24 Beginning Inventory (new business) 25 0 25 Direct Labor Time per Unit (in hours) 2.00 Cost per Hour $20.00 Manufacturing Overhead Variable Cost/Unit Fixed Costs $4.00 $7,179 DIRECT LABOR BUDGET Units to be Produced Direct Labor Hours Per Unit Total Direct Labor Hours Required Direct Labor Cost Per Hour Total Direct Labor Cost Direct Labor Hours Per Unit Direct Labor Cost Per Hour Cost of Direct Labor per Product January February March