question archive A buyer purchases 900 sneakers from a vendor to retail at $89
Subject:MathPrice:2.84 Bought6
A buyer purchases 900 sneakers from a vendor to retail at $89.00. In the first week, the store sold 30 pairs at regular price.
a)Calculate the weeks-of-supply (WOS) and sell-through percentage (ST%) for week 1.
b)The second week, the store sold 40 pairs at regular price. Calculate the WOS and ST% for week 2. What was the build in unit sales for week 2 from week 1?
c)The third week, the buyer took a POS markdown to $69.99 and sold 65 pairs. Calculate WOS and ST% for week 3. What was the build in unit sales for week 3?
See Explanation
Step-by-step explanation
Given Data:
WOS = Onhand Inventory / Average weekly units sold
ST = Units sold / Beginning inventory
Table Below
(A) | (B) | (C) | |
Week 1 | Week 2 | Week 3 | |
Opening Inventory | 900 | 870 | 830 |
Units Sold | 30 | 40 | 65 |
(900/30) | (870/40) | (830/65) | |
WOS | 30 | 21.75 | 12.7692307692 |
ST | 3.3% | 4.5% | 7.8% |
30/900 | (40/870) | (65/830) | |
0.033 | 0.045 | 0.078 | |
In Percent % = | 0.033*100 = 3.3% | 0.045*100 = 4.5% | 0.078 * 100 = 7.8% |
For Week 2
Where,
Initial Purchase = 900
Less: Units sold = 30
Stock on hand = 870
For Week 3
Stock on hand = 870
Less : Units sold = 40
Stock on hand = 830