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.A. 12.50B. 158.33C. 85.00D. 48.00Production ModelPickson LuthiersCorporationDataGuitar ModelScarCTDela MortWaraxInvazenSelling price/Unit Variable cost/Unit Min Sales Max Sales750.00660.0002500788.0002000680.00700.00800.001000850.00800.00500Productionrates (units/hour) ScarCTAssemblyPaintingSound TestingInspectionPackaging3520109Dela Mort352010121010080Warax25152085Invazen218520108HoursAvailable220220220220220

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

Answered: Pickson Luthiers Corporation makes four…

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

A local bank has generated the following metrics: an arrival rate of 18 customers per hour with a service time of 3 minutes per customer, and wait times Wq = 0.45 hours for s = 1, Wq = 0.0127 hours for s = 2, and Wq = 0.0017 hours for s = 3. The goal is to solve the following argument: argmin $7s + $49Lq. What is the optimal service level?
the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
A manufacturing company makes two types of water skis, a trick ski and a slalom ski. The relevant manufacturing data are given in the table. Labor-Hours per Ski Maximum Labor-Hours Available per Day 384 36 Department Fabricating Finishing Trick Ski 12 1 Slalom Ski 8 1 If the profit on a trick ski is $50 and the profit on a slalom ski is $30, how many of each type of ski should be manufactured each day to realize maximum profit? What is the maximum profit? The maximum profit is $. The maximum occurs when trick skis and slalom skis are produced.
A small scale industry manufactures electrical regulators, with a small group of semi-skilled workers both male and female. Due to limitations in space and finance, the number of workers employed cannot exceed 11 and their total salary cannot be more than Rs60, 000 per month. The male workers are paid Rs.6000 per month while the female workers are paid Rs. 5000 per month. It has been found that the male workers are swifter and since they are willing to work overtime, they contribute Rs.10, 000 per month as compared to Rs.8500 from their female counterparts. Apart from their salary, food coupons are provided: 6 coupons to per male employee and 5 coupons to per female employee. However, the total maximum amount of coupons that can be distributed are only 90. a) Formulate the model and find out how many male and female members should the company employ so as to maximize their contribution? b) If they make the female compensation equal to their male counterpart, should there be…
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 650 small cars, at least 500 medium cars, and at least 650 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? Fred Motors packages Admiral Motors packages Chrysalis packages What will be the total cost?$
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 550 small cars, at least 500 medium cars, and at least 550 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? |packages | packages |packages Fred Motors Admiral Motors Chrysalis What will be the total cost? 2$
A manager must decide which type of equipment to buy, Type A or Type B. Type A equipment cost $15,000 each, and Type B cost $11,000 each. The equipment can be operated 8 hours a day, 250 days a year. Either machine can be used to perfom two types of chemical analysis, C1 and C2. Annual service requirements and processing times are shown in the following table. Which type of equipment should be purchased, and how many of that type wil be need? The goal is to minimize total purchase cost. processing time per analysis (hr) Analysis type Annual volume A B C1 1200 1 2 C2 900 3…
A custom motor cycle shop is experiencing high demand from its customers for its services. The owner performs all tasks relating to customization. Assume each customer brings one motor cycle for customization. The owner needs to determine if he needs to add more help to meet customer demand. A week has 40 hours (maximum amount of time available for the owner to work) . The maximum number of customizations that can be done per week is 8 bikes ( if there is no wasted time ). The following is the data collected from observations for a typical week: Every Friday the shop is cleaned by the owner. This takes 5 hours 15 % of the customization needs rework which takes 75 % more time than regular customization 15 % of the customers will be called by the owner to reschedule completion by the owner. This takes 2 hours per customer. Determine OEE. How should the owner handle the business ? Show all formulas, calculations and results.
Five to six times a year, Kicker puts on tent sales in various cities throughout Oklahoma and the surrounding states. The tent sales are designed to show Kicker customers new products, engender enthusiasm about those products, and sell soon to be out-of-date products at greatly reduced prices. Each tent sale lasts one day and requires parking lot space to set up the Kicker semitrailer; a couple of show cars; a disc jockey playing music; a tent to sell Kicker merchandise, distribute brochures, and so on. Last year, the Austin, TX tent sale was held in a corner of the parking lot outside the city exhibition hall where the automotive show was in progress. Because most customers were interested more in the new model cars than in the refurbishment of their current cars, foot traffic was low. In addition, customers did not want to carry speakers and amplifiers all the way back to where they had originally parked. Total direct costs for this tent sale were $14,300. Direct costs…
help please
The Stratton Company produces two basic types of plastic pipe. Three resources are crucial to the output of pipe: extrusion hours, packaging hours, and a special additive to the plastic raw material. The following data represent next week’s situation. All data are expressed in units of 100 feet of pipe. Product Resource Type 1 Type 2 Resource Availability Extrusion Packaging Additive mix 4 hr 2 hr 2 lb 6 hr 2 hr 1 lb 48 hr 18 hr 16 lb The contribution to profits and overhead per 100 feet of pipe is $34 for type 1 and $40 for type 2. Formulate a linear programming model to determine how much of each type of pipe should be produced to maximize contribution to profits and to overhead, assuming that everything produced can be sold.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS