Required: 1. Prepare a merchandise purchases budget (in units only) for each product for each of the months of March, April, and May.

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter7: The Master Budget And Flexible Budgeting
Section: Chapter Questions
Problem 1E: The sales department of Macro Manufacturing Co. has forecast sales for its single product to be...
icon
Related questions
icon
Concept explainers
Question
Please provide answer in text (Without image)
Keggier's Supply is a merchandiser of three different products. Beginning inventories for March are footwear, 20,000 units, sports
gear, 80,000 units, and apparel, 50,000 units. Management believes each of these inventories is too high and begins a new policy that
ending Inventory in any month should equal 30% of the budgeted sales units for the following month. Budgeted sales units for March,
April, May, and June follow.
Footwear
Sports gear
Apparel
FOOTWEAR
Budgeted Sales in Units
April
May
32,000
95,000
40,000 35,000 37,000
Required:
1. Prepare a merchandise purchases budget (in units only) for each product for each of the months of March, April, and May.
March
15,000 25,000
70,000 90,000
Budgeted sales units
Add Desired ending inventory
SPORTS GEAR
Next period budgeted sales units
Ratio of ending inventory to future sales
Desired ending inventory
Total required units
Less Beginning inventory units
Units to purchase
Budgeted sales units
Add Desired ending inventory
APPAREL
Next period budgeted sales units
Ratio of ending inventory to future sales
Desired ending inventory
Total required units
Less Beginning inventory unts
Unts to purchase
June
35,000
90,000
25,000
KEGGLER'S SUPPLY
Merchandise Purchases Budget
March
Budgeted sales units
25,000
30%
25,000
90.000
April
32,000
0
32,000
95.000
May
35,000
35,000
90,000
Transcribed Image Text:Keggier's Supply is a merchandiser of three different products. Beginning inventories for March are footwear, 20,000 units, sports gear, 80,000 units, and apparel, 50,000 units. Management believes each of these inventories is too high and begins a new policy that ending Inventory in any month should equal 30% of the budgeted sales units for the following month. Budgeted sales units for March, April, May, and June follow. Footwear Sports gear Apparel FOOTWEAR Budgeted Sales in Units April May 32,000 95,000 40,000 35,000 37,000 Required: 1. Prepare a merchandise purchases budget (in units only) for each product for each of the months of March, April, and May. March 15,000 25,000 70,000 90,000 Budgeted sales units Add Desired ending inventory SPORTS GEAR Next period budgeted sales units Ratio of ending inventory to future sales Desired ending inventory Total required units Less Beginning inventory units Units to purchase Budgeted sales units Add Desired ending inventory APPAREL Next period budgeted sales units Ratio of ending inventory to future sales Desired ending inventory Total required units Less Beginning inventory unts Unts to purchase June 35,000 90,000 25,000 KEGGLER'S SUPPLY Merchandise Purchases Budget March Budgeted sales units 25,000 30% 25,000 90.000 April 32,000 0 32,000 95.000 May 35,000 35,000 90,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning