Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If someone can assist in entering the orange data for below. Percentage of Total Inches (Full Assortment) Percentage of Total Facings (Full Assortment) Total Capacity
If someone can assist in entering the orange data for below.
Percentage of Total Inches (Full Assortment)
Percentage of Total Facings (Full Assortment)
Total Capacity
Weeks of Holding Capacity
Pack down Frequency (in days)
Percent of Total Sales
Difference Between Percent of Total Sales and Percent of Total Facings
Difference Between Percent of Total Sales and Percent of Total Inches
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Store & SKU \# & SKU Description & \begin{tabular}{c} Position \\ Width in \\ Inches \\ (Total SKU \\ facings \\ are \\ accounted \\ for) \end{tabular} & \begin{tabular}{c} % of Store \\ Total \\ (Inches) \end{tabular} & \begin{tabular}{c} \# of SKU \\ Facings \end{tabular} & \begin{tabular}{c} % of Store \\ Total \\ (Facings) \end{tabular} & \begin{tabular}{c} Capacity \\ per Facing \end{tabular} & \begin{tabular}{c} Total \\ Capacity \end{tabular} & \begin{tabular}{l} Sales \\ Units \end{tabular} & \begin{tabular}{c} APSW \\ Units \end{tabular} & \begin{tabular}{c} Weeks of \\ Holding \\ Capacity \end{tabular} & \begin{tabular}{c} Packdow \\ n \\ Frequency \\ (Days) \end{tabular} & Sales \$ & \begin{tabular}{c} % of Total \\ Sales \end{tabular} & \begin{tabular}{c} Difference \\ Between \\ % of Total \\ Sales &% \\ of Total \\ Facings \end{tabular} & \begin{tabular}{l} Difference \\ Between \\ % of Total \\ Sales \& \% \\ of Total \\ Inches \end{tabular} \\ \hline 1 & 207585 & HDX 27 GALLON TOUGH TOTE & 38.00 & & 2 & & 14 & & 235,000 & 75.00 & & & \#\#\#\#\# & & & \\ \hline 1 & 1001075212 & HDX 55 GALLON TOUGH TOTE & 19.80 & & 1 & & 9 & & 30,000 & 9.00 & & & \#\#\#\#\# & & & \\ \hline 1 & 1005554889 & HDX 70 GALLON TOUGH TOTE WITH WHEELS & 23.92 & & 1 & & 3 & & 12,000 & 4.50 & & & \#\#\#\#\# & & & \\ \hline 1 & 1002351566 & HDX 38 GALLON TOUGH TOTE & 22.00 & & 1 & & 11 & & 25,000 & 11.50 & & & \#\#\#\#\#\# & & & \\ \hline 1 & 1001669661 & 64QT LATCHING BOX - WHITE & 15.00 & & 1 & & 5 & & 39,500 & 16.00 & & & \#\#\#\#\# & & & \\ \hline & Store 1 Total & & 118.72 & 0.00% & 6 & 0.00% & 41 & 0 & 106500 & 116 & 0 & 0 & \#\#\#\#\#\# & 0.00% & 0.00% & 0.00% \\ \hline 2 & 207585 & HDX 27 GALLON TOUGH TOTE & 19.00 & & 1 & & 14 & & 300,000 & 100.00 & & & \#\#\#\#\#\# & & & \\ \hline 2 & 1001075212 & HDX 55 GALLON TOUGH TOTE & 19.80 & & 1 & & 9 & & 50,000 & 20.25 & & & \#\#\#\#\# & & & \\ \hline 2 & 1005554889 & HDX 70 GALLON TOUGH TOTE WITH WHEELS & 47.84 & & 2 & & 3 & & 13,000 & 4.00 & & & \#\#\#\#\# & & & \\ \hline 2 & 1002351566 & HDX 38 GALLON TOUGH TOTE & 22.00 & & 1 & & 11 & & 25,000 & 10.00 & & & \#\#\#\#\# & & & \\ \hline & Store 2 Total & & 108.64 & 0.00% & 5 & 0.00% & 36 & 0 & 388,000 & 250 & 0.00 & 0.00 & \#\#\#\#\#\# & 0.00% & 0.00% & 0.00% \\ \hline 3 & 207585 & HDX 27 GALLON TOUGH TOTE & 19.00 & & 1 & & 14 & & 225,000 & 55.00 & & & \#\#\#\#\# & & & \\ \hline 3 & 1001075212 & HDX 55 GALLON TOUGH TOTE & 19.80 & & 1 & & 9 & & 26,550 & 18.00 & & & \#\#\#\#\# & & & \\ \hline 3 & 1005554889 & HDX 70 GALLON TOUGH TOTE WITH WHEELS & 23.92 & & 1 & & 3 & & 11,500 & 3.25 & & & \#\#\#\#\# & & & \\ \hline 3 & 1002351566 & HDX 38 GALLON TOUGH TOTE & 22.00 & & 1 & & 11 & & 12,500 & 8.75 & & & \#\#\#\#\#\# & & & \\ \hline & Store 3 Total & & 84.72 & 0.00% & 4 & 0.00% & 36 & 0 & 275,550 & 335 & 0.00 & 0.00 & \#\#\#\#\#\# & 0.00% & 0.00% & 0.00% \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started