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 Desired Ending Inventory Beginning Inventory (new business) 56.5% 0 19 20 Materials 21 Desired Ending Inventory 20.1% 22 Quantity of Direct Materials Needed per Unit. 6.0 23 Projected Cost Per Direct Material $6.00 24 Beginning Inventory (new business) 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 2 3 5 Unit Sales Sales Price per Unit Total Sales Revenue SALES BUDGET January February March April 3 Unit Sales 4 5 Desired Ending Inventory Total Units Needed 6 7 Beginning Inventory Number of Units to Produce B PRODUCTION BUDGET January February March April