Labor needed$/$Unit

$7\mathrm{.}5$

$65$

$5\mathrm{.}5$

$45$

$3\mathrm{.}5$

$2\mathrm{.}5$

Raw Material needed$/$Unit

$1\mathrm{.}8$

$27$

$0\mathrm{.}7$

$0\mathrm{.}6$

$0\mathrm{.}5$

$3\mathrm{.}6$

Unit Sale Price

$$11\mathrm{.}00$

$$12\mathrm{.}00$

$$6\mathrm{.}00$

$55\mathrm{.}00$

$54\mathrm{.}00$

$$15\mathrm{.}00$

Cost$/$Unit

$54\mathrm{.}70$

$$5\mathrm{.}30$

$$3\mathrm{.}20$

$52\mathrm{.}80$

$$1\mathrm{.}90$

$$6\mathrm{.}90$

Demand for each product

$948$

$908$

$1085$

$971$

$1177$

$952$

Unit Profit

$56\mathrm{.}30$

$$6\mathrm{.}70$

$52\mathrm{.}80$

$52\mathrm{.}20$

$$2\mathrm{.}10$

$$8\mathrm{.}10$

$10$

$11$

Total Profit

$12$

$13$

Constraints

Total Labor

$5000$

$14$

Total Raw Material available $<=$

$2000$

$15$

$16$

$17$

Refer to Practices $1,2,3,4.$

$18$

$19$

$20$

You have to think about other constraints such as the Units Made must be the Demand, and Units Made must be an integer.

$21$

R

Assume that you are working in a pharmacy company. For this given month, you have $5000$ labor hours available, raw materials $2000$ pounds available. You can make use of the labor and raw materials to produce $6$ products, each requireing different numbers of labor hours, raw material for each unit production. Also, each unit product has different price, cost, demand and profit. Note, we cannot produce too much for a product because there is a demand limit$.$ Over production would be a waste.

Now, how can we define the production for these products so that we can maximize our Total Profit in cell C$11?$

Row $3$: Labor units needed for producing $1$ unit of each product

Row $4$: Raw Material needed$/$Unit$,$ means how many raw materials are needed for producing $1$ unit of proudct. For example, for product $1,1\mathrm{.}8$ raw materials are needed, while for product $5,0\mathrm{.}5$ units of raw materials are neeeded for producing $1$ unit of product $5.$