Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The steps you will follow for this project are as follows: 1) Download the Excel data file. 2) Click on the Video button on the

The steps you will follow for this project are as follows: 1) Download the Excel data file. 2) Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step-by-step 3) Perform the requirements on the data file. 4) Check your work in the Excel file with these Check founta 5) Use your Excel fle to answer the four multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365 B) If you do not have Office 365, click here to learn how to get it for free C) Troubleshooting FAQ 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 a your instructor. Using the Excel file you created for Thunder, what is the gross profit percentage for book fairs in year 27 OA 38% OB. 30% OC. 31% OD. 36% Using the Excel file you created for Thunder, what is the gross profit percentage for wholesalers in year 87 OA 42% OB. 34% OC. 37% Op. 36% Clear all Sales Revenue Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Subscription boxes S 755,984 $ 738,944 $ 765,884 $ 795,837 $ 766,202 $ 745,938 $ 734,115 $ Year 8 722,404 Sparklines Book fairs $ 677,459 $ 725,889 $ 698,221 $ 736,948 $ 775,997 $ 799,202 $ 814,509 $ 835,974 Company website 313,205 $ 299,884 $ 325,847 $ 348,678 $ 322,661 $ 375,849 $ Wholesalers $ 412,551 $ 422,558 $ 404,613 $ 418,976 $ 401,223 $ 399,875 $ 402,551 422,608 $ $ 429,759 412,847 Gross Profit Subscription boxes $ 300,060 $ 301,932 $ 307,198 $ 303,658 $ 312,106 $ 310,755 $ 317,587 $ 319,896 Book fairs $ 256,453 $ 259,467 $ 266,266 $ 268,678 $ 266,774 5 278,252 5 281,011 $ 283,018 Company website $ 131,496 $ 137,262 $ 141,501 $ 145,967 $ 148,868 5 141,664 5 149,406 $ 159,806 Wholesalers $ 123,814 $ 123,632 $ 127,600 $ 131,525 $ 138,191 5 142,130 5 153,716 $ 173,473 Gross Profit % Subscription boxes Book fairs Company website Wholesalers Check Figures R1 Wholesalers Gross Profit Percentage in year 1 R2 Book fairs Gross Profit Percentage in year 5 R3 Gross Profit Percentage Subscription boxes Print Done 30% 34% Trending up - X u through t Figures do now Using the Excel file you created for Thunder, which distribution channel(s) is trending upward in sales revenue over the eight-year time period? OA. Subscription boxes, Company website, Wholesalers OB. Subscription boxes, Wholesalers OC. Subscription boxes, Book fairs, Company website, Wholesalers OD. Book fairs, Company website Using the Excel file you created for Thunder, which distribution channel(s) is trending upward in gross profit over the eight-year time period? OA. Subscription boxes, Wholesalers OB. Book fairs, Company website OC. Subscription boxes. Company website, Wholesalers OD. Subscription boxes, Book fairs, Company website, Wholesalers

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

Step: 3

blur-text-image

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

Cima Learning System Management Accounting Performance Evaluation Edition

Authors: Robert Scarlett

4th Edition

0750684305, 978-0750684309

More Books

Students also viewed these Accounting questions

Question

=+7 How has the COVID-19 pandemic impacted the operations of IHRM?

Answered: 1 week ago