Question: Create a range named AE that includes every AvgRev value for Economy cars, and Create a range named AP that includes every AvgRev value for


Create a range named AE that includes every AvgRev value for Economy cars, and Create a range named AP that includes every AvgRev value for Premium cars.

On the third row, below the final row of the data, create a label called Average Quarterly Revenue per Economy Car (Airport).

In the first fully visible cell to the right of the label, calculate the Average Quarterly Revenue per Economy Car (Airport) using the average function and the named range AE

In the next line create a label called Average Quarterly Revenue per Premium

YearQuarterLocationCarClassRevenueNumCars"AvgRev "
2017Q1AirportPremium$349,8523,205$3,205.00
2017Q2AirportPremium$370,1283,487$186,807.50
2017Q3AirportPremium$752,2723,581$377,926.50
2017Q4AirportPremium$496,8403,192$250,016.00
2018Q1AirportPremium$701,4603,787$352,623.50
2018Q2AirportPremium$626,2323,392$314,812.00
2018Q3AirportPremium$665,5483,474$3,474.00
2018Q4AirportPremium$687,8443,327$345,585.50
2019Q1AirportPremium$912,9003,602$458,251.00
2019Q2AirportPremium$561,1243,371$282,247.50
2019Q3AirportPremium$752,7203,581$378,150.50
2019Q4AirportPremium$521,2343,345$262,289.50
2017Q1AirportEconomy$342,1403,267$172,703.50
2017Q2AirportEconomy$422,1924,068$213,130.00
2017Q3AirportEconomy$580,5763,214$291,895.00
2017Q4AirportEconomy$533,7443,576$268,660.00
2018Q1AirportEconomy$486,2523,440$244,846.00
2018Q2AirportEconomy$486,0563,424$3,424.00
2018Q3AirportEconomy$503,2123,287$253,249.50
2018Q4AirportEconomy$555,7683,848$279,808.00
2019Q1AirportEconomy$589,6683,524$3,524.00
2019Q2AirportEconomy$427,3203,947$215,633.50
2019Q3AirportEconomy$650,7653,909$327,337.00
2019Q4AirportEconomy$598,7673,699$3,699.00

Step by Step Solution

★★★★★

3.40 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create the named ranges and calculate the average quarterly revenue per car class you can follow ... View full answer

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!

Q:

Set D - Fill in the below table of Kap values at 25C. Product Barium Chromate Cadmium(II) Carbonate Copper(II) Sulfide Lead(II) Sulfide Nickel(II) Sulfide (alpha phase) Potassium Nitrate (your...

Q:

On 1 July 2040, Freemantle Ltd acquired all the issued shares of Kununurra Ltd for $5,600,000. At this date the equity of Kununurra Ltd consisted of: Share capital Retained earnings General reserve...

Q:

Subsidiary Corporation is a wholly owned subsidiary of Parent Corporation. The two corporations have the following balance sheets: Other Facts: ¢ Parents basis in its Subsidiary stock is...

Q:

Hi, can you prepare this assignment for me, please. it's a presentation about company Coca-Cola Amatil (Australia) base on 3 annual reports and complete all the task requirement...

Q:

Please help with this finance questions and see below necessary attached documents. Dashboards You are presented with a data file that includes sales to date by product, customer type etc. You have...

Q:

Use the Agricultural Time series database on "Excel Databases.xls".Use the variable Broccoli over the first three years of the study (Months 1 - 36 only).Assume Month 1 = January.Develop an estimated...

Q:

a) from the table values below produce a histogram of the Market value b) from the table values below produce Descriptive Statistics for the Market value c) from the table values below produce a...

Q:

Quality improvement, theory of constraints. The Wellesley Corporation makes printed cloth in two departments: Weaving and Printing. Direct material costs are Wellesleys only variable costs. The...

Q:

(1) Assume Shrieves average project has a coefficient of variation in the range of 0.2 to 0.4. Would the new line be classified as high risk, average risk, or low risk? What type of risk is being...

Q:

Develop a regression model to predict deathrate using all the provided variables in the dataset. Interpret the significance of the model and the variables medIncome popEst2015 povertyPercent...

Q:

Check my work Following are selected transactions of Danica Company for 2017 and 2018. 1.25 points 2017 Dec. 13 Accepted a $12,000, 45-day, 6% note dated December 13 in granting Miranda Lee a time...

Q:

Search for 5 examples of Cloud-based Hotel PMS and explain its features and benefits.

Q:

Productivity gains have fueled the expansion of American business over the last 30 years including through several jobless recoveries. A) What are the only two ways to increase productivity?

Q:

Describe how control charts are drawn and used to determine if a process is out of statistical control. Explain the International Standards for quality documentation. Introduction Developing...

Q:

Select two or three of their attributes that Elon Muskshould either immolate or avoid in professional life. Define, cite, and apply these traits. Provide examples from your research, cite your...

Q:

Consider a project in which you are currently involved (or in which you have recently been involved). Describe the two different types of contracts that is available for you to use, and which one...

Q:

Problem 5. ABC bonds are 10-year, 14% coupon bonds and currently have a rating of BBB. You expect big changes for the company over the next year, and you are certain that exactly one year from now...

Q:

Calculate I, , and a for a 0.0175 m solution of Na 3 PO 4 at 298 K. Assume complete dissociation. How confident are you that your calculated results will agree with experimental results?

Q:

Dolphin Ceramics produces large planters to be used in urban landscaping projects. A special earth clay is used to make the planters. The standard quantity of clay used for each planter is 24 pounds....

Q:

Hoffmans Packaging Department had the following information at July 31. All direct ­materials are added at the end of the conversion process. The units in ending work in process inventory were...

Q:

Healthy Start Bakery mass- produces bread using three sequential processing departments: Mixing, Baking, and Packaging. The following transactions occurred during February: 1. Direct materials used...

Q:

The price tags in Angies Flower Shop include the 13% Harmonized Sales Tax (HST). How much HST will she report for a plant sold at $39.55?

Q:

Mr. LeClair and Ms. Bartoli own adjacent hobby farms. They have just received their property tax notices providing the following assessment and tax information: The regional government applies one...

Q:

Marichka bought five litres of milk and four dozen eggs for $19.51. Lonnie purchased nine litres of milk and three dozen eggs for $22.98. What were the prices for a litre of milk and a dozen eggs?