Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file A company produces three different types of wrenches: W1, W2, and W3. It has a firm order for 2,000 W1 wrenches, 3,750 W2 wrenches, and 1,850 W3 wrenches. Between now and the delivery date, the company has only 17,500 fabrication hours and 1,600 inspection hours. The time that each wrench requires in each department is shown in the table for this problem. Also shown are the costs to manufacture the wrenches in-house and the costs to outsource them. For labelling considerations, the company wants to manufacture in-house at least 60% of each type of wrench that will be shipped. How many wrenches should be outsourced? What will be the total cost to satisfy the order? Wrench Fabrication Hours Inspection Hours In-House Cost Outsource Cost W1 2.25 0.25 $17.00 $19.00 W2 3.25 0.30 $19.00 $21.00 W3 3.75 0.45 $22.00 $24.00

Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file A company produces three different types of wrenches: W1, W2, and W3. It has a firm order for 2,000 W1 wrenches, 3,750 W2 wrenches, and 1,850 W3 wrenches. Between now and the delivery date, the company has only 17,500 fabrication hours and 1,600 inspection hours. The time that each wrench requires in each department is shown in the table for this problem. Also shown are the costs to manufacture the wrenches in-house and the costs to outsource them. For labelling considerations, the company wants to manufacture in-house at least 60% of each type of wrench that will be shipped. How many wrenches should be outsourced? What will be the total cost to satisfy the order? Wrench Fabrication Hours Inspection Hours In-House Cost Outsource Cost W1 2.25 0.25 $17.00 $19.00 W2 3.25 0.30 $19.00 $21.00 W3 3.75 0.45 $22.00 $24.00

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

The Elastic Firm has two products coming on the market, Zigs and Zags. To make a Zig, the firm needs 10 units of product A and 15 units of product B. To make a Zag, they need 20 units of product A and 15 units of product B. There are only 2,000 units of product A and 3,000 units of product B available to the firm. The profit on a Zig is R4 and on a Zag it is R6. Management objectives in order of their priority are: (1) Produce at least 40 Zags. (2) Achieve a target profit of at least R750. (3) Use all of the product A available. (4) Use all of the product B available. (5) Avoid the requirement for more product A. Formulate this as a goal programming problem.
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hours of drilling time maybe used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans that yields the highest profit. Use the corner point graphical approach
Dana’s Ribbon World makes award rosettes. Following is information about the company: Variable cost per rosette $ 2.00 Sales price per rosette $ 6.00 Total fixed costs per month $ 6000.00 Required: 1. Suppose Dana’s would like to generate a profit of $1,120. Determine how many rosettes it must sell to achieve this target profit. 2. If Dana’s sells 2,140 rosettes, compute its margin of safety in units, in sales dollars, and as a percentage of sales. 3. Calculate Dana’s degree of operating leverage if it sells 2,140 rosettes. 4a. Using the degree of operating leverage, calculate the change in Dana’s profit if unit sales drop to 1,819 units. 4b. Prepare a new contribution margin income statement to verify change in dana's profit.
Creative sports design (CSD) manufactures a standard size racket and an over sized racket. The firm's rackets are extremely light due to the use of a magnesium- graphite alloy that was invented by the firm's founder. Each standard size racket uses 0.125 kilograms of the alloy and each oversize racket uses 0.4 kilograms; over the next two week production period only 80 kilograms of the alloy are available. Each standard size racket uses 10 min. of manufacturing timeand each oversize racket uses 12 min. The profit contributions are $10 for each standard size racket and $15 for each oversized racket, and 40 hours of manufacturing time are available each week. Managment specified that at least 20% of the total production must3 be the standard size racket. How many rackets of each type should CSD manufacture over the next 2 weeks to maximize the total profit contributions? Assume that because of the unique nature of their products, CSD can sell as many rackets as they can produce?
Wallace Company makes and sells a single product. Each unit of product requires two hours of labor with a wage rate of $8 per hour. The company has budgeted to sell 8,000 units and to produce 10,000 units during the current month. The product requires three pounds of material for each unit produced. Budgeted direct labor costs for the current month would be: $192,000 $128,000 $80,000 $64,000 $160,000
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend. His political consultants have provided him with the following estimates of additional votes as a result of the advertising effort: -for every small sign placed by the roadside, he will garner 20 additional votes. -for every large sign placed by the roadside, he will garner 30 additional votes. -for every thousand bumper stickers placed on cars, he will garner 15 additional votes. -for every hundred personal mailings to voters, he will garner 40 additional votes. -for every radio ad heard, he will garner 485 additional votes. The costs for each of the advertising devices, along with the practical minimum and maximum that should be planned for each, are shown on the following table. How should the candidate plan…
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
The Electrocomp Corporation manufactures two electrical products: air conditioners and large fans. The assembly process for each is similar in that both rquire a certain amount of wiring and drilling. Each air condtioner takes 3 hours of wiring and 2 hours of drilling. During the next production period, 240 hours of wiring time are available, and up to 140 hours of drilling time may be used. Each air conditioner sold yieds a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate the best combination of air conditioners and fans that yiedls the highest profit. Use the corner point graphical approach.
Triple X Company manufactures and sells refrigerators. It makes some of the parts for the refrigerators and purchases others. The engineering department believes it might be possible to cut costs by manufacturing one of the parts currently being purchased for $8.25 each. The fi rm uses 100,000 of these parts each year. The accounting department compiles the following list of costs based on engineering estimates:Fixed costs will increase by $50,000. Labor costs will increase by $125,000.Factory overhead, currently running $500,000 per year, may be expected to increase 12 percent.Raw materials used to make the part will cost $600,000.Given the preceding estimates, should Triple X make the part or continue to buy it?
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
Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. You must make 4 chairs for every table. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.) Scenario 1 Large wood per table 3 Small wood per table 2 Large wood per chair 1 Small wood per chair 4 Revenue per table $35 Revenue per chair $29 Large wood inventory 300 Small wood inventory 500