Helen Holmes makes pottery by hand in her basement. She has 20 hours available each week to make bowls and vases. A bowl requires 3 hours of labor, and a vase requires 2 hours of labor. It requires 2 pounds of special clay to make a bowl and 5 pounds to produce a vase; she is able to acquire 35 pounds of clay per week. Helen sells her bowls for $50 and her vases for $40. She wants to know how many of each item to make each week to maximize her revenue. Requirements: a) Define decision variables and tabulated data b) Formulate the Integer Linear Programming Model.

Helen Holmes makes pottery by hand in her basement. She has 20 hours available each week to make bowls and vases. A bowl requires 3 hours of labor, and a vase requires 2 hours of labor. It requires 2 pounds of special clay to make a bowl and 5 pounds to produce a vase; she is able to acquire 35 pounds of clay per week. Helen sells her bowls for $50 and her vases for $40. She wants to know how many of each item to make each week to maximize her revenue. Requirements: a) Define decision variables and tabulated data b) Formulate the Integer Linear Programming Model.

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

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
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.
A machine part to be fabricated may be made from alloy of either of two metals. There is an order for 10,000 units. Metal A costs 3 pesos per kg, while Metal B costs 9 pesos per kg. If Metal A is used, the material per unit weighs 110 grams; for metal B, 30 grams. When metal A is used, 50 units can be produced per hour; for metal B, 80 units per hour. Metal B fabrication requires the aid of a tool costing P1,000, which will be useless after the 10,000 units are finished. The machine operator's wage is P50 per hour. If all other costs are identical, determine which material will be more economical to finish the 10,000-unit order. How much is the total cost difference between the use of metal A and metal B?
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.
fi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint shop and body assembly shop. If the paint shop were only painting trucks, then 80 per day could be painted. If the paint shop were only painting cars, then 120 per day could be painted. If the body shop were only producing cars, then it could process 100 per day. If the body shop were only producing trucks, then it could process 100 per day. Each truck contributes GHS60,000 to profit, and each car contributes GHS40,000 to profit. Use linear programming to determine a daily production schedule that will maximize the company’s profits.
Mack’s guitar fabrication shop produces low cost, highly durable guitars for beginners. Typically, out of the 100 guitars that begin production each month, only 80 percent are considered good enough to sell. The other 20 percent are scrapped due to quality problems that are identified after they have completed the production process. Each guitar sells for $300. Because some of the production process is automated, each guitar only requires 10 labor hours. Labor is paid at $10/hour, materials cost is $40/guitar, and overhead is $2,000. a) Calculate the labor and multifactor productivities. b) After some study, the operations manager recommends 3 options to improve the company’s multifactor productivity: (1) increase the sales price by 10 percent, (2) improve quality so that only 10 percent are defective, or (3) reduce labor, material, and overhead costs by 10 percent. Which option has the greatest impact on the multifactor productivity measure?
A machine tool company conducts a job-training programme at a ratio of one for everyten trainees. The training programme lasts for one month. From past experience it has been found thatout of 10 trainees hired, only seven complete the programme successfully. (The unsuccessful traineesare released). Trained machinists are also needed for machining. The company's requirement for thenext three months is as follows:January: 100 machinists, February: 150 machinists and March: 200 machinists.In addition, the company requires 250 trained machinists by April. There are 130 trained machinistsavailable at the beginning of the year. Pay roll cost per month is:Each trainee Rs. 400/- per month.Each trained machinist (machining or teaching): Rs. 700/- p.m.Each trained machinist who is idle: Rs.500/- p.m.(Labour union forbids ousting trained machinists). Build a l.p.p. for produce the minimum costhiring and training schedule and meet the company’s requirement.
Tyler bakes Cookies (C) and Breads (B) with the help of two ovens in his little bakery. The time taken by Oven A to bake each cookie batch is 14 minutes and the time taken by Oven B is 12 minutes. The time taken by Oven A to bake a batch of bread is 16 minutes and the time taken by Oven B is 17 minutes. Each week both Ovens can be used for 50 hours each to bake Cookies and Breads. The rest of the time is used for baking other products. Moreover, Tyler starts each week with a stock of 25 batches of Cookies and 30 batches of Breads because the Cookies and Breads he produces can be considered to be “fresh” for a maximum of 2 weeks. There is an average weekly demand of 70 batches of Cookies and 50 batches of Breads. For each batch of Cookies, Tyler makes $30 in profit and for each batch of Breads Tyler makes $25 in profit. If there are any “close to losing freshness” goods at the end of the week, Tyler sells them at heavily discounted prices on weekends with a profit of $5 per batch of…
There are 10 apples in a basket Each apple has 4 worms. HOW MANY Worms do the apples have have in all
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…
Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…