I want to check my work. My answers are the numbers in the clip of the excel sheet. I was presented with as blank Material Purchase Budget sheet. The first column options were selected from the dropdown choices pictured below my answers.

Question 8 Answer Current Attempt in Progress Marx Industrial has estimated that production for the next ve quarters will be: lst quarter, 2020 49,500 u nits 2nd quarter, 2020 44,300unit3 3rd quarter. 2020 54,200 0 nits 4th quarter. 2020 42,400 units 15t quarter, 2021 51,100 units. Finished units of production require 6 pounds of raw material per unit. The raw material cost is $7 per pound. There is $311,850 at raw material on hand at the beginning of the rst quarter, 2020. Marx desires to have 15 percent of Halt quarter's material requirements on hand at the end of each quarter. Prepare quarterly direct materials purchases budgets for Marx industrial for 2020. Jr Options from Drop Down choices 4' Units to be produced Cost of Raw Material per unit Cost of raw material needed for production ADD Desired ending inventory of Raw Material total material needed LESS Beginning Inventory of raw material 1 Required raw Material Purchase l Units in be produced Cusl 0f rawmaleriai per mm l Besiredendinginvaimry ufmwmzlerial l Tolel maleriai needed | Beginninglmenlulvofraw material l ' Requiredmwmaterialwrcmws - Coal of rawmaleriai needed for production Quarter 1 49,500 2,079,000 282,240 2,361,240 31 1,850 2,049,390 Quarter 2 44,800 42 1,881,600 341,460 2,223,060 282,240 1,940,320 Quarter 3 54,200 42 2,276,400 267,120 2,543,520 341,460 2,202,050 Quarter 4 42,400 42 1,730,800 321,930 2,102,730 267,120 1,535,510 Year 190,900 42 8,017,800 321,930 3,339,730 321,930 8,017,800