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
|
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 sailboats in year 5 will equal
6 comma 000
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).
Homework Answers
Answer: Spring of season 5 will be: 1811
Explanation:
| AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | |
| 170 | Multiplicative seasonal method | ||||||||||
| 171 | Season | sales in year 1 | sales in year 2 | sales in year 3 | sales in year 4 | Seasonal factor Year 1 | Seasonal factor Year 2 | Seasonal factor Year 3 | Seasonal factor Year 4 | Average seasonal factor | sales in year 5 |
| 172 | sales in the season/yearly average | sales in the season/yearly average | sales in the season/yearly average | sales in the season/yearly average | Average of all seasonal factor of all years | Average seasonal factor*1500 | |||||
| 173 | Winter | 1480 | 1200 | 1080 | 960 | 1.26 | 0.87 | 0.80 | 0.76 | 0.93 | 1390 |
| 174 | spring | 1560 | 1420 | 1620 | 1580 | 1.33 | 1.03 | 1.20 | 1.26 | 1.21 | 1811 |
| 175 | summer | 1040 | 2120 | 2000 | 1960 | 0.89 | 1.54 | 1.48 | 1.56 | 1.37 | 2055 |
| 176 | fall | 600 | 750 | 690 | 520 | 0.51 | 0.55 | 0.51 | 0.41 | 0.50 | 745 |
| 177 | Average | 1170 | 1372.5 | 1347.5 | 1255 |
Excel formulas
| AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | |
| 170 | Multiplicative seasonal method | ||||||||||
| 171 | Season | sales in year 1 | sales in year 2 | sales in year 3 | sales in year 4 | Seasonal factor Year 1 | Seasonal factor Year 2 | Seasonal factor Year 3 | Seasonal factor Year 4 | Average seasonal factor | sales in year 5 |
| 172 | sales in the season/yearly average | sales in the season/yearly average | sales in the season/yearly average | sales in the season/yearly average | Average of all seasonal factor of all years | Average seasonal factor*1500 | |||||
| 173 | Winter | 1480 | 1200 | 1080 | 960 | =AD173/AD$177 | =AE173/AE$177 | =AF173/AF$177 | =AG173/AG$177 | =AVERAGE(AH173:AK173) | =AL173*1500 |
| 174 | spring | 1560 | 1420 | 1620 | 1580 | =AD174/AD$177 | =AE174/AE$177 | =AF174/AF$177 | =AG174/AG$177 | =AVERAGE(AH174:AK174) | =AL174*1500 |
| 175 | summer | 1040 | 2120 | 2000 | 1960 | =AD175/AD$177 | =AE175/AE$177 | =AF175/AF$177 | =AG175/AG$177 | =AVERAGE(AH175:AK175) | =AL175*1500 |
| 176 | fall | 600 | 750 | 690 | 520 | =AD176/AD$177 | =AE176/AE$177 | =AF176/AF$177 | =AG176/AG$177 | =AVERAGE(AH176:AK176) | =AL176*1500 |
| 177 | Average | =AVERAGE(AD173:AD176) | =AVERAGE(AE173:AE176) | =AVERAGE(AF173:AF176) | =AVERAGE(AG173:AG176) |
Add Answer to:
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...
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)
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: 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).
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
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
North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be:...
North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 80.0 + 0.50Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Factor (Index) Winter 0.75 Spring 1.25 Summer 1.45 Fall 0.55 In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one...
Demand for C&A Resort has a seasonal pattern. Total demand next year is expected to be...
Demand for C&A Resort has a seasonal pattern. Total demand next year is expected to be 1,525. Given the historical data of last two years, what is the seasonal index for summer? Season Year 1 Year 2 Fall Winter156 212 Spring 489 518 Summer314 352 352 391 O 1.449 1.068 365 0.957 0.526
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
The Bubble Up Bottling Company of Budapest, Hungary, is interested in forecasting sales of Bubble Up...
The Bubble Up
Bottling Company of Budapest, Hungary, is interested in forecasting
sales
of Bubble Up over the next two
years. The company has analyzed Bubble Up's market share
for its service area over the
past 20 quarters. Market share has generally been growing as
indicated in the table B
below.
During this same five year
period, total soft drink sales in the region (as measured in
100,000s of cases) have been
as in the table A below.
Table A...
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 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,...
Demand for C&A Resort has a seasonal pattern. Total demand next year is expected to be 1,525. Given the historical data of last two years, what is the seasonal index for summer? Season Year 1 Year 2 Fall Winter156 212 Spring 489 518 Summer314 352 352 391 O 1.449 1.068 365 0.957 0.526
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
The Bubble Up
Bottling Company of Budapest, Hungary, is interested in forecasting
sales
of Bubble Up over the next two
years. The company has analyzed Bubble Up's market share
for its service area over the
past 20 quarters. Market share has generally been growing as
indicated in the table B
below.
During this same five year
period, total soft drink sales in the region (as measured in
100,000s of cases) have been
as in the table A below.
Table A...
Most questions answered within 3 hours.
-
The equilibrium constant, Kp , for the following reaction is
1.04×10-2 at 548 K. NH4Cl(s) NH3(g)...
asked 18 minutes ago -
During a recent budgeting discussion, the CFO at "NW Accounting
Services" proposed eliminating the marketing research...
asked 16 minutes ago -
Block B has a mass of 3.80kg and is moving to the left at a
speed...
asked 20 minutes ago -
If n distinct objects are distributed randomly into
n distinct boxes, what is the probability that:...
asked 21 minutes ago -
a) The frequency of light coming out from a laser source is 297
MHz. What is...
asked 43 minutes ago -
LABORATORY EXERCISES:
Using nested for loops, write a java program to print the
pattern as shown...
asked 43 minutes ago -
Assume that the correlation coefficient between achievement test
scores (X) and grade point averages (Y) among...
asked 56 minutes ago -
In Chapter 1 titled "So Close and Yet So Different", in "Why
Nations Fail" authors bring...
asked 53 minutes ago -
Leadership Philosophy
Write a two-page paper identifying your personal leadership
philosophy based on your new perspective...
asked 50 minutes ago -
Which of these function correctly defines the function g(),
which should return a pointer to a...
asked 59 minutes ago -
Pickett Industries just paid a dividend of D0 = $1.10. Analysts
expect the company's dividend to...
asked 59 minutes ago -
Suppose a random sample of 900 measurements is taken from an
unknown population. The average of...
asked 1 hour ago