Operations and Supply Chain Management 9th edition
9th Edition
ISBN: 9781119320975
Author: Roberta S. Russell, Bernard W. Taylor III
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 12P
Design a production plan for FansForYou in Problem 14.6 using linear programming and Excel Solver.
FansForYou is a small, privately owned company that manufactures fans. Large variations in demand due to seasonality have contributed to high costs for the company. FansForYou currently uses a level production strategy because it prefers not to hire and fire employees.
However, if there is enough cost justification, the company will consider alternative production plans.
- a. What is the cost of the current production plan?
- b. How much would FansForYou save by using a chase demand strategy?
- c. How much would FansForYou save by keeping a steady workforce of 20 workers and supplementing with overtime and subcontracting as needed?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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…
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…
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…
Chapter 14 Solutions
Operations and Supply Chain Management 9th edition
Ch. 14.S - Prob. 1QCh. 14.S - Prob. 2QCh. 14.S - Prob. 3QCh. 14.S - Prob. 4QCh. 14.S - Prob. 5QCh. 14.S - Prob. 6QCh. 14.S - Prob. 7QCh. 14.S - Prob. 8QCh. 14.S - Prob. 1PCh. 14.S - The Tycron Company produces three electrical...
Ch. 14.S - Prob. 3PCh. 14.S - The Pinewood Cabinet and Furniture Company...Ch. 14.S - The Mystic Coffee Shop blends coffee on the...Ch. 14.S - Prob. 6PCh. 14.S - Prob. 7PCh. 14.S - Prob. 8PCh. 14.S - Prob. 9PCh. 14.S - Prob. 10PCh. 14.S - Prob. 11PCh. 14.S - Prob. 12PCh. 14.S - Prob. 13PCh. 14.S - Prob. 14PCh. 14.S - Prob. 15PCh. 14.S - Prob. 16PCh. 14.S - Prob. 17PCh. 14.S - Prob. 18PCh. 14.S - Prob. 19PCh. 14.S - Prob. 20PCh. 14.S - Prob. 22PCh. 14.S - Prob. 23PCh. 14.S - Prob. 24PCh. 14.S - Prob. 25PCh. 14.S - Prob. 27PCh. 14.S - Prob. 28PCh. 14.S - Prob. 1.1CPCh. 14.S - Prob. 1.2CPCh. 14.S - Prob. 1.3CPCh. 14.S - Prob. 1.4CPCh. 14.S - Prob. 1.5CPCh. 14.S - Prob. 1.6CPCh. 14.S - Prob. 1.7CPCh. 14.S - Prob. 1.8CPCh. 14.S - Prob. 1.9CPCh. 14.S - Prob. 2.1CPCh. 14 - Prob. 1.1ASCCh. 14 - Prob. 1.2ASCCh. 14 - Supply and Demand in the Spirits Industry A...Ch. 14 - Supply and Demand in the Spirits Industry A...Ch. 14 - Supply and Demand in the Spirits Industry A...Ch. 14 - Disneys Magic Numbers Sales and operations...Ch. 14 - Disneys Magic Numbers Sales and operations...Ch. 14 - Prob. 1QCh. 14 - List several alternatives for adjusting capacity....Ch. 14 - Prob. 3QCh. 14 - How do linear programming, the linear decision...Ch. 14 - Prob. 5QCh. 14 - What options are available for altering the...Ch. 14 - Prob. 7QCh. 14 - Prob. 8QCh. 14 - Explain the process of collaborative planning. How...Ch. 14 - Prob. 11QCh. 14 - Prob. 12QCh. 14 - Prob. 1PCh. 14 - Prob. 2PCh. 14 - Prob. 3PCh. 14 - Prob. 4PCh. 14 - Mamas Stuffin is a popular food item during the...Ch. 14 - Prob. 6PCh. 14 - Slopes Sleds (SS) makes skis, snowboards, and...Ch. 14 - Prob. 8PCh. 14 - Midlife Shoes, Inc, is a manufacturer of sensible...Ch. 14 - Design a production plan for Mamas Stuffin in...Ch. 14 - Design a production plan for FansForYou in Problem...Ch. 14 - Prob. 16PCh. 14 - Prob. 17PCh. 14 - Prob. 18PCh. 14 - Prob. 19PCh. 14 - Prob. 20PCh. 14 - Prob. 21PCh. 14 - Prob. 22PCh. 14 - How many units are available-to-promise in period...Ch. 14 - Complete the available-to-promise table below.Ch. 14 - Complete the available-to-promise table below.Ch. 14 - Calculate the available-to-promise row in the...Ch. 14 - Complete the following table. How many Bs are...Ch. 14 - Managers at the Dew Drop Inn are concerned about...Ch. 14 - Prob. 29PCh. 14 - Prob. 30PCh. 14 - Prob. 31PCh. 14 - Prob. 32PCh. 14 - The Forestry Club sells Christmas trees each year...Ch. 14 - Prob. 34PCh. 14 - Tariott Hotel rents rooms for 125 a night that...Ch. 14 - Prob. 36PCh. 14 - Prob. 1.1CPCh. 14 - Prob. 1.2CPCh. 14 - Prob. 1.3CP
Additional Business Textbook Solutions
Find more solutions based on key concepts
1-1. Define marketing and outline the steps in the marketing process. (AASCB: Communication)
Marketing: An Introduction (13th Edition)
The annual report is considered by some to be the single most important printed document that companies produce...
Accounting Information Systems (14th Edition)
Preparing Financial Statements from a Trial Balance The following accounts are taken from Equilibrium Riding, I...
Fundamentals of Financial Accounting
IFRS5-1 Explain the difference between the “nature-of-expense” and “function-of-expense” classifications.
Financial Accounting: Tools for Business Decision Making, 8th Edition
To what does the lifetime value of the customer refer, and how is it calculated?
MARKETING:REAL PEOPLE,REAL CHOICES
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)
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
- Use 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_forwardThe 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_forward
- Help 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_forwardSolve 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_forward
- The 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_forward12 X1, X230 1 x =0x2 write the Following linear Programming model by 1- general Form Canonical Forms Canonical formY 2- Standard Form Max Z=35X+ 4 X 2 +6 X3 ST. X+2X2-5x3 = 40 3X, + 6X2 + 7x 3 = 30 7x, +lox2 x3 = 50 X3 X 2 X 3 <0arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY