Prepare a three-period moving-average forecast for the data

Assignment Help Operation Management

Reference no: EM13902537

In the Atlanta area, the number of daily calls for the repair of Xerox copy machines has been recorded as follows: Day of month Calls (count) 1 92 2 127 3 106 4 165 5 125 6 111 7 178 8 97 Using Excel, perform the following calculations: Prepare a three-period moving-average forecast for the data. What is the error on each day? Prepare a three-period weighted-moving-average forecast using weights of w1=0.5, w2=0.3, w3=0.2 Which of the two forecasts is better? Then, Using the data prepare exponentially smoothed forecasts for the following cases: alpha = 0.1 and F1 = 90 alpha = 0.3 and F1 = 90

Reference no: EM13902537

Questions Cloud

Write a query that will show how may bookings have been made : Display the names of guests that have stayed at the hotel more than 10 times - Display details of the room(s) with the most bedrooms in the hotel.

What profit does cheapest earn per week with current system : Cheapest Car Rental rents cars at the Chicago airport. The rental market consists of two segments: the short term segment, which rents for an average of 0.5 weeks, and the medium-term segment, which rents for an average of 2 weeks. Identify throughpu..

Explain marginal product of second workers higher than first : Explain why the marginal product of the second and third workers might be higher than the first. Why might you expect the marginal product of additional workers to diminish eventually?

Objectives for a public health program : An explanation of three potential implications of having poorly articulated goals and objectives for a public health program and Description of your goal and objectives

Prepare a three-period moving-average forecast for the data : In the Atlanta area, the number of daily calls for the repair of Xerox copy machines has been recorded as follows: Day of month Calls (count) 1 92 2 127 3 106 4 165 5 125 6 111 7 178 8 97 Using Excel, perform the following calculations: Prepare a thr..

Conflict management refers solely to negotiation strategies : Conflict management refers solely to negotiation strategies that are designed to avoid unnecessary conflict and reduce or resolve excessive conflict. Conflict refers to a process in which one party perceives that its interests are being supported or ..

Complete the health care resources matrix : Imagine you are an administrator for a health care organization and have been asked by your stakeholders to determine how the organizations allocation of resources will be impacted by new health care laws. Complete the Health Care Resources Matrix

What is the break-even point in dollars of sales : A firm is selling two products, chairs and bar stools, each at $60 per unit. Chairs have a variable cost of $30, and bar stools $25. Fixed cost for the firm is $21,000. what is the break-even point in dollars of sales? In units of chairs and bar stoo..

Formulate as linear programming problem : A firm operates two farms of comparable productivity. Each farm has a certain amount of usable acreage and a supply of labor hours to plant and tend the crops. Farm 1 has 600 acres and 2000 labor hours available per month. The firm needs to determine..

User Account

All Pages