Can you please assist me with part C? Ive done the caluctions a million times but my calculations are are not adding up. Thank you 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 milesdriven during the past 5 years are as follows:Year2345Mileage3,1004,0503,4503,7503,800a) Using a 2-year moving average, the forecast for year 6 = 3775 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 = 108.3 miles (round your response to one decimal place). (Hint: You will haveonly 3 years of matched data.)c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.35 and 0.65 (the weight of 0.65 is for the most recent period) = 3782.5 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.35 and 0.65 =(Hint: You will have only 3 years of matched data.)miles (round your response to one decimal place).

Forecasting is the process of prediction in which sales demand is estimated using historic…

c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.35 and 0.65 (the weight of 0.65 is for the most recent period) = 3782.5 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.35 and 0.65 = (Hint: You will have only 3 years of matched data.) miles (round your response to one decimal place).

c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.35 and 0.65 (the weight of 0.65 is for the most recent period) = 3782.5 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.35 and 0.65 = (Hint: You will have only 3 years of matched data.) miles (round your response to one decimal place).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

b) Explain your approach to improve project delivery with the adoption of project ‘operational planning’. c) Explain your approach to using project product breakdown structure as opposed to work breakdown structure on a project you have been tasked to perform.
Integrated Health was a large private, nonprofit health care system located in Tempe,Arizona. A year ago, the decision was made to implement a computerized medication administration record (MAR) at Integrated Health. During the first year, the MAR system would be implemented at Central Hospital of Tempe. After the “bugs” were worked out, the computerized MAR would be implemented system-wide. The MIS department at Central Hospital was designated as the initiator and direction setter for the project. Art Smith, the Chief Information Officer at Central Hospital assigned Kate Cohen, a programmer/analyst, as project leader. Kate had the responsibility for developing and implementing the MAR project at Central. Kate did the programming work for the MAR and assembled a team from Pharmacy Services, Nursing Services, and Internal Auditing. Members of the project team provided feedback on the software, made suggestions related to user training, and worked on an implementation schedule. Both team…
Why do IT professionals may overlook project cost management how this might affect their ability to complete projects within budget
Integrated Health was a large private, nonprofit health care system located in Tempe,Arizona. A year ago, the decision was made to implement a computerized medication administration record (MAR) at Integrated Health. During the first year, the MAR system would be implemented at Central Hospital of Tempe. After the “bugs” were worked out, the computerized MAR would be implemented system-wide. The MIS department at Central Hospital was designated as the initiator and direction setter for the project. Art Smith, the Chief Information Officer at Central Hospital assigned Kate Cohen, a programmer/analyst, as project leader. Kate had the responsibility for developing and implementing the MAR project at Central. Kate did the programming work for the MAR and assembled a team from Pharmacy Services, Nursing Services, and Internal Auditing. Members of the project team provided feedback on the software, made suggestions related to user training, and worked on an implementation schedule. Both team…
Based on the provided components, develop a business model canvas of your project so that you can make an informed decision about whether or not to commit resources to taking it forward. a) Customer relationship b) Revenue stream
Explain program evaluation and review technique (PERT)?
Jack have been designated to organise an off-the job ‘Soft Skills training program’ for the employees of the company. Write a memo to your employer mentioning that the training will begin two weeks from the date of the memo and that it will take five days to complete. It will cost the company Rs. 3000 per employee and a maximum of 20 people can attend. Also, if the number of participants is beyond 10, the cost will be lowered to Rs. 2500 per employee. Seek an approval for this training program.
How can stakeholders' involvement in requirement analysis help ensure project success, and what challenges may arise in this process?
Use any of the information gathering techniques (i.e. Brainstorming) to identify five cost risks associated with a construction project?
Adjustments are made to accomplish?
Integrated Health was a large private, nonprofit health care system located in Tempe,Arizona. A year ago, the decision was made to implement a computerized medication administration record (MAR) at Integrated Health. During the first year, the MAR system would be implemented at Central Hospital of Tempe. After the “bugs” were worked out, the computerized MAR would be implemented system-wide. The MIS department at Central Hospital was designated as the initiator and direction setter for the project. Art Smith, the Chief Information Officer at Central Hospital assigned Kate Cohen, a programmer/analyst, as project leader. Kate had the responsibility for developing and implementing the MAR project at Central. Kate did the programming work for the MAR and assembled a team from Pharmacy Services, Nursing Services, and Internal Auditing. Members of the project team provided feedback on the software, made suggestions related to user training, and worked on an implementation schedule. Both team…
What are the benefits and downsides of SPI techniques, and how can one determine whether or not a certain method is suitable for a given project and business setting?