Kegglers Supply is a merchandiser of three different products. The company's February 28 Inventories are footwear, 18.000 units sports equipment, 78,000 units; and apparel, 49,000 units. Management believes each of these inventories is too high. As a resulta new policy dictates that ending inventory in any month should equal 32% of the expected unit sales for the following month. Expected Budgeted Sales in Units March April May June 15,500 26,500 32,000 36,000 Footwear Sports equipment 40,500 37,500 32,500 23,000 Required: 1. Prepare a merchandise purchases budget (in units) for each product for each of the months of March April, and May. KEGGLER'S SUPPLY Merchandise Purchases Budget For March, April, and May March April FOOTWEAR Budgeted sales for next month Ratio of ending inventory to future sales Required units of available merchandise Budgeted purchases SPORTS EQUIPMENT Budgeted sales for next month Raoof ending inventory to future sales FOOTWEAR Budgeted sales for next month Ratio of ending inventory to future sales Required units of available merchandise Budgeted purchases SPORTS EQUIPMENT Budgeted sales for next month Ratio of ending inventory to future sales 11 Required units of available merchandise Budgeted purchases APPAREL Ratio of ending inventory to future sales Required units of available merchandise Budgeted purchases