This question starts with the second attachment. I don't know how to format this in excel in this linear programming problem and enter the data to use solver. The information and percents are confusing me. I sent this question off yesterday and no one replied.

`` Assignment 9 - Lined X \[` Winter 2019 Linear P X ` Linear Programming X| [ LP Product Mix using X| G homework help - GO X| FNCE 1 13 : 113 - Gra X| + X D > & https : / / learn . macewan . ca / bb cs web dav / pid - 205 5640 - dot- content- rid - 8394529 _ 7 / courses / 005214- 07- 2191 - 1 - CC07 - 71220 / Winter % 20 20 7 9 % 20 Linear % 2 . : {} Apps ! [ Office My Account ) https : / / support 2 . se ." ! You Tube [ @) Fitness Blender * How to Clean a Flat ." \} Project Wild Wands ." How to repair eyela ." No More Girly Fitne . potential loss to $150 , 000 . 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 three 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 : 25% D & https: / / learn . macewan . ca / bb cs web dav / pid - 205 5640 - at- content- rid - 8394529 _ 7 / courses / 005214- 07 - 2191- 1- CC07 - 712 20 / Winter % 20 20 1 9 % 20 Linear % 2 . : {} Apps ! [ Office My Account ) https : / / support 2 . se ." @ You Tube [ @) Fitness Blender* How to Clean a Flat ." \} Project Wild Wands ." How to repair eyela ." No More Girly Fitne . 3 The specifications of each of the four base mixes before they are blended together is : Base 1 Base 2 Base 3 Base 4 Pigment Volume 30. 0% 25. 0% 25. 0% 30. 0% Solvent Volume 48. 0% 60. 0% 67.5% 55. 0% Additive 1 Volume 10. 0% 5. 0 % 0. 0 % 5. 0% Additive 2 Volume 6 . 0 % 5 . 0% 2. 0% 10. 0% Additive 3 Volume 6. 0% 5. 0% 5.5 % 0 . 0% Unit Cost $15 $25 5 20 540 Recommend what percentage of each base mix should be included in the blend to achieve specifications listed , keeping input costs as low as possible . Base mix 3 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 3 rises to $30 per unit and note what would happen to total cost in this situation . ENG TIESA PM \\