A manufacturing company produces two products, P1 and P2, and seeks to maximize its profit, where each unit of P1 generates $50, and each unit of P2 generates $40. The production of P1 requires 4 hours of labor and 3 units of raw material per unit, while P2 requires 3 hours of labor and 2 units of raw material per unit. The company has a total of 240 labor hours and 100 units of raw material available. Additionally, demand for P1 is limited to a maximum of 40 units, while there is no restriction for P2. The goal is to determine the optimal production quantities of P1 and P2 to maximize profit while satisfying these constraints. [5] 9328-2

A manufacturing company produces two products, P1 and P2, and seeks to maximize its profit, where each unit of P1 generates $50, and each unit of P2 generates $40. The production of P1 requires 4 hours of labor and 3 units of raw material per unit, while P2 requires 3 hours of labor and 2 units of raw material per unit. The company has a total of 240 labor hours and 100 units of raw material available. Additionally, demand for P1 is limited to a maximum of 40 units, while there is no restriction for P2. The goal is to determine the optimal production quantities of P1 and P2 to maximize profit while satisfying these constraints. [5] 9328-2

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.
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
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…
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.
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?
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…
During an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.
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…
A manufacturing cell makes three models of a product – AKC1011, BC0001, and AC0102. The daily demand for the three products are as follows: 200 of AKC1011, 500 BC0001, and 300 of AC0102. Develop a balanced mixed-model sequence that should be repeated throughout the day in order to meet demand.
Kofi Abebrese runs a small industrial company that specialize in the production of high standard windows for housing estates. A worker is paid GH¢0.9 per hour and can produce two window with an hour. Each window uses a frame costing GH¢1 and incur a variable overheads of GH¢0.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 GH¢600. 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 GH¢30,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…
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.