Question: 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

 This project only has one attempt. Review the check figures withyour data file results before answering the questions. If your check figures

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 data worksheet for Requirement 1 in Kitchen Accessories, what is the gross profit for customer number 291137 on 1/18/2015? (To find customer 291137 in Excel, in the Home ribbon, click on Find \& Select and choose the option to Find.) A. $3,906.98 B. $1,982.40 C. $1,331.71 D. $5,889.38 Using the pivot table you created for Requirement 2 in Kitchen Accessories, what were total sales for 2016 in the International region? A. $12,684,022.13 B. $1,982,322.11 C. $19,427,495.57 D. $21,271,784.69 Using the pivot table you created for Requirement 3 in Kitchen Accessories, what was the gross profit in 2015? A. $37,062,004.00 B. $63,170,404.83 C. $45,346,392.10 D. $55,387,207.02 Using the pivot table you created for Requirement 4 in Kitchen Accessories, what was the most profitable brand in 2018, as measured by gross profit? A. Classique B. Au Courant Using the pivot table you created for Requirement 5 in Kitchen Accessories, what was the most profitable collection in 2018, for the Classique brand as measured by the gross profit percentage? A. Syracuse B. Key West C. Rochester D. Aiden Using the pivot table you created for Requirement 6 in Kitchen Accessories, which region was the most profitable in 2018, as measured by the gross profit percentage? A. Atlantic Northeast B. Pacific Northwest C. Great Plains D. Mid Atlantic E. Southwest F. International G. Intermountain H. Gulf Coast 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 data worksheet for Requirement 1 in Kitchen Accessories, what is the gross profit for customer number 291137 on 1/18/2015? (To find customer 291137 in Excel, in the Home ribbon, click on Find \& Select and choose the option to Find.) A. $3,906.98 B. $1,982.40 C. $1,331.71 D. $5,889.38 Using the pivot table you created for Requirement 2 in Kitchen Accessories, what were total sales for 2016 in the International region? A. $12,684,022.13 B. $1,982,322.11 C. $19,427,495.57 D. $21,271,784.69 Using the pivot table you created for Requirement 3 in Kitchen Accessories, what was the gross profit in 2015? A. $37,062,004.00 B. $63,170,404.83 C. $45,346,392.10 D. $55,387,207.02 Using the pivot table you created for Requirement 4 in Kitchen Accessories, what was the most profitable brand in 2018, as measured by gross profit? A. Classique B. Au Courant Using the pivot table you created for Requirement 5 in Kitchen Accessories, what was the most profitable collection in 2018, for the Classique brand as measured by the gross profit percentage? A. Syracuse B. Key West C. Rochester D. Aiden Using the pivot table you created for Requirement 6 in Kitchen Accessories, which region was the most profitable in 2018, as measured by the gross profit percentage? A. Atlantic Northeast B. Pacific Northwest C. Great Plains D. Mid Atlantic E. Southwest F. International G. Intermountain H. Gulf Coast

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!