Question

In: Operations Management

The following data were collected on the yearly registration for a six sigma seminar at the...

The following data were collected on the yearly registration for a six sigma seminar at the University of Malaya

Tahun/Year

Pendaftaran/ Registration

1

400

2

600

3

400

4

500

5

1000

6

800

7

700

8

900

9

1200

10

1400

a. Calculate a 3-year moving average to forecast registration from year 4 to year 11.

Solutions

Expert Solution

I have solved the question using Excel for accurate results, same formula can be applied using calculator to solve,

The formulas used in the above calculations in Excel are as shown below:

The formula is explained below:

ROUND - It rounds the values of the forecasts to 2 decimal places as "2" is given as an argument in ROUND function,

AVERAGE(C4:C6) - Calculates the average of the three values from C4 to C6, which is equal to C4+C5+C6 / 3 .

keosha answered 1 year ago
Next > < Previous

Related Solutions

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following​ table: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations (000) 5.00 7.00 3.00 5.00 9.00 9.00 7.00 11.00 13.00 14.00 12.00 a. Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (α) of 0.40 and a starting forecast for 5.00 year 1 (round your responses to one demical...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following​ table:                                                                                                                                                              Year 1 2 3 4 5 6 7 8 9 10 11 Registrations​ (000) 4.00 5.00 4.00 4.00 9.00 9.00 6.00 9.00 11.00 16.00 12.00 ​a) Calculate the forecasted registrations for years 2 through 12 using exponential​ smoothing, with a smoothing constant ​(α​) of 0.30 and a starting forecast of 4.00 for year 1 ​(round your responses to...
Forecasting 1. Demand data collected on yearly registrations for a Six Sigma seminar at the Quality...
Forecasting 1. Demand data collected on yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table Year 1 2 3 4 5 6 7 8 9 10 11 12 Registration 4000 6000 4000 5000 10000 8000 7000 9000 12000 14000 15000 a. Estimate (forecast) demand again for years 4-12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 0.50, 0.25, and 0.25. b....
The following data shows the yearly production data collected from country A and B. Yearly profit...
The following data shows the yearly production data collected from country A and B. Yearly profit in ‘000 Calculate: 1) the coefficient of variation for firms in State A and B 2) the interquartile range for firms in State A and B 3) the median profit for firms in State A and B 4) the mode profit for firms in State A and B 5) the profit variance for firms in State A and B 6) mean deviation from the...
Which of the following statements regarding "Six Sigma" is TRUE?   A. The Six Sigma program...
Which of the following statements regarding "Six Sigma" is TRUE?   A. The Six Sigma program was developed by Toyota in the 1970s.   B. Six Sigma means that about 94 percent of a firm's output is free of defects.   C. The Six Sigma program is for manufacturing firms and is not applicable to services.   D. Six Sigma certification is granted by the International Standards Organization (ISO).   E. The term has two distinct meanings - one is...
Data were collected on the amount that a sample of six moviegoers paid for two tickets...
Data were collected on the amount that a sample of six moviegoers paid for two tickets with online service charges, large popcorn, and two medium soft drinks at a sample of six local cinemas: $43.00      $33.75        $40.25        $35.05        $31.00        $36.15 Construct a 95% confidence interval estimate of the population mean price for two tickets with online service charges, large popcorn, and two medium soft drinks and answer the following questions: a.   i.   What is the point estimate of the population...
1) The following data shows the yearly production data collected from firms in XYZ state and...
1) The following data shows the yearly production data collected from firms in XYZ state and ABC state. Yearly production in tons Number of Firms in XYZ Number of Firms in ABC 50 - 150 9 35 150 - 250 10 40 250 - 350 11 56 350 - 450 40 62 450 - 550 56 78 550 - 650 68 55 650 - 750 110 53 750 - 850 125 52 850 - 950 98 44 950 - 1050...
Six sigma industries
Six sigma industries
Lean and Six Sigma Research: What Companies created each of these methodologies (Lean and Six Sigma)...
Lean and Six Sigma Research: What Companies created each of these methodologies (Lean and Six Sigma) and approximately what date? Define “Lean” and “Six Sigma” and identify the purpose or goal of each in their most fundamental terms. What is “Lean Six Sigma”? What is the basic methodology used in Lean versus the basic methodology used in Six Sigma? What are the major tools used by Lean versus by Six Sigma? Identify a company that has implemented, Lean and report...
Six sigma concepts, methodologies and tools Describe the concept of Six Sigma for supply chain management....
Six sigma concepts, methodologies and tools Describe the concept of Six Sigma for supply chain management. Describe two benefits of creating and using a QFD(Quality Function Development) matrix. Describe each part of the QFD matrix and how a QFD matrix is created. Describe the steps for benchmarking. Give brief descriptions of these Six Sigma tools and where they can be used; Affinity diagram Kano model Pareto analysis Brainstorming Fishbone analysis Process flow charts Failure mode analysi Design of experiment In...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT