Linear Programming - Microsoft Excel Solver [1.5 mark] Company A produces a pill that is a mixture of four vitamins: A, B, C and D. The costs for A, B, C and D are $1, $2, $3 and $4 respectively. Your supervisor gives you a set of constraints and ask you to identify the minimum cost to produce this pill. Constraint (1): Raw material 1 B + 2 C + 2 D >= 100 Constraint (2): Machinery 2 A + D >= 30 Constraints(3)-(6): A, B, C and D >= 0 a. Use Microsoft Excel Solver to generate the output (both Answer and Sensitivity Reports) and screen capture them to your Word file. b. Write down the optimal solution c. Write down the minimum cost of the pill d. Constraint (1) shows the minimum requirement for a certain combination of B, C and D. The current minimum requirement is 100. If this minimum requirement is changed from 100 to 250, what is the new cost?