Question

In: Operations Management

1. All forecasts should be rounded to an integer number (regular rounding). Use Excel to do...

1. All forecasts should be rounded to an integer number (regular rounding). Use Excel to do your computations. Each part of the problem should be on a different Excel Sheet/Tab.

Part (a)    Use the 6-period moving average method to forecast for these data and for the first six months of the third year. Compute MSD/E, MAD, MAPE, and Bias.

Month (t) Model 3 A(t)
1 148
2 125
3 78
4 53
5 25
6 29
7 9
8 68
9 84
10 110
11 147
12 120
13 147
14 109
15 96
16 70
17 42
18 36
19 34
20 28
21 71
22 102
23 103
24 144

Solutions

Expert Solution

Excel calculation and formulae is shown below

Please comment of any doubt

Rate me

Thanks


Related Solutions

General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary...
General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary analysis and hypothesis test constructions, and explain completely. Read the textbook Chapter 11. Solve the textbook example on page 403, "Mobile Electronics," in order to compare four different in-store locations with respect to their average sales. Use One-Way ANOVA to analyze the data set, data, given for this homework. Use 5% level of significance. 1) Do the Levene test in order to compare the...
General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary...
General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary analysis and hypothesis test constructions, and explain completely. Read the textbook Chapter 13. Imagine that you are managing a mobile phone company. You want to construct a simple linear regression model to capture and represent the relationship between the number of customers and the annual sales level for a year with 95% confidence. You had conducted a pilot study for the past fifteen years...
Sixty percent of all children in a school do not have cavities. The probability, rounded to...
Sixty percent of all children in a school do not have cavities. The probability, rounded to four decimal places, that in a random sample of 9 children selected from this school, at least 4 do not have cavities is: SHOW WORK PLS
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test...
PLEASE DO NO USE EXCEL, as we are not able to use excel on our test XYZ company is considering a new machine that costs $300,000 and would reduce pre-tax manufacturing costs by $108,000 annually. XYZ would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The net operating working capital...
For all integers n > 2, show that the number of integer partitions of n in...
For all integers n > 2, show that the number of integer partitions of n in which each part is greater than one is given by p(n)-p(n-1), where p(n) is the number of integer partitions of n.
Instructions: All the questions should be answered with a graph Graphs should be made in excel...
Instructions: All the questions should be answered with a graph Graphs should be made in excel and pasted in the word Explanation must be handwritten not typed The assignment should be very neatly done or else it will not be considered for evaluation. Q1. Explain law of demand and Supply with two separate graphs. Q2. What is Contraction and Expansion for Demand and Supply. Explain with a Demand schedule and graph. Q3.  Consider Product X is Car. With help of graph...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company...
PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6-years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $350 [($2,100/6) = $350 per year]. If the old machine is not replaced, it can...
Prompt user to enter an integer number from console. Use 2 methods to multiply this number...
Prompt user to enter an integer number from console. Use 2 methods to multiply this number by factor 7, display result. This is required to be done in MIPS Assembly Language.
DO NOT USE EXCEL SHOW STEPS EXPLAIN ALL PARTS A group of 18 people from New...
DO NOT USE EXCEL SHOW STEPS EXPLAIN ALL PARTS A group of 18 people from New York and a group of 15 people from Los Angeles passed the same quiz. The mean grade of group A is 78 points, with the standard deviation σ1=5, the mean grade of group B is 75 points, σ2=4.5. Use α=0.05. Assuming that the subjects are chosen randomly, the cities’ population are independent, and the points are normally distributed: (a) Check if there is a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT