Prepare a merchandise purchases budget (in UNITS) for each product for each of the months...here is a pic of the drop down menus for the blank boxes on the left:

please stick to the terminology in these pictures and the format of the spreadsheet! Thanks

Keggler's Supply is a merchandiser of three different products. The company's February 28 inventories are footwear, 22,000 units; sports equipment, 81,500 units; and apparel, 49,000 units. Management believes that excessive inventories have accumulated for all three products. As a result, a new policy dictates that ending inventory in any month should equal 31% of the expected unit sales for the following month. Expected sales in units for March, April, May, and June follow. Budgeted Sales in Units Footwear Sports equipment Apparel March April May June 14,500 23,500 34,000 34,000 71,500 89,500 96,000 89,500 42,000 38,500 33,000 24,000 Required: 1. Prepare a merchandise purchases budget (in units) for each product for each of the months of March, April, and May