Question
Pinsetters Supply is a merchandiser of three different products. The companys February 28 inventories are footwear, 18,000 units; sports equipment, 78,000 units; and apparel, 48,000
Pinsetters Supply is a merchandiser of three different products. The companys February 28 inventories are footwear, 18,000 units; sports equipment, 78,000 units; and apparel, 48,000 units. Management believes that excessive inventories have accumulated for all three products. As a result, a new policy dictates that ending inventory in any month should equal 31% of the expected unit sales for the following month. Expected sales in units for March, April, May, and June follow. |
Budgeted Sales in Units | ||||
March | April | May | June | |
Footwear | 15,500 | 24,000 | 32,500 | 35,000 |
Sports equipment | 69,500 | 90,000 | 95,000 | 89,500 |
Apparel | 41,000 | 38,500 | 33,000 | 23,000 |
Required: |
1. | Prepare a merchandise purchases budget (in units) for each product for each of the months of March, April, and May. (Amounts to be deducted should be indicated with a minus sign. Omit the "%" sign in your response.) |
PINSETTERS SUPPLY Merchandise Purchases Budgets For March, April, and May | |||
March | April | May | |
FOOTWEAR | |||
Budgeted sales for next month | |||
Ratio of ending inventory to future sales | % | % | % |
(Click to select)Budgeted beginning inventoryBudgeted purchasesBudgeted ending inventoryBudgeted merchandise inventoryBudgeted sales | |||
(Click to select)Less: Budgeted salesAdd: Budgeted salesAdd: Budgeted purchasesLess: Budgeted purchasesBudgeted beginning inventory | |||
Required units of available merchandise | |||
(Click to select)Add: Actual (or budgeted) ending inventoryLess: Actual (or budgeted) beginning inventoryBudgeted salesAdd: Actual (or budgeted) beginning inventoryLess: Actual (or budgeted) ending inventory | |||
Budgeted purchases | |||
SPORTS EQUIPMENT | |||
Budgeted sales for next month | |||
Ratio of ending inventory to future sales | % | % | % |
(Click to select)Budgeted ending inventoryBudgeted salesBudgeted beginning inventoryBudgeted merchandise purchasesBudgeted purchases | |||
(Click to select)Add: Budgeted salesBudgeted beginning inventoryAdd: Budgeted purchasesLess: Budgeted salesLess: Budgeted purchases | |||
Required units of available merchandise | |||
(Click to select)Less: Actual (or budgeted) ending inventoryBudgeted salesAdd: Actual (or budgeted) ending inventoryAdd: Actual (or budgeted) beginning inventoryLess: Actual (or budgeted) beginning inventory | |||
Budgeted purchases | |||
APPAREL | |||
Budgeted sales for next month | |||
Ratio of ending inventory to future sales | % | % | % |
(Click to select)Budgeted merchandise purchasesBudgeted ending inventoryBudgeted purchasesBudgeted salesBudgeted beginning inventory | |||
(Click to select)Add: Budgeted purchasesAdd: Budgeted salesBudgeted beginning inventoryLess: Budgeted salesLess: Budgeted purchases | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started