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,400 | 1,200 | 1,080 | 960 |
Spring | 1,500 | 1,420 | 1,620 | 1,500 |
Summer | 1,040 | 2,120 | 2,000 | 2,000 |
Fall | 600 | 770 | 650 | 520 |
George 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)
Season | Year 1 | Year 2 | Year 3 | Year 4 | Avg Yearly Demand | Avg Monthly Demand | Year 5 | |
Winter | 1,400.00 | 1,200.00 | 1,080.00 | 960.00 | 1,160.00 | 1,273.75 | 0.91 | 1,274.98 |
Spring | 1,500.00 | 1,420.00 | 1,620.00 | 1,500.00 | 1,510.00 | 1,273.75 | 1.19 | 1,659.67 |
Summer | 1,040.00 | 2,120.00 | 2,000.00 | 2,000.00 | 1,790.00 | 1,273.75 | 1.41 | 1,967.42 |
Fall | 600.00 | 770.00 | 650.00 | 520.00 | 635.00 | 1,273.75 | 0.50 | 697.94 |
Total Average Annual Demand | 5095 | 5,600.00 |
George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: Season 1 2 3 4 Winter Spring Summer Fall George has forecasted that annual demand for his sailboats in year 5 will equal 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).
George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of...
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,...
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 comma 4801,480 1 comma 2001,200 1 comma 0801,080 960960 Spring 1 comma 5601,560 1 comma 4201,420 1 comma 6201,620 1 comma 5801,580 Summer 1 comma 0401,040 2 comma 1202,120 2 comma 0002,000 1 comma 9601,960 Fall 600600 750750 690690 520520 George has forecasted that annual demand for his...
George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: 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, the demand level for George's sailboats in the spring of year 5 will be _______ sailboats (enter a whole number).
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 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