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
  | 
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||