Please help, and please use excel to solve the LP!

Problem 1 (35 points): Consider a five-week production planning problem. The table below gives the amount of demand you need to satisfy each week. week 1 week 2 week 3 week 4 week 5 100 190 120 210 140 The regular production capacity is 120 units per week. The inventory carrying cost is $3 per unit. The capacity limit and cost of overtime production vary by week and are given as follows: week 1 week 2 week 3 week 4 week 5 capacity 30 40 80 90 70 cost per unit 5 8 11 5 Question: Please develop a Linear Program (LP) model (write down variable definitions, the objective function, and constraints) for production planning. Solve the LP to find the optimal solution (attach your spreadsheet if you solve the problem by Excel Solver or your code if you write your own program)