Concept explainers
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 14 Solutions
Operations and Supply Chain Management 9th edition
Additional Business Textbook Solutions
Operations Management: Processes and Supply Chains (11th Edition)
Operations Management: Sustainability and Supply Chain Management (12th Edition)
Business in Action (8th Edition)
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
Business in Action
Operations Management, Binder Ready Version: An Integrated Approach
- 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
- 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