
Two different
a. Compute MAD for each set of forecast, Given your results, which forecast appears to be more accurate? Explain.
b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate?
c. In practice, either MAD or MSE would be employed to compute forecast errors. What factors might lead a manager to choose one rather than the other?
d. Compute MAPE for each data set. Which forecast appears to be more accurate?
a)

To compute: Mean Average Deviation (MAD) for each set of forecasts.
Introduction: Mean Absolute Deviation (MAD) is the average distance between the data values and the mean. Mean Squared Error (MSE) is the average of the squares of the deviation and error.
Explanation of Solution
Given information:
Given the following data on demand and forecasts during two periods, decide which method gives more accurate results, by computing the Mean absolute deviation (MAD) for both the methods as shown below.
Calculate the Mean absolute deviation (MAD) as shown below for the two methods:
Compute the Mean absolute deviation (MAD) for the forecasting method F1 as shown below
Substitute the value of
Compute the Mean absolute deviation (MAD) for the forecasting method F2 as shown below
Substitute the value of
Between the two methods, the second forecasting method F2 has lower MAD and hence more accurate compared to the first method F1
b)

To compute: Mean Squared Error (MSE) for each set of forecasts.
Introduction: Mean Squared Error (MSE) is the average of the squares of the deviation and error.
Explanation of Solution
Given information:
Given the following data on demand and forecasts during two periods, decide which method gives more accurate results, by computing the Mean squared error (MSE) for both the methods as shown below.
Calculate the Mean squared error (MSE) as shown below for the two methods
Compute the Mean squared error (MSE) for the forecasting method F1 as shown below
Substitute the value of
Compute the Mean squared error (MSE) for the forecasting method F2 as shown below
Substitute the value of
Between the two methods, the second forecasting method F2 has lower MSE and hence more accurate compared to the first method F1.
c)

To determine: The factors that lead managers to choose any approach over another.
Introduction: Mean Squared Error (MSE) is the average of the squares of the deviation and error.
Explanation of Solution
MSE magnifies the error by squaring the difference. Therefore, MSE is able to quickly point out wrong forecasting models. However, both MAD and MSE are equally accurate in defining the errors in forecasting. It depends on the individual analyst to choose a particular method for decision making.
d)

To compute: Mean Absolute Percentage Error (MAPE) for each set of forecasts.
Explanation of Solution
Compute the Mean Absolute Percentage Error (MAPE) as shown below.
The absolute percentage error is computed by dividing the absolute error value by the actual demand figures.
The Mean Absolute Percentage Error (MAPE) is computed by adding the absolute percentage errors for the eight periods and dividing the sum by eight.
The calculations are shown above in the table derived, using Microsoft Excel.
The second forecasting method F2 has a lower MAPE of 4.11% compared to the first forecasting method F1 which gives a MAPE value of 5.34%. Therefore, the second method is more accurate.
Want to see more full solutions like this?
Chapter 3 Solutions
Operations Management
- Can you guys help me with this? Thank you! Here's the question: Compared to the CONSTRAINT model, how has the network changed? How do you plan to add contingency to your network? Please answer this throughly Here's the what-if scenario: Assume that Dallas plant has lost power. It cannot serve the DCs anymore and has to remain locked indefinitely. Re-optimize the network considering this new constraint. Here's the scenario comparison analysis: Scenario Constraint Scenario vs What-if Scenario Summary In comparing the Constraint Scenario to the What-if Scenario, a few key differences highlight the efficiencies evident in the supply chain. Firstly, the total cost in the Constraint Scenario is lower at $7,424,575.45, while the What-if Scenario incurs a total cost of $7,486,369.12, resulting in a cost delta of $61,793.67. Additionally, although both scenarios exhibit the same average service time of 0.72 days, the What-if Scenario has a more favorable average end-to-end service time of 2.41…arrow_forwardEmployee In-Service Training ASSIGNMENT: In-Service Training. The intern is required to plan and implement two in-service training sessions for employees. Each in-service should last at least 10 but not more than 30 minutes and should be given to all employees affected. The preceptor or supervisor/unit manager must approve all in-service topics. 1) One presentation should be related to a policy or procedure of any kind (e.g. proper use of equipment); 2) The second presentation must be related to sanitation or safety. For each in-service presentation, the intern must develop a written class plan and a visual aid (may be a handout, poster, PowerPoint slide presentation, etc.) appropriate to the life experiences, cultural diversity and educational background of the target audience. The intern must also measure behavior change. Note, this cannot be measured by a written pre- and post- test. That would be measuring knowledge. The intern mustactually observe and document that the learners…arrow_forwardFor a dietary manager in a nursing home to train a dietary aidearrow_forward
- Dietary Management in a Nursing Home. As detailed as possible.arrow_forwardFor dietary management in a nursing home. As detailed as possible.arrow_forwardA small furniture manufacturer produces tables and chairs. Each product must go through three stages of the manufacturing process – assembly, finishing, and inspection. Each table requires 3 hours of assembly, 2 hours of finishing, and 1 hour of inspection. The profit per table is $120 while the profit per chair is $80. Currently, each week there are 200 hours of assembly time available, 180 hours of finishing time, and 40 hours of inspection time. Linear programming is to be used to develop a production schedule. Define the variables as follows: T = number of tables produced each week C= number of chairs produced each week According to the above information, what would the objective function be? (a) Maximize T+C (b) Maximize 120T + 80C (c) Maximize 200T+200C (d) Minimize 6T+5C (e) none of the above According to the information provided in Question 17, which of the following would be a necessary constraint in the problem? (a) T+C ≤ 40 (b) T+C ≤ 200 (c) T+C ≤ 180 (d) 120T+80C ≥ 1000…arrow_forward
- As much detail as possible. Dietary Management- Nursing Home Don't add any fill-in-the-blanksarrow_forwardMenu Planning Instructions Use the following questions and points as a guide to completing this assignment. The report should be typed. Give a copy to the facility preceptor. Submit a copy in your Foodservice System Management weekly submission. 1. Are there any federal regulations and state statutes or rules with which they must comply? Ask preceptor about regulations that could prescribe a certain amount of food that must be kept on hand for emergencies, etc. Is the facility accredited by any agency such as Joint Commission? 2. Describe the kind of menu the facility uses (may include standard select menu, menu specific to station, non-select, select, room service, etc.) 3. What type of foodservice does the facility have? This could be various stations to choose from, self-serve, 4. conventional, cook-chill, assembly-serve, etc. Are there things about the facility or system that place a constraint on the menu to be served? Consider how patients/guests are served (e.g. do they serve…arrow_forwardWork with the chef and/or production manager to identify a menu item (or potential menu item) for which a standardized recipe is needed. Record the recipe with which you started and expand it to meet the number of servings required by the facility. Develop an evaluation rubric. Conduct an evaluation of the product. There should be three or more people evaluating the product for quality. Write a brief report of this activity • Product chosen and the reason why it was selected When and where the facility could use the product The standardized recipe sheet or card 。 o Use the facility's format or Design one of your own using a form of your choice; be sure to include the required elements • • Recipe title Yield and portion size Cooking time and temperature Ingredients and quantities Specify AP or EP Procedures (direction)arrow_forward
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPractical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning


