Simulation To start the simulation, review all communication and documents. You will find key information to assist your success in the simulation. Actual Demand in Previous Months 15K MAPE: 0% Demand 10K 5K Regular Midgrade 0% 0% 0 January 2025 (24 Month Remaining) ՈՐ AUG o Make a Forecast Current Decision Past Decision Forecast for January 2025 Sept Month Range 00 Oct Nov Dec Use Al REGULAR ↓ 0 t Gallons (3 chances) MIDGRADE 1 Gallons Forecast demand can not be less than 100! Answer Price Prediction: M Possible increase in January 2025 Regular + Midgrade

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 9P
icon
Related questions
Question

(All info i was given, i simplified it)

 

Gas sales across type: 80% of gas sales tend to be regular. 15% midgrade, 5% tend to be premium. $0.10 increase in price per gallon tends to decrease gallons sold by 1 to 3%. Jan-0.87, Feb-0.95, Mar-1.00, Apr-1.05, May-1.08, Jun1.15, Jul-1.13, Aug-1.07, Sep-1.02, Oct-0.94, Nov-0.89, Dec-0.85.

You want the MAPE to be below 20%, if ypu can get it to or below 10% they'll throw in extra $10k bonus. They wont get bonus if it is above 11% or 20%. It cannot be over 20%. 

 

Forecast for January 2025 and 

Simulation
To start the simulation, review all communication and documents. You will find key information to assist your
success in the simulation.
Actual Demand in Previous Months
15K
MAPE: 0%
Demand
10K
5K
Regular Midgrade
0%
0%
0
January 2025
(24 Month Remaining)
ՈՐ
AUG
o Make a Forecast
Current Decision
Past Decision
Forecast for January 2025
Sept
Month Range
00
Oct
Nov
Dec
Use Al
REGULAR
↓
0
t
Gallons
(3 chances)
MIDGRADE
1
Gallons
Forecast demand can not be less than 100!
Answer
Price Prediction: M
Possible increase in January
2025
Regular
+ Midgrade
Transcribed Image Text:Simulation To start the simulation, review all communication and documents. You will find key information to assist your success in the simulation. Actual Demand in Previous Months 15K MAPE: 0% Demand 10K 5K Regular Midgrade 0% 0% 0 January 2025 (24 Month Remaining) ՈՐ AUG o Make a Forecast Current Decision Past Decision Forecast for January 2025 Sept Month Range 00 Oct Nov Dec Use Al REGULAR ↓ 0 t Gallons (3 chances) MIDGRADE 1 Gallons Forecast demand can not be less than 100! Answer Price Prediction: M Possible increase in January 2025 Regular + Midgrade
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning