help me answer this question pls A small furniture manufacturer produces tables and chairs. Each product must go through three stages of themanufacturing process - assembly, finishing, and inspection. Each table requires 3 hours of assembly. 2 hours of finishing,and 1 hour of inspection. Each chair requires 2 hours of assembly, 2 hours of finishing, and 1 hour of inspection. The profitper table is $120 while the profit per chair is $80. Currently, each week there are 200 hours of assembly time available, 180hours of finishing time, and 40 hours of inspection time. To develop a production schedule, two decision variables aredefined as followsT= number of tables to be produced each weekC= number of chairs to be produced each weekSuppose it is decided that the number of hours used in the assembly process must be at least 90% of the number of hoursused in the finishing department. How would this constraint be written?A) 31+ 2C< 0.9(2T + 2C)в) зт+ 2C$ 16237 + 2C2 0.9(27 + 2C)37 + 202 162E 37 + 202 90

Linear programming is a technique in operation management, which helps in finding the optimal…

Suppose it is decided that the number of hours used in the assembly process must be at least 90% of the number of hours used in the finishing department. How would this constraint be written? A 37 + 2C s 0.9(27 + 2C) B) 37+ 2C< 162 c) 37 + 20 2 0.9(2T + 2C) 3T+ 2C> 16?

Suppose it is decided that the number of hours used in the assembly process must be at least 90% of the number of hours used in the finishing department. How would this constraint be written? A 37 + 2C s 0.9(27 + 2C) B) 37+ 2C< 162 c) 37 + 20 2 0.9(2T + 2C) 3T+ 2C> 16?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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…
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…
A diabetic patient needs at least 40 units of Vit. A, at least 30 units of Vit. C, and at least 40 units 30 units of Vit. E each day. Each brand X multivitamin capsule contains 4 units of Vit. A, 6 units of Vit. C, and 2 units of Vit. E; each brand Y capsule contains 5 units of Vit. A, 3 units of Vit.C, and 5 units of Vit. E. If each brand X capsule costs P6.00 and each brand Y capsule costs P9.00, how many capsules should the patient take each day to minimize the costs?
A company produces two products: A and B. Prod-uct A sells for $11 per unit and product B sells for $23 per unit. Producing a unit of product A requires two hours on assembly line 1 and one unit of raw ma-terial. Producing a unit of product B requires two units of raw material, one unit of A, and two hours on as-sembly line 2. On line 1, 1300 hours of time are avail-able, and 500 hours are available on line 2. A unit of raw material can be bought (for $5 a unit) or produced(at no cost) by using two hours of time on line 1.a. Determine how to maximize profit.b. The company will stop buying raw material whenthe price of raw material exceeds what value? (UseSolverTable.)
You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________
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.
There is an upstream Picking department that feeds two downstream Packing departments: Pack Singles and Pack Multis. Those Packing departments feed to a Shipping department that loads the outgoing trucks. 40% of your Pick volume goes to Pack Singles and has a packing rate of 104 units per labor hour (uph). 60% of the Pick volume goes to Pack Multis and has a pack rate of 215 units per labor hour. Your pickers pick both Single and Multi items throughout the day at an overall average rate of 114 units per labor hour. All units that are packed in both processes go through the Ship process at a rate of 570 units per hour. You have 102 people today for all 4 departments and you absolutely must pack 47,880 units in Pack Multis Items to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer. Redirect 1: You now need to process all of the Pack Singles Volume in the first 5…
Machine A costs Rs 45,000 and its operating costs are estimated to be Rs 1,000 for the first year increasing by Rs 10,000 per year in the second and subsequent years.Machine B costs Rs 50,000 and operating costs are Rs 2,000 for the first year, increasing by Rs 4,000 in the second and subsequent years.If at present we have a machine of type A, should we replace it with B? if so when?Assume that both machines have no resale value and their future costs are not discounted.
The MFA Co. Ltd. presently moves pallet loads of cans from production to the truck dock for loading. The loading dock foreman claims that due to increased production the company needs to purchase five new fork trucks and to hire five persons to operate these trucks. Using the present equipment (fork trucks) the maximum load of cans that can be transported is 1500 lb. at a 13.5” load center. The fork truck currently in use is manufacturer - rated for 3,000 lb. at the 24” load center. Question: Can the pallet load capacity be increased? What, if any, new equipment is required?
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?
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…