Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 & $
\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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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