I have created the sales budget and Production budget. can someone please help with the Direct Materials budget? please show all steps. thank you

3. The globes require two direct materials: shells and base rings: two (2) mild steel shells are required for each globe produced. Management desires to have materials on hand at the end of each month equal to 10 percent of the following month's globe production needs. Use the @ROUND function to round to the nearest whole number the number of sells desired in ending inventory. The beginning inventory of shells, in July 2020, is expected to be 47 shells. Shells are expected to cost $100 each. (Note: budgeted production in October is required in order to complete the direct materials budget for September. Use the @ROUND function to round to the nearest whole number the number of shells to purchase). One base ring is required for each globe. Management desires to have base rings on hand at the end of each month equal to 15 percent of the following month's production needs. Use the @ROUND function to round to the nearest whole number the number of base rings desired in ending inventory. The beginning inventory, in July 2020, is expected to be 35 base rings. Base rings are expected to cost $40 each. (Note: budgeted production in October is required in order to complete the direct materials budget for September. Use the @ ROUND function to round to the nearest whole number of base rings to purchase). Prepare a Direct Materials budget. Also, because two direct materials are required for production - shells and base rings - you will need a separate schedule for each direct material. July August September Quarter October November $ $ 360 00 480.00 51000 1,350.00 1,595 00 $ 1,59500 $ 1.595.00 $ 1,595 00 574 20000 S 765,600.00 $ 81345000 $2,153.250,00 72000 800.00 5 1 595.00 $ 1595 00 $1148400.00 $ 957 000 00 20% s 80% 114 840 00 $ 153, 120 00 $ 162.690.00 S430,650.00 459,360 00 612 48000 650.700.00 1.722.600.00 574 200.00 $ 765 600 00 S 813,450.00 $ 2153,250,00 $ $ 229 880.00 5 191.400.00 918,720 00 705 600.00 $ 114840000 $95700000 July August September 2 8 Sales Budget Unit Sales 10 Unit Price Sales Revenue 12 Cash Sale 14 Credit Sale Total 16 17 as Production Budget 19 Unit sales 20 Desired ending inventory 21 Total needed Beginning inventory 3 Units to produce 6 5 6 7 Direct Material Budget Quantity of DM needed for production Desired DM ending inventory Total Quantity of DM needed DM beginning inventory Quantity of DM to purchase Quarter October November 800 300 24 384 150 234 480 20 506 24 -402 510 30 546 26 520 1,350 36 1,380 150 1.231 720 30 750 30 July August September Quarter October November 234 482 520 1230 714