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 agoRelated 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
ADVERTISEMENT
Latest Questions
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
- Do we have any online or offline tool to convert c and cpp programs into MIPS...
- -what is the pH of HCl 0,1M and NaCl 0,1M mixed together solution? -What is the...
- function X=extractDWT(x_train,startS,endS,wStep,wRange) % x_train = input signal % startS = from second % endS = end...
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
- Computing Cost of Goods Sold and Ending Inventory. Bartov Corporation reports the following beginning inventory and...
- SQL FORMAT (11-13 are completed and correct) -- 11. what are the names of all students...
ADVERTISEMENT