For Thumb$-$up please share the excel file by completion of these questions what i really need is with dropbox etc:

Fred Jonasson manages a family$-$owned farm. To supplement several food products grown on the farm, Fred also raises pigs for market. He now wishes to determine the quantities of the available types of feed $($corn$,$ tankage$,$ and alfalfa$)$ that should be given to each pig. Since pigs will eat any mix of these feed types, the objective is to determine which mix will meet certain nutritional requirements at a minimum cost. The number of units of each type of basic nutritional ingredient contained within a kilogram of each feed type is given in the following table, along with the daily nutritional requirements and feed costs. Develop a linear programming model. Clearly define your decision variables, objective function, and constraints.

Nutritional Ingredient

Kilogram

Of Corn

Kilogram

Of Tankage

Kilogram

Of Alfalfa

Minimum daily

Requirement

Carbohydrates

$90$

$20$

$40$

$200$

Protein

$30$

$80$

$60$

$180$

Vitamins

$10$

$20$

$60$

$150$

Cost

$84$

$72$

$60$

Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times $($in minutes$)$ required on each machine are as follows:

Machine

Shaper

Grinder

Component $1$

$9$

$3$

Component $2$

$5$

$4$

Component $3$

$3$

$0$

The shaper is available for $120$ hours, and the grinder for $110$ hours. No more than $200$ units of component $3$ can be sold, but up to $1,000$ units of each of the other components can be sold. In fact, the company already has orders for $600$ units of component $1$ that must be satisfied. The per unit selling price and per unit variable cost for each of the three components are as follows:

Selling Price

Mterial Cost

Labor Cost

Component $1$

$25$

$12$

$5$

Component $2$

$18$

$8$

$4$

Component $3$

$27$

$13$

$5$

NewAge Pharmaceuticals produces the drug NasaMist from four chemicals. Today, the company must produce $5000$ pounds of the drug. The three active ingredients in NasaMist are A$,$ B$,$ and C$.$ By weight, at least $7\%$ of NasaMist must consist of A$,$ at least $5\%$ must consist of B$,$ and at least $3\%$ must consist of C$.$ The cost per pound of each chemical and the amount of each active ingredient in one pound of each chemical are given in the table below. At least $600$ pounds of chemical $3$ must be used. Create a spreadsheet model for this problem and solve it using Solver to determine the cheapest way of producing today$$s batch of NasaMist. Please submit the spreadsheet file and clearly mark down your solution.

Ingredient$/$lb of chemical

Chemical $1$

Chemical $2$

Chemical $3$

Chemical $4$

A

$0\mathrm{.}06$

$0\mathrm{.}1$

$0\mathrm{.}12$

$0\mathrm{.}03$

B

$0\mathrm{.}04$

$0\mathrm{.}03$

$0\mathrm{.}09$

$0\mathrm{.}02$

C

$0\mathrm{.}01$

$0\mathrm{.}04$

$0\mathrm{.}04$

$0\mathrm{.}01$

Cost$/$lb of chemicals

$8$

$10$

$11$

$14$

A manufacturing company wants to determine the number of product X and product Y to produce in order to maximize profit over the next four$-$week planning horizon. Constraints affecting the production quantities are the production capacities in three departments. Product X provides a profit of $$5$ per unit and Product Y provides a profit of $$4$ per unit. The linear programming model with production times and capacities expressed as follows:

Max

Profit $=5$X $+4$Y

s$.$t$.$

$12$X $+6$Y $<=20,400$

$($department $1)$

$9$X $+15$Y $<=25,200$

$($department $2)$

$6$X $+6$Y $<=12,000$

$($department $3)$

X$,$ Y $>=0$

Please use the graphical method to solve this model.

a$.$ Graph and shade the feasible region.

b$.$ Label and determine the coordinates of all the corner points.

c$.$ Find the optimal solution. You can use the iso$-$profit line method or the cornerpoints method. Show your work and indicate the optimal solution on your graph.

d$.$ Which constraints are binding?