solve all requirements please (inventory, purchases, COGS budget for first 3 quarters of the year, COGS for entire 9 month period)

Wuestion Help Scannell Inc., sells tire rims. Its sales budget for the nine months ended September 30, 2014, follows: Click the icon to view the budget) In the past, cost of goods sold has been 40% of total sales. The director of marketing and the financial vice president agree that each quartor's ending inventory should not be below 535,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of $255,000 during the fourth quarter The January 1 inventory was $37.000 Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entiro nine-month period. Scannell, Inc. Inventory, Purchases, and cost of Goods Sold Budget Nine Months Ended September 30, 2014 Plus: Less Data Table - Quarter Ended Nine-Month March 31 Cash sales, 30% 46,500 $ 108,500 June 30 September 30 61,500 $ 54,000 $ 143,500 126,000 Total 162,000 378,000 Credit sales, 70% Total sales 155,000 $ 205,000 $ 180,000 $ 540,000 Print Done