ZuoTi.Pro
Question

The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 200 Summer...

The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 200 Summer 143 Fall 385 Winter 575 last year Spring 468 Summer 272 Fall 684 Winter 960 Use regression analysis on deseasonalized demand to forecast next summer’s demand. (Round your answer to the nearest whole number.) Forecast for next summer’s demand 236

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1
Slope 54.54
Intercept 215.45
Year Season Period Actual demand Seasonal averages Seasonal Indices Deseasonalized demand Trendline (using regression) Reseasonalized forecast
1 Spring 1 200 334.0 0.725 275.97 269.99 196
Summer 2 143 207.5 0.450 317.62 324.53 146
Fall 3 385 534.5 1.160 331.97 379.07 440
Winter 4 575 767.5 1.665 345.28 433.61 722
2 Spring 5 468 0.725 645.78 488.14 354
Summer 6 272 460.9 0.450 604.13 542.68 244
Fall 7 684 1.160 589.78 597.22 693
Winter 8 960 1.665 576.47 651.76 1085
3 Spring 9 0.725 706.30 512
Summer 10 0.450 760.84 343
Fall 11 1.160 815.38 946
Winter 12 1.665 869.92 1449

So,

Forecast for next summer’s demand = 343

Calculations

0 0
Add a comment
Know the answer?
Add Answer to:
The following are historical demand data: YEAR SEASON ACTUAL DEMAND 2 years ago Spring 200 Summer...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Calculate Forcasting

    The following are historical demand data:ACTUALYEARSEASONDEMAND2011Spring208Summer138Fall360Winter5682012Spring466Summer265Fall684Winter970Use regression analysis on deseasonalized Demand to forecast demand in summer 2013. (Do not round intermediate calculations.Round your answer to the nearest whole number)

  • 12. Compute the forecast for Spring of 2019 using the demand data pe bain and seasonality....

    12. Compute the forecast for Spring of 2019 using the demand data pe bain and seasonality. Use "decomposition using least square regrew computation. Complete the tables below. (14 points) e demand data pyes below. Assume that the data dioplays both sing least square regression technique. You may use and spreadsheets for you Season Demand De seasonalized dead Spring 2250 Summer 3050 2017 Fall 2900 Winter 5500 Spring 3750 Summer 4200 2018 Fall 3900 Winter 6600 Trend equation (or regression equation)...

  • 3. A decision maker considers that the demand is affected by the season since it is...

    3. A decision maker considers that the demand is affected by the season since it is highest during the winter. He aims at making a forecast for each season of the next year. Total annual demand is 4000 customers in the next year. Based on the information given below, what is the forecast for each season of the next year? Visitors Season Fall Winter Spring Summer Year 1 200 1400 520 720 Year 2 230 1600 580 831

  • Plan production for the next year. The demand forecast is: spring, 19,500; summer, 9,400; fall, 15,000;...

    Plan production for the next year. The demand forecast is: spring, 19,500; summer, 9,400; fall, 15,000; winter, 18,800. At the beginning of spring, you have 66 workers and 990 units in inventory. The union contract specifies that you may lay off workers only once a year, at the beginning of summer. Also, you may hire new workers only at the end of summer to begin regular work in the fall. The number of workers laid off at the beginning of...

  • George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of...

    George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows:Year Season1234Winter1,4001,2001,080960Spring1,5001,4201,6201,500Summer1,0402,1202,0002,000Fall600770650520George has forecasted that annual demand for his sailboats in year 5 will equal 5,600 sailboats. Based on the given data and using the multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be _______ sailboats (enter a whole number)

  • Problem 4.26 P Question Help George Kyparisis owns a company that manufactures sailboats. Actual demand for...

    Problem 4.26 P Question Help George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Year Season 1 2 3 4 Winter 1,440 1.280 1,000 960 Spring 1,500 1.440 1,620 1,540 Summer 1,020 2,140 2,020 1,960 Fall 600 750 650520 George has forecasted that annual demand for his sailboats in year 5 will equal 6,500 sailboats. Based on the given data and using the multiplicative seasonal model,...

  • Vandelay Industries manufactures sailboats. Actual demand for their sailboats for each season over the past four...

    Vandelay Industries manufactures sailboats. Actual demand for their sailboats for each season over the past four years was as follows: YEAR SEASON 1 2 3 4 Winter 1,400 1,200 1,000 900 Spring 1,500 1,400 1,600 1,500 Summer 1,000 2,100 2,000 1,900 Fall 600 750 650 500 Complete all parts of this problem in Excel. Clearly identify the responses to each part of the question. a. (20 pts) Download ForecastSolver.xlsx from BbLearn and save it on your computer. Open the file...

  • Mark Cotteleer owns a company that manufacturers canoes. Actual demand for Mark’s canoes during each season...

    Mark Cotteleer owns a company that manufacturers canoes. Actual demand for Mark’s canoes during each season in 2012 through 2015 was as follow. Based on this data and the additive seasonal model, what will the demand level be for Mark’s canoes in the spring of 2017. Year Season 2012 2013 2014 2015 Winter 1400 1200 1000 900 Spring 1500 1400 1600 1500 Summer 1000 2100 2000 1900 Fall 600 750 650 500 You can use excel to solve this problem

  • Problem 8-7 Develop a production plan and calculate the annual cost for a firm whose demand...

    Problem 8-7 Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,700; winter, 8,300; spring, 6,900; summer, 12,700. Inventory at the beginning of fall is 535 units. At the beginning of fall you currently have 35 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular...

  • Develop a production plan and calculate the annual cost for a firm whose demand forecast is...

    Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 11,000; winter, 7,700; spring, 6,700; summer, 13,000. Inventory at the beginning of fall is 550 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT