Question: 3. Now you try it 1. Click cell E14 , click the Data tab , click the What-If Analysis button , and then click Goal

3. Now you try it

1. Click cell E14, click the Data tab, click the What-If Analysis button, and then click Goal Seek.

2. Click the To value box, type 4,637,500, click the By changing cell box, click cell E13, and then click OK twice.

What is the average price per trip if Quest sells 12% business trips?

What is the future revenue from sales if Quest sells 12% more trips?

3. Now you try it 1. Click cell E14, click the Data

E14 A B D E F G H Quest Specialty Travel Your Name 2 Revenue Scenarios Scenario 1: Add 500 business trips Future Sales Current Sales 6 Trips sold 3000 Trips sold 3500 7 Average price per trip 1,000 Average price per trip 1,325 8 Revenue 3,000,000 Revenue 4,637,500 10 Scenario 2: Sell 12% more trips Future Sales Current Sales 11 12 Trips sold 3360 3000 Trips sold 13 Average price per trip 1,000 Average price per trip s 3,000,000 Revenue L 14 Revenue 15 16 18 19 20 E14 A B D E F G H Quest Specialty Travel Your Name 2 Revenue Scenarios Scenario 1: Add 500 business trips Future Sales Current Sales 6 Trips sold 3000 Trips sold 3500 7 Average price per trip 1,000 Average price per trip 1,325 8 Revenue 3,000,000 Revenue 4,637,500 10 Scenario 2: Sell 12% more trips Future Sales Current Sales 11 12 Trips sold 3360 3000 Trips sold 13 Average price per trip 1,000 Average price per trip s 3,000,000 Revenue L 14 Revenue 15 16 18 19 20

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

2. Get ready Use spreadsheet software to open the WhatIf file. 3. Now you try it 1. Click cell E14 , click the Data tab , click the What-If Analysis button , and then click Goal Seek . 2. Click the...

Use Spreadsheet software. 1. Click cell E14, click the Data Tab, click the What-If Analysis button, and then click Goal Seek. 2. Click the To value box, type 4,637,500, click the By changing cell...

They require investments of $500,000 today and $200,000 a year from now. They guarantee returns in the following years: Year 2: $125,000 Year 3: $150,000 Year 4: $250,000 Year 5: $300,000 You also...

I need help on this one. Thank you Office 2013 - myitlab:grader - Instructions Exploring Series Vol. 2 Templates, Styles, and, Macros Project Description: As the department head of the Information...

EXCEL WORK , I need majorHELP !! Even if it is a differnet name , i just need help doing it! Analysis_Ingraham). 2. Create a footer with your name on the left side, the sheet name code in the center,...

I'm on #3 and kinda stuck. I've googled the steps and it isn't helping. Could you show me how to solve these? PROJECT STEPS Charlie is a salesman at Pick Up Motors car dealership. He is performing a...

The tieps you will follow for thin project are as folow: 1) Downiload the Excel chatu fle 2 Click on the Video button on the bothom left or within the Get More Help mena for this cuestion how. This...

Using the accompanying Retirement_Calculator spreadsheet model, Claire wants to use Scenario Manager to compare the following retirement saving scenarios: Click here for the Excel Data File Scenario...

Using the essential elements ( format your formulas, use cell references, Double-check your mathematical operators and order, simplify with functions) Review the information abiut prospective...

Please explain each step im having a hard time understanding where I am going wrong. \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\...

Part C Table Write complete equation for the reaction that occurs when the two solutions are mixed. Express your answer as a chemical equation. Identify all of the phases in your answer. in AX ?...

Characteristics that are unique to multiple birth children include: They function with more dependence and need more parental attention OA. OB. Display less sibling rivalry than other types of...

Null Identity II grad * g r a d vec ( A ) = 0

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

to promote and effect the cohesion of the organization: the corporate glue.

to facilitate a cultural and functional interchange in order to encourage managers to take a fresh look at problems and issues;

to gain top management involvement by ensuring that managers know the global resources of the organization;