please answer the following and show work if possible

Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of 30,000 units. Company policy is to end each month with merchandise inventory equal to 15% of budgeted sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. The company budgets sales of 200,000 units in October Sales units Purchases Unit 170,000 192,500 August 320,000 318,500 September 310,000 293,500 July Prepare the merchandise purchases budgets for the months of July, August, and September WALKER COMPANY Merchandise Purchase For July August, and September July August September 30,000 Budgeted ending inventory units Required units of available inventory Units to be purchased 192.500 318 500 293,500