In-Class Budgeting Project 4 3 Sales Projections in Units January February March April 5 6 22,266 27,344 35,742 45,644 44,685 7 8 May 9 10 Projected Sales Price/Unit $ 487.00 11 13 12 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $ 13.00 Fixed Costs $3,295 14 15 16 Production: Desired Ending Inventory Beginning Inventory (new business) 17 71.1% 0 18 19 20 Materials 84.0% 11.00 $22.00 21 Desired Ending Inventory 22 Number of Materials per Unit 23 Projected Cost/Material Unit Beginning Inventory (new business) 25 26 Direct Labor Time per Unit (in hours) 28 Cost per Hour 24 0 27 2.00 $13.00 29 30 Manufacturing Overhead Variable Cost/Unit 31 $4.00 32 Fixed Costs $8,127 33 3A 2 January February March April Units to be produced Materials Per Unit Total Materials Needed 5 6 Desired Ending Inventory In Materials Total Materials Needed Beginning Inventory 7 8 Total Materials Needed to be purchased 9 Cost per Unit of Material 10 Total Material Cost 11 12 13 Materials Per Unit Cost per Unit of Material Cost of Material per Product 14 15 January 3 February March April Number of Units Produced Direct Labor Hours Per Unit 5 Total Direct Labor Hours 6 Needed Cost Per Direct Labor Hour 7 Total Direct Labor Cost 8 10 Direct Labor Hours Per Unit 11 Cost Per Direct Labor Hour 12 Cost of Direct Labor per Product 13