Answer:
Walker Company
a. Merchandise Purchases Budget for the months of July, August, and September:
July August September
Sales units 210,000 290,000 290,000
Ending inventory 43,500 43,500 27,000
Goods available 253,500 333,500 317,000
Beginning inventory 31,500 43,500 43,500
Purchases 222,000 290,000 273,500
b. The ratio of ending inventory to the next month's sales = 15% (Ending Inventory/Sales next month * 100)
c. The units budgeted for sale in October = 180,000 units.
Explanation:
a) Data and Calculations:
September ending inventory = 27,000 units
Ending inventory always equal to 15% of budgeted sales for the following month.
Sales (Units) Purchases (Units)
July 210,000 222,000
August 290,000 290,000
September 290,000 273,500
October 180,000
July August September October
Sales units 210,000 290,000 290,000 180,000
Ending inventory 43,500 43,500 27,000
Goods available 253,500 333,500 317,000
Beginning inventory 31,500 43,500 43,500 27,000
Purchases 222,000 290,000 273,500
