Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The monthly sales for Telco Batteries, Inc., were as follows: Month Sales January 24 February 25 March 19 April 17 May 16 June 20 July

  1. The monthly sales for Telco Batteries, Inc., were as follows:
Month Sales
January 24
February 25
March 19
April 17
May 16
June 20
July 21
August 22
September 24
October 24
November 25
December 27

a) Plot the monthly sales data.

b) Forecast January sales using each of the following:

i) Naive method.

ii) A three-month moving average.

iii) A six-month weighted average using 0.1, 0.1, 0.1, 0.2, 0.2, and 0.3, with the heaviest weights applied to the most recent months.

iv) Exponential smoothing using an a 5 0.3 and a September forecast of 18.

v) A trend projection.

c) With the data given, which method would allow you to forecast next March's sales?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Writing For Hospitality

Authors: Peter Nyhiem, Vivienne J Wildes

1st Edition

0131715712, 9780131715714

More Books

Students also viewed these General Management questions

Question

7. How can an interpreter influence the utterer (sender)?

Answered: 1 week ago

Question

8. How can an interpreter influence the message?

Answered: 1 week ago