Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

Problem:

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

Month Sales

Jan 20
Feb 21
Mar 15
Apr 14
May 13
Jun 16
Jul 17
Aug 18
Sep 20
Oct 20
Nov 21
Dec 23

Requuired:

Question 1) Plot the monthly sales data on a sheet of graph paper.

Question 2) Forecast January sales for the new year using each of the following:

a) Basic naïve method.
b) A 3-month moving average.
c) A 6-month weighted moving average using 0.1, 0.1, 0.1, 0.2, 0.2, 0.3, with the heaviest weights applied to the most recent months.
d) Exponential smoothing using a smoothing constant of 0.3 and a September forecast of 18 (note that you must compute forecasts for Oct, Nov, and Dec before computing the one for January).
e) A trend projection using the least squares method

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

Solve the given numerical problem and show step by step calculation.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91147593

Have any Question?


Related Questions in Operation Management

The valvemaker corporation is owned by vinnie valvemaker it

The Valvemaker Corporation is owned by Vinnie Valvemaker. It makes valves. His business has been making valves since the 1920s, having been founded by his grandfather Vernon Valvemaker. Vinnie's mother Veronica Valvemake ...

1 determine the facts in order to make well-grounded

1. Determine the facts: In order to make well-grounded ethical decisions, we need to know the facts. In business situations, this includes an investigation of the law. Business people are required to follow the law. The ...

Need 1500 words give full answer pleasecompany wal-mart

Need 1500 words give full answer please Company: Wal-Mart (write on the following guidline) 1. Define the process: its start, end, and what it does. 2. Describe the process: list the key tasks performed and sequence of s ...

You manage one stage of a manufacturing process that uses

You manage one stage of a manufacturing process that uses machines to stamp out metal parts. You are trying to figure out how many machines to have at that stage of the process. You have an exponential/poisson arrival ra ...

Research canadian or provincial legal principles that would

Research Canadian (or provincial) legal principles that would apply to the product you are buying or selling. Research the country your company will be located and explain the legal differences when doing business with t ...

1 provide an example of an enforceable contract and explain

1. Provide an "example" of an enforceable contract and explain "why" it is enforceable (not from the textbook make a fictional case). 2. Provide an "example" of an unenforceable contract and explain "why" it is unenforce ...

Provide an in-depth analysis of the factors relevant to the

Provide an in-depth analysis of the factors relevant to the success of Charmtech Labs LLC in the market, including: -Cultural, legal, political, and economic factors that your client must understand to ensure the success ...

1 analyses mentioned in the case suggested that the market

1) Analyses mentioned in the case suggested that the market for in-house diagnostics would grow in the next five years. A) True B) False 2) Veterinary clinics found that having diagnostic equipment in-house led to a lowe ...

Assignment evaluating a leader write a research paper or

Assignment: Evaluating a Leader Write a research paper or approximately 850 words reviewing a leader. This person can be someone with whom you have worked, or a historical or contemporary public leader. Evaluate this lea ...

It is not unusual for even large corporate boards to have

It is not unusual for even large corporate boards to have no women or minorities on them. In the U.S., women held 16 percent of board seats at Fortune 500 companies in 2012. In her 2013 book, Lean In, Sheryl Sandberg poi ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As