A9) (a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of strapsmanufactured, and TP = number of straps purchased. Express time in minutes per unit.)MinCutting constraintMilling constraintShaping constraintFrame constraintSupport constraintStrap constraint.FM, FP, SM, SP, TM, TP ≥ 0How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.)(FM, FP, SM, SP, TM, TP) = ((b) What is the total cost (in $) of the manufacturing and purchasing plan?$(c) How many hours of production time are used each department? (Round your answers to two decimal places.)Cuttinghrshrs.MillingShapinghrs(d) How much (in $) should Frandec be willing to pay for an additional hour of time in the shaping department?$(e) Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its position by pursuing this opportunity? Why or why not? (Round your answer to three decimal places.)---Select---indicates that the solution ---Select--- be improved.The reduced cost of A linear programming computer package is needed.Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec'sproduction schedule calls for 4,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing andpurchase costs per unit are shown.ComponentFrameSupportStrapComponentFrameManufacturing Cost Purchase CostSupport$39.00StrapCapacity (hours)$12.50$7.50Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows.Cutting3.51.30.8350Department2.2$52.001.7$16.00Milling Shaping420$8.503.12.61.7680

(a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of straps manufactured, and TP = number of straps purchased. Express time in minutes per unit.) Min Cutting constraint Milling constraint Shaping constraint Frame constraint Support constraint Strap constraint FM, FP, SM, SP, TM, TP ≥ 0 How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.) (FM, FP, SM, SP, TM, TP) = (b) What is the total cost (in $) of the manufacturing and purchasing plan? $ (c) How many hours of production time are used in each department? (Round your answers to two decimal places.) Cutting hrs Milling hrs. Shaping hrs

(a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of straps manufactured, and TP = number of straps purchased. Express time in minutes per unit.) Min Cutting constraint Milling constraint Shaping constraint Frame constraint Support constraint Strap constraint FM, FP, SM, SP, TM, TP ≥ 0 How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.) (FM, FP, SM, SP, TM, TP) = (b) What is the total cost (in $) of the manufacturing and purchasing plan? $ (c) How many hours of production time are used in each department? (Round your answers to two decimal places.) Cutting hrs Milling hrs. Shaping hrs

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 linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 5,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. Component Department Cutting Milling…
A linear programming computer package is needed. Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 4,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows. Component Department Cutting Milling…
A linear programming computer package is needed. The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Television Radio Online Audience per advertisement 400,000 72,000 160,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. If the promotional budget is limited to $20,500, By how much would audience contact increase if an extra $100 were allocated to the promotional budget? (Round your answer to the nearest whole number.)
The Crandon Manufacturing Company produces two principal product lines. One is a portable circular saw, and the other is a precision table saw. Two basic operations are crucial to the output of these saws: fabrication and assembly. The maximum fabrication capacity is 4000 hours per month; each circular saw requires 2 hours, and each table saw requires 1 hour. The maximum assembly capacity is 5000 hours per month; each circular saw requires 1 hour, and each table saw requires 2 hours. The marketing department estimates that the maximum market demand next year is 3500 saws per month for both products. The average contribution to profits and overhead is $900 for each circular saw and $600 for each table saw. Management wants to determine the best product mix for the next year so as to maximize contribution to profits and overhead. Also, it is interested in the payoff of expanding capacity or increasing market share.
each Distributors packages and distributes industrial supplies. A standard shipment can be packaged in a class A container, a class K container, or a class T container. A single class A container yields a profit of $10; a class K container, a profit of $8; and a class T container, a profit of $12. Each shipment prepared requires a certain amount of packing material and a certain amount of time. Formulate and solve this problem using LP software. Resources Needed per Standard Shipment Class of Container Packing Material (pounds) Packing Time (hours) A 2 2 K 1 6 T 3 4 Total amount of resource available per week 120 pounds 210 hours Hugh Leach, head of the firm, must decide the optimal number of each class of container to pack each week. He is bound by the previously mentioned resource restrictions but also decides that he must keep his 6 full-time packers employed all 210 hours (6 workers × 35 hours)…
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has .70 pounds of raisins and .30 pounds of peanuts, and the standard mix has 0.45 pounds of raisins and 0.55 pounds of peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $0.6 per pound and raisins cost $1.55 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? b. What is the expected profit?
A small candy shop is preparing for the holiday season. The owner must decide how many bags of Deluxe Mix and how many bags of Standard Mix of Peanut/Raisin Delite to put up. The Deluxe Mix has 2/3 pound raisins and 1/3 pound peanuts, and the Standard Mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $0.60 per pound and raisins cost $1.50 per pound. The Deluxe Mix will sell for $2.90 per pound, and the Standard Mix will ell for $2.55 per pound. The owner estimates that no more than 110 bags of one type can be sold. If the goal is to maximize profits, how many bags of each type should be prepared?
A company manufactures both mountain bikes and trail bikes. The cost of materials for a mountain bike is $60, and the cost of materials for a trail bike is $40. The cost of labor to manufacture a mountain bike is $80, and the cost of labor to manufacture a trail bike is $60. During a week in which the company has budgeted $1,800 for materials and $2,500 for labor, how many mountain bikes does the company plan to manufacture? mountain bikes
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.60 for a one-pound bag, and the standard mix will sell for $4.10 for a one-pound bag. The owner estimates that no more than 270 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? b. What is the expected profit?
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisins and 1/2 pound peanuts per bag. The shop has 90 pounds of raisins and 60 pounds of peanuts to work with. Peanuts cost $.60 per pound and raisins cost $1.50 per pound. The deluxe mix will sell for $4.00 for a one-pound bag, and the standard mix will sell for $3.55 for a one-pound bag. The owner estimates that no more than 210 bags of one type can be sold. a. If the goal is to maximize profits, how many bags of each type should be prepared? Deluxe _____bags Standard ______bags b. What is the expected profit? Profit ________
La Jolla Beverage Products is considering producing a wine cooler that would be a blend of a white wine, a rose wine, and fruit juice. To meet taste specifications, the wine cooler must consist of at least 45% white wine, at least 25% and no more than 35% rose, and exactly 25% fruit juice. La Jolla purchases the wine from local wineries and the fruit juice from a processing plant in San Francisco. For the current production period, 10000 gallons of white wine and 6500 gallons of rose wine can be purchased; an unlimited amount of fruit juice can be ordered. The costs for the wine are $1 per gallon for the white and $1.5 per gallon for the rose; the fruit juice can be purchased for $0.5 per gallon. La Jolla Beverage Products can sell all of the wine cooler it can produce for $2.5 per gallon. Is the cost of the wine and fruit juice a sunk cost or a relevant cost in this situation? Formulate a linear program to determine the blend of the three ingredients that will maximize the total…
Patz Company produces two types of machine parts: Part A and Part B, with unit contribution margins of $400 and $800, respectively. Assume initially that Patz can sell all that is produced of either component. Part A requires two hours of assembly, and B requires five hours of assembly. The firm has 400 assembly hours per week. What if market conditions are such that Patz can sell at most 100 units of Part A and 80 units of Part B? Express the objective function with its associated constraints for this case. Objective function: Max Z = $400 A + $800 B Assembly-hour constraint fill in the blank 7 A + fill in the blank 8 B ≤ fill in the blank 9 Demand constraint for Part A A ≤ fill in the blank 10 Demand constraint for Part B B ≤ fill in the blank 11 Identify the optimal mix and its associated total contribution margin.Component A $fill in the blank 12 units Component B $fill in the blank 13 units Total contribution $fill in the blank 14