The Electrotech Corporation manufactures two industrial-sized electrical devices:generators and alternators. Both of these products require wiring and testingduring the assembly process. Each generator requires 3 hours of wiring and 2 hourof testing and can be sold for a $275 profit. Each alternator requires 3 hours ofwiring and 3 hours of testing and can be sold for a $190 profit. There are 260hours of wiring time and 140 hours of testing time available in the next productionperiod and Electrotech wants to maximize profit.1. Formulate the LP model for this problem.2. Create the spreadsheet model and use Solver to solve the problem.

Find the given details below:Profit of generator = $275Profit of alternator = $190Wiring hours for…

Answered: The Electrotech Corporation…

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

Assuming your company is producing Apple and Samsung phone cases. It is required to process in the assembly and paint shops to make either phone case. It takes 1/60 of a day and 1/40 of a day to paint an Apple case and a Samsung case in the paint shop, respectively. It takes 1/50 of a day to assemble either type of case in the assembly shop. An Apple phone case and a Samsung phone case yield profits of $300 and $220, respectively, per case sold. What is a maximum-profit daily production plan for your company?
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)
Hansen Controls has been awarded a contract for a large number of control panels. To meet this demand, it will use its existing plants in Houston and Tulsa, and consider new plants in Portland, St. Louis and Lexington. Finished control panels are to be shipped to Denver, Kansas City and Seattle. Pertinent information is given in the table. Denver 1 1- 2- 3- Sources 4- 5- Houston Tulsa Portland Construction St. Louis Cost Kansas City 2 ---- 1 Shipping Cost to Destination: Capacity Seattle 3 6 6 500,000 450,000 Lexington 400,000 Demand 14,000 13,000 18,000 We develop a transportation model as an LP that includes provisions for the fixed costs (construction costs in this case) for the three new plants. The solution of this model would reveal which plants to build and the optimal shipping schedule. Let xij = the number of panels shipped from source i to destination j y₁ = 1 if plant i is built, = 0 otherwise (i = 3, 4, 5) The constraint x21 + x22+x23 <= 13,000*y3 represents which of the…
Dairy company SG is producing milk at a fixed rate of 5,000 gallons/hour. The total customer order over a day is 100,000 gallons of milk. This demand is distributed evenly from 8:00 am to 6:00 pm. If there is no milk available, customers will wait until enough is produced to satisfy your orders. The company starts to produce at 8 am with 25,000 gallons in finished goods inventory. In the end, after that all the demand has been met, the plant continues producing until the stock of products finished is restored to 25,000 gallons. When answering the following questions, please address the trucks / milk as a continuous flow process. Start by drawing a graphic indicating how much milk is in stock and how much milk is “on hold” throughout the day. a) At what time of day will customers have to wait for their orders to be filled? b) At what time will customers stop waiting? c) Suppose the milk is collected in trucks with a capacity of 1,250 gallons each. What is the maximum number of trucks…
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.
Kala is one of the top manufacturer of ukuleles. The manufacturer produces three different types of ukuleles. Its Concert produce $6 in profit per unit; its Soprano produce $4 in profit per unit; and its Tenor produce $8 in profit per unit. Each type of ukulele passes through three manufacturing stages as a part of the entire production process. The three process centers of modelling, curing and assembly has an available production time per day of 12 hours, 14 hours and 16 hours, respectively. To produce one hundred units of Concert, the time required for the process of modelling, curing and assembly is 2 hours, 3 hours and 2 hours, respectively. To produce one hundred units of Soprano, 2 hours of modelling, 2 hours of curing and 1 hour of assembly is required. Whereas 4 hours of modelling, 2 hours of curing and 2 hours of assembly is required to produce one hundred units of Tenor. Sensitivity report of the problem is given as below where C = unit of Concert to be produced each day, S=…
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?
The Noname Computer Company builds a computer designated model ICU2. It imports the motherboard of the computer from Taiwan, but the company inserts thesockets for the chips and boards in its plant in Lubbock, Texas. Each computerrequires a total of ninety 64K dynamic random access memory (DRAM) chips.Noname sells the computers with three add-in boards and two disk drives. The company purchases both the DRAM chips and the disk drives from an outside supplier.The product structure diagram for the ICU2 computer is given in Figure 8–6.Suppose that the forecasted demands for the computer for weeks 6 to 11 are220, 165, 180, 120, 75, 300. The starting inventory of assembled computers inweek 6 will be 75, and the production manager anticipates returns of 30 in week 8and 10 in week 10.c. Determine the schedule of outside orders for the disk drives
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
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…
JCL Inc. is a major chip manufacturing firm that sells its products to computer manufacturers like Dell, Gateway, and others. In simplified terms, chip making at JCL Inc. involves three basic operations: depositing, patterning, and etching. Depositing: Using chemical vapor deposition (CVD) technology, an insulating material is deposited on the wafer surface, forming a thin layer of solid material on the chip. Patterning: Photolithography projects a microscopic circuit pattern on the wafer surface, which has a light-sensitive chemical like the emulsion on photographic film. It is repeated many times as each layer of the chip is built. Etching: Etching removes selected material from the chip surface to create the device structures. The table below lists the required processing times and setup times at each of the steps. There is unlimited space for buffer inventory between these steps. Assume that the unit of production is a wafer, from which individual chips are cut at a later…

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