Plot the monthly sales data

Assignment Help Operation Management

Reference no: EM13954019

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

MONTH SALES

January 20

February 21

March 15

April 14

May 13

June 16

July 17

August 18

September 20

October 20

November 21

December 23

a) Plot the monthly sales data.

b) Forecast January sales using each of the following: i) Naive method. ii) A 3-month moving average. iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.

iv) Exponential smoothing using an α = .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?

Reference no: EM13954019

Questions Cloud

What daily order quantity is optimal : Burger prince buys top-grade beef for $1.00 per pound. A large sign over the entrance guarantees that the meat is fresh daily. Any leftover meat is sold to the local high school cafeteria for 80 cents per pound. Four hamburger can be prepared from ea..

London transportation system : What are the nature and characteristics of the individuals that attacked the London transportation system on July 7, 2005?

Traditional project analysis : What are the NPV, IRR, MIRR, and payback of the proposed ambulatory surgery center? Do the measures indicate acceptance or rejection of the proposed ambulatory surgery center? Inflation is one of the most difficult factors to deal with in project ana..

Long term bonds outstanding : Select a company with long term bonds outstanding. Locate and analyze a current quotation for that bond. Compare the current price with the par value. Explain at least one (1) reason for the difference.

Plot the monthly sales data : Plot the monthly sales data. Forecast January sales using each of the following: Naive method. A 3-month moving average. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. Exponen..

What can businesses do to prevent unexpected problems : What can businesses do to prevent unexpected problems in dealing with sociocultural, economic and financial, legal and regulatory, and physical and environmental forces in global markets?

Developing each new solution for any transportation problem : The stepping-stone method is being used to solve a transportation problem. There is only one empty cell having a negative improvement index, and this index is -2. The stepping stone path for the cell indicates that the smallest quantity for the cells..

Businesses will participate in global trade in the future : About 95 percent of the world's population lives outside the United States but many U.S. companies, especially small businesses, still do not engage in global trade. Why not? Do you think more small businesses will participate in global trade in the ..

Dissatisfied with university registration process : Construct a cause and effect diagram to reflect student dissatisfied with university registration process .Use the four Ms or create your own organizing scheme .Include 12 cause. Draw a Pareto chart summarizing these responses. Include the “no compla..

User Account

All Pages