APPROACH Formulate this production-mix situation as an LP problem. The production manager first specifies production levels for each product for the coming month. He lets: Xị = number of units of XJ201 produced X; = number of units of XM897 produced X3 = number of units of TR29 produced X4 = number of units of BR788 produced SOLUTION The LP formulation is: Objective: Maximize profit = 9X1 + 12X, + 15X3 + 11X4 subject to: 5x, + 1.5X2 + 1.5Xz + 1X4 < 1,500 hours of wiring available 3X, + 1X, + 2X3 + 3X s 2,350 hours of drilling available 2X, + 4X2 + 1X3 + 2X4 s 2,600 hours of assembly available .5X, + 1X, + 5X + .5X4 s 1,200 hours of inspection X1 2 150 units of XJ201 X, 2 100 units of XM897 X3 2 200 units of TR29 X4 2 400 units of BR788 X1, X2, X3, Xg 2 0

APPROACH Formulate this production-mix situation as an LP problem. The production manager first specifies production levels for each product for the coming month. He lets: Xị = number of units of XJ201 produced X; = number of units of XM897 produced X3 = number of units of TR29 produced X4 = number of units of BR788 produced SOLUTION The LP formulation is: Objective: Maximize profit = 9X1 + 12X, + 15X3 + 11X4 subject to: 5x, + 1.5X2 + 1.5Xz + 1X4 < 1,500 hours of wiring available 3X, + 1X, + 2X3 + 3X s 2,350 hours of drilling available 2X, + 4X2 + 1X3 + 2X4 s 2,600 hours of assembly available .5X, + 1X, + 5X + .5X4 s 1,200 hours of inspection X1 2 150 units of XJ201 X, 2 100 units of XM897 X3 2 200 units of TR29 X4 2 400 units of BR788 X1, X2, X3, Xg 2 0

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

If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
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.
Answer the 3 subparts in 2 sentences each. For each of the following scenarios, please identify the most appropriate Operations Research model. RPI is facilitating a mentorship program and wants to assign undergraduate students with graduate student mentors. There are more undergraduate students than graduate students; therefore, each graduate student can be assigned at most 3 undergraduate student mentees. The goal is to maximize assignment satisfaction. The children’s game Snakes and Ladders is played in a sequential fashion. If a player is on a given square, the player can move to a different square based on selecting a card. This is a game of chance and there is no strategy in the game. The goal is predict who will win the game given the current location of both players. The US government wants to connect all major US cities with high-speed internet lines, which requires laying lines below ground. The US government wants to use the least amount of high-speed lines to connect…
Answer the 3 subparts in 2 sentences each. For each of the following scenarios, please identify the most appropriate Operations Research model. RPI is facilitating a mentorship program and wants to assign undergraduate students with graduate student mentors. There are more undergraduate students than graduate students; therefore, each graduate student can be assigned at most 3 undergraduate student mentees. The goal is to maximize assignment satisfaction. The children’s game Snakes and Ladders is played in a sequential fashion. If a player is on a given square, the player can move to a different square based on selecting a card. This is a game of chance and there is no strategy in the game. The goal is predict who will win the game given the current location of both players. The US government wants to connect all major US cities with high-speed internet lines, which requires laying lines below ground. The US government wants to use the least amount of high-speed lines to connect…
Box Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $24,975 Material cost per unit = $0.17 Labor cost per unit = $0.12 Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Box Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Note :write the equations seperately A firm is making two products A & B. Each unit of A incurs a cost of production to the tune of $150 and that of B incurs a cost of $200. Product A carns a profit of $15/unit and B gets $20/unit. The estimated monthly demand of both A & B is at maximum 500 units. Monthly production budget is set at $50.000.How many units of A & B should the firm make in order to maximize profit. Conduct sensitivity analysis and answer the following questions: 1. State the optimal solution. 2. What is the objective function value? 3. Find out the range of profit for A in the objective function for which the above solution remains optimal.
Telsla produces a range of electric car models. The following presents hypothetical information in regards to the production of these cars. The production manager would like your assistance to identify the optimal production mix. Below is an estimation of the costs to manufacture these products. Model S Model 3 Model X Selling price $130,000.00 $63,000.00 $150,000.00 Direct materials $60,000.00 $26,000.00 $67,000.00 Direct labour $17,500.00 $11,500.00 $20,750.00 Variable overhead $13,125.00 $8,625.00 $15,562.50 Fixed overhead $8,750.00 $5,750.00 $10,375.00 Each of these products goes through the same manufacturing process. The time for each process required for each model and the total hours available for each process are provided in the table below. Process Model S Model 3 Model X Total hours available Body 2 1.5 2.5 750,000 Stamping 1 0.75 1.2 400,000 Plastics 2 1.75 2.1 700,000 Assembly 4 3.5 4.5 1,400,000 Required: Using Excel…
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
A company is preparing an aggregate production plan for its product for the next four months. The company's expected monthly demand is given in the following table. The company will have 100 million in inventory at the beginning of this month and wishes to hold at least 100 Units at the end of each month.Important data is shown below: production cost per unit =$125 cost of inventory storage per month per unit =$10 cost of hiring per worker =$50 firing cost per worker =$100 initial number of workers =25 each worker can produce =25 units per month Month->expected demand: M1 ->600 M2->800 M3->700 M4->900 What is the total cost of a chase plan that uses only hiring/firing?
8-1 (Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table on this page contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob Winkler would like to determine a product mix to maximize his daily revenue. Cabinet Style Carpentry (Hours/Cabinet) Painting (Hours/Cabinet) Finishing (Hours/Cabinet) Net Revenue/Cabinet ($) French Provincial 3 1.5 0.75 28 Danish Modern 2 1 0.75 25 Department Capacity (Hours) 360 200 125 a) Formulate as an LP problem. b) Solve using an LP software program or…
8-1 (Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table on this page contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob Winkler would like to determine a product mix to maximize his daily revenue. Perform the four steps (i.e., define variables, determine objective function, identify constraints, list the non-negativity statement) and write equations. Use the table in the picture
Steve's Scooer plans to sell it standard scooter for $500 and it chrome for $650. Steve purchases the standard scooter for $150 and Chrome for $250. Steve expects to sell one standard scooter for every three chrome scooter. Steve's monthly fixed cost are $263000. How many of each scooter must Steve sell each month to break even? and how many of each scooter must Steve sell each month to earn $697000?