Keggler's Supply is a merchandiser of three different products. The company's February 28 inventories are footwear, 20,000 units: sports equipment, 80,000 units, and apparel 50,000 units Management believes each of these inventories is too high. As a result, a new policy dictates that ending inventory in any month should equal 30% of the expected unit sales for the following month. Expected sales in units for March April May, and June follow. Footwear Sports equipment Apparel Budgeted sales in Units Marchi April wy June 15,000 25,000 $2,000 35,000 20,000 90,000 95.000 90,000 38,000 37,000 25,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 FOOTWEAR Budgeted sales for next month Ratio of ending inventory to future sales April May Required units of available merchandise Budgeted purchases SPORTS EQUIPMENT Budgeted sales for ned month Ratio ofending Inventory to future les Required units of available merchandise Budgeted purchases 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 FOOTWEAR Budgeted sales for next month Ratio of ending inventory to future sales April May Required units of available merchandise Budgeted purchases SPORTS EQUIPMENT Budgeted sales for next month Ratio of ending inventory to future sales Required units of available marchandise Budgeted purchases APPAREL Budgeted sales for next month Ratio of ending Inventory to future sales Required units of available merchandise Budgeted purchases