After using excel to find the solution, write your answers to the following questions in this document. Remember that each team member should attempt to use solver and turn in their own supporting excel sheet.

___/4 pts Briefly Explain what each of the four different decision variables is and its final value. Make sure you provide a description. I have provided a starter for you below

V1: verb (information related to the sign) final answer item

___/3 pts Write the final Z max or min formulas below:

__/4 pt Complete the sentences below by circling the correct bolded word, calculating Z, and identifying the correct customer

MyT Pet MAXIMIZED PROFITS / MINIMIZED COSTS (circle or highlight one) for a total of Z = $__________________ for ________________________

MyT Pet MAXIMIZED PROFITS / MINIMIZED COSTS (circle or highlight one) for a total of Z = $__________________ for _________________________

___/5 pts Aside from non-negativity of the variables, What are the constraints? (hint: look at the sensitivity report provided). Write a short description for each constraint in the order listed in the solver report, followed by writing out the formula (dont forget to circle which type of equality/inequality)

	-Description-	Variables and Coefficients	what type? Circle one	RHS
C1			( = )
C2			( = )
	Include as many rows as relevant

___2 pts List each Binding constraint (by C# and name) below and explain how you came to that answer (use LP language for full credit)

___2 Pts For each Non-binding constraint(s) what is the amount of slack/surplus? (use terminology from LP and/or excel e.g. write as C# has a slack of ##)

MY-T Pet (24 points-Group and Individual work) MY-T Pet is a specialty pet food provider that makes specialized and custom mixes to sell to veterinarians. MY-T Pet has four different proprietary mixes that they blend to make most of the routine dog foods that they sell. MY-T pet has a customer, Avenues Vet, who just placed an order of 5000lbs and another, Ocean View Vet) that placed an order for 8000lbs of a new dog food they just began offering. They are cost of goods (COGs) sensitive, and want to find the optimal mix to use to make the dogfood that meets the clients' specifications. __/4 pt Complete the sentences below by circling the correct bolded word, calculating Z, and identifying the correct customer "MyT Pet MAXIMIZED PROFITS / MINIMIZED COSTS (circle or highlight one) for a total of Z= $ *** for "MxI Pet MAXIMIZED PROFITS / MINIMIZED COSTS (circle or highlight one) for a total of Z= $ for The make-up of their 4 different Proprietary Mixes is provided in Table 1, and the Certificate of Analysis they will provide with each batch order, listing the specifications they have agreed to meet, is provided in Table 2. _/5 pts Aside from non-negativity of the variables, What are the constraints? (hint: look at the sensitivity report provided). Write a short description for each constraint in the order listed in the solver report, followed by writing out the formula (don't forget to circle which type of equality/inequality) Mix 4 Table 1: Proprietary Mixes Quantities and Cost per LB Mix 1 Mix 2 Mix 3 crude protein (%) 18 25 30 crude fat (%) 25 19 15 crude fiber (%) 5 4 2 Trace minerals (%) Moisture (%) 2 1 Niacin (mg/kg) | 250.00 250.00 200.00 Cost ($) 10 .250.300.32 -Description- Variables and Coefficients what type? RHS Circle one (2 = ) 1.5 300.00 0.15 Include as many rows as relevant Table 2: Certificate of Analysis Ingredient Crude Protein Crude Fat Crude Fiber Trace Minerals Moisture Niacin Specification (per LB) 19% (min) 18% (min) 4% (max 5% (min) No more than 10% | 250 mg/kg (min) After using excel to find the solution, write your answers to the following questions in this document. Remember that each team member should attempt to use solver and turn in their own supporting excel sheet. 2 pts List each Binding constraint (by C# and name) below and explain how you came to that answer (use LP language for full credit) /4 pts Briefly Explain what each of the four different decision variables is and its final value. Make sure you provide a description. I have provided a starter for you below _2 Pts For each Non-binding constraint(s) what is the amount of slack/surplus? (use terminology from LP and/or excel e.g. write as "C# has a slack of ##") V1: verb (information related to the sign) final answer item /3 pts Write the final Z max or min formulas below: +4 pts for completed excel sheet/per person