BIG produces four types of yogurts A, B, C, and D. Each box of yogurt carries protein, sugar, and Fat. The following table provides information about content of each box of yogurt together with production cost of each box. Protein /Box Sugar/Box Fat/Box Production Cost/Box Yogurt A 10 3 1.5 $ 2.00 Yogurt B 20 2 1 $ 3.00 Yogurt C 30 2.5 1.5 $ 5.00 Yogurt D 20 2 1.5 $ 3.50 BIG wants to produce yogurts in such a way that will provide at least 400 grams of protein with minimum production cost. However, BIG also have to make sure they are not providing more than 200 gm of Sugar and 200 gm of Fat while providing the required protein. Moreover, BIG has to produce at least one unit of each type of yogurt and the number of yogurt A produced should not be more than the number of yogurt C produced. SOLVE USING EXCEL SOLVER

BIG produces four types of yogurts A, B, C, and D. Each box of yogurt carries protein, sugar, and Fat. The following table provides information about content of each box of yogurt together with production cost of each box. Protein /Box Sugar/Box Fat/Box Production Cost/Box Yogurt A 10 3 1.5 $ 2.00 Yogurt B 20 2 1 $ 3.00 Yogurt C 30 2.5 1.5 $ 5.00 Yogurt D 20 2 1.5 $ 3.50 BIG wants to produce yogurts in such a way that will provide at least 400 grams of protein with minimum production cost. However, BIG also have to make sure they are not providing more than 200 gm of Sugar and 200 gm of Fat while providing the required protein. Moreover, BIG has to produce at least one unit of each type of yogurt and the number of yogurt A produced should not be more than the number of yogurt C produced. SOLVE USING EXCEL SOLVER

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Demand 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…
3.3 BriteSmile brand of teeth whitening products is considering adding a modified ver- sion of the product-a gel product in addition to its regular paste product. Variable costs and prices to wholesalers are: Unit selling price Unit variable costs Current paste product $5.00 $1.50 New gel product $6.50 $3.25 BriteSmile expects to sell 2 million units of the new gel product in the first year after introduction, but it estimates that only 30% of those sales will come from buyers who do not already purchase the company's paste product (that is, new customers). BriteSmile estimates that it would sell 3 million units of the current paste product if it did not introduce the gel. If the fixed costs of launching the new gel product will be $300,000 during the first year, should BriteSmile add the new gel product to its line? Why or why not?
Inventory Management You are the store manager at a local branch of DigiLife, a large electronics retail chain. A new version of a popular consumer electronics device called the Amulet is coming out this year. It is your job to sell as many Amulets as you can while minimizing your costs in order to maximize your store's profits. Your Goal Earn $1,000,000 in net profits of Amulet sales.
Shoes Ltd. manufactures three items: Sneakers, Takkies and Sandals. The table below contains information regarding these products: Sneakers (R/ unit) Takkies (R/ unit) Sandals (R/ unit) Material cost 60 75 40 Labour cost 24 68 42 Variable overhead cost 7 12 16 Fixed overhead cost 36 23 11 Selling price per unit 870 990 650 Volume of production 12 000 28 500 31 200 Fixed overheads are allocated to products based on direct labour hours. Direct labour hours are constrained and therefore limited to 140 000 hours. The direct labour rate is R25 per hour. w Required: Q.3.1 Calculate the contribution margin per labour hour and then rank the products in order of profitability. Q.3.2 Calculate the number of units of each product that needs to be manufactured to
Demand for stereo headphones and MP3 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 last year was as follows: MONTH DEMAND (UNITS) January 4,120 February 4,220 March 3,920 April 4,320 May 4,920 June 4,620 July 5,220 August 4,820 September 5,320 October 5,620 November 6,220 December 5,920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (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 level of confidence? (Do not round intermediate calculations. Round…
Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
What would be the impact on profitability of processing Product B further, rather than selling product B at the intermediate stage? O increase in profitability of $24,000 Increase in profitability of $10,000 Decrease in profitability of $5,000 Decrease in profitability of $15,000 None of the above 2nd question solve plz
Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…
Navajo Company's year-end financial statements show the following. The company recently discovered that in making physical counts of inventory, it had made the following errors: Year 1 ending inventory is understated by $69,000 and Year 2 ending inventory is overstated by $39,000. For Year Ended December 31 (a) Cost of goods sold (b) Net income (c) Total current assets (d) Total equity Year 1 $ 744,000 Year 2 $ 974,000 287,000 1,266,000 1,406,000 294,000 1,379,000 1,599,000 Year 3 $ 809,000 269,000 1,249,000 1,264,000 Required: 1. For each key financial statement figure-(a), (b), (c), and (d) above-prepare a table to show the adjustments necessary to correct the reported amounts. 2. What is the total error in combined net income for the three-year period resulting from the inventory errors? Complete this question by entering your answers in the tabs below. Required 1 Required 2 For each key financial statement figure-(a), (b), (c), and (d) above-prepare a table to show the adjustments…
Put this in other words. Analyze and elaborate this one. In the intricate orchestration of supply chain management, predictive analytics emerges as an indispensable conductor. Drawing upon colossal datasets from multifarious sources, predictive analytics unfurls a tapestry of precise supply and demand prognostications, meticulous inventory optimization, seamless logistics orchestration for punctual deliveries, anticipation of equipment maintenance exigencies, and the nimble adaptation to unforeseen contingencies. In this ever-evolving landscape, predictive analytics has metamorphosed into a critical lever for cultivating an agile and resilient supply chain, warding off disruptions, and laying the foundations for sustainable success.
Corral Cartage leases trucks to service its shipping contracts. Larger trucks have cheaper operating costs if there is sufficient business, but are more expensive if they are not full. CC has estimates of monthly shipping demand. What comparison method(s) would be appropriate for choosing which trucks to lease? 1.Present Worth(PW) 2.Annual Worth(AW) 3.Payback Period