Operations Management: Processes and Supply Chains (11th Edition)
11th Edition
ISBN: 9780133872132
Author: Lee J. Krajewski, Manoj K. Malhotra, Larry P. Ritzman
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 12P
Gemini Inc. is using the Sales and Operations Planning with Spreadsheets Solver in OM Explorer to develop a 5-nioiith production plan. Use the provided derived outputs and calculated costs to specify the model’s inputs. (Hint: Don’t forget that the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
By selecting Cigna Accredo pharmacy that i identify in my resand compare the current feedback system against the “Characteristics of a Good Multiple Source Feedback Systems” described in section 8-3-3. What can be improved? As a consultant, what recommendations would you make?
Scenario
You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill.
Accurate forecasts are important for many reasons, including for the company to ensure they have the materials
they need to create the products required in a certain period of time. Your objective is to minimize the forecast
error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%.
You have historical monthly sales data for the past year and access to software that provides forecasts based on
five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential
Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given
data, you will identify trends and patterns to create a more accurate forecast.
Approach
Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…
Approach
Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next
month.
Remember to select the forecasting technique that produces the forecast error nearest to zero. For example:
a. Naïve Forecast is 230 and the Forecast Error is -15.
b. 3-Month Moving Forecast is 290 and the Forecast Error is -75.
c. Exponential Smoothing Forecast for .2 is 308 and the Forecast Error is -93.
d. Exponential Smoothing Forecast for .5 is 279 and the Forecast Error is -64.
e. Seasonal Forecast is 297 and the Forecast Error is -82.
The forecast for the next month would be 230 as the Naïve Forecast had the Forecast Error closest to zero with a
-15. This forecasting technique was the best performing technique for that month. You do not need to do any
external analysis-the forecast error for each strategy is already calculated for you in the tables below.
Naïve
Month Period
Actual
Demand
Naïve Forecast
Error
3-
Month
Moving
Forecast
3-
Month
Moving…
Chapter 10 Solutions
Operations Management: Processes and Supply Chains (11th Edition)
Ch. 10 - List the types of costs incurred when employees...Ch. 10 - Prob. 2DQCh. 10 - Prob. 3DQCh. 10 - Explain why management should be concerned about...Ch. 10 - The Barberton Municipal Division of Road...Ch. 10 - Bob Canton’s golf camp estimates the following...Ch. 10 - Prob. 3PCh. 10 - Prob. 4PCh. 10 - Management at the Kerby Corporation has determined...Ch. 10 - Gretchen’s Kitchen is a fast-food restaurant...
Ch. 10 - Prob. 7PCh. 10 - Tax Prep Advisers, Inc. has forecasted the...Ch. 10 - Climate Control, Inc. makes expedition-quality...Ch. 10 - Prob. 11PCh. 10 - Gemini Inc. is using the Sales and Operations...Ch. 10 - Gerald Glynn manages the Michaels Distribution...Ch. 10 - Cara Ryder manages a ski school in a large resort...Ch. 10 - Prob. 15PCh. 10 - Prob. 17PCh. 10 - The Hickory Company manufactures wooden desks....Ch. 10 - Prob. 19PCh. 10 - The Mowry Machine Shop still has five jobs to be...Ch. 10 - If we use the same number of workers in each...Ch. 10 - Prob. 2AMECh. 10 - Prob. 3AMECh. 10 - Suppose the overtime cost is $3,300. What happens...Ch. 10 - Suppose the undertime cost is the same as the...Ch. 10 - Prob. 6AMECh. 10 - Prob. 1VCCh. 10 - Does Starwood employ a chase, level, or mixed...Ch. 10 - How would staffing for the opening of a new hotel...Ch. 10 - Explain the alternatives available to Darlene Fry...Ch. 10 - Prob. 2C
Additional Business Textbook Solutions
Find more solutions based on key concepts
Real options and its types. Introduction: The net present value is the variation between present cash inflows v...
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
CHAPTER CASE
S&S Air’s Mortgage
Mark Sexton and Todd Story, the owners of S&S Air, Inc., were impressed by the ...
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
The flowchart for the process at the local car wash. Introduction: Flowchart: A flowchart is a visualrepresenta...
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
The Warm and Toasty Heating Oil Company used to deliver heating oil by sending trucks that printed out a ticket...
Essentials of MIS (13th Edition)
How is activity-based costing useful for pricing decisions?
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
How did the recession of 2007-2009 compare with other recessions since the Great Depression in terms of length?...
Foundations of Financial Management
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Scenario You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%. You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast. Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…arrow_forwardUse the internet to obtain crash safety ratings for passenger vehicles. Then, answer thesequestions:a. Which vehicles received the highest ratings? The lowest ratings?b. How important are crash-safety ratings to new car buyers? Does the degree of importancedepend on the circumstances of the buyer?c. Which types of buyers would you expect to be the most concerned with crash-safety ratings?d. Are there other features of a new car that might sway a buyer from focusing solely on crashsafety? If so, what might they be?arrow_forward“Implementing a Performance Management Communication Plan at Accounting, Inc.” Evaluate Accounting Inc.’s communication plan. Specifically, does it answer all of the questions that a good communication plan should answer? Which questions are left unanswered? How would you provide answers to the unanswered questions? “Implementing an Appeals Process at Accounting, Inc.” If you were to design an appeals process to handle these complaints well, what would be the appeal process? Describe the recommended process and why.arrow_forward
- The annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00arrow_forwardHelp answer showing level work and formulasarrow_forwardI need to forecast using a 3-Period-Moving-Average-Monthly forecasting model which I did but then I need to use my forecast numbers to generate a Master Production Schedule (MPS) I have to Start with actual sales (my own test data numbers) for August-2022 Oct-2022 i need to create MPS to supply demand starting November-2022 April 2023 I just added numbers without applying formulas to the mps on the right side of the spreadsheet because I do not know how to do it. The second image is the example of what it should look like. Thank You.arrow_forward
- Solve the following Question 1. How do volume and variety affect the process selection and layout types? Discuss 2. How is the human resource aspect important to operation function? Discuss 3. Discuss the supply network design and its impact on the overall performance of the organization.arrow_forwardHelp with question?arrow_forwardWhat are some good examples of bullet points on a resume for a Christian Elementary School?arrow_forward
- What is an example of a cover letter for a Christian School Long-Term Substitute Teaching position?arrow_forwardThe supply chain is a conventional notion, but organizations are only really interested in making products that they can sell to customers. Provided they have reliable supplies of materials and reasonable transport for finished products, logistics is irrelevant. Do you think this is true? If yes, explain, and if no, clearly explain as well.arrow_forwardworking as a program operations managerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License