Question: I need help calculating the total planned dollars, unit sales, and classification % to total sales volume Example Attached Below: begin{tabular}{|l|r|r|l|r|} hline Classification name &

I need help calculating the total planned dollars, unit sales, and classification % to total sales volume
Example Attached Below:

\begin{tabular}{|l|r|r|l|r|} \hline Classification name & TotalPlannedDollarSalesbyclass & AverageUnitRetailperclassification & UnitSalesbyclassification & Classification%tototalSalesvolume \\ \hline 1. Trench Coat & $3,500,000.00 & $200.00 & 17,500 & \\ \hline 2. Puffer Coat & $2,500,000.00 & $69.90 & 35,765 & 25% \\ \hline 3. Teddy Coat & $2,000,000.00 & $150.00 & 13.333 & \\ \hline 4.AviatorJacket5.Poncho & $1,500,000.00 & $140.00 & 10,714 & \\ \hline Totalsales$10,000,000 & $500,000.00 & & 5,556 & \\ \hline \end{tabular} \begin{tabular}{|l|r|r|l|r|} \hline Classification name & TotalPlannedDollarSalesbyclass & AverageUnitRetailperclassification & UnitSalesbyclassification & Classification%tototalSalesvolume \\ \hline 1. Trench Coat & $3,500,000.00 & $200.00 & 17,500 & \\ \hline 2. Puffer Coat & $2,500,000.00 & $69.90 & 35,765 & 25% \\ \hline 3. Teddy Coat & $2,000,000.00 & $150.00 & 13.333 & \\ \hline 4.AviatorJacket5.Poncho & $1,500,000.00 & $140.00 & 10,714 & \\ \hline Totalsales$10,000,000 & $500,000.00 & & 5,556 & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
