I need help in this question. Please do it correctly and follow all the steps. Please show me all the steps so i can sol

[answerhappygod]

I need help in this question. Please do it correctly and
follow all the steps. Please show me all the steps so i can solve
it myself. Please use SOLVER TABLE. Must use solver Table as Part B
is related to SOLVER TABLE AND DO TWO WAY ANALYSIS WITH THE HELP OF
SOLVER TABLE AND SHOW ME HOW TO DO IT WITHTHE HELP OF
SCREENSHOTS
PLEASE SHOW ALL STEPS

whats missing? everything is there

I Need Help In This Question Please Do It Correctly And Follow All The Steps Please Show Me All The Steps So I Can Sol 1 (25.41 KiB) Viewed 43 times

I Need Help In This Question Please Do It Correctly And Follow All The Steps Please Show Me All The Steps So I Can Sol 2 (25.43 KiB) Viewed 43 times

I Need Help In This Question Please Do It Correctly And Follow All The Steps Please Show Me All The Steps So I Can Sol 3 (13.22 KiB) Viewed 43 times

I Need Help In This Question Please Do It Correctly And Follow All The Steps Please Show Me All The Steps So I Can Sol 4 (26.83 KiB) Viewed 43 times

Repco produces three drugs, A, B, and C, and can sell these drugs in unlimited quantities at unit prices $8. $90, and $280, respectively. Producing a unit of drug A requires one hour of labor. Producing a unit of drug B requires two hours of labor and three units of drug A. Producing one unit of drug C requires three hours of labor, two units of drug A and two units of drug B. Any drug A that is used to produce drug B cannot be sold separately, and any drug B that is used to produce drug C cannot be sold separately. A total of 9000 hours of labor are available. Please answer the following questions - a. Help Repco use LP to maximize its sales revenue. (15 pts) b. Using Solvectable to find out how the production of drug C is changing, if the selling price of drug C could be $200, $210, $220, $230, $240, $250, $260, $270, $280, $290, $300, $310, $320, $330, $340, $350; and available labor hours could be 4000, 5000, 6000, 7000, 8000, 9000, and 10000 respectively.
Drug B 2 Drug C 3 3 2 0 2 0 0 1 Repco production process model 2 3 Inputs used (along side) to make one unit of product (along top) 4 Drug A 5 Labor hours 1 6 7 Drug A 0 8 Drug B 0 9 Drug C 0 10 11 Unit selling prices Drug A 12 13 14 Production and sales plan 15 Drug A 16 Units produced 17 18 Units used in production 19 Units sold 20 21 Labor hour constraint 22 Drug B Drug C Drug B Drug C >= Hours used Hours available
Drug A Drug B Drug C 13 14 Production and sales plan 15 16 Units produced 17 18 Units used in production 19 Units sold 20 21 Labor hour constraint 22 Hours used Hours available 23 24 25 Revenue from sales
118 E F G H j к K L M м N 7000 8000 9000 10000 A B C D 1 Twoway analysis for Solver model in Q3.a (15 pts) worksheet 2 3 Drug_C_Production 4000 5000 6000 4 $2001 5 $2101 6 $220 7 $230 8 $240 9 $250 10 $260 11 $270 12 $280 13 $290 14 $300 15 $310 16 $320 17 $330 18 $340 19 $350 20 21