Koggler's Supply is a merchandiser of three different products. The company's February 28 inventories are footwear, 22.000 units sports equipment, 80,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 30% of the expected unit sales for the following month Expected sales in units for March April May, and June follow arch Tootwear sports equignant Apparel tudoted in this April May 10,000 26,000 34.000 36,000 69.000 8.500 95,500 *5.500 40.500 37.500 33,500 22.000 Required: 1. Prepare a merchandise purchases budget fin units) for each product for each of the months of March April, and May Agri May 28.400 34.800 REGGLER'S SUPPLY Merchandise Purchase Budget For March April, and May March FOOTWEAR Budgeted sales for read month Ratio of ending inventory to Mures 30% Budgeted ending inventory 7.500 Budgeted units sale for month Required units of bile merchandise Acil for estimated) beginning inventory Budgeted purchases (200) SPORTS EQUIPMENT Budgeted sales for next month Ratio of ending inventory to stare sales Budgeted ending Inventory Budgeted units sales for month Required units of available merchandise Acil for estimated) beginning inventory Budgeted purchases 15.550 APPAREL Budgeted sales for next month Ratio of ending inventory to Mures 30% Budgeted ending inventory Budgeted sales for month Required units of valable merchandise Actual for estimated) beginning inventory 49.000 Budgeted purchases 2.750 90 500 33.700 11.250 36.00 10.050 30,050