Question
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
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 $ |
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started