LP Challenge Assignment A 0.00 $22 B 120.00 $15 $1,800.00 Number of units Profit Constraints: Wiring time Drilling time Assembly time Linear Program Challenge Assignment: Please refer to the lesson related to plotting a Linear Program Model using ISO and Corner Point methods. Instructions: 1. Solve the following equation using Solver in tab one. Beginning in tab two (create a new excel tab) 2. Create an Algebraic Linear Program model to solve the line of the Linear program equation using algebraic substitution, etc. 3. Plot the solutions lines for each constraint. 4. Next, create and test two ISO lines and plot to the chart. 4. Plot the corner points as dots on the chart. 5. Use the drawing tool to create the bounds of the feasible region. This is a challenge assignment, do your best. I do not expect perfection on this assignment. You will not be tested on this portion of the Linear Programming learning lessons. This is simply an exercise to make sure you understand the algebraic theory connected to Linear Programming. This, in turn, will result in a stronger overall understanding of linear program models to enrich your final group project. Do your best, you will be graded mainly on effort, not perfection. You may work as a group, if you can make this happen, remotely! Deadline: December 5th @ 11:00 p.m. 3 2 1.5 2 1 0.5 240.00