# Demand Forecast - You will build a variety

Question # 00838427 Posted By: wildcraft Updated on: 02/10/2023 01:44 AM Due on: 02/10/2023
Subject Economics Topic General Economics Tutorials:
Question

Demand Forecast

The purpose of this assignment is to help you practice skills that are essential to success in this course and your professional life after graduation. You will conduct a forecast. Almost all decisions by managers involve a forecast.

You will build a variety of skills. For this assignment, you will seek out quality data, choose a time horizon, select a forecasting technique, make the forecast, and critique the goodness of fit in the regression equation. Additionally, you will build general education skills, critical thinking, communication, and information literacy.

Forecast - Conduct a forecast by choosing and using simple regression analysis given data as an input, and evaluate the forecast result by the criteria of the regression equation.

Use the following scenario and data:

· Scenario - FlyHigh airlines is test marketing their boxed snacks sold on their short flights. FlyHigh selected 15 different markets for a quarter-long sales test. For the entire quarter, the boxed snack was sold onboard at 4 different prices starting at \$8.50 a box. Data was collected on the average income of the passenger aboard the flights. Data was also collected that represented a snack purchased off-board (presumably in the airport) and carried on by the passenger. The amount of passengers that this boxed snack was available to and the ultimate quantity sold was also collected.

Forecast Data can be found in the attachment section

· What is your selected linear demand function given the variables presented? (hint: Qd = x + y + z + q….)

· What is the estimated linear demand function (Q = ….)?

· What percentage of the variation in sales (Q) is explained by the demand function?

· What if the price of the boxed lunch sold on board was increased by \$2?

· If a typical market sold a boxed snack at \$8.75, their average income was \$80,378, the off-board priced snack was \$7.50, and the population was 6,378, what is the expected sales?

· Given this information, as a manager, make a recommendation to FlyHigh airlines on the price of their boxed snacks.

## Sheet1

 flight market Price of snack sold on airplane average income of passenger price of snack (presumably carried by passenger) amount of passengers available quantity sold 1 8.5 75586 8.75 274000 7952 2 8.5 67521 8.5 13450 8222 3 8.5 71333 7.64 54150 7166 4 8.75 77352 7.35 6800 6686 5 8.75 41450 7.75 11245 7715 6 8.75 57655 8.15 54500 6643 7 9 60265 8.55 26600 5155 8 9 69542 8 158000 7127 9 9 71596 7.75 22500 5834 10 9.25 72657 7.45 46150 5093 11 9.25 66421 7.89 8200 5828 12 9.25 77624 7.49 38500 6590 13 9.5 80110 8.15 105000 6228 14 9.5 87421 7.8 92000 7218 15 9.5 88450 7.9 38720 5846
Tutorials for this Question
1. ## Solution: Demand Forecast - You will build a variety

Tutorial # 00833887 Posted By: wildcraft Posted on: 02/10/2023 01:45 AM
Puchased By: 2
Tutorial Preview
The solution of Demand Forecast - You will build a variety...
Attachments
Demand_Forecast_-_You_will_build_a_variety.ZIP (18.96 KB)

Great! We have found the solution of this question!