Executive officers of Munoz Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two difference sources Source of Estimate Sales manager Marketing consultant Pirst Quarter $389,000 522,000 Second Quarter $320,000 452,000 Third Quarter $274,000 414,000 Fourth Quarter $484,000 647,000 Munoz's past experience indicates that cost of goods sold is about 65 percent of sales revenue. The company tries to maintain 15 percent of the next quarter's expected cost of goods sold as the current quarter's ending inventory. This year's ending inventory is $20,000. Next year's ending Inventory is budgeted to be $21,000. Required a. Prepare an inventory purchases budget using the sales manager's estimate. b. Prepare an inventory purchases budget using the marketing consultant's estimate. Complete this question by entering your answers in the tabs below. Required A Required B Prepare an inventory purchases budget using the sales manager's estimate (Round your final answers to nearest whole dollar amount.) First Quarter Socond Third Quarter Fourth Quarter Quarter $ 389,000 $ 320,000 $ 274,000 $ 484.000 Sales Cost of goods sold Plus: Desired ending Inventory Total inventory needed Less: Beginning inventory Required purchases 0 0 0 $ 0$ 05 0s 0 RA Required B > Executive officers of Munoz Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two difference sources. Source of Estimate Sales manager Marketing consultant First Quarter $389,000 522,000 Second Quarter $320,000 452,000 Third Quarter $274,000 414,000 Fourth Quarter $484,000 647,000 Munoz's past experience indicates that cost of goods sold is about 65 percent of sales revenue. The company tries to maintain 15 percent of the next quarter's expected cost of goods sold as the current quarter's ending inventory. This year's ending inventory is $20,000. Next year's ending Inventory is budgeted to be $21,000. Required a. Prepare an inventory purchases budget using the sales manager's estimate b. Prepare an Inventory purchases budget using the marketing consultant's estimate. Complete this question by entering your answers in the tabs below. Required A Required B Prepare an inventory purchases budget using the marketing consultant's estimate. (Round your final answers to nearest whole dollar amount.) Second Fint Quarter Fourth Third Quarter Quarter Quarter Sales $ 522,000 $ 452,000 $ 414,000 S 647.000 Total Inventory needed o 0 0 0 Required purchases $ 0 $ 0 $ $ O