Set up a six$-$month plan by using the following data from a gift store during the Fall$-$Winter season by hand:

Planned Sales of $$1,800$ thousand

Monthly $\%$ distribution of sales: $12\mathrm{.}20\%,13\mathrm{.}00\%,15\mathrm{.}46\%,18\mathrm{.}08\%,30\mathrm{.}02\%,$ and $11\mathrm{.}24\%($from August to Jan.$)$

Reduction $\%$ for each month: $2\mathrm{.}12\%,2\mathrm{.}64\%,2\mathrm{.}82\%,3\mathrm{.}02\%,4\mathrm{.}80\%,$ and $2\mathrm{.}40\%$

Stock$-$Sales ratios from the same period of last year: $3\mathrm{.}78,4\mathrm{.}24,4\mathrm{.}76,3\mathrm{.}26,3\mathrm{.}02,4\mathrm{.}22$

Jan EOM$ $$920$ thousand

IMU:$58\%$

Set up Expanded P&L based on the above, using $40\%$ for operation expenses.

Calculate Average Stock, Inventory Turnover Rate, and GMROI for the season.

Set up a six$-$month plan by using the following data from a gift store during the Fall$-$Winter season by hand:

Planned Sales of $$1,800$ thousand

Monthly $\%$ distribution of sales: $12\mathrm{.}20\%,13\mathrm{.}00\%,15\mathrm{.}46\%,18\mathrm{.}08\%,30\mathrm{.}02\%,$ and $11\mathrm{.}24\%($from August to Jan.$)$

Reduction $\%$ for each month: $2\mathrm{.}12\%,2\mathrm{.}64\%,2\mathrm{.}82\%,3\mathrm{.}02\%,4\mathrm{.}80\%,$ and $2\mathrm{.}40\%$

Stock$-$Sales ratios from the same period of last year: $3\mathrm{.}78,4\mathrm{.}24,4\mathrm{.}76,3\mathrm{.}26,3\mathrm{.}02,4\mathrm{.}22$

Jan EOM$ $$920$ thousand

IMU:$58\%$

Set up Expanded P&L based on the above, using $40\%$ for operation expenses.

Calculate Average Stock, Inventory Turnover Rate, and GMROI for the season.

Continue from above by using the Excel method: changing the reduction rate for each month in the above by subtracting $0\mathrm{.}5\%$ and see how lowering reduction impacts OTB on both retail and cost levels.