Please help in solving the linear problom. please make it clear Problem 6:A coffee manufacturer blends four component coffee beans into three final blends ofcoffee. The table below summarises the very precise recipes for the final coffee blends,the cost and availability information for the four components, and the wholesale priceper pound of the final blends. The percentages in the body of the table indicate thepercentage of each component to be used in each blend.Component1234Wholesaleprice perpoundFinal Blend (%)212040152535152030310354015OR1.25 OR1.5 OR1.4Cost perpound (OR)0.600.800.550.70Maximumavailability eachweek (pounds)40000250002000045000wishes toWeekly capacity for the processor's plant is 100000 pounds, and the companyoperate at full capacity. There is no problem in selling the final blends, although there isa requirement that minimum production levels of 10000, 25000, and 30000 pounds,respectively, be met for blends 1, 2, and 3. Determine the number of pounds of eachcomponent, which should be used in each blend so as to maximise total weekly profit.

Answered: Image /qna-images/answer/bfe77e9c-78cb-44ae-ac9a-88a5e20a79af.jpg

A coffee manufacturer blends four component coffee beans into three final blends of coffee. The table below summarises the very precise recipes for the final coffee blends, the cost and availability information for the four components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend.

A coffee manufacturer blends four component coffee beans into three final blends of coffee. The table below summarises the very precise recipes for the final coffee blends, the cost and availability information for the four components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend.

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?
Arts N Crafts Industries manufacturers high-end lightfixtures, which it sells internationally. The company is re-sponsible for paying for shipping its product to a distributorlocated in Atlanta, Georgia. Due to the high cost of ship-ping, the company is considering shipping its productsunassembled, but will include detailed assembly instruc-tions in each package. By shipping unassembled products,Arts N Crafts will be able to shrink the size of its cartons andthereby increase the number of products per pallet from16 (4 rows of 4) to 25 (5 rows of 5). Note that this changewill not appreciably increase each product’s 8-pound ship-ping weight. Furthermore, since individual fixtures will bepacked more tightly, they will be less susceptible to damageand easier to handle. Thus, the company expects the freightclass to decrease from 85 to 70. Currently the companyships 400 units per week.a. Using Table 15.2, assess the impact of the proposedchange in packaging on weekly shipping cost.b. How…
Hair Zone manufactures a brand of hair-styling gel. It is considering adding a modified version of the product – a foam that provides stronger hold. Hair Zone’s variable costs and prices to wholesalers are: Current hair gel New foam productUnit selling price 2.00 2.25Unit variable costs 0.85 1.25 Hair Zone expects to sell 1 million units of the new styling foam in the first year after introduction, but it expects that 60 per cent of those sales will come from buyers who normally purchase Hair Zone’s styling gel. Hair Zone estimates that it would sell 1.5 million units of the gel if it did not introduce the foam. If the fixed cost of launching the new foam will be €100,000 during the first year, should Hair Zone add the new product to its line? Why or why not?
Hair Zone manufactures a brand of hair-styling gel. It is considering adding a modifiedversion of the product—a foam that provides stronger hold. Hair Zone’s variable costs and prices to wholesalers are: Current Hair Gel New Foam Product Unit selling price 2.00 2.25 Unit variable costs . 85 1.25Hair Zone expects to sell 1 million units of the new styling foam in the first year after introduction, but it expects that 60% of those sales will come from buyers who normally purchase Hair Zone’s styling gel. Hair Zone estimates that it would sell 1.5 million units of the gel if it did not introduce the foam. If the fixed cost of launching the new foam will be $100,000 during the first year, should Hair Zone add the newproduct to its line? Why or why not?
Q1 Cars are shipped from three distribution centres to five dealers. The shipping cost is based on the mileage between the sources and the destinations and is independent of whether the truck makes the trip with partial or full loads. Table Q1 summarizes the mileage between the distribution centres and the dealers together with the monthly supply and demand figures given in number of cars. A full truckload includes 18 cars. The transportation cost per truck mile is $25. Table Q1: The mileage between distribution centres Dealer Supply 1 2 3 4 1 100 150 200 140 35 400 Centre 50 70 60 65 80 200 3 40 90 100 150 130 150 Demand 100 200 150 160 140 (a) Formulate the associated transportation model. (b) Determine the optimal shipping schedule. (Hint: Supplyldemand quantities are expressed in truck loads, determined by dividing the number of cars by 18 and rounding the result up if necessary.)
Q1 Cars are shipped from three distribution centres to five dealers. The shipping cost is based on the mileage between the sources and the destinations and is independent of whether the truck makes the trip with partial or full loads. Table Q1 summarizes the mileage between the distribution centres and the dealers together with the monthly supply and demand figures given in number of cars. A full truckload includes 18 cars. The transportation cost per truck mile is $25. Table Q1: The mileage between distribution centres Dealer Supply 1 2 3 4 1 100 150 200 140 35 400 Centre 2 50 70 60 65 80 200 3 40 100 150 130 150 Demand 100 200 150 160 140 (a) Formulate the associated transportation model. (b) Determine the optimal shipping schedule.
You are the buyer for a major U.S. health care company. As buyer, your job is to procure and buy parts for the production of X-Ray machines. The buyer from your sister plant in Paris, France has contacted you to supply them with 5 center sections, (a major component used in the X-Ray tube), because they will run out of these parts within 3 days. The center section is procured from a single source supplier in England, weighs approximately 40 pounds, is made of lead and has a 6-week lead time, (the time your supplier requires to manufacture the center section). Based on this criterion, answer the following questions: What mode of transportation is appropriate for shipping this part to Paris, France? What carrier will you use? Which carrier offers the best value?
Phylis Ltd has the following transactions in respect of its goods during Dec 2015. Opening stock 78 units @ GH¢25 Dec 5 bought 250 units @ GH¢24 Dec 10 sold 175 units @ GH¢95 Dec 11 bought 140 units @ GH¢26 Dec 12 sold 200 units @ GH¢48 Dec 15 paid for printing GH¢7,200 Dec 16 bought 400 units @ GH¢20 Dec 22 sold 140 units @ GH¢85 Dec 22 commission to sales Executives GH¢ 20,000 Dec 23 sold 155 units @ GH¢40 Additional information; 1. The cost of carrying a unit material inwards was agreed at GH¢1.5 2. Out of the general administrative expenses of GH¢15,200 only GH¢3,700 had been paid during December. 3. The goods sold on December 23rd only 20% has been collected by the company as at close of the year-month 4. The outstanding balance of GH¢7,100 was paid on the 20th January 2021 You are required to: a. Write up the stores ledger card using the weighted average method of stock valuation. b. Prepare trading, profit and loss…
Elite 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.
Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. *4802075500 Let’s say that last November you have sold 10,000 pieces of chrysanthemum at 25 pesos each. For every piece sold, you will be given a commission of 10%. How much was your total commission? *225,00025,00010,0002.50250,000
Use the table below to answer the following question(s). Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters as part of the winter collection for $65 with an inventory of 1500. The main selling season is 60 days between November and December. The store then sells the remaining units in a clearance sale at 65 percent discount. Out of the 60 main retail days, Fiberia sells the sweaters at full retail price for only 45 days, while giving a discount of 25 percent for the remaining 15 days. The demand functions a, and b are given as 79.5 and 1.1 respectively. Marked Down Pricing Model for Fiberia Accessories's new sweater Data Retail Price Inventory Selling Season (days) Days at Full Retail Intermediate Markdown Clearance Markdown Demand Function A B $65 1500 60 45 25 percent |65 percent 79.5 1.1 Compute the everyday sales throughout the discount sales period.
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company: