Complete the following six month merchandise plan using the criteria below $$ use the following chart $$ or if you chose to use excel, make sure to format it to one page $($or one mark deduction$)$ with title on spreadsheet.

$1.$Sales PLAN for the season: $$777,777$ with the following monthly sales PLAN percentages: $13\%,15\%,15\%,16\%,24\%,17\%,$

fill in monthly PLAN sales $ and total PLAN $

$2.$ P$6$ EOM PLAN $$452,600$

$3.$Monthly Reductions PLAN are $12\mathrm{.}54\%,12\mathrm{.}48\%,12\mathrm{.}19\%,11\mathrm{.}8\%,11\mathrm{.}65\%,13\mathrm{.}22\%,$

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

$4.$S$-$S ratio PLAN: $3\mathrm{.}68,4\mathrm{.}2,3\mathrm{.}84,2\mathrm{.}8,3,3\mathrm{.}96$

Fill in the planned purchases $(1)$

$5.$ACTUAL sales variance for P$1-$P$3$ are $-13\mathrm{.}23\%,-9\mathrm{.}76\%,-6\%,$

Fill in P$1-$P$3$ ACTUAL sales $ $(1)$

Forecast P$4-$P$6$ ACTUAL sales $ $(1)$

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

$6.$ Complete the BOM & EOM Plan $(1)$

$7.$ Complete average inventory for the season $(6$ months$)(1)$

$8.$ complete inventory turnover for the season $(1)$

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