Budgeting on Excel utilize cell reference to transfer numbers from the data sheet to the worksheet, Use Formula to perform calculations. Sales Budget, Selling &Administrative (S&A) Expense Budget, Production Budget, Materials Requirements Budget, Direct Labor Budget, Manufacturing Overhead Budget, Cost of goods Sold per Unit, Projected Income Statement

Project #2 Sales Projections in Units January February 13,338 50 788 March 31,100 April 51,971 May 58,915 Projected Sales Price/Unit $ 132.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $ 18.00 Fixed Costs S 247.00 Production: Desired Ending Inventory Beginning Inventory (new business) Materials Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) Direct Labor Time per Unit (in hours) Cost per Hour Manufacturing Overhead Variable Cost/Unit Fixed Costs $ 82.6% 0 17.0% $ 80 19.00 0 3.00 $ 17.00 $ 5.00 8.862