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

standard mix of Peanut/Raisin Delite to put up. The deluxe mix has .68 pounds of raisins and .32 pounds of peanuts, and the standard mix has 0.5 pounds of raisins and 0.5 pounds of peanuts per bag. The shop has 80 pounds of raisins and 50 pounds of peanuts to work with. Peanuts cost $0.75 per pound and raisins cost $1.5 per pound. The deluxe mix will sell for $2.9 for a one-pound bag, and the standard mix will sell for $2.55 for a one-pound bag. The owner estimates that no more than 110 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? (Round your answers down to a whole number.) Deluxe Standard b. What is the expected profit? (Round your answer to two decimal places.) Expected profit
Please solve very soon completely all parts
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$
QMB Apparel, Inc is a local clothing company that produces two types of shirt: Polo Shirts (P) & Dress Shirts (D). The profit contributions for each shirt and the associated production restrictions (in number of minutes available) are listed below: Polo Shirts (P) Dress Shirts (D) $25 $30 Profit per Unit Cutting Sewing Inspection Polo Shirts (P) Dress Shirts (D) Number of Minutes Available 40 50 1,200 40 1,100 20 1,050 60 70 Using the information in the tables above, what is the optimal amount of Polo Shirts (P) and Dress Shirts (D) that QMB Apparel should produce to maximize it's profits? 40 Polo Shirts (P) & 10 Dress Shirts (D) 5 Polo Shirts (P) & 20 Dress Shirts (D) 30 Polo Shirts (P) & 0 Dress Shirts (D) O0 Polo Shirts (P) & 48 Dress Shirts (D) 010 Polo Shirts (P) & 40 Dress Shirts (D)
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…
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 82 percent are considered good enough to sell. The other 18 percent are scrapped due to quality problems that are identified after they have completed the production process. Each guitar sells for $240. Because some of the production process is automated, each guitar only requires 10 labor hours. Each employee works an average of 160 hours per month. Labor is paid at $10 per hour, materials cost is $40 per guitar, and overhead is $3,800. Part 2 a. The labor productivity ratio for Mack's guitar fabrication shop is
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
Sturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the workweek, for a total of 120 hours of capacity per week. The shop efficiency (the percent of total time available for production), which accounts for setups, changeovers, and maintenance, averages 70% with a standard deviation of 5%, which reduces the weekly capacity. Six key parts are produced, and the plant has three different types of machines to produce each part. The machines are not interchangeable as they each have a specific function. The time to produce each part on each machine varies. The mean time and standard deviation (in hours) to produce each part on each machine are shown below: Mean Time Part Type Machine A Machine B Machine C 1 3.5 2.6 8.9 2 3.4 2.5 8 3 1.8 3.5 12.6 4 2.4 5.8 12.5 5 4.2 4.3 28 6…

SEE MORE QUESTIONS

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