(Solved): For each of the following problems: Formulate an LP model for this problem (Make sure your LP model ...

For each of the following problems: Formulate an LP model for this problem (Make sure your LP model includes: definitions of decision variables, an objective function, constraints, and bounds on variables.). Create a spreadsheet implementation of the LP model (Starting from an empty spreadsheet) and solve it using Solver. It is advisable to adhere to principles of good spreadsheet design. Clearly indicate the optimal solution, which constraints are binding, and the amount of slack/surplus for each constraint. Galaxy Industries Galaxy Industries would like to determine production levels for four of its toy water guns that will maximize the total profit. Galaxy wants to produce at least 100 units and at most 1000 units of each toy water gun. The following table summarizes the profits and the resources requirements. The last row provides the resources available per week.