Question

In: Economics

Incline Electronics produces three different products in a plant that is open 40 hours per week....

Incline Electronics produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times (in hours) on each of three machines.

Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available, and 8 type 3 machines available. Products 1, 2, and 3 contribute $90, $120, and $150, respectively, in marginal profit per unit produced.

a. Select the correct LP model for this problem.

Let P₁ represent Units of product 1 to make.
Let P₂ represent Units of product 2 to make.
Let P₃ represent Units of product 3 to make.

I	MAX	90P₁ + 120P₂ + 150P₃
	ST	2P₁ + 2P₂ + 1P₃ ≤ 240
		3P₁ + 4P₂ + 6P₃ ≤ 400
		4P₁ + 6P₂ + 5P₃ ≤ 320
		9P₁ + 12P₂ + 12P₃ ≤ 665
		P_i ≥ 0

II	MIN	90P₁ + 120P₂ + 150P₃
	ST	2P₁ + 2P₂ + 1P₃ ≤ 240
		3P₁ + 4P₂ + 6P₃ ≤ 320
		4P₁ + 6P₂ + 5P₃ ≤ 400
		9P₁ + 12P₂ + 12P₃ ≤ 665
		P_i > 0

III	MIN	90P₁ + 120P₂ + 150P₃
	ST	2P₁ + 2P₂ + 1P₃ ≥ 400
		3P₁ + 4P₂ + 6P₃ ≥ 665
		4P₁ + 6P₂ + 5P₃ ≥ 320
		9P₁ + 12P₂ + 12P₃ ≥ 240
		P_i > 0

IV	MAX	90P₁ + 120P₂ + 150P₃
	ST	2P₁ + 2P₂ + 1P₃ ≤ 400
		3P₁ + 4P₂ + 6P₃ ≤ 240
		4P₁ + 6P₂ + 5P₃ ≤ 320
		9P₁ + 12P₂ + 12P₃ ≤ 665
		P_i ≥ 0

Select I,II,III,IV

b. Implement your model in a spreadsheet and solve it. How many units for each product should Incline Electronics produce? Round your answers to one decimal place, if necessary.

	Quantity
Product 1
Product 2
Product 3

c. What is the total profit for the optimal solution?
$

d. How many workers should be assigned to each type of machine? Round your answers to one decimal place, if necessary.

Machine 1
Machine 2
Machine 3

Solutions

Expert Solution

a. The correct option is D.

We need to maximize revenue. Total revenue would be

90P1+120P2 + 150P3. So, maximizing constraint is

MAX 90P1+120P2 + 150P3

This leaves us with options A and D.

Now, the workers work 35 hours and there are total 19 workers. So total worker hours available is 19*35=665. Worker constraint is

9P1 + 12P2 + 12P3 ≤ 665

There are 10 Type 1 machines. The plant orks for 40 hours per week. Machine 1 hours available=40*10=400. Similarly, machine 2 hours available hours 6*40=240. Machine 3 hours available 8*40=320.

Machine constraints

2P1 + 2P2 + 1P3 ≤ 400
3P1 + 4P2 + 6P3 ≤ 240
4P1 + 6P2 + 5P3 ≤ 320

Combining all constraints, we get

Option D

B. Using solver option (In Data tab), we can solve the problem for maximum profit.
Note- if solver option is not there in your data tab, go to options and then plug-ins and enable it first.

First elts setup the problem in excel. We have already designed the problem in part A. Putting it in excel will look like this.

The quantity and profit tabs are zero right now because excel solver will determine the quantities for max profit.

Clicking on solver and then we need to enter for the following parameters.

We are maximizing profit (F3) by changing the number of units made (B2:D2) subject to constraints. Click on solve and we will get the following output.

As can be seen,

Quantity 1=6.7
Quantity 2=41.3
Quantity 3=9.2

C. Total profit, as solved in part B, is $6925

D. Workers for
Machine 1=3
Machine 2=6.9
Machine 3=9.1

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

In a new restaurant Jake’s offers three different burgers that is open 40 hours per week....

In a new restaurant Jake’s offers three different burgers that is open 40 hours per week. Each product requires the following processing times (in minutes) in each of three station. Burger Max Burger Special Mega Burger Grill 2 2 1 Preparation 3 4 6 Packaging 4 6 5 Each station must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 grills, 6 preparation stations, and 8 packaging machines available....

Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours are...

Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours are available on each machine. The profit contribution and production time in hours per unit are as follows: Category Product 1 Product 2 Product 3 Profit/unit $30 $50 $20 Machine 1 time/unit 0.5 2 0.75 Machine 2 time/unit 1 1 0.5 Two operators are required for machine 1; thus, 2 hours of labor must be scheduled for each hour of machine 1 time. Only one...

An industrial plant was trying to determine if hours of training affected the output per week...

An industrial plant was trying to determine if hours of training affected the output per week of employees. They randomly sampled 15 employees and randomly assigned them to 5, 9 or 16 hours of training before putting them on the production line. The output of the third week after training was measured and the following data were gathered for the 15 employees. 5 9 16 8 16 23 9 18 26 10 20 26 12 22 29 16 24 26...

Jilai earns $12 per hour for up to 40 hours of work each week. He is...

Jilai earns $12 per hour for up to 40 hours of work each week. He is paid $18 for every hour in excess of 40. Jilai faces a 20 percent tax rate on his labor earnings. Regardless of how much he works, he also receives $200 in tax-free dividends from prior investments each week. There are 110 non-sleeping hours in the week. graph jilai.

Jasmine Electronics Company produces two products, Resistors and Transistors in a small manufacturing plant. During June,...

Jasmine Electronics Company produces two products, Resistors and Transistors in a small manufacturing plant. During June, Jasmine Electronics produced 100 units of Resistors and 100 units of Transistors incurring a total manufacturing overhead cost of $21,000. Assume Jasmine Electronics uses Activity Based Costing and that its total manufacturing overhead costs of $21,000 were assigned to the following: ABC cost pools: Material inspections & preparation ($10,000) $ 10 per pound of raw materials Material moves ($2,000) $ 25 per move Machine...

Do engineers work more hours per week than the national average hours per week worked? ...

Do engineers work more hours per week than the national average hours per week worked? [ Choose ] Two-sided test One-sided lower test One-sided upper test Is the gas mileage of a smart for two coupe really less than 40 mpg? (According to the 2013 EPA gas mileage figures, the answer is yes. Doesn't seem that smart…) [ Choose ] Two-sided test ...

A process makes two products. A and B. and operates 5 days per week. 8 hours...

A process makes two products. A and B. and operates 5 days per week. 8 hours per day. Demand for the two products for the next week is as follows: Day 1: A: 20; B:26 Day 2: A: 10: B:15 Day 3: A: 20; B:19 Day 4: A: 18; B:20 Day 5: A: 12; B: 20 What is the takt time of the process? What would a level production schedule look like?

Accurate Reports has 70 employees each working 40 hours per week and earning $25 an hour....

Accurate Reports has 70 employees each working 40 hours per week and earning $25 an hour. Federal income taxes are withheld at 15% and state income taxes at 6%. FICA taxes are 7.65% of the first $118,500 earned per employee and 1.45% thereafter. Unemployment taxes are 6.20% of the first $7,000 earned per employee. 1. Compute the total salaries expense, the total withholdings from employee salaries, and the actual payroll payment (salaries payable) for the first week of January. (Round...

A company produces three different types of cameras. The hours required to produce each model are...

A company produces three different types of cameras. The hours required to produce each model are listed in the following table: Camera Model Model A Model B Model C Hours Required 1.6 1.8 2.3 As of January there are 95 permanent workers and 165 production hours available per worker per month. The forecast demand for each model in the first half of next year is shown in the table below: Model January February March April May June A 5000 5600...

Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...

Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 84.00 $ 70.00 $ 74.00 Variable expenses: Direct materials 25.20 21.00 9.00 Other variable expenses 25.20 31.50 42.80 Total variable expenses 50.40 52.50 51.80 Contribution margin $ 33.60 $ 17.50 $ 22.20 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 750 units of each product per month. The same...

Subjects