Problem 3 For the problem above, using the picture below write the formula for: A B D E F G 1 2 TOM'S SALSA - How much Whole Foods Sales & Mexico City Salsa 3 4 W M 5 Decision Variables 6 7 Objective (profit) 8 9 Constraints w M LHS (formula for used) Symbol RHS 10 11 12 Whole Tomatoes Tomato Sauce Tomato Paste 13 14 Non-Negativity W,M 0 15 16 Provide values and / or formulas to solve the above problem using solver: E.g. Value to be entered as: Cell E 15: 9 or Cell E 15: = E5 Formula to be entered as: Cell E6: = C6*C4 + D6*D4 a) Cell C7 b) Cell D7 c) Cell C11 d) Cell D11 e) Cell E11 f) Cell F11 g) Cell G11 h) Cell C12 i) Cell D12 j) Cell E12 k) Cell F12 1) Cell G12 m) Cell C13 n) Cell D13 o) Cell E13 p) Cell F13 q) Cell G13 Using the information from the spreadsheet template, fill in the appropriate parameters that you would set up in solver: Solver Parameters Set Objective: To: o Max Min Value Of: 0 By Changing Variable Cells: r) "Set Objective" cell is s) "By changing variable cells" cell range is Add Constraint F2 Cell Reference: Constraint: