Forecasting 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) Demand Jul AUG o Make a Forecast Current Decision Past Decision Forecast for January 2025 REGULAR L 0 MIDGRADE 0 Sept Forecast demand can not be less than 100! Month Range Nov Dec Use Al Gallons (3 chances) 1 Gallons Answer Price Prediction: Possible increase in January 2025 6 Months 44 >> Regular + Midgrade

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....
icon
Related questions
Question

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. Wont get bonus if it is above 11% or 20%. It cannot be over 20%. 

 

Forecasting
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)
Demand
Jul
AUG
o Make a Forecast
Current Decision
Past Decision
Forecast for January 2025
REGULAR
L
0
MIDGRADE
0
Sept
Forecast demand can not be less than 100!
Month Range
Nov
Dec
Use Al
Gallons
(3 chances)
1
Gallons
Answer
Price Prediction:
Possible increase in January
2025
6 Months
44 >>
Regular
+ Midgrade
Transcribed Image Text:Forecasting 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) Demand Jul AUG o Make a Forecast Current Decision Past Decision Forecast for January 2025 REGULAR L 0 MIDGRADE 0 Sept Forecast demand can not be less than 100! Month Range Nov Dec Use Al Gallons (3 chances) 1 Gallons Answer Price Prediction: Possible increase in January 2025 6 Months 44 >> 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
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing