Old MathJax webview

Please indicate answer number and also Excel Solver formulas

Simplex Method must be used

QUESTION 1/1 A company is considering manufacturing automotive and acrylic paints. Each paint contains, in varying proportions, some or of the three main raw materials essential for high quality paint. Automotive paint costs the company R35 per litre. Acrylic paint costs R20 per litre. The company would like to determine the lowest-cost combination of paints that meets the average monthly demand for each type of paint. The following table contains relevant information about the composition of automotive and acrylic paints, as well as the minimum quality batch requirement for each raw material. Solve with the Simplex Method, using Excel. i. Min Quality Automotive Acrylic Requirement R35 R20 Cost/litre Raw material Resin Solvent Pigment 10 8 2 20 6 0 180 96 3 [20] ii. ii. Generate a sensitivity analysis report [41 What is the maximum amount of Acrylic paint that the company can manufacture at high quality? 13] What is the lowest cost that the company can incur for solvent? 13] iv