HomeworkLib
Question
I need to find the exponential smoothing.
0.3 0.8 INOV Loct 131-175 [130.074 Dec 129.47 Jan 128.577 Feb 128,06 march 125. 136 1
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Ans) Formula is, ft+1 =αdt + (1-α)ft

where,

dt =actual demand and

ft= previous forecast

For ,α1 =0.3

november=0.3*131.175 +(1-0.3)131.175 = 131.175

december = 0.3 * 130.074 + 0.7 * 131.175 = 130.844

january = 0.3 * 129.47 + 0.7 * 130.844 = 130.431

February = 0.3 * 128.577 + 0.7 * 130.431= 129.874

March = 0.3 * 128.06 + 0.7 * 129.874 = 129.329

October = 0.3 * 125.136+ 0.7 * 129.329 = 127.936

For, α2 =0.8

november=0.8*131.175 +(1-0.8)131.175 = 131.175

december = 0.8 * 130.074 + 0.2 * 131.175 = 130.294

january = 0..8* 129.47 + 0.2 * 130.294 = 129.634

February = 0.8 * 128.577 + 0.2 * 129.634= 128.788

March = 0.8 * 128.06 + 0.2 * 128.788 = 128.205

October = 0.8 * 125.136+ 0.2 * 128.205 = 125.749

Forecast for 0.3 Forecast for 0.8
October 131.175 127.936 125.749
November 130.074 131.175 131.175
December 129.47 130.844 130.294
January 128.577 130.431 129.634
February 128.06 129.874 128.788
March 125.136 129.329 128.205

Do give positive rating if this answer is helped.

0 0
Add a comment
Know the answer?
Add Answer to:
I need to find the exponential smoothing. 0.3 0.8 INOV Loct 131-175 [130.074 Dec 129.47 Jan...
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

  • Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing...

    Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing system, claiming that their judgmental forecasts are much better than any computer could do. Their past record of predictions is as follows: Week Actual Demand Manager's Forecast 1 3,800 4,400 2 4,100 4,800 3 4,300 3,700 4 3,100 3,800 5 3,900 3,500 6 4,500 3,500 7 5,700 4,900 8 4,000 4,700 9 4,500 3,500 10 4,900 5,400 How would the manager’s forecast compare to...

  • i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the...

    i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the weeks. A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...

  • Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows:...

    Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Jan Feb Mar Apr May June July Aug Sep Oct Demand 46 47 50 49 50 48 51 49 52 53 Nov. Dec. 52 54 C. Forecast next year January sales using the following methods: I. Linear regression (You can use excel to get slope and intercept) ii. Trend adjusted exponential smoothing model. Use a = 0.2, B = 0.3, for the month...

  • I need to find: A) the ending balance in Retained Earnings as of Dec 31, Year...

    I need to find: A) the ending balance in Retained Earnings as of Dec 31, Year 4 B) The beginning balance in Retained Earnings as of Jan 1st, Year 4 Current Assets $900,000 Current Liabilities $400,000 Fixed Assets, Net $600,000 Investments $100,000 Long-Term Debt $500,00 Dividends Declared on Common Stock during the Year $50,000 Income Summary (income) $225,000 Retained Earnings, January 1, Year 4-? Common Stock $150,000 Premium on Common Stock $250,000 Thank you for your help

  • find mape for naive approach S of Quilt covers Bud Bandiscount de March April May and...

    find mape for naive approach S of Quilt covers Bud Bandiscount de March April May and June t store in Carbonde over the past year we shown below Management prepared forecasting a combination of exponential smoothing and its collective judgment for the Sep 95 Oct 110 Nov 120 Dec 119 Jan 92 95 Un sales Management's Forecast Feb 4 - Mar Apr 102 0 120 114 May 90 108 Jun 108 110 a) MAD for the forecast developed by the...

  • How do I plot a series graph with this data provided? Month 1987 1988 1989 1990...

    How do I plot a series graph with this data provided? Month 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 Jan 95 104 101 88 132 125 111 127 119 147 Feb 94 100 96 110 109 118 123 129 147 146 Mar 98 99 82 129 101 121 121 132 164 133 Apr 96 88 84 113 111 140 139 108 135 148 May 95 89 85 114 140 141 119 115 124 141 Jun 115 108...

  • 6.Use Exponential smoothing forecasts with alpha of 0.1, 0.2, ..., 0.9 to predict March 2019 demand....

    6.Use Exponential smoothing forecasts with alpha of 0.1, 0.2, ..., 0.9 to predict March 2019 demand. Identify the value of alpha that results in the lowest MAD. 7.Find the monthly seasonal indices for the demand values using Simple Average (SA) method. Find the de-seasonalized demand values by dividing monthly demand by corresponding seasonal indices. 8.Use regression to perform trend analysis on the de-seasonalized demand values. Is trend analysis suitable for this data? Find MAD and explain the Excel Regression output...

  • I. The Rau Co. closes its books once a year on Dec. 31. Required: (a) Make...

    I. The Rau Co. closes its books once a year on Dec. 31. Required: (a) Make the necessary Dec. 31, 2000, adjusting entry for each of the following: (1) On Aug. 1, 2000, Rau received $2,800 in advance for seven months of consulting work. An income statement account was credited on Aug. 1st (2) On March 1, 2000, Rau paid $7,200 in advance for one year's rent. A balance sheet account was debited on March 1 st (3) On Nov....

  • I need the answer to #2 listed above. This is the code I have come up...

    I need the answer to #2 listed above. This is the code I have come up with, and it is wrong. I am new to this and need help. group by sust.cida Q2 (7 Points) Show customer id (CID) for customers who have spent 30,000 or more with the company in 2019. Money is considered "spent" when the entire work order is completed as recorded in workorder.completionDate. (Correct query will find customer 2). Use ONE SQL statement. select workarder.id from...

  • I only need entries for depreciation expense for sept 1 and dec 30 Presented here are...

    I only need entries for depreciation expense for sept 1 and dec 30 Presented here are selected transactions for Cullumber Limited for 2018. Cullumber uses straight-line depreciation and records adjusting entries annually. Jan. 1 Sept. 1 Dec. 30 Sold a delivery truck for $18,840 cash. The truck cost $64,060 when it was purchased on January 1, 2015, and was depreciated based on a four-year useful life with a $5,800 residual value. Sold computers that were purchased on January 1, 2016....

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