90.2K

Verified Solution

Link Copied!

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)

	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
Weekly sales PLAN $

Answer & Explanation Solved by verified expert

See Answer