Question: Task 3 Use the information in the green lookup table to calculate the blue area using the Vlookup function Group Name Group Segment Revenue Expenses

Task 3
Use the information in the green lookup table to calculate the blue area using the Vlookup function
Group Name Group Segment Revenue Expenses Net Income/Loss Region Region Avg.Sales Region Region Avg.Sales
Postcards Store Big 8249.32767 594.878242 7654.4494 N N $17,116
Randles Roadshack Small 6557.872983 83.33938597 6474.5336 S S $17,807
Examineers Inc Medium 6180.035747 551.2667804 5628.769 E E $14,296
Buttersworth Co Small 9915.454311 336.8576784 9578.5966 W W $11,956
FASST Trax Small 4047.669178 481.0083009 3566.6609 SE NE $10,746
Hula Hoopers Big 4797.087505 962.3550943 3834.7324 NE SE $18,944
Hehehe Medium 6537.800101 931.9697248 5605.8304 N
Marleyville Tea Small 3151.422775 848.213517 2303.2093 S
Creepy Lada Medium 9504.781827 827.5632244 8677.2186 E
Jokes R Us Big 9378.14047 566.7976536 8811.3428 W
Petie's Palace Small 6772.133042 436.8799836 6335.2531 SE
Ramone's Castle Big 48922666.99 41584266.94 7338400 NE

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 Databases Questions!

Q:

answer the all question please equired Homework Questions The concept of earnings power is the long-term (3 to 5 year) expectation of the company's earnings after any near-term anomalous behavior has...

Q:

answer the all question please equired Homework Questions The concept of earnings power is the long-term (3 to 5 year) expectation of the company's earnings after any near-term anomalous behavior has...

Q:

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

Q:

I have attached pictures of the project instructions in excel. Please help. Thank you so much DETAILED ASSIGNMENT REQUIREMENTS The the Chart of Accounts, below, shows the balances in GBI accounts as...

Q:

COMPANY OVERVIEW Headquartered in Canton, Ohio, The Timken Corporation was a worldwide producer of anti- friction bearings and steel. The company's businesses were organized into three segments:...

Q:

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

Q:

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

Q:

See Project 03-01 Assignment Spring 2015.docx Please Help me on this homework i am having some trouble answering it. Product SAP ERP GBI Release 6.04 Level Undergraduate Graduate Focus...

Q:

1. Welfare analysis: Basic concepts Identify whether each of the following statements best illustrates the concept of consumer surplus, producer surplus, or neither. Consumer Producer Statement...

Q:

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Q:

Chatterbox Incorporated has a fiscal year-end of December 31, 2020. On January 1, 2020, the company had the following information for their CCA classes: of Class 1- The buildings in Class 1 were...

Q:

A 2.4156-g sample of PCl5 was placed in an empty 2.000- L flask and allowed to decompose to PCl3 and Cl2 at 250.0oC: PCl5(g) PCl3(g) + Cl2(g) At equilibrium the total pressure inside the flask was...

Q:

A manufacturer's production budget shows 3 , 4 8 0 units to produce in April, and 3 , 6 8 0 units to produce in Msy . Each finished unit requires 6 pounds of direct materials and 2 direct labor...

Q:

Question 2 0 ( 1 point ) For SEO and paid search, the best way to improve ranking is to: never click on competitor sites place the highest C P C bid Purchase as many key words as possible Publish...

Q:

Based on Oprah Winfreys media persona as revealed in the case, which of the Big Five Dimensions of Traits does she score high on in your opinion (Chapter 2)?

Q:

Do you agree that women are more emotional than men? Do they show greater emotional expression, experience emotions more intensely, express both positive and negative feelings (except anger) more...

Q:

Some might argue that H&Ms failure to communicate began first within the firm. Explain how the firms structure might have led to this failure.