I need the awnsers solved in excel for me$,$ not directions on how to do it

$1)$ Type your name in Cell A$1.$ Type your section $(03)$ for $12$:$30$ and $(04)$ for $2$:$00.$

$2)$ Type $$Cost$$ in C$5$; $$Dec$.$ Var.$$ in C$6$; $$Cost per Unit$$ in C$7$; $$Solutions$$ in C$8.$ For Cell D$5,$ type $=$SUMPRODUCT$($D$7$:F$7,$D$8$:F$8)$; you will get an initial $0.$

$3)$ Type $$Choc$.$ X$1$ in D$6$; $$PeaButX$2$ in E$6$; and $$CaramelX$3$ in F$6.$

$4)$ Type $0\mathrm{.}18,0\mathrm{.}12,$ and $0\mathrm{.}15$ in Cells D$7$ through F$7.$

$5)$ Type $$C$1$ through $$C$5$ in Cells B$10$ through B$14.$

$6)$ Type $30\%$ Choc.$$ In Cell C$10$; $$Protein$$ in Cell C$11$; $$Carbohy$.$ in Cell C$12$; $$Sat$.$ Fats$$ in Cell C$13$; and $$Weight$$ in Cell C$14.$

$7)$ Type the coefficients for each constraint, i$.$e$.0\mathrm{.}7$ in Cell D$11$; $3\mathrm{.}5$ in Cell E$11$; and $2$ in Cell F$11.$ The exercise gave you constraints C$2$ through C$4.$ You need to formulate Constraints $1$ and $5.[$If you cannot figure them out, you may email me$.$ I$$ll give you the equations for one point each. This is better than coming up with wrong answers on the rest of the assignment.$]$ In Cells G$10$:G$14,$ you need to put in the inequality $(>=$ for $>$ and for For Cells H$10$:H$14,$ you need to type in the values for the RHS$,$ i$.$e$.5$ for Cell H$11$; $6$ for Cell H$12$; and $5$ for Cell H$13.$ Check your entries; this is a prime place for errors.

$8)$ Type $$LHS$$ in Cell D$17$; $$Relation$.$ in Cell E$17$; and $$RHS$$ in Cell F$17.$

$9)$ Type $$C$1$ through C$5$ in Cells B$18$:B$22.$ For Cells c$18$:c$22,$ type in the information used in Cells C$10$:C$14.$ For Cells E$18$:E$22,$ type in the correct inequalities, as you did in Cells G$10$:G$14.$ For Cells F$18$:f$22,$ type in the RHS values, as you did in Cells H$10$:H$14.$ For Cell D$18,$ type SUMPRODUCT$($D$10$:F$10,$D$8$:F$8).$ For Cells D$19-$D$22$ use the same formula, but change the cells in the first pair; D$8$:F$8$ is constant. You will initially get $0$ for D$18$ through D$22.$

You have now completed Sheet $1.$ Go to $$Data$$ and then $$Solver$.$ Be sure to check your entries. A typo could

$10)$ For objective function, type $$$D$$5.$

$11)$ Click on $$Min$.$

$12)$ Type $$$D$$8$:$F$$8$ for $$By Changing Variable Cells.$$

$13)$ For $$Subject to the Constraints,$$ click on $$Add$.$ Put in $$D$18,$ hit the correct relationship, and then $$F$18$; then click $$Add$.$ Do this for each of the remaining four constraints. When you$$ve entered the final constraint, click $$Cancel$.$ Check the constraints.

$14)$ You can click $$Make Unconstrained Variables Non$-$Negative.$$ For $$Select a solving method$,$ use $$GRG Nonlinear.$$

$15)$ You need to click on $$Answer$$ and $$Sensitivity$.$ If all goes well, you will get an $$Answer Report $1$ and $$Sensitivity Report $1.$ The objective function value should be $0\mathrm{.}6066.$ Note: $$E$-0$x$$ means a very small number, essentially zero. If $$Solver Results$$ box does not come u

Type your name in cell A$1$; type your class time in cell A$2.$ Turn in a hard copy of your

work, as well as sending your assignment to eLearning.

The Marz Chocolate Company produces Marz$-$Mallow candy bars. The candy bars contain

chocolate $($X$1),$ peanut butter $($X$2),$ and caramel $($X$3)($in terms of ounces$).$ The objective is to

minimize the cost of producing the candy bar. Chocolate costs eighteen cents per ounce; peanut

butter costs twelve cents per ounce; and caramel costs fifteen cents per ounce. Constraint $1$

requires the candy bars to be composed of at least $30\%$ chocolate $($by weight$).$ Constraint $2$

requires the candy bars to have at least five grams of protein. Constraint $3$ requires the candy

bars to have no more than six grams of carbohydrates. Constraint $4$ requires the candy bars to

have no more than five grams of saturated fats. Constraint $5$ requires the candy bars to be at least

four ounces in weight. You'll need to figure out how to write Constraints $1$ and $5.[$Note: since

the ounces and grams are in separate constraints, there's no need to convert them.$]$

$C2$: $0\mathrm{.}7x1+3\mathrm{.}5x2+2x35(Protein)$

$C3$:$,1\mathrm{.}2x1+2\mathrm{.}8x2+0\mathrm{.}05x36(Carbohydrates)$

$C4$: $0\mathrm{.}55x1+2\mathrm{.}2x2+1\mathrm{.}2x35(Saturated$ Fats$)$

Set this up as an Excel spreadsheet and use the information in the Excel "Answer Report" to

answer the following questions:

a$)$ How many ounces of chocolate, peanut butter, and caramel should Marz use in order to

minimize the cost of producing Marz$-$Mallow candy bars?

b$)$ Which constraints are binding?

c$)$ How many grams of saturated fat are included in the candy bar?

Use the information in the Excel "Sensitivity Report" to answer the questions below:

d$)$ If the cost of chocolate became twenty cents, what would happen to your cost?

e$)$ If the allowable amount of protein fell to $4,$ how much would the minimum cost be$?$

f$)$ If the allowable amount of the total weight rose to $5,$ how much would the minimum

cost be$?$