Given the sixmonth merchandise budget below answer questions

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

$116,350

$52,640

$73,085

$54,684.50

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?

Solution

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

                                               

The answer is a as uploaded in the JPEG file. Mar Apr May jun july Total 25% 20% 20% 15% 10% 100% $26,250 $21,000 $21,000 $15,750 $10,500 $105,000 47% 47% 47% 47% 47% $49,350 $49,350 $49,350 $49,350 $49,350 $296,100 $11,290.17 $11,290.17 $11,290.17 $11,290.17 $11,290.17 $67,741 2.3 1.96 1.85 1.87 2.2 $60,375.00 $41,160.00 $38,850.00 $29,452.50 $23,100.00 $221,287.50 $26,515.17 $40,480.17 $42,790.17 $46,937.67 $48,040.17 $247,553.50 $116,350.15