Operations and Supply Chain Management, 9th Edition WileyPLUS Registration Card + Loose-leaf Print Companion
9th Edition
ISBN: 9781119371618
Author: Roberta S. Russell
Publisher: Wiley (WileyPLUS Products)
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 14, Problem 11P
Design a production plan for Mama’s Stuffin’ in Problem 14.5 using linear programming and Excel Solver.
Mama’s Stuffin’ is a popular food item during the fall and winter months, but it is marginal in the spring and summer. Use the following demand
- a. Level production over the 12 months.
- b. Produce to meet demand each month. Absorb variations in demand by changing the size of the workforce.
- c. Keep the workforce at its current level. Supplement with overtime and subcontracting as necessary.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A landscaping company want to plan for the number of employees it needs to hire for upcoming year. In order to do planning it is good to know the demand for landscape for the previous years.
The following table shows the demand for landscaping from 2019 to 2020. Help the company to forecast the demand for 2021.
Period
Demand
Winter 2019
23
Spring 2019
1000
Summer 2019
1300
Fall 2019
200
Winter 2020
34
Spring 2020
1050
Summer 2020
1340
Fall 2020
330
show work
You are responsible of developing the six-month aggregate production plan at Sodas Galore, a
manufacturer of soft drinks. Your company makes three types of sodas: regular, diet and
super-caffeinated. All three types are made using the same production process, and the
switching costs can be ignored as they are so minimal. The S&OP team case created the
following forecast of demand for the next six months. In addition to the sales forecast, the
company has also developed planning values that are also shown in the next table.
Month
Sales Forecast (cases)
Softdrinks Planning Values
January
24,000
Current workforce
8 workers
32,000 Average monthly output per worker
32,000 Inventory holding cost
46,000 Regular wage rate
February
4,000 cases per month
$.30 per case per month
$20.00 per hour
March
April
May
60,000 Regular production hours/month
44,000 Overtime wage rate
160 hours
June
$30.00 per hour
240,000 Hiring cost
$1,000 per worker
$1.15 per case
Total
Subcontracting cost
Firing/layoff…
A company wants to develop a level production plan for a family of products. The opening inventory is 550 units, and a decrease to 200 units is expected by the end of the plan.The demand for each of the periods is given in what follows. All periods have the samenumber of working days. How much should the company produce each period? Whatwill be the ending inventories in each period? Do you see any problems with the plan?
Chapter 14 Solutions
Operations and Supply Chain Management, 9th Edition WileyPLUS Registration Card + Loose-leaf Print Companion
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
Consider the sales data for Computer Success given in Problem 7. Use a 3-month weighted moving average to forec...
Operations Management: Processes and Supply Chains (11th Edition)
6. Explain why such forecasting devices as moving averages, weighted moving averages, and exponential smoothing...
Operations Management: Sustainability and Supply Chain Management (12th Edition)
What is precedent, and how does it affect common law?
Business in Action (8th Edition)
The best fits using exponential smoothing, trend analysis, and linear regression for the given data. Introducti...
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
What is precedent, and how does it affect common law?
Business in Action
What are the three historical milestones in operations management? How have they influenced management?
Operations Management, Binder Ready Version: An Integrated Approach
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 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardElite Distributor magazine is currently working on determining the number of publications they should print for the incoming trade show. The production manager analyzed the past data and summarized the following information. The average demand for the magazine is 3264 issues with a standard deviation of 120 issues during a similar trade shows. The magazine is sold for $10 each during the trade show and printing cost is $2.64 per issue. The leftover magazines is sold to a trade association for $1 a magazine to be distributed to its members during the next annual meeting. Considering this information, how many magazines should be printed before the trade show? (round your FINAL answer to the nearest integer). Hi if you can use Excel please complete the question that way. Thank You.arrow_forward
- The following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 Jun 10100 Olives Company is considering using a pure chase strategy. The company has an inventory balance of 300 units and a work force capable of making 9000 units at the beginning of January. Stockout cost due to loss sale is estimated to be $800 per unit. Monthly inventory holding cost are $20 per unit. Olives estimates that adding capacity will cost $75 per unit and firing capacity will cost $50 per unit. Under this plan which of the following is true. O Olives will have inventory cost at the end of January of $5500 O Olives will spend $500 on hiring at the beginning of January O Olives will spend $13,750 on firing at the beginning of January Olives will need to use overtime in April, May and June O Olives holding cost will be be a total of $11000 for the entire plan O None of the other answers are correctarrow_forwardThe following is the forecasted demand for Olives Company over the next few months. Month Forecasted Demand Jan 9025 Feb 9000 Mar 9450 Apr 9830 May 9630 10100 Jun Olives Company plans on using a constant production of 9,250 units a month at a $941 per unit cost. The company has an inventory balance of 300 units at the beginning of January. Stockout cost due to loss sale is estimated to be $202 per unit. Monthly inventory holding cost are $20 per unit. Olives Company can produce an additional 10% of its' regular production in overtime at the cost of $80 more per unit. Assume that Olives Company will avoid stockout if possible Under this plan how much will will Olives Company spend on inventory holding cost (answer to the nearest whole number)arrow_forwardproduction planning and control please helparrow_forward
- production planning and control please helparrow_forwardTwo items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600arrow_forwardOver the past 12 months, Super Toy Mart has experienced a demand variance of 10,250 units and has produced an order variance of 12,050 units. Part 2 a) The bullwhip measure for Super Toy Mart is ______ (round your response to two decimal places). Part 3 b) If Super Toy Mart had made a perfect forecast of demand over the past 12 months and had decided to order 1/12 of that annual demand each month, the bullwhip measure would have been ______ (round your response to the nearest whole number.)arrow_forward
- The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with lost sales, i.e., without backorders. Given this information, what is the number in the cell that says xx?arrow_forward3. As manager of the St. Cloud Theater Company, you have decided that concession sales would support themselves. The following table provides the information you have been able to put together thus far: Item Softdrink Selling Price $1.00 Variable Cost $0.65 Percent of Revenue Wine Coffee 1.75 1.00 0.95 0.30 25 25 30 Candy 1.00 0.30 20 Last year's manager. Jim Freeland, has advised you to add 10% of variable cost as a waste allowance for all categories. You estimated labor cost to be $250.00 (5 booths with 2 people each). Even if nothing is sold, your labor cost will be $250.00, so you decide to consider this as fixed cost. Booth rental, which is a contractual cost of $50.00 for each booth per night, is also a fixed cost. a. What is the break-even volume per evening of performance? b. How mush would you expect to sell each evening at the break-even point?arrow_forwardDemand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical 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
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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
Introduction to Forecasting; Author: Ekeeda;https://www.youtube.com/watch?v=5eIbVXrJL7k;License: Standard YouTube License, CC-BY