80.2K

Verified Solution

Link Copied!

\begin{tabular}{|l|r|r|r|r|} \hline \multicolumn{1}{|c|}{ Distribution channel } & Units & \multicolumn{1}{|c|}{ Price } & Total sales \\ \hline Web sales: Company website & 800 & $ & 1.50 & \\ \hline Retail stores & 1,500 & $ & 3.50 & \\ \hline Web sales: Amazon.com & 1,200 & $ & 2.00 & \\ \hline Wholesale clubs & 1,200 & $ & 1.30 & \\ \hline Total & & & & \\ \hline & & & & \\ \hline Details for Web sales: & & & \\ \hline Total Web sales in units & & & \\ \hline Total Web sales in dollars & & & \\ \hline Average Web sales per unit & & & \\ \hline Retail compared to Wholesale: & & & \\ \hline Difference in units & & & \\ \hline Difference in total sales dollars & & & \\ \hline \end{tabular} This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the Excel file you created, what are the total sales? A. $3,600.00 B. 4,700 C. $10,410.00 D. $1,560.00 Using the Excel file you created, what are the total unit sales from the Web distribution channels? A. 4,700 B. 1,200 C. 2,000 D. 800 Using the Excel file you created, what are the total dollar sales from the Web distribution channels? A. $3,600.00 B. $10,410.00 C. $2,400.00 D. $1,200.00 Using the Excel file you created, what are the average Web sales per unit? A. $2.00 B. $2.21 C. $1.80 D. $1.50 Using the Excel file you created, what is the difference between the retail store units and the wholesale club units? A. 300 B. 1,200 C. 2,000 D. 1,500 Using the Excel file you created, what is the difference between the retail store total sales dollars and the wholesale club total sales dollars? A. $1,560.00 B. $5,250.00 C. $1,200.00 D. $3,690.00

Answer & Explanation Solved by verified expert

See Answer