July August September October November Sales Budget Unit Sales 667.00 690.00 747.50 977.50 1,150.00 Multiply by: Sales price $735 $735 $735 $735 $735 Total Sales Reveune 718,462.50 Types of Sales Cash sales 49,024.50 50,715.00 54,941.25 71,846.25 84,525.00 Credit sales 646,616.25 0.1 0.9 HHHHHHHHH 718,462.50 July August September October November Production budget Unit sales 667.00 690.00 747.50 977.50 1,150.00 Plus: Desired ending inventory 83 90 117 138 Total needed 750 780 865 1,116 1,150 Less: Beginning inventory 55 83 90 117 138 # of units to produce 695 697 775 998 1,012 0.12 1.75 $11.00 2.2 $25.00 July August September October November Direct Materal Budget- Silk its to be produced-production budge 695 697 775 998 1,012 Multiply by: Quantity of DM needed per unit 1.75 1.75 1.75 1.75 1.75 Quality needed for production 1,215.90 1,219.58 1,356.43 1,746.85 1,771.00 lus: Desired ending inventory of DM 183 203 262 266 0 Total quality needed 1,399 1,423 1,618 2,013 1,771 Less: Beginning inventory of DM 220 183 203 262 266 Quality to purchase 1,179 1,240 1,415 1,751 1,505 Multiply by: Cost per pound $25.00 $25.00 $25.00 $25.00 $25.00 Total cost of DM purchases 29,473 30,989 35,386 43,771 37,625 ect Materal Budget- Vicose Fabri its to be produced-production budge 695 697 775 998 1,012 tiply by: Quantity of DM needed per u 2.2 2.2 2.2 2.2 2.2 Quality needed for production 1,529 1,533 1,705 2,196 2,226 lus: Desired ending inventory of DM 169 242 245 Total quality needed 1,698 1,721 1,947 2,441 2,226 Less: Beginning inventory of DM 187 69 188 242 45 Quality to purchase 1,511 1,552 1,759 2,199 1,981 Multiply by: Cost per pound $11.00 $11.00 $11.00 $11.00 $11.00 Total cost of DM purchases 16,616.16 17,073.98 19,351.42 24,189.44 21,795.40 Direct labor Budget July August September October November Units to be produced 595 597 775 998 1,012 Mulitiply by: DLH per unit 12 12 12 12 12 Total Hours Required 8,338 8,363 9,301 11,978 12,144 Mulitiply by: DLH rate per unit $25.00 $25.00 $25.00 $25.00 $25.00 Total Direct Labor cost 299,460.00 12 $25.00 $20.00 $5.50 July August September October November MOH Budget Units to be produced 695 697 775 998 1,012 Variable MOH cost Indirect Materials $ 17,370 $ 17,423 $ 19,378 $ 24,955 $ 25,300 Indirect Labor 13,896 $ 13,938 $ 15,502 19,964 20,240 Utilities 3,821 $ 3,833 $ 4,263 5,490 5,566 Total Variable MOH $ 35,087 $ 35,193 $ 39,143 $ 50,409 $ 51,106 Fixed MOH Cost Indirect Labor 25,000 $ 25,000 $ 25,000 25,000 $ 25,000 Utilities 2,200 $ 2,200 2,200 2,200 2,200 Others 22,000 $ 22,000 $ 22,000 22,000 $ 22,000 Total Fixed MOH 49,200 $ 49,200 $ 49,200 49,200 $ 49,200 Total MOH 84,287 $ 84,393 S 88,343 S 99,609 $ 100,306Variable selling and administrative expenses are $45.50 per jacket sold. Fixed selling and administrative expenses are $3 5,000 per month. These costs are not itemized, ie, the budget has only twoline items variable operating expenses and xed operating expenses. Prepare an Operating Expenses budget