Learning Goal: I’m working on a supply chain case study and need the explanation

Learning Goal: I’m working on a supply chain case study and need the explanation and answer to help me learn.
The instructions are attached. The rubric is detailed in this post. Follow the directions accordingly. Make sure to include graphs, tables, etc.
Module B – Linear Programming Applications in Marketing, Finance, and Operations Management
Case Study #4: Planning an Advertising Campaign
Grading Rubric- Make Sure to Include all portions of the Grading Rubric in the paper…identify them in Bold letters.
Define, model and solve the LP problem (40 pts)
The linear programming model ( 20 pts ) broken out as …Define your decision variables (5 pts)
Objective function (5 pts)
Constraints (5 pts)
Using the shadow price to determine the total exposure rating (5 pts)Was the additional $10K worthwhile?
Prepare a spreadsheet model ( 20 pts )Determined the optimal solution (5 pts)
Was able to validate the model results (5 pts)
Conducted the sensitivity analysis for part 2 solution, OR
Reran model to determine new optimal solution and value based on $10K increase (5 pts)
Optimized the correct objective function (maximize the exposure rating and not new customers being added) (5 pts)