Keggler's Supply is a merchandiser of three different products. Beginning inventories for March are footwear, 18,000 units; sports gear, 81,500 units; and apparel, 48,500 units. Management believes each of these inventories is too high and begins a new policy that ending inventory in any month should equal 31% of the budgeted sales units for the following month. Budgeted sales units for March, April, May, and June follow. Footwear Sports gear Apparel Required: March Budgeted Sales in Units April May 23,000 32,000 June 35,500 15,000 68,000 91,000 95,500 90,500 41,000 39,000 33,000 23,000 1. Prepare a merchandise purchases budget (in units only) for each product for each of the months of March, April, and May. FOOTWEAR Budgeted sales units KEGGLER'S SUPPLY Merchandise Purchases Budget March April May Add: Desired ending inventory Next period budgeted sales units 23,000 32,000 35,500 Ratio of ending inventory to future sales 31% 31% 31% Desired ending inventory 7,130 9,920 11,005 Total required units Units to purchase SPORTS GEAR Budgeted sales units Add: Desired ending inventory Units to purchase SPORTS GEAR Budgeted sales units Add: Desired ending inventory Next period budgeted sales units 91,000 95,500 90,500 Ratio of ending inventory to future sales 31% 31% 31% Desired ending inventory 28,210 29,605 28,055 Total required units Units to purchase APPAREL Budgeted sales units Add: Desired ending inventory Next period budgeted sales units 39,000 33,000 23,000 Ratio of ending inventory to future sales 31% 31% 31% Desired ending inventory 12,090 10,230 7,130 Total required units Units to purchase