A craftsman named William Barnes builds two kinds of birdhouses, one for wrens and a second for bluebirds. Each wren birdhouse takes 4 hours of labor and 4 units of lumber. Each bluebird house requires 2 hours of labor and 12 units of lumber. The craftsman has available 48 hours of labor and 120 units of lumber. Wren houses yield a profit of $6 each and bluebird houses yield a profit of $15 each. The aim of the objective function for William should be to Maximize the objective value. Decision variables: X = number of wren houses to be produced Y = number of bluebird houses to be produced Z= 6X+ 15 Y a) Objective function: Subject to: 4X + 2Y 4X+ 12Y ≤ 48 (C₁) ≤ 120 (C₂) X, Y 20 b) On the graph on right, constraints C, and C₂ have been plotted. Using the point drawing tool, plot all the corner points for the feasible area. The optimum solution is: X = (round your response to two decimal places).

A craftsman named William Barnes builds two kinds of birdhouses, one for wrens and a second for bluebirds. Each wren birdhouse takes 4 hours of labor and 4 units of lumber. Each bluebird house requires 2 hours of labor and 12 units of lumber. The craftsman has available 48 hours of labor and 120 units of lumber. Wren houses yield a profit of $6 each and bluebird houses yield a profit of $15 each. The aim of the objective function for William should be to Maximize the objective value. Decision variables: X = number of wren houses to be produced Y = number of bluebird houses to be produced Z= 6X+ 15 Y a) Objective function: Subject to: 4X + 2Y 4X+ 12Y ≤ 48 (C₁) ≤ 120 (C₂) X, Y 20 b) On the graph on right, constraints C, and C₂ have been plotted. Using the point drawing tool, plot all the corner points for the feasible area. The optimum solution is: X = (round your response to two decimal places).

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

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?
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…
SIMPLEX METHOD A factory makes tennis rackets and cricket bats. A tennis racket takes 1.5 hours of machine time and 3 hours of craftsman’s time in its making while a cricket bat takes 3 hour of machine time and 1 hour of craftsman’s time. In a day, the factory has the availability of not more than 42 hours of machine time and 24 hours of craftsman’s time. If the profit on a racket and on a bat is Php 20.00 and Php 10.00 respectively, find the maximum profit of the factory when it works at full capacity.
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?
Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.
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 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…
Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25
Two firms, A and B, each currently dump 168 tons of chemicals into the local river. The government has decided to reduce the pollution and from now on will require a pollution permit for each ton of pollution dumped into the river. The government gives each firm 90 pollution permits. The abatement costs of one ton of pulltion is $122 for Firm A and $147 for Firm B. What would be the total cost of reducing pollution, if the government does NOT allow the firm to trade the permits between each other?
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 mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130 volume units? If so, how many each type of pellet should be in the mixture? Pellet Type 5. Number of Cost per Pellet in Cents Weight Units per Pellet Volume Pellets Units per Pellet Regular Large Extra large 2 1 4 y 1 4 3