1 2 A B C JONES Project #2 3 Sales Projections in Units January February March...

Transcribed Image Text:

1 2 A B C JONES Project #2 3 Sales Projections in Units January February March 4 5 6 7 April 8 May 9 10 Projected Sales Price/Unit 11 17,498 49,405 47,481 44,397 48,287 $ 134.78 12 Monthly Projected Selling & Administrative Expenses 34 13 14 15 Variable Cost/Unit Fixed Costs 16 Production: E $ 1.15 $ 2,257 H 17 Desired Ending Inventory 18 Beginning Inventory (new business) 5.4% 0 19 20 Materials 21 Desired Ending Inventory 70.1% 22 Number of Materials per Unit 12.29 23 Projected Cost/Material Unit $ 22.80 24 Beginning Inventory (new business) 0 + 25 26 Direct Labor 27 Time per Unit (in hours) 28 Cost per Hour 2.21 $15.39 29 30 Manufacturing Overhead 31 Variable Cost/Unit $4.30 32 Fixed Costs $13,109 33 34 35 36 37 38 Data Sheet Ready Sales Budget Accessibility: Investigate Operating Budget Production Budget Materials F 1 2 A B C JONES Project #2 3 Sales Projections in Units January February March 4 5 6 7 April 8 May 9 10 Projected Sales Price/Unit 11 17,498 49,405 47,481 44,397 48,287 $ 134.78 12 Monthly Projected Selling & Administrative Expenses 34 13 14 15 Variable Cost/Unit Fixed Costs 16 Production: E $ 1.15 $ 2,257 H 17 Desired Ending Inventory 18 Beginning Inventory (new business) 5.4% 0 19 20 Materials 21 Desired Ending Inventory 70.1% 22 Number of Materials per Unit 12.29 23 Projected Cost/Material Unit $ 22.80 24 Beginning Inventory (new business) 0 + 25 26 Direct Labor 27 Time per Unit (in hours) 28 Cost per Hour 2.21 $15.39 29 30 Manufacturing Overhead 31 Variable Cost/Unit $4.30 32 Fixed Costs $13,109 33 34 35 36 37 38 Data Sheet Ready Sales Budget Accessibility: Investigate Operating Budget Production Budget Materials F