Developer: Cliff Welborn

$4.$ Note only: The Sales data you have been given covers $21$ days. We will assume these stores are open $365$ days per year.

A

Instruction Steps

In column K of POS identify the store State for each transaction $($store locations are found in Store Location tab$).$ You will have to do some work on this page to g

In POS, Create a Pivot Table $($no chart$)($starting in cell M$13)$ detailing the KY Stores & the total Qty of each item sold

Note only: At this point you have a table detailing the qty of each item sold in KY over a $21$ day period.

Note only: The Sales data you have been given covers $21$ days. We will assume these stores are open $365$ days per year.

On Turns & Days populate the Sold Qty for each item

Using On Hand Inventory for Kentucky, determine the Inventory Turnover Ratio and Days on Hand for each item.

Sort by Psku

Insert a column in B titles Description and populate it with the product Descriptions.

Conditionally format the Days column to items with

less than $7$ days on hand $=$ yellow

between $7$ and $42$ days on hand $=$ green

more than $42$ days on hand $=$ red

$($Sample output from Turns & Days is below$)$

Copy & Paste Values of the entire Turns & Days page onto itself to remove all formulas and lookups