Question: The question is 1-Using the IF function calculate OverHead automatically as 40% of the revenue for economy car and 60% of the revenue for premium

The question is

1-Using the IF function calculate OverHead

automatically as 40% of the revenue for economy car and 60% of the revenue for premium car. Do calculate each one individually

please provide the formula clearly

The question is 1-Using the IF function calculate

CarClass Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Economy Premium Revenue NumCars OverHead $342.140 3.2671 $349 852 3.205 $343,252 3.705 $351,060 34771 $422.192 4,068 $370.128 3.487 $455,4241 4.800l $296.120 2.897 $580.576 3.214 $752 272 3.581 $504,800 4.2001 $471.816 3.500 $533.744 3.5761 $496 840 3.192 $582.504 3.350 $619,900 3,199 $486.252 3 440 $701 460 3.787 $415.016 3.430 $552,324 3,629 $486.056 3.424 $626 2321 3,392 $488,588 3,551 $585,156 3.4401 $503 212 3.287 $665,548 3.474 $483.256 3.5151 $643, 168 3.493 $555.768 3.848 $687 844 3.3271 $421,120 $527 900 3.371 $589.6683.524 $912.900 36021 $422 288 3.613 $663 276133271 $427 320 3.947 $561,124 3.371 $321,768 3.524 $674,67213,602 $650.765 3.909 $752.720 3.581 $598.543 4 543 $521 2311 3,7651 $598.767 3.699 $521 234 325 $592.345 3.768 $678 655 3.754) 26 27 28 30 34 41

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 General Management Questions!

The question is 1-Using the IF function calculate OverHead automatically as 40% of the revenue for economy car and 60% of the revenue for premium car. Do calculate each one individually 2 4 5 6...

Using the IF function calculate cost automatically as 40% of the revenue for economy car and 60% of the revenue for premium car. Do not calculate each one individually. Calculate profit as Revenue...

Prepare a summary of the auto industry by reviewing the attached report. Then compare these two companies, Group 1 Auto and Sonic Automotive. Base on a review of the two companies financial...

Year Quarter Location CarClass Revenue NumCars 2018 Q2 Airport Premium 303242 1933 2018 Q2 Airport Hybrid 303607 1982 2018 Q2 Airport SUV 303199 2027 2019 Q2 Airport Economy 368286 2153 2018 Q1...

Excel Project 1 - MS Excel (Spring 2020) Use the following project description to complete this activity (all the details are included in this document, in the 22 steps below) For a review of the...

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Question 1 (1 point) Which of the following statements describes Black Fly's process costing system? Question 1 options: Direct materials and direct labour are traced to each specific order. The...

This is the sorted data, as asked in question 10. Step Requirement In the Data worksheet: a. Create an Excel table with the recently imported data. b. Pick a style with the styles group to format the...

Excel Project 1 MS Excel Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title...

An insulated rigid tank initially contains 1.4-kg saturated liquid water at 200oC and air. At this state, 25 percent of the volume is occupied by liquid water and the rest by air. Now an electric...

Why does it make sense to choose the absolute value here Are we looking for gender composition being male-female dominant OR the magnitude of differences in gender composition. Explain?

The Shoe Box is conyldering adding a new line of winter footwear to its product lineup. When analyaing the vability of this addition, the include all the following in its anelysis with the exception...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...