Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Quality Audits For Improved Performance

Authors: Dennis R. Arter

3rd Edition

0873895703, 978-0873895705

More Books

Students also viewed these Accounting questions