Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing,inspection, and packaging. The accompanying table shows the relevant data. Production rates are shown in units/hour. (ScarCT is assembled elsewhere.) Pickson wants to determine how manyguitars to make to maximize monthly profit. According to the linear optimization model, what would be the total time in hours spent on inspecting the Dela Mort models? Round to two decimal places.Click the icon to view the model.OA. 12.50B. 158.33C. 85.00D. 48.00Production ModelPickson LuthiersCorporationDataGuitar ModelScarCTDela MortWaraxInvazenSelling price/Unit Variable cost/Unit Min Sales Max Sales750.00660.0002500788.000800.00850.00Productionrates (units/hour) ScarCTAssemblyPainting35Sound Testing 20109InspectionPackaging680.00700.00800.00Dela Mort352010121010080Warax2515208520001000500Invazen20101858HoursAvailable220220220220220-X

Linear optimization is used to determine the best possible solution or outcome from a set of…

Answered: Production Model Pickson Luthiers…

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.
Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. (ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit. Pickson Luthiers Corporation Data Guitar Model Selling price/Unit Variable cost/Unit Min Sales Max Sales ScarCT 750.00 660.00 0 2500 Dela Mort 788.00 680.00 0 2000 Warax 800.00 700.00 100 1000 Invazen 850.00 800.00 80 500 Production rates (units/hour) ScarCT Dela Mort Warax Invazen Hours Available Assembly - 35 25 20 220 Painting 35 20 15 10 220 Sound Testing 20 10 20 18 220 Inspection 10 12 8 5 220 Packaging 9 10 5 8 220 Use a linear optimization model based on the data to answer the following…
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many arcs will the network have?
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 units
The ore of a gold mine in the Mountain Province contains, on the average, 2 gram of gold perton. One method of processing cost ₱1,800.00 per ton and recovers 90% of the gold, whileanother method cost only ₱1,400.00 per ton and recovers 85% of the gold. If the gold can besold at ₱8,000.00 per gram, which method is better and by how much?
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…
HMO has 40 doctors to be apportioned among four clinics. The HMO decides to apportion the doctors based on the average weekly patient load for each clinic, given in the following table. Clinic A B C D Average Weekly 275 392 611 724 Patient Load Find the apportion of A and C using using Adam's Method. Use modified divisor 52. Doctors for clinic A Doctors for clinic B = %3D Doctors for clinic C= Doctors for clinic D =
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.
The world's oceans contain on average of 0.9 oz of Au /ton of ocean water. There were 2 proposed novel process in mineral extraction to recover the Au and they were compared using Engineering Economic Analysis. Process X costs $600/ton of ocean water processed and a recovery of 90%, while Process Z costs $450/ton and a recovery of 60%. Both processes will need the same amount of capital investment and equal ounces of Au extracted daily. If the Au today is $2,200/oz, which process is more feasible considering the fact that the world's ocean can be inexhaustible? This problem requires the analysis to be on the basis of profit per ounce of Au extracted.
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…
A manufacturing firm has three plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (25) Customer 2 (50) Customer 3 (125) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS