please help wuth my Linear Programming Assignment

1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a \& b below). This is especially important to show how you used solver. 2. One Excel Spreadsheet with clearly labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this into three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, and 3) Constraints Equations. This should go in the appendix of your memo. (6 marks for each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks for each issue) c. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in a single report). ( 2 marks for each issue). See the basic structure of the report and memo on pages 5&6. d. General organization and formatting 4 marks. Decision 3: Operations - Materials Blending Richelieu Specialty Paints has begun making paints for the interior design market. The company starts the process by blending four base paint mixes that they buy from major manufacturers. They then add other components to finish off the paint mix to customer specifications. Each of the four base mixes includes pigment, solvent, and two additives. When Richelieu blends the four base mixes they want the final product to be within these specifications (these numbers are a percentage of total volume): - Pigment: 26%x32% - Solvent: 59%x66% - Additive 1:3\% x5% - Additive 2: 5%x7% The specifications of each of the four base mixes before they are blended are: Recommend what percentage of each base mix should be included in the blend to achleve the specifications listed, keeping input costs as low as possible. Base mix 2 is purchased overseas and thus the price fluctuates due to currency exchange rates. Comment on how the percentage of each base included in the blend would change if the cost for mix 2 rises by 22% and note what would happen to the total cost in this situation. (instructor's note: you do not need units of volume, use the percentages) 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a \& b below). This is especially important to show how you used solver. 2. One Excel Spreadsheet with clearly labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this into three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, and 3) Constraints Equations. This should go in the appendix of your memo. (6 marks for each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks for each issue) c. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in a single report). ( 2 marks for each issue). See the basic structure of the report and memo on pages 5&6. d. General organization and formatting 4 marks. Decision 3: Operations - Materials Blending Richelieu Specialty Paints has begun making paints for the interior design market. The company starts the process by blending four base paint mixes that they buy from major manufacturers. They then add other components to finish off the paint mix to customer specifications. Each of the four base mixes includes pigment, solvent, and two additives. When Richelieu blends the four base mixes they want the final product to be within these specifications (these numbers are a percentage of total volume): - Pigment: 26%x32% - Solvent: 59%x66% - Additive 1:3\% x5% - Additive 2: 5%x7% The specifications of each of the four base mixes before they are blended are: Recommend what percentage of each base mix should be included in the blend to achleve the specifications listed, keeping input costs as low as possible. Base mix 2 is purchased overseas and thus the price fluctuates due to currency exchange rates. Comment on how the percentage of each base included in the blend would change if the cost for mix 2 rises by 22% and note what would happen to the total cost in this situation. (instructor's note: you do not need units of volume, use the percentages)