Sales Budget Prior year sales in units Projected unit sales increase Projected total unit sales Sales price per unit Budgeted sales Revenue Q1 02 03 04 Year 65,041 80,021290110 75,02170,027 15 86,27480531 15 15 74,797 15 92,024 30 15 333,626 30 30 $ 30 $ 30 $ S2,588,220 S 2,415,930 2243,910 S 2760,720 S 10,008,70 Production Budget Projected Unit Sales Plus: Ending Inventory Total units needed Less: Beginning Inventory Units to be produced 86,274 8,053 94,327 80,531 7,480 74,797 8,50088,0119202 8,053 83,999 7,480 76,519 92,024 8,625 100,649 9,202 91,447 85,827 79,958 Direct Materials Budget Units to be Produced Material per unit Units of material for product Plus Ending Inventory Total units DM needed Less: Begnning DM Units of DM to purchase Cost per unit DM Total Cost of DM purchases 85,827 79,958 76,519 91,447 Direct Labor Budget Units to be produced Sales Budget Prior year sales in units Projected unit sales increase Projected total unit sales Sales price per unit Budgeted sales Revenue Q1 02 03 04 Year 65,041 80,021290110 75,02170,027 15 86,27480531 15 15 74,797 15 92,024 30 15 333,626 30 30 $ 30 $ 30 $ S2,588,220 S 2,415,930 2243,910 S 2760,720 S 10,008,70 Production Budget Projected Unit Sales Plus: Ending Inventory Total units needed Less: Beginning Inventory Units to be produced 86,274 8,053 94,327 80,531 7,480 74,797 8,50088,0119202 8,053 83,999 7,480 76,519 92,024 8,625 100,649 9,202 91,447 85,827 79,958 Direct Materials Budget Units to be Produced Material per unit Units of material for product Plus Ending Inventory Total units DM needed Less: Begnning DM Units of DM to purchase Cost per unit DM Total Cost of DM purchases 85,827 79,958 76,519 91,447 Direct Labor Budget Units to be produced