The firm's inventory policy is to have ending inventory equal to 10% of next month's sales. Fill in the missing numbers. March February Ending inventory (No Response) (No Response) Beginning inventory (No Response) (No Response) (No Response) Budgeted sales 9,000 17,000 17,000 Budgeted production (No Response) (No Response) (No Response) (If you get stuck on the beginning inventory for February: it is equal to the ending inventory for January, which you can compute with the available data on February sales) April 2,500

Solve the problem

Keggler's Supply is a merchandiser of three different products. The company's February 28 inventories are footwear, 19,000 units, sports equipment, 81,500 units; and apparel, 49,000 units. Management belleves each of these inventories is too high. As a result, a new policy dictates that ending inventory in any month should equal 29% of the expected unit sales for the following month. Expected sales in units for March, April, May, and June follow. Footwear Sports equipment Apparel Required: 1. Prepare a merchandise purchases budget (in units) for each product for each of the months of March, April, and May. Budgeted Sales in Units March April May 15,000 24,500 31,000 71,500 88,000 95,000 40,500 37,500 33,000 24,000 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 Budgeted purchases APPAREL Merchandise…

Antonio Banderos & Scarves sells headwear that is very popular in the fall-winter season. Units sold are anticipated as follows: October November December January 1,650 2,650 5,300 4,300 13,900 If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup. October November December January The production manager thinks the above assumption is too optimistic and decides to go with level production to avoid being out of merchandise. She will produce the 13,900 items at a level of 3,475 per month. a. What is the ending inventory at the end of each month? Compare the units sold to the units produced and keep a running total. (Do not leave any empty spaces; input a 0 wherever it is required. Negative values should be indicated by a minus sign.) Units sold Antonio Banderos & Scarves Units Produced Change in inventory Ending inventory