Homework Answers
| Year | Season | Period | Demand | Seasonal averages | Seasonal Factor | De-seasonalized demand |
| 2017 | Spring | 1 | 2250 | 3000 | 0.75 | 3014 |
| Summer | 2 | 3050 | 3625 | 0.90 | 3381 | |
| Fall | 3 | 2900 | 3400 | 0.85 | 3428 | |
| Winter | 4 | 5500 | 6050 | 1.51 | 3653 | |
| 2018 | Spring | 5 | 3750 | 0.75 | 5023 | |
| Summer | 6 | 4200 | 4018.75 | 0.90 | 4656 | |
| Fall | 7 | 3900 | 0.85 | 4610 | ||
| Winter | 8 | 6600 | 1.51 | 4384 | ||
| 2019 | Spring | 9 | 0.75 | |||
| Slope = | 247.47 | |||||
| Intercept = | 2905.12 |
Regression Equation: Trend forecast = 2905.12 + 247.47 * Period
For Spring (2019), the Period = 9
So,
Trend forecast = 2905.12 + 247.47 * Period = 2905.12 + 247.47 * 9 = 5132
Seasonal factror = 0.75 because of Spring.
So,
Forecast with trend and seasonality = 5132*0.75 = 3849
Add Answer to:
12. Compute the forecast for Spring of 2019 using the demand data pe bain and seasonality....
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
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)
Alpha- beta-gamma- 0.25 0.2 0.3 Year Season Period Sales Level Trend Seasonal Forecast 2019 Sprin...
alpha- beta-gamma- 0.25 0.2 0.3 Year Season Period Sales Level Trend Seasonal Forecast 2019 Spring 87 149 125 72 100 0.79 1.32 1.18 0.71 6 Summer Fall Winter 113.87.0 2020 Spring 95.4 Summer 10 If sales in Spring 2018 are 100, update the level-L(S
alpha- beta-gamma- 0.25 0.2 0.3 Year Season Period Sales Level Trend Seasonal Forecast 2019 Spring 87 149 125 72 100 0.79 1.32 1.18 0.71 6 Summer Fall Winter 113.87.0 2020 Spring 95.4 Summer 10 If sales...
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...
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...
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...
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...
Exercise 2.1 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden...
Exercise 2.1 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown below: Demand for fertilizer (in 1000's of bags) Using any software to develop a trend line for the demand for fertilizer. Exercise 3.1 In the past, Judy Holmes's tire dealership sold an average of 1000 radials each year: Year 1 200 Season Fall Winter Spring Summer 350 150 300 Year 2 250 300 165 285 Average Seasonal Index 225.0 225/250 =...
alpha- beta-gamma- 0.25 0.2 0.3 Year Season Period Sales Level Trend Seasonal Forecast 2019 Spring 87 149 125 72 100 0.79 1.32 1.18 0.71 6 Summer Fall Winter 113.87.0 2020 Spring 95.4 Summer 10 If sales in Spring 2018 are 100, update the level-L(S
alpha- beta-gamma- 0.25 0.2 0.3 Year Season Period Sales Level Trend Seasonal Forecast 2019 Spring 87 149 125 72 100 0.79 1.32 1.18 0.71 6 Summer Fall Winter 113.87.0 2020 Spring 95.4 Summer 10 If sales...
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...
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...
Exercise 2.1 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown below: Demand for fertilizer (in 1000's of bags) Using any software to develop a trend line for the demand for fertilizer. Exercise 3.1 In the past, Judy Holmes's tire dealership sold an average of 1000 radials each year: Year 1 200 Season Fall Winter Spring Summer 350 150 300 Year 2 250 300 165 285 Average Seasonal Index 225.0 225/250 =...
Most questions answered within 3 hours.
-
Ken believes the average age of men who come to get a haircut at
his barber...
asked 8 minutes ago -
(Ratio Analysis): Last year Co. XYZ had sales of $ 400,000, with
“cost of goods sold”...
asked 16 minutes ago -
can someone please write the balanced chemical
equation for the synthesis of Bromoacetanilide
from;
aniline +...
asked 12 minutes ago -
1. If a corporation purchases land and building and subsequently
tears down the building and uses...
asked 24 minutes ago -
Consider a 23-year bond with 7 percent annual coupon payments.
The market rate (YTM) is 6.4...
asked 27 minutes ago -
a tuba creates a 4th harmonic of frequency 116.5 Hz. what is the
frequency of the...
asked 33 minutes ago -
A coconut mass 2kg falls from a 30m tall tree. The coconut falls
and comes to...
asked 36 minutes ago -
Group Policies
Research GROUP POLICY OBJECTS (GPO'S)
You can start in the Windows Server 2012 eBook...
asked 40 minutes ago -
software engineering
Problems.
Create a use case diagram for class registration for a
university.
Create a...
asked 40 minutes ago -
You are trying to convince your friend who wants to attend
medical school to take BY123...
asked 55 minutes ago -
Subject: C++
I have created a class called QueueOfIntegers in a file called
QueueOfIntegers.h, which is...
asked 54 minutes ago -
calculate the number of molecules of gas in a
container of 2.0 liter at 30 degrees...
asked 1 hour ago