ZuoTi.Pro
Question

Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Jan Feb Mar Apr May June July
C. Forecast next year January sales using the following methods: I. Linear regression (You can use excel to get slope and int
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Below is the screenshot of the formula applied -

ESSE Double Exponential Forecast - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to

Below is the screenshot of the result -

ASS= File Home Insert Page Layout Formulas Data Revier | Cut Calibri V11 VÁ A ==, Copy Paste BIU - A = 3 Format Painter Clipb

I)

From above-

Slope = 0.5909

Intercept = 46.242

Liner Equation Y = 46.242 + 0.5909*t

For Jan, t = 13

Demand Y = 46.242 + 0.5909*13 = 53.9237 = 53.92

ii)

From screenshot,

Forecast for January = 52.40

0 0
Add a comment
Know the answer?
Add Answer to:
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows:...
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

  • The monthly sales for Yazici Batteries, Inc., were as follows:

    The monthly sales for Yazici Batteries, Inc., were as follows:                                                                                                                                        Month Jan       Feb      Mar     Apr      May     Jun       Jul        Aug      Sept     Oct      Nov      DecSales    19        21        17        14        11        18        16        19        20        20        23        23b) The forecast for the next month (Jan) using the naive method (round your response to a whole number)The forecast for the next period (Jan) using a 3-month moving average approach =(round your response to two decimal places)The forecast for the next period (Jan) using a 6-month weighted average with weights ofandwhere the heaviest weights are applied to the most recent month = (round your response to one decimalplace)Using...

  • The monthly sales for Yazici Batteries, Inc., were as follows:

    The monthly sales for Yazici Batteries, Inc., were as follows:MonthJanFebMarAprMayJunJulAugSeptOctNovDecSales202115121518151922212124This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = _______  sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = _______  sales (round your response to two decimal places) The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20,0.20, and 0.30,...

  • The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar...

    The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...

  • The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May...

    The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 24 Sales 19 23 16 15 13 15 17 18 22 21 23 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach 22.67sales (round...

  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: MonthSales(000)UnitsFeb.15Mar.18Apr.12May.20Jun.23Ju1.23Aug -27b. Forecast September sales volume using each of the following: (1)A linear trend equation.(2) A five-month moving average. (3) Exponential smoothing with a smoothing constant equal to .25, assuming a March forecast of 17(000).(4) The naive approach. (5) A weighted average using.55 for August, .10 for July, and .35 for June.

  • 1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

    1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units) Feb. 21 Mar. 20 Apr. 17 May 22 Jun. 20 Aug. 22 a. Plot the monthly data on a sheet of graph paper.b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five month moving average (3) A weighted average using 60 for August, 30 for July, and. 10 for June (4) Exponential smoothing with a smoothing constant equal to.20, assuming a March-forecast of...

  • That is the question. There's no more information I can give you about it. The information...

    That is the question. There's no more information I can give you about it. The information technology department needs to forecast spending on cyber security. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing with trend accounting for seasonality given a smoothing constant (alpha) of 0.26, a trend smoothing constant (delta) of 0.59, a previous trend amount, seasonally adjusted,...

  • National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000) Units Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 b. Forecast September sales volume using each of the following: SHOW WORKS!!!! (1) Thenaiveapproach. (2) A five month moving average. (3) A weighted average using .60 for August, .30 for July, and .10 for June. (4) Exponential smoothing with a smoothing constant equal to .20,...

  • Calculate a 3-months simple moving average, for each possible month of years 2014/2015/2016. Calculate the MAD, MSE and MAPE for this method. In addition to the formulas in the computer, show one manual calculation of a forecast of this method, for any mo

    Calculate a 3-months simple moving average, for each possible month of years 2014/2015/2016. Calculate the MAD, MSE and MAPE for this method. In addition to the formulas in the computer, show one manual calculation of a forecast of this method, for any month you choose (10 marks)JanFebMarAprMayJunJulAugSepOctNovDecYear474549485250515455566063201450515254565756595555658120155456585761626365676769752016

  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 17 Mar. 20 Apr. 14 May. 22 Jun. 21 Jul. 25 Aug. 29 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)    Yt _ thousands (2) A five-month moving average. (Round your answer to 2 decimal places.)    Moving average _ thousands...

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
ADVERTISEMENT