2.2 $25.00 July August September October November Direct Materal Budget- Silk its to be produced-production budget 695 697 775 1,150 860 Multiply by: Quantity of DM needed per unit 1.75 1.75 1.75 1.75 1.75 Quality needed for production 1,216 1,220 1,356 2,013 1,505 Plus: Desired ending inventory of DM 183 203 262 266 0 Total quality needed 1,399 1,423 1,618 2,279 1,505 Less: Beginning inventory of DM 220 183 203 262 266 Quality to purchase 1,179 1,240 1,415 2,017 1,239 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 50,421 30,975 Direct Materal Budget- Vicose Fabric its to be produced-production budget 695 697 775 1,150 860 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,530 1,892 Plus: Desired ending inventory of DM 169 188 242 245 Total quality needed 1,698 1,721 1,947 2,775 1,892 Less: Beginning inventory of DM 187 169 188 242 245 Quality to purchase 1,511 1,552 1,759 2,533 1,647 Multiply by: Cost per pound $11.00 $11.00 $11.00 $11.00 $11.00 Total cost of DM purchases 16,616 17,074 19,351 27,868 18,1173. The iackets require two direct materials: silk fabric and viscose fabric for lining. Silk Silk fabric is purchased by the yard. ] .'i'S yards of silk fabric are required for each jacket produced. Management desires to have materials on hand at the end ofeach month equal to 15 percent ofthe following month's jacket production needs. Use the @ROUND function to round to the nearest whole number the number of yards l of silk desired in ending inventory. The beginning inventory of silk fabric, July 2023, is expected to be 220 yards. Silk fabric is expected to cost $25.00 per yard. Use the @ROUND function to round to the nearest whole number the number of yards of silk to purchase (DM to purchase). (NOTE: budgeted production in October is required mommncomplete the direct materials budget for September.) Viscose for lining Viscose fabric is purchased by the roll of 10 yards. 2.2 yards ofviscose fabric are required for each jacket produced. Management desires to have viscose fabric on hand at the end of each month equal to 1] percent of the following month's production needs. Use the @ROUND function to round to the nearest whole number the number of viscose yards desired in ending inventory. The beginning inventory, July 2023, is expected to be 18'? yards. The roll of 10 yards is expected to cost $110. Use the @ROUND function to round to the nearest whole number the number of viscose fabric yards to purchase (DM to purchase}. (NOTE: budgeted production in October is required to complete the direct materials budget for September.) Prepare a Direct Materials budget. Also, because two direct materials are required for production silk and viscose fabric you will need a separate schedule for each direct material. Sales Budget THEM\" Previous year sales 1, 000 Increase in volume by 15% 87 90 98 128 150 Budgeted Sales 667 690 748 978 1,150 Multiply by: Sales price $735 $735 $735 $735 $735 Total budgeted sales 490,245 507,150 549,413 718,463 845,250 Types of Sales Cash sales 49,025 50,715 54,941 71,846 84,525 Credit sales 441, 221 456, 435 494, 471 646, 616 760 725 0.1 490,245 507, 150 549, 413 718, 463 845,250 (lgmm Production budget Unit sales 667 690 748 978 1,150 Plus: Desired ending inventory 83 90 117 290 0 Total needed 750 780 865 1,268 1,150 Less: Beginning inventory 55 83 90 117 290 # of units to produce 695 697 775 1,150 860 0.12