Set up the entire 6 month plan using the following 6 month plan with the following ‎information and Use formula’s to calculate the remaining values: ‎

‎1.‎ Sales PLAN: $333,333 ‎ ‎

2.‎ monthly sales PLAN percentages: 13%, 15%, 15%, 16%, 24%, 17%, fill in monthly ‎PLAN sales $ and total

‎3.‎ Jan EOM PLAN $152,600‎

‎4.‎ Monthly Reductions PLAN are 2.54%, 2.48%, 2.19%, 1.8%, 1.65%, 3.22%, fill in ‎PLAN monthly and total reduction $ and the total %

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

‎6.‎ Fill in the planned purchases

‎7.‎ ACTUAL sales variance for August – October are -13.23%, -9.76%, -6%, Fill in P1-‎P3 ACTUAL sales $

‎8.‎ Forecast P4-P6 ACTUAL sales $ and variance to plan % with totals (based on ‎your forecast ‎) ‎

9.‎ ‎ Complete the BOM & EOM Plan ‎

10.‎ Complete the WEEKLY SALES PLAN $ for each month.