Show in excel how to calculate the MAD using weighted average or what the formula would be?
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage 1 3,050 2 3 4 5 3,950 3,450 3,750 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3750 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 83.33 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = 3750 miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60 = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage 1 3,050 2 3 4 5 3,950 3,450 3,750 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3750 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 83.33 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = 3750 miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60 = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)
Expert Answer:
Related Book For
Operations Management
ISBN: 978-0132687584
1st Canadian Edition
Authors: Jay Heizer, Barry Render, Paul Griffin
Posted Date:
Students also viewed these general management questions
-
The Bonavista Patient Transfer Company is considering the purchase of a new ambulance. The decision will rest partly on the anticipated distance to be driven next year. The kilo meters driven during...
-
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are...
-
What does a SWOT analysis reveal about the overall attractiveness of lululemon's situation?
-
Consider the following 20 observations, representing quarterly information for 5 years. a. Plot the above series and discuss its trend and seasonal components. b. Use decomposition analysis to make...
-
What value of C makes the two cash flows equal? Assume i = 10%. 20 20 $72 $50 $50 C 1 2 3 1 2 3
-
Work automation is the practice of replacing human workers with technology (i.e., software programs or robots). Describe the impact that work automation is likely to have on business and society in...
-
Construct a systems flowchart based on the narrative and the output from Problems 4- 4 through 4- 6. Use Microsoft Visio or other diagramming software.
-
An atom has a magnetic moment = (2.0 x 10-23 A-m) and is located in an external magnetic field B = (0.15 T) . How much energy is required to rotate the atom so that its magnetic moment points in the...
-
Using the Internet, find two examples of advertisements for sports products that use indirect objectives and two examples of advertisements that use direct objectives.
-
At the end of the current year, Accounts Receivable has a balance of $685,000; Allowance for Doubtful Accounts has a credit balance of $6,000; and sales for the year total $3,080,000. Bad debt...
-
a. The three bulbs in Figure Q23.16 are identical. Rank the bulbs from brightest to dimmest. Explain. b. Suppose a wire is connected between points 1 and 2 . What happens to each bulb? Does it get...
-
For the circuit of Figure P26.60, a. What is the resonance frequency? b. At resonance, what is the peak current through the circuit? FIGURE P26.60 (10 V) cos (2ft) i eeee-ww 1002 1.0 mH 1.0 F
-
Figure P26.2 shows voltage and current graphs for a resistor. a. What is the value of the resistance \(R\) ? b. What is the emf frequency \(f\) ? FIGURE P26.2 VR 10 V- Voltage Current 0.50 A 0+ 0.00...
-
The two circuits in Figure Q22.13 use identical batteries and wires made of the same material and of equal diameters. Rank in order, from largest to smallest, the currents \(I_{1}\) to \(I_{7}\) at...
-
The two circuits in Figure Q22.12 use identical batteries and wires made of the same material and of equal diameters. Rank in order, from largest to smallest, the currents \(I_{1}, I_{2}, I_{3}\),...
-
We have reason to believe that inconsistent handers may value curiosity more than consistent handers. Does this mean inconsistent handers would score higher on personality traits like "openness to...
-
Listed below are several terms and phrases associated with basic assumptions, broad accounting principles, and constraints. Pair each item from List A (by letter) with the item from List B that is...
-
Cynthia Knotts seafood restaurant buys fresh Nova Scotia lobster for $5 per pound and sells them for $9 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery...
-
Drolet Manufacturing Company, in Saint-Hubert, Quebec, makes flashing lights for toys. The company operates its production facility 300 days per year. It has orders for about 12 000 flashing lights...
-
We place our trust in authorities for many things, and when this trust is breached, we demand answers. Such was the case in Walkerton, Ontario, in May 2000. Starting May 15 of that year, many...
-
Owing to a small federal grant from the Department of Housing and Urban Development (HUD) to the Town of Stillman, Nadine Gordimer, CPA has performed grant audits for the town in each of the past...
-
Michael Cunningham, CPA is preparing a report on internal control in conjunction with an audit of the City of Warwick's June 30, 1999 financial statements. The audit is being conducted in accordance...
-
As a GAO auditor, you have been assigned to perform an audit of a Department of Education School Breakfast Program. The Department had instructed all schools to order commodities in economical...
Study smarter with the SolutionInn App