[go: up one dir, main page]
Scribd
Upload
49 views1 page

Prescriptive Analytics Assignment - Raju Kumar - Part9

The document outlines a production optimization problem for BodyPlus100 and BodyPlus200 machines, including constraints on production hours and costs. It calculates the profit based on the production quantities and provides a recommended production plan of 50 BodyPlus100 and approximately 16.67 BodyPlus200 machines. The objective is to maximize profit while adhering to specified constraints.

Uploaded by

Raju Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
49 views1 page

Prescriptive Analytics Assignment - Raju Kumar - Part9

The document outlines a production optimization problem for BodyPlus100 and BodyPlus200 machines, including constraints on production hours and costs. It calculates the profit based on the production quantities and provides a recommended production plan of 50 BodyPlus100 and approximately 16.67 BodyPlus200 machines. The objective is to maximize profit while adhering to specified constraints.

Uploaded by

Raju Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

According to the data above:

X: # of BodyPlus100 to be produced.
Y: # of BodyPlus200 to be produced.
Equations # 1:
8X + 12Y ≤ 600
5X + 10Y ≤ 450
2X + 2Y ≤ 140
X ≥ 0 and Y ≥ 0

BFI get only 70% of the retail price, as follows:


Revenue = (2400 * 0.7X) + (3500 * 0.7Y) = 1680X + 2450Y

The cost of packaging plus raw materials cost is given by:


1050X + 1575Y

The labour cost in the 3 departments is given by:


(8X + 12Y) * 20 + (5X + 10Y) * 15 + (2X + 2Y) * 12; 259X + 414Y

Then, the total cost is calculated as follows:


1050X + 259X = 1309X
1575Y + 414Y = 1989Y; 1309X + 1989Y

And the profit is the difference between revenue minus cost, and is given by:
1680X – 1309X = 371X
2450Y – 1989Y = 461Y

Equation # 2:
Profit = 371X + 461Y

The requirement that the BodyPlus 200 must be at least 25% of the total production:
Y ≥ (X + Y) * 0.20 → X – 3Y ≥ 0

Q1. What is the recommended number of BodyPlus 100 and BodyPlus 200 machines to produce?
Objective: Max 371X + 461Y
S.T.
Total Hours Available 8X + 12Y <= 600
Machining and Welding 5X + 10Y <= 450
Painting and Finishing 2X + 2Y <= 140
Assembly, Test, and Packaging -0.25X + 0.75Y >= 0
X Y Objective
Decision variables 50 16.66667 26233.33
Coefficients 371 461
X Y LHS RHS
Constraint1 8 12 600 <= 600
Constraint2 5 10 416.6667 <= 450
Constraint3 2 2 133.3333 <= 140
Constraint4 -0.25 0.75 0 >= 0
Constraint5 1 50 >= 0
Constraint6 1 16.66667 >= 0
Constraints
Name Cell Value Formula Status Slack
Constraint1 LHS 600.00 $Q$8<=$S$8 Binding 0.00
Constraint2 LHS 416.67 $Q$9<=$S$9 Not Binding 33.33
Constraint3 LHS 133.33 $Q$10<=$S$10 Not Binding 6.68
Constraint4 LHS 0.00 $Q$11>=$S$11 Binding 0.00
Constraint5 LHS 50.00 $Q$12>=$S$12 Not Binding 50.00
Constraint6 LHS 16.67 $Q$13>=$S$13 Not Binding 16.68

You might also like