Questions

Complete the spreadsheet on the worksheet provided,

inputting the stock$-$sales ratio and the purchases. Are you

satisfied with your $6-$month plan?

Review the notes and decide if Heather took the

information into account. Use the highlighted line under

each element on page $2$ of the Excel worksheets provided to

show how you would revise the flow to reflect the notes

better.

Summarize your suggested adjustments and support your

conclusions on page $3$ of the Excel worksheets provided.

Be succinct $-$ be logical in your responses.

To Consider

$1.$ The company is adding a new major sale event to the month of September

$2.$ On the $4-5-4$ calendar, Christmas is one day earlier in the week $($does this affect sales?$)$

$3.$ The direction from upper management is that old season goods should be cleared out in August and January

$4.$ Last year, because of poor receipt flow from vendors, August and September were under$$receipted to plan and October was over receipted to plan

$5.$ The most current OTB projection shows July EOM at $$950,000.$