Please assist me with this question. c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3)tracking signal at month 10, and (4) 2s control limits. (Negative values should be indicated by a minus sign. Round your answers to 2decimal places.)MSEMADTracking signalControl limits0 ±: Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months.The forecasts and actual sales are as follows:Month12345678009010Forecast 1Forecast 2Sales835850845825795850815835840830Forecast 1820790795815800775785770800795MAPE F1MAPE F2a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.)MSEForecast 2765795830%%815790791815770805810MADb. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimalplaces.)

Formulae used: For Error = Actual Sales – Forecast For Abs = Absolute value of | Actual Sales –…

c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s control limits. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limits 0+

c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s control limits. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limits 0+

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

give a breakdown of part b please
What are your preferred methods of receiving information? Does your answer differ depending on the type of information being sent?
What is Round Table Discussion? Explain your answer
Mr. Arshi was being introduced as a new Board of director for a local Bank to all the employees in the HQ. During a visit at one of the branch offices, he was informed by a supervisor that employee turnover is too high, and no sooner had one employee been put on the job than another one resigned. She told that she had little time to work with the new employees as they came and went. All branch supervisors hired their own employees without communication with the HQ or other branches. After touring the 22 branches and finding similar problems in many of them, Arshi wondered what HQ should do or what action he should take. As HR Manager, What specific functions should an HR unit carry out?
Which of the authorized relationships in Florida offers the least amount of representation but the most flexibility in terms of what kind of relationship the other party to an in-house residential transaction can have? transaction broker no brokerage both single agent and transaction broker single agent
The Dean of Iqra University (IU), a prestigious educational institution, has requested the President of Jupiter Insurance Company Limited to accept five final year students as interns during the summer holidays. As the Public Relations Officer of Jupiter Insurance Company Limited, you have been directed to write a email of about 250 – 300 words, to the Dean stating that it would not be possible to provide internship facility this year. You may offer any reasons for not agreeing to the Dean’s request. However, your letter should be worded in a courteous tone as IU not only provides substantial business to your company but also because the Dean has considerable influence and respect in the business and professional circles. Assessment Rubric:
What should you include in your application letter?
What are the advantages and disadvantages of laundering staff uniforms on property verses using an off-site laundry?
Why is the appearance of the Inspector of considerable importance at meetings and negotiation sessions?
6.Assume that you are a hotelier who has a group booked at your hotel. The group has picked up all of its originally requested rooms and is now requesting additional rooms at the same reduced rates you originally agreed to when their group rooms contract was signed. You do have rooms available to fulfill the group’s new request, but you know those remaining rooms could now be sold to the general public at rates much higher than those being paid by the group. What factors would you consider prior to granting, or not granting, this group’s request for additional rooms? 7.Some hotels state that they guarantee room availability (but not room type availability) when a guest arrives with a guaranteed reservation. Name one advantage of such an approach. Name one disadvantage. 8.Some hotels’ FOMs authorize their front office agents to adjust room charges up to the amount of a guest’s total charges for their stay. Other FOMs limit the dollar amount of adjustment that can be made without…