FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions

Question

=+42. Small business. The director of a small business development center located in a mid-sized city is reviewing data about its clients. In particular, she is interested in examining if the...

Answered: 1 week ago

Question

★★★★★
Jason worked various jobs during his teenage years to save money for college. Now it is his twentieth birthday, and he is about to begin his college studies at the University of South Florida (USF)....

Answered: 1 week ago

Question

★★★★★
Net Work Corporation, whose annual accounting period ends on December 31, issued the following bonds: Date of bonds: January 1, 2015 Maturity amount and date: $230,000 due in 10 years (December 31,...

Answered: 1 week ago

Question

★★★★★
Profits have been decreasing for several years at Pegasus Airlines. In an effort to Improve the company's performance, the company is thinking about dropping several fights that appear to be...

Answered: 1 week ago

Question

★★★★★
Consider the following bi-criteria problem: Prove whether or not the following solutions are efficient: a. X(1) = (0,0,2,18,0) b. X(2) = (0,0,8,0,12) c. X(3) = (0,4,0,20,0) Maximize Minimize Subject...

Answered: 1 week ago

Question

★★★★★
Catch a Wave Company manufactures surfboards. Its standard cost information follows: Catch a Wave has the following actual results for the month of June: Required: Calculate the following for Catch a...

Answered: 1 week ago

Question

★★★★★
Messers Up-to-date Ltd. has instructed you to prepare a cash budget for October to December from the following particulars: (i) Cash and bank balance as on October 1, 20,000. (ii) Actual and budgeted...

Answered: 1 week ago

Question

★★★★★
A CARE warehouse in Tegucigalpa, Honduras holds a variety of humanitarian inventory items such as tents, blankets, kitchen utensils, canned food, pallets of water bottles, and medical kits. Over...

Answered: 1 week ago

Question

★★★★★
Repeat Problem 92 for a diverging mirror. Comment on any similarities or differences with the two types of mirrors. Data from Problem 92 A converging mirror has a focal length of \(300...

Answered: 1 week ago

Previous Question Next Question