The production planner for Fine Coffees, Inc., produces two coffee blends: American (A) and British (B). Two of his resources are constrained: Columbia beans, of which he can get at most 300 pounds (4,800 ounces) per week; and Dominican beans, of which he can get at most 200 pounds (3,200 ounces) per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. What are optimal weekly profits

The production planner for Fine Coffees, Inc., produces two coffee blends: American (A) and British (B). Two of his resources are constrained: Columbia beans, of which he can get at most 300 pounds (4,800 ounces) per week; and Dominican beans, of which he can get at most 200 pounds (3,200 ounces) per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. What are optimal weekly profits

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
The Petoskey Potato Chip Company produces 3 varieties of gourmet potato chip. The varieties and average daily demand are given below: Bar-B-Que: 325 cases/day Sour Cream & Onion: 215 cases/day Classic Cut: 360 ases/day The company runs 24 hours/day and can produce 1,300 cases of potato chips per day. Each case of potato chip costs $20 to produce and Petoskey assumes 18% of this cost as the annual holding cost. It takes Petoskey 5 hours to setup for production of a different variety at a cost of $715. Calculate the minimum cost cycle time in days. Answer: 25.2 How is this calculated?
The seasonal yield of olives in a Piraeus, Greece, vineyard is greatly influenced by a process of branch pruning. If olive trees are pruned every two weeks, output is increased. The pruning process, however, requires considerably more labor than permitting the olives to grow on their own and results in a smaller size olive. It also, though, permits olive trees to be spaced closer together. The yield of 1 barrel of olives by pruning requires 5 hours of labor and 1 acre of land. The production of a barrel of olives by the normal process requires only 2 labor hours but takes 2 acres of land. An olive grower has 250 hours of labor available and a total of 150 acres for growing. Because of the olive size difference, a barrel of olives produced on pruned trees sells for $20, whereas a barrel of regular olives has a market price of $30. The grower has determined that because of uncertain demand, no more than 40 barrels of pruned olives should be produced. Use graphical LP to find (a) the…
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…
Kofi Abebrese runs a small industrial company that specialize in the production of high standard windows for housing estates. A worker is paid GHC0.9 per hour and can produce two window with an hour. Each window uses a frame costing GHC1 and incur a variable overheads of GHC0.7. Each window sells for GH¢3. Currently, due to the economic condition, work is rather slack and three employees are occupied in carrying out extensive repairs to Kofi Abebrese's own house. Kofi owns a warehouse next to the factory, which had been used as a factory store, in the past. It is now let out on a renewable annual lease of GHC600. A new building company, Allied Consult, which specializes in the production of prefabricated houses has asked Kofi if he would be interested in accepting a contract for GHC30,000 which will be for a year initially, to produced molded internal building sections. Kofi estimates that, the contract will take 13,200 hours of works, or the work of five men for a year, and that…
4) The making of rivet holes in structural steel members can be done by 2 methods. The first method consists of laying out the position of the holes in the members and using a drill press costing P100k. The machinist is paid P60 per hour and he can drill 80 holes per hour. The second method makes use of a multiple-punch machine costing P80k. The punch operator is paid P40 an hour and he can punch out 1 hole for 3 seconds. This method also requires an expense of P1.25 per hole to set the machine. (a) if all other costs are assumed equal, what is the total cost for each machine for 10k holes, assuming the total cost of each machine to be charged to these holes? (b) for how many holes will the costs be equal?
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines of industrial chassis for the rack mounting of Internet routers, modems, and other telecommunications equipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per pound and for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of a Standard chassis rack and $15 contribution on a Deluxe chassis rack. During the next production cycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or in chassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16 pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal. The output of metal sheeting is restricted only by the capacity of the polisher. For the next production cycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassis manufacture…
Plainwell Polymers is going to producing the main dashboard structure for a new car design. The dashboard will be produced in three colors with expected daily demand as follows: Black: 365 units/day Grey: 110 units/day Tan: 210 units/day The injection-molding machine can produce a total of 1,090 parts per day running 24 hours per day. It costs Plainwell $1,040 to set up each color for producition and the daily holding cost for each part is $0.49. What is the length of the lowest cost cyclic schedule (ignoring setup time constraints) in days?
A company produces a niche hunting blind. Because of the nature of this product, demand varies greatly by season. In fact, demand exceeds production capacity during hunting season (fall,) but is very low in the summer months. To meet the high demand during the fall, the company produces the blind year round, producing more than what is needed in the summer in order to carry over inventory into the peak season. Their production facility can produce at most 60 blinds per month using regular labor at a cost of $125 each. Up to 15 additional blinds can be produced by utilizing overtime labor at a cost of $135 each. The blinds are sold for $225. Because of storage cost and the opportunity cost of capital, each blind held in inventory from one month to the next incurs a cost of $15 per blind. Since demand is uncertain, the company would like to maintain an ending inventory of at least 5 blinds during the warm months (May–September) and at least 15 blinds during the other months…