Answered step by step
Verified Expert Solution
Link Copied!

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 Inchesimage text in transcribed

\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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

What are you curious about regarding Sooki?

Answered: 1 week ago