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
- Two 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_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
- A popular brand of tennis shoe has had the following demand history by quarters over a three-year period. a. Determine the seasonal factors for each quarter.b. Based on the result of part (a), determine the deseasonalized demand series.c. Predict the demand for each quarter of Year 4 for the deseasonalized series from a six-quarter moving average.d. Using the results from parts (a) and (c), predict the demand for the shoes for each quarter of Year 4.arrow_forwardData collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Year Demand (Bags) 4 6. 3 4. 4. 10 6 8. 8. 8. 12 10 14 11 15 O A. 13.67 O B. 14.00 OC. 14.87 O D. 11.79 Click to select your answer. Us MacBook Air 888 * ES F2 F4 F6 F7 4) F9 F10 %23 2$ & * 4 6. 7 8 9. Q W R T Y F C V В alt command command option %#3arrow_forwardLeah Johnson, director of Urgent Care of Brookline, wants to increase capacity to provide low-cost flu shots but must decide whether to do so by hiring another full-time nurse or by using part-time nurses. The table below shows the expected costs of the two options for three possible demand levels: States of Nature (demand) Alternatives Low Medium High Hire full−time $320 $480 $700 Hire part−time $0 $340 $800 Probabilities 0.20 0.55 0.25 Part 2 a) The alternative with the least expected cost is ▼ a. Hire full-time b. Hire part-time The expected price of this alternative is $_______ (enter your answer as a whole number). Part 4 b) The appropriate decision tree for Leah Johnson is presented in Figure____?arrow_forward
- Lake Grove Confectionaries (LGC) sells chocolates for the holiday season in specially designed boxes. The firm sells four designs, and currently, all packaging is done in the plant as chocolates are manufactured. All manufacturing and packaging for the holiday season are completed before the start of the season. The demand forecast for each of the four designs is normally distributed, with a mean m=10,000 and a standard deviation of s=6,000. Each box costs $15 and is sold for $30. Any unsold boxes are discounted by $9. The cost of holding a box in inventory is $1. What is the expected profit of this policy?arrow_forwardplease try to provide solution in 30 minarrow_forwardLorie Nursery plans to sell 6,000 potted plants during May, 5, 700 in June, and 6,000 during July. The company keeps 10% of the next month's sales as ending inventory. How many units should Lorie Nursery produce during June?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