In: Finance
Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents) 4. What is the “Total $ Planned Purchases at Cost” figure? |
Last Year’s Total Sales = $100,000
Planned % Sales Increase = 5%
Planned % Reductions = 14%
Planned EOM for Period = $25,000
Planned IMU% for Period = 53%
Six-Month Merchandise Budget |
|||||||
Spring/Summer |
February |
March |
April |
May |
June |
July |
Totals |
Planned Sales |
|||||||
Planned Sales % |
10% |
25% |
20% |
20% |
15% |
10% |
100% |
Planned BOM Stock |
____________ |
||||||
Planned S/S Ratio |
2.70 |
2.30 |
1.96 |
1.85 |
1.87 |
2.20 |
____________ |
Planned EOM Stock |
____________ |
||||||
Planned Reductions |
|||||||
Planned Reductions % |
10% |
15% |
20% |
22% |
18% |
15% |
100% |
Planned Purchases @ Retail |
|||||||
Planned Purchases @ Cost |
A. |
$116,350 |
|
B. |
$52,640 |
|
C. |
$73,085 |
|
D. |
$54,684.50 |
The answer
Planned Purchase represents the merchandise that is to be purchased during any given period.
The formula for Planned Purchase =Planned Sales+Planned Reductions+Planned EOM -Planned BOM
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||