Table $1$: Period $2$ Model Stock Plan

Create a table in Excel that shows your model stock plan for Period $2.$ Planned purchases of shorts for Period $2$ are $$750,000.$

Allocate $32\mathrm{.}75\%$ of the total planned purchases to the $$25$ price point. Allocate $67\mathrm{.}25\%$ of the total planned purchases to the $$35$ price point. Then, convert from dollars within each price point to number of units within each price point. $(1$ point for correct answers$)$

Notice that you need to consider geography in this model stock plan. There are two geographies: $1)$ Utah and $2)$ all other regions.

Of those units retailed at $$25$dots $(0\mathrm{.}5$ point for correct answer$)$

$2\mathrm{.}88\%$ are required for Utah stores $($more conservative market$)$

$97\mathrm{.}12\%$ are required for stores for all other regions

Of those units retailed at $$35$dots $(0\mathrm{.}5$ point for correct answer$)$

$2\mathrm{.}88\%$ are required for Utah stores $($more conservative market$)$

$97\mathrm{.}12\%$ are required for stores for all other regions

Now that you know how many $$25$ price point shorts will be allocated to the two different geographies and how many $$35$ price point shorts will be allocated to the two different geographies...

Decide on what percentage of shorts within each price point and geography will be $2\mathrm{.}5"$ inseam, $3\mathrm{.}5"$ inseam, $5"$ inseam, and Bermuda. The percentages you choose for "Utah" versus "all other regions" must be logical $($Utah has a more conservative market$).$

Once you have determined the percentages, calculate the number of units of $2\mathrm{.}5"$ inseam, ${3\mathrm{.}5}^{\text{'}\text{'}}$ inseam, $5^n$ inseam, and Bermuda that should be allocated to "Utah" versus "all other regions." $(0\mathrm{.}25$ point based on correct math and $0\mathrm{.}25$ point for logic$).$