60.1K

Verified Solution

Link Copied!

Complete the following six month merchandise plan using the criteria below:

1.Sales PLAN for the season: $777,777

-monthly sales PLAN percentages: 13%, 15%, 15%, 16%, 24%, 17%,

fill in monthly PLAN sales $ and total PLAN $

2. P6 EOM PLAN $452,600

3.Monthly Reductions PLAN are 2.54%, 2.48%, 2.19%, 1.8%, 1.65%, 3.22%,

fill in PLAN monthly amounts AND TOTAL amount $ and total % (1)

4.S-S ratio PLAN: 3.68, 4.2, 3.84, 2.8, 3, 3.96

Fill in the planned purchases (1)

5.ACTUAL sales variance for P1-P3 are -13.23%, -9.76%, -6%,

Fill in P1-P3 ACTUAL sales $ (1)

Forecast P4-P6 ACTUAL sales $ (1)

Complete variance to plan % with TOTAL (based on your forecast (1)

6. Complete the BOM & EOM Plan (1)

BONUS: Complete the WEEKLY SALES PLAN $ for each month.(1)

NOTES:

• Use the word template below OR if you use excel, ensure rows and columns match, and document has been formatted on one page and has appropriate title on it. One Mark will be deducted if it is not formatted on one page with your names.
• Forecast based on logical flow of forecast trends.

Names___________________________________________________________________

	P1	P2	P3	P4	P5	P6	Season Total
Monthly % sales PLAN
Sales $ PLAN
Sales $ ACTUAL
% Variance to sales plan
Reduction % PLAN
Reduction $ PLAN
BOM $ Plan
EOM $ Plan
PLAN Purchase $
S-S Ratio PLAN
Bonus: Weekly sales PLAN $

Answer & Explanation Solved by verified expert

See Answer