147) PLEASE HELP! The following table contains the demand from the last 10 months:MONTH12345678910Month12345678910ACTUAL DEMAND3235Month12L68036a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F₁) of 32.Note: Round your intermediate calculations and answers to 2 decimal places.38413939414440ExponentialSmoothingb. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a ō of 0.20, an initial trend forecast (T₂) of1.00, and an initial exponentially smoothed forecast (F₁) of 31.Note: Round your intermediate calculations and answers to 2 decimal places.FITT b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a ō of 0.20, an initial trend forecast (7₁) of1.00, and an initial exponentially smoothed forecast (F₁) of 31.Note: Round your intermediate calculations and answers to 2 decimal places.Month123567810FITTc-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts.Note: Round your intermediate calculations and answers to 2 decimal places.Single exponential smoothing forecastExponential smoothing with trend forecastc-2. Which is best?MADO Exponential smoothing with trend forecastO Single exponential smoothing forecast

Exponential smoothing is a forecasting model which identifyi ng the forecasting value based on the…

The following table contains the demand from the last 10 months. MONTH 1 2 3 4 5 6 7 8 9 10 ACTUAL DEMAND 32 35 36 Month 1 2 3 4 5 6 7 8 9 10 38 41 39 39 41 44 40 a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F₁) of 32. Note: Round your intermediate calculations and answers to 2 decimal places. Exponential Smoothing b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a o of 0.20, an initial trend forecast (T₂) of 1.00, and an initial exponentially smoothed forecast (F₂) of 31. Note: Round your intermediate calculations and answers to 2 decimal places.

The following table contains the demand from the last 10 months. MONTH 1 2 3 4 5 6 7 8 9 10 ACTUAL DEMAND 32 35 36 Month 1 2 3 4 5 6 7 8 9 10 38 41 39 39 41 44 40 a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F₁) of 32. Note: Round your intermediate calculations and answers to 2 decimal places. Exponential Smoothing b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a o of 0.20, an initial trend forecast (T₂) of 1.00, and an initial exponentially smoothed forecast (F₂) of 31. Note: Round your intermediate calculations and answers to 2 decimal places.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Problem 3 Sensitivity Analysis. A masonry plant produces four types of breeze-blocks (a type of…

A: Objective Functions and Constraints: Based on the given details, the objective…

Q: Two senior managers (Brad and Dave) at Alpine Inc. are disagreeing about the managerial skills…

A: In today’s competitive industry world Project management & product management are extremely…

Q: do fast.

Q: Question ID: 1251795 Kate and Mark, a married couple, own a limited liability company. Although Kate…

A: A) A cross-purchase buy-sell agreement between Kate, Mark, and the children

Q: An employee has fallen in the employee hallway leading to the main lobby which is made of concrete…

A: The combined skill of directing an organization's people resources toward collective success is…

Q: A Chemical Company LLC is unable to satisfy customer demand for one of their products. The ratios…

A: Given: Department Capacity predecessors A 350 B 400 A C 350 B D 250 E 200 F…

Q: Question 4: For either of the grievances from Question 3 above, draft a memo for upper management…

A: An employee's grievance letter is a formal complaint, submitted to an employer in writing, that…

Q: By understanding the structure of the organization for which our software team is to provide a…

A: Understanding the structure of the company for which the solution is being developed is essential…

Q: In essence, any person in a supervisory position can cause his/her company to be prosecuted and in…

A: Typically, civil trials involve personal conflicts between individuals and corporations. In criminal…

Q: Several guests have complained that the fish was not fresh at last night’s banquet and they are…

A: Ensuring food safety is paramount in the hospitality industry, especially when dealing with…

Q: Which of the following describes the activity when the hotel closes available rooms on certain…

A: In the hotel industry, effective room management is crucial for optimizing revenue and ensuring…

Q: Problem #1 Name: Frank Smith Date 4/6 4/7 4/8 4/9 4/10 4/11 In 8:00 8:00 7:45 7:45 8:15 10:00 Out…

Q: Use of technology in service: Technology has changed the traditional way of doing retail business.…

A: Food-Town is a small, autonomous, conventional supermarket in Melbourne that specialises in a…

Q: CUU is planning to procure an administrative building for its students, and design a contract…

A: Establishing a precise contract agreement that describes the major criteria and expectations for the…

Q: Blossom, Inc. produces a crop of chickens at a total cost of $81,400. The production generates…

A: To calculate the incremental profit or loss if Blossom, Inc. slaughters the chickens, we need to…

Q: minimize the total preparation time. When will the entire menu be completed? Dish Marinating Cooking…

A: Johnson's rule is a way of arranging works in two work centers used in operations research. Its main…

Question

100%

147) PLEASE HELP!

The following table contains the demand from the last 10 months:
MONTH
123456789
10
Month
1
2
3
4
5
6
7
8
9
10
ACTUAL DEMAND
32
35
Month
1
2
L680
36
a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F₁) of 32.
Note: Round your intermediate calculations and answers to 2 decimal places.
38
41
39
39
41
44
40
Exponential
Smoothing
b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a ō of 0.20, an initial trend forecast (T₂) of
1.00, and an initial exponentially smoothed forecast (F₁) of 31.
Note: Round your intermediate calculations and answers to 2 decimal places.
FITT

b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a ō of 0.20, an initial trend forecast (7₁) of
1.00, and an initial exponentially smoothed forecast (F₁) of 31.
Note: Round your intermediate calculations and answers to 2 decimal places.
Month
1
2
3
5
6
7
8
10
FITT
c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts.
Note: Round your intermediate calculations and answers to 2 decimal places.
Single exponential smoothing forecast
Exponential smoothing with trend forecast
c-2. Which is best?
MAD
O Exponential smoothing with trend forecast
O Single exponential smoothing forecast

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1; Explanation

VIEW

Step 2; a) Single exponential smoothing

VIEW

Step 3 b) Exponential smoothing with trend values.

VIEW

Step 4; c) MAD

VIEW

Step 5; Final answer

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Question 5: Suppose a brewery uses a Cobb-Douglas production function for his production. He studies the production process and finds the following. An additional machine-hour of fermentation capacity would increase output by 500 bottles per day (i.e. MPK = 500). An additional man-hour of labor would increase output by 1000 bottles per day (i.e. MPL = 1000). The price of a man-hour of labor is $50 per hour. The price of a machine-hour of fermentation capacity is $5 per hour. 3. Suppose that the price of a machine-hour of fermentation capacity rises to $25 per hour. How does this change the answer from part 1?
Question 9
Question 5 You are receiving an shipment and come across a box of shaving cream. What should you do? Please choose all that apply. Receive the shaving cream Raise an Andon CSecure it well with bubble wrap after scanning it in O Note is as Flammable on your workstation Submit
185. Subject :- Accounting
Article: Harry Hartfield was looking over some recent travel brochures while consulting his recent Google search. Retirement is only 5 days away and he could not wait to see the Fiji Islands. He and his wife thought they would start with a restful break before they started their travels in earnest. Harry is the head aero engineer at Global Delivery Direct and has been in charge of purchasing the planes and maintenance for the last 15 years after being an employee with GDD 25 years before. Harry had worked up in the company to his current position and has seen a lot of initiatives come and go when it came to eco-friendly flying machines. In the last four weeks, Harry has been breaking in his replacement, Imogine Farthing, who is coming from their London branch. Harry likes Imogine and thinks that she will do well. However, she is keen to purchase the new Boeing 777 cargo plane. She thinks it will go a long way to improving their fuel consumption and air emissions in the long-run…
The Johnsons do not have a reservation with the hotel, but they do need accommodations for the night. Which of the following describes this type of guest? Question 20 options: a) Walk-in b) Leisure c) Transient d) Nongroup
Article: McDonald's Corporation 1. Discuss the strategic issue(s) that McDonald's needs address.
Question 3 a) An electronics firm produces electronic components, which it supplies to various electrical manufacturers. Quality control records. indicate that different employees produce different numbers of defective items. The average number of defects produced by each employee for each of six components is given in the following table: Employee 1 2 3 4 5 6 A 30 22 18 14 25 32 B 24 28 22 18 14 Component C 25 18 D 26 30 14 23 14 E 30 20 12 21 16 18 (i) Draw a network diagram for the problem (ii) Del Formulate a linear programming mathematical model for solving the problem. Enter F 22 13 22 30 28 20 End +