solution

AutoSave Off H2 9a Prob2.9_Baker.xlsx O Search Jack Repa 7 ? File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments G ?, Solver Recent Sources [è Existing Connections AL ZA 112 WA AL Le From Text/CSV Le From Web Get Data From Table/Range <n na=”” clear=”” ye=”” reapply=”” advanced=”” ??=”” queries=”” &=”” connections=”” properties=”” refresh=”” all=”” edit=”” links=”” queries=”” &=”” connections=”” currencies=”” sort=”” stocks=”” filter=”” outline=”” text=”” to=”” ??8=”” columns=”” es=”” what-if=”” forecast=”” analysis=”” sheet=”” get=”” &=”” transform=”” data=”” data=”” types=”” sort=”” &=”” filter=”” data=”” tools=”” forecast=”” analyze=”” a1=”” ?=”” fx=”” microsoft=”” excel=”” 16.0=”” sensitivity=”” report=”” d=”” e=”” f=”” g=”” h=”” 1=”” j=”” k=”” l=”” m=”” n=”” 0=”” ?=”” r=”” 4=”” a=”” b=”” ?=”” 4=”” 5=”” 6=”” variable=”” cells=”” 7=”” 8=”” cell=”” name=”” 9=”” $c$14=”” a=”” produce=”” 1=”” 10=”” $d$14=”” a=”” produced2=”” 11=”” $e$14=”” a=”” produced3=”” 12=”” $f$14=”” a=”” produced4=”” 13=”” $g$14=”” a=”” produced5=”” 14=”” $c$15=”” b=”” produce=”” 1=”” 15=”” $d$15=”” b=”” produced2=”” 16=”” $e$15=”” b=”” produced3=”” 17=”” $f$15=”” b=”” produced4=”” 18=”” $g$15=”” b=”” produced5=”” 19=”” 19=”” $c$16=”” c=”” produce=”” 1=”” 20=”” 20=”” $d$16=”” c=”” produced2=”” 21=”” $e$16=”” c=”” produced3=”” 22=”” $f$16=”” c=”” produced4=”” 22=”” 23=”” 23=”” $g$16=”” c=”” produced=”” 24=”” 24=”” $c$17=”” d=”” produce=”” 1=”” 25=”” 23=”” $d$17=”” d=”” produced2=”” 26=”” $e$17=”” d=”” produced3=”” 27=”” $f$17=”” d=”” produced4=”” 28=”” $g$17=”” d=”” produced=”” 29=”” $c$18=”” e=”” produce1=”” 30=”” $d$18=”” e=”” produced2=”” 31=”” $e$18=”” e=”” produced3=”” sensitivity=”” report=”” 1=”” 1e+30=”” final=”” reduced=”” objective=”” allowable=”” allowable=”” value=”” cost=”” coefficient=”” increase=”” decrease=”” 2000=”” 300=”” 300=”” 1e+30=”” 300=”” 2000=”” 290=”” 300=”” 1e+30=”” 290=”” 2000=”” 290=”” 300=”” 1e+30=”” 290=”” 2000=”” 284=”” 300=”” 1e+30=”” 284=”” 2000=”” 283.3333333=”” 300=”” 1e+30=”” 283.3333333=”” 1600=”” 1600=”” 200=”” 200=”” 1e+30=”” 200=”” 1600=”” 175=”” 200=”” 1e+30=”” 175=”” 1600=”” 175=”” 200=”” 1e+30=”” 175=”” 100=”” 1600=”” 160=”” 200=”” 1e+30=”” 160=”” 1600=”” 158.3333333=”” 200=”” 1e+30=”” 158.3333333=”” 1000=”” 500=”” 500=”” 500=”” 1000=”” 500=”” tovu=”” 200=”” 304=”” 1e+30=”” 200=”” 1000=”” 200=”” 500=”” 30=”” 200=”” 1000=”” 200=”” 20=”” tovu=”” 500=”” 24=”” 30=”” 1e+30=”” 20=”” 466.6666667=”” 0=”” 500=”” 1900=”” u=”” 200=”” 20=”” 20=”” 1000=”” 400=”” 1e+30=”” 400=”” 725=”” n=”” 125=”” ?=”” 400=”” 225=”” 225=”” 0=”” 400=”” 240=”” 240=”” 400=”” 0=”” -240=”” 400=”” 240=”” 240=”” 1e+30=”” 0-266.6666667=”” 400=”” 266.6666667=”” 1e+30=”” 600=”” 400=”” 400=”” 1e+30=”” 400=”” 600=”” 150=”” 400=”” 1e+30=”” 150=”” 600=”” 150=”” 400=”” 1e+30=”” 150=”” sheet1=”” sheet2=”” sheet3=”” #=”” 1e+30=”” 400=”” 400=”” 240=”” ready=”” ?=”” +=”” 80%=”” type=”” here=”” to=”” search=”” o=”” el=”” x=”” 11_43=”” am=”” 10/11/2021=”” h=”” 66°f=”” autosave=”” off=”” h2=”” 9a=”” prob2.9_baker.xlsx=”” o=”” search=”” jack=”” repa=”” 7=”” ?=”” file=”” home=”” insert=”” draw=”” page=”” layout=”” formulas=”” data=”” review=”” view=”” help=”” share=”” comments=”” ,=”” solver=”” al=”” za=”” 112=”” wa=”” al=”” le=”” from=”” text/csv=”” recent=”” sources=”” le=”” from=”” web=”” [è=”” existing=”” connections=”” get=”” data=”” from=”” table/range=”” get=”” &=”” transform=”” data=””><n na ?? clear ye reapply advanced queries & connections refresh b properties all edit links queries & connections currencies sort stocks filter outline text to ??8 columns es what-if forecast analysis sheet data types sort & filter data tools forecast analyze a1 ? fx microsoft excel 16.0 sensitivity report j k l m n 0 ? r – 240 ? b c d e f g h 25 $d$17 d produced2 725 0 400 400 26 $e$17 d produced3 225 0 400 240 400 27 $f$17 d produced4 u 0 -240 400 240 1e+30 20 28 $g$17 d produced5 0 -266.6666667 400 266.6666667 1e+30 23 29 $c$18 e produce 1 600 400 400 1e+30 400 30 ju $d$18 e produced2 600 150 400 1e+30 150 31 $e$18 e produced3 600 150 400 1e+30 150 32 $f$18 e produced4 160 0 400 16.66666667 150 33 33 $g$18 e produced5 0-16.66666667 400 16.66666667 1e+30 34 35 constraints 36 final shadow constraint allowable allowable 37 cell name value price r.h. side increase decrease 38 $c$20 actual emissions produce1 91 0 999 1e+30 908 39 $d$20 actual emissions produced2 80 10000 80 11 29 40 $e$20 actual emissions produced3 60 10000 60 9 31 9 41 $f$20 actual emissions produced4 an an 16000 15 40 40 11 4 42 $g$20 actual emissions produced5 20 16666.66667 20 16 44 16 14 43 12 $c$21 actual hours used produce 1 4000 0 4000 1e+30 2.27374e-13 44 $d$21 actual hours used produced2 3725 0 n 4000 1e+30 275 16 45 $e$21 actual hours used produced3 3225 0 4000 1e+30 775 46 $f$21 actual hours used produced4 2560 0 1e+30 47 $g$21 actual hours used produced5 1866.666667 0 4000 1e+30 2133.333333 48 49 50 51 52 sensitivity report 1 sheet1 sheet2 sheet3 + ready 4000 1440 * dropbox x ? screenshot added a screenshot was added to your dropbox. e 0070 i type here to search o et x 66°f 11:43 am 10/11/2021 na=”” ??=”” clear=”” ye=”” reapply=”” advanced=”” queries=”” &=”” connections=”” refresh=”” b=”” properties=”” all=”” edit=”” links=”” queries=”” &=”” connections=”” currencies=”” sort=”” stocks=”” filter=”” outline=”” text=”” to=”” ??8=”” columns=”” es=”” what-if=”” forecast=”” analysis=”” sheet=”” data=”” types=”” sort=”” &=”” filter=”” data=”” tools=”” forecast=”” analyze=”” a1=”” ?=”” fx=”” microsoft=”” excel=”” 16.0=”” sensitivity=”” report=”” j=”” k=”” l=”” m=”” n=”” 0=”” ?=”” r=”” -=”” 240=”” ?=”” b=”” c=”” d=”” e=”” f=”” g=”” h=”” 25=”” $d$17=”” d=”” produced2=”” 725=”” 0=”” 400=”” 400=”” 26=”” $e$17=”” d=”” produced3=”” 225=”” 0=”” 400=”” 240=”” 400=”” 27=”” $f$17=”” d=”” produced4=”” u=”” 0=”” -240=”” 400=”” 240=”” 1e+30=”” 20=”” 28=”” $g$17=”” d=”” produced5=”” 0=”” -266.6666667=”” 400=”” 266.6666667=”” 1e+30=”” 23=”” 29=”” $c$18=”” e=”” produce=”” 1=”” 600=”” 400=”” 400=”” 1e+30=”” 400=”” 30=”” ju=”” $d$18=”” e=”” produced2=”” 600=”” 150=”” 400=”” 1e+30=”” 150=”” 31=”” $e$18=”” e=”” produced3=”” 600=”” 150=”” 400=”” 1e+30=”” 150=”” 32=”” $f$18=”” e=”” produced4=”” 160=”” 0=”” 400=”” 16.66666667=”” 150=”” 33=”” 33=”” $g$18=”” e=”” produced5=”” 0-16.66666667=”” 400=”” 16.66666667=”” 1e+30=”” 34=”” 35=”” constraints=”” 36=”” final=”” shadow=”” constraint=”” allowable=”” allowable=”” 37=”” cell=”” name=”” value=”” price=”” r.h.=”” side=”” increase=”” decrease=”” 38=”” $c$20=”” actual=”” emissions=”” produce1=”” 91=”” 0=”” 999=”” 1e+30=”” 908=”” 39=”” $d$20=”” actual=”” emissions=”” produced2=”” 80=”” 10000=”” 80=”” 11=”” 29=”” 40=”” $e$20=”” actual=”” emissions=”” produced3=”” 60=”” 10000=”” 60=”” 9=”” 31=”” 9=”” 41=”” $f$20=”” actual=”” emissions=”” produced4=”” an=”” an=”” 16000=”” 15=”” 40=”” 40=”” 11=”” 4=”” 42=”” $g$20=”” actual=”” emissions=”” produced5=”” 20=”” 16666.66667=”” 20=”” 16=”” 44=”” 16=”” 14=”” 43=”” 12=”” $c$21=”” actual=”” hours=”” used=”” produce=”” 1=”” 4000=”” 0=”” 4000=”” 1e+30=”” 2.27374e-13=”” 44=”” $d$21=”” actual=”” hours=”” used=”” produced2=”” 3725=”” 0=”” n=”” 4000=”” 1e+30=”” 275=”” 16=”” 45=”” $e$21=”” actual=”” hours=”” used=”” produced3=”” 3225=”” 0=”” 4000=”” 1e+30=”” 775=”” 46=”” $f$21=”” actual=”” hours=”” used=”” produced4=”” 2560=”” 0=”” 1e+30=”” 47=”” $g$21=”” actual=”” hours=”” used=”” produced5=”” 1866.666667=”” 0=”” 4000=”” 1e+30=”” 2133.333333=”” 48=”” 49=”” 50=”” 51=”” 52=”” sensitivity=”” report=”” 1=”” sheet1=”” sheet2=”” sheet3=”” +=”” ready=”” 4000=”” 1440=”” *=”” dropbox=”” x=”” ?=”” screenshot=”” added=”” a=”” screenshot=”” was=”” added=”” to=”” your=”” dropbox.=”” e=”” 0070=”” i=”” type=”” here=”” to=”” search=”” o=”” et=”” x=”” 66°f=”” 11_43=”” am=””>