Pick any two problems of your interest Solve them in a single Excel workbook You will follow the following steps to find the optimal solution a Define Decision Variable b Formulate the Objective Function c Formulate the Constraints d Solve the problem using Solver c Interpret the result In order to ensure optimal health (and thus accurate test results), a lab technician needs to feed the rabbits a daily diet containing a minimum of 24 grams (g) of fat, 36 g of carbohydrates, and 4 g of protein But the rabbits should be fed no more than five ounces of food a day Rather than order rabbit food that is custom blended, it is cheaper to order Food X and Food Y, and blend them for an optimal mix Food X contains 8 g of fat, 12 g of carbohydrates, and 2 g of protein per ounce, and costs $0 20 per ounce Food Y contains 12 g of fat, 12 g of carbohydrates, and 1 g of protein per ounce, at a cost of $0 30 per ounce What is the optimal blend You have $12,000 to invest, and three different funds from which to choose The municipal bond fund has a 7 return, the local bank's CDs have an 8 return, and the high risk account has an expected (hoped for) 12 return To minimize risk, you decide not to invest any more than $2,000 in the high risk account For tax reasons, you need to invest at least three times as much in the municipal bonds as in the bank CDs Assuming the year end yields are as expected, what are the optimal investment amounts A building supply has two locations in town The office receives orders from two customers, each requiring 3 4 inch plywood Customer A needs fifty sheets and Customer B needs seventy sheets The warehouse on the east side of town has eighty sheets in stock the west side warehouse has forty five sheets in stock Delivery costs per sheet are as follows $0 50 from the eastern warehouse to Customer A, $0 60 from the eastern warehouse to Customer B, $0 40 from the western warehouse to Customer A, and $0 55 from the western warehouse to Customer B Find the shipping arrangement which minimizes costs

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Mar 25, 2024

Pick any two problems of your interest. Solve them in a single Excel workbook. You will follow the following steps to find the optimal solution.

Pick any two problems of your interest. Solve them in a single Excel workbook. You will follow the following steps to find the optimal solution.

a. Define Decision Variable

b. Formulate the Objective Function

c. Formulate the Constraints.

d. Solve the problem using Solver.

c. Interpret the result.

In order to ensure optimal health (and thus accurate test results), a lab technician needs to feed the rabbits a daily diet containing a minimum of 24 grams (g) of fat, 36 g of carbohydrates, and 4 g of protein. But the rabbits should be fed no more than five ounces of food a day. Rather than order rabbit food that is custom-blended, it is cheaper to order Food X and Food Y, and blend them for an optimal mix. Food X contains 8 g of fat, 12 g of carbohydrates, and 2 g of protein per ounce, and costs $0.20 per ounce. Food Y contains 12 g of fat, 12 g of carbohydrates, and 1 g of protein per ounce, at a cost of $0.30 per ounce. What is the optimal blend?
You have $12,000 to invest, and three different funds from which to choose. The municipal bond fund has a 7% return, the local bank's CDs have an 8% return, and the high-risk account has an expected (hoped-for) 12% return. To minimize risk, you decide not to invest any more than $2,000 in the high-risk account. For tax reasons, you need to invest at least three times as much in the municipal bonds as in the bank CDs. Assuming the year-end yields are as expected, what are the optimal investment amounts?
A building supply has two locations in town. The office receives orders from two customers, each requiring 3/4-inch plywood. Customer A needs fifty sheets and Customer B needs seventy sheets. The warehouse on the east side of town has eighty sheets in stock; the west-side warehouse has forty-five sheets in stock. Delivery costs per sheet are as follows: $0.50 from the eastern warehouse to Customer A, $0.60 from the eastern warehouse to Customer B, $0.40 from the western warehouse to Customer A, and $0.55 from the western warehouse to Customer B. Find the shipping arrangement which minimizes costs.