A plastic parts supplier produces two types of plastic parts used for electronics. Type 1 requires 20minutes of labor and 35 minutes of machine time. Type 2 requires 50 minutes of machine hours and 78 minutes of labor. There are 500 hours available per week of labor and 750 machine hours available. Type 1 has a profit margin of $25 a unit and Type 2 has a profit margin of $45 a unit. The plastic parts supplier must choose the quantity of Type 1 and Type 2 to produce which maximizes profit. (a) Formulate this as a linear programming problem. (b) Find the solution that gives the maximum profit using Excel Solver.

A plastic parts supplier produces two types of plastic parts used for electronics. Type 1 requires 20minutes of labor and 35 minutes of machine time. Type 2 requires 50 minutes of machine hours and 78 minutes of labor. There are 500 hours available per week of labor and 750 machine hours available. Type 1 has a profit margin of $25 a unit and Type 2 has a profit margin of $45 a unit. The plastic parts supplier must choose the quantity of Type 1 and Type 2 to produce which maximizes profit. (a) Formulate this as a linear programming problem. (b) Find the solution that gives the maximum profit using Excel Solver.

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

Determine the optimum preventive maintenance frequency for each of the pieces of equipment if breakdown time is normally distributed: (Round "Probability Ratio" to 4 decimal places, and all other answers to 2 decimal places. Negative values should be indicated by a minus sign.) Use Table. Equipment. A201 B400 C850 Equipment A201 B400 CB50 Equipment Average Time (days) between Breakdowns A201 B400 C850 20 30 45 Preventive Maintenance Cost Click here for the Excel Data File: $330 $230 $580 Probability Ratio Standard Deviation 3 Breakdown Cont $2,230 $3,530 $4,825 Interval (days)
Non-inventory goods were purchased and delivered on June 15, 2010. Several security interests exist in these goods. Which of the following security interests has priority over the others? Group of answer choices purchase money security interest perfected June 24, 2010 Security interest perfected June 20, 2010 Security interest attached June 15, 2010 Security interest in future goods attached on June 10, 2010
An injection molding system has a first cost of $90,000, and an annual operating cost of $42,000 in year 1, increasing by $5000 per year thereafter. The salvage value of the system is 30,000 if you sell after 1 year of use. The salvage value decreases by $5,000 each year thereafter. The maximum useful life of the machine is 4 years. Using a MARR of 20% per year, determine the ESL and the corresponding Equivalent Annual Cost of the system.
Oakwood Hospital is considering using ABC analysis to classify laboratory SKUs into three categories: those that will be delivered daily from their supplier (Class A items), those that will be controlled using a continuous review system (B items), and those that will be held in a two-bin system (C items). The following table shows the annual dollar usage for a sample of eight SKUs. Rank the SKUs, and assign them to their appropriate category. SKU Code Dollar Value Annual Usage 1 2 3 4 5 6 7 8 $0.01 $0.03 $0.45 $1.00 $4.50 $0.90 $0.30 $1.50 1,200 120,000 100 44,000 900 350 70,000 200
Each breakdown of a graphic plotter table atAirbus Industries costs $50. Find the expected daily breakdown cost, given the following data:
Of the items produced daily by a factory, 40% come from line I and 60% from line II. Line I has a defect rate of 8%, whereas line II has a defect rate of 10%. If an item is chosen at random from the day's production, find the probability that it will not be defective.
Neverland Company, a retailer, plans to sell 15,000 units of Product X during the month of August. If the company has 2,500 units on hand at the start of the month, and plans to have 2,000 units on hand at the end of the month, how many units of Product X must be purchased from the supplier during the month? * 17,000 15,000 14,500 15,500
Carol Cagle bas a repetitive manufacturing plantproducing trailer bitches in Arlington, Texas. The plant has anaverage inventory tu rnover of only 12 times per year. She hastherefore determined that she will reduce her component lotsizes. She has developed the following data for one component,the safety chain clip:Annual demand = 31,200 unitsDaily demand = 120 unitsDaily production (in 8 hours) = 960 unitsDesired lot size (I hour of production) = 120 unitsHolding cost per unit per year = $12Setup labor cost per hour = $20How many minutes of setup time should she have her plant manageraim for regarding this component?
Casting molds are produced by MYMOLD company. Each order has unique specifications, depending on customer needs. MYMOLD has received an order of two molds from a customer. The agreed selling price of the molds is 5000TL per mold. According to the agreement, for a defective mold the customer will pay 1000TL instead of the standard price. The customer will not buy any more than two molds and there is a 2000 TL fine for not meeting the demand with two non-defective molds. The excess molds can be salvaged for 500 TL per piece. The cost of production per mold is 2000TL and the probability of producing a non-defective mold is 0.8. Assume that MYMOLD decided to produce two molds, and the first production has been succesfull (a non-defective mold is produced). What is the expected profit given the result of the first production?
Justin is a carpenter and makes furniture which he sells via the internet. He needs a new machine with steel attachments to speed up the drilling process for his work. He contacts Fixing and Building Machines Ltd who recommends a machine which they claim is more than 10 times quicker and stronger than his old machine. Justin goes into Fixing and Building Machines Ltd. Before paying for the machine, he sees a sign on the wall behind the counter that has the words “Important Information: READ BEFORE PURCHASE! Fixing and Building Machines Ltd accepts no liability.....” in bold, red print at the top. However, the sign is falling down from the wall and the rest of the words are obscured by a large plant. Had Justin been able to read the rest of the sign, he would have read “....for loss howsoever caused.” Justin signs a document, buys this machine and takes it with him. When he tried it he found it to be no quicker than his old one and the attachments broke. He also found that it started…
A large city in the mid-West needs to acquire a street-cleaning machine to keep its roads looking nice year-round. A used cleaning vehicle will cost $85,000 and have a $20,000 market (salvage) value at the end of its five-year life. A new system with advanced features will cost $150,000 and have a $40,000 market value at the end of its five-year life. The new system is expected to reduce labor hours compared with the used system. Current street-cleaning activity requires the used system to operate 8 hours per day for 20 days per month. Labor costs $50 per hour (including fringe benefits), and MARR is 12% per year.]
As soon as an invoice is received from a customer, it needs to be checked for mismatches of items. The check may result in either of these three options: - i) there are no mismatches, in which case the invoice is posted; - ii) there are mismatches, but these can be corrected, in which case the invoice is re-sent to the customer; and - iii) there are mismatches, but these cannot be corrected, in which case the invoice is blocked. Once one of these three activities is performed the invoice is parkedand the processcompletes. Finally, give name to this process.