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

keosha answered 4 months ago
Next > < Previous

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...
All Code should be written in C: 1. A perfect number is defined as a number...
All Code should be written in C: 1. A perfect number is defined as a number whose proper divisors (factors not including the number itself) add up to the same number. For example, 28 is a perfect number because its perfect divisors are 1, 2, 4, 7, 14, which add up to 28. Write a C function called is_perfect that takes a since integer as input, and returns 1 if the number is perfect, or 0 otherwise. 2. Using the...
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...
. Create a Python function that asks the user for a number (integer). The function should...
. Create a Python function that asks the user for a number (integer). The function should then tell the user how many hundreds can go into the number, and how much is left over. Hint: the % operator calculates the remainder of a division. For example, 10 % 3 gives a result 1. Hint2: Deal with the positive and negative values in separate parts of an if-else structure. Get the calculation work for positive values first. For negative values, make...
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...
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.
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT