PLEASE SOLVE IN EXEL IF DON'T PLEASE DO NOT SOLVE IF SOLVE SURELY DOWNVOTE

Pesola Company makes several different Solar Panel products at their manufacturing faculty. The demand for their Solar panel Model Y product during the next four months is given in the table below. Additionally, production costs and production capacity of each month is given:

Pesola accounting dept calculated an inventory carrying cost of $1.50 per month for each unit of the solar panel Model Y and has a beginning inventory of 120 units. To maintain a stable work force level, the company wants to ensure that at least 400 units is produced each month. They also have a policy of maintaining a safety stock of 50 units per month. Pesola want to determine how many of the solar panels Model Y to manufacture during each of the next four months to meet the demand at the min cost.

Month

1 2 3 4

Demand 420 580 310 540

Production Cost $48 $44 $45 $46

Production Capacity 500 520 450 550

1. Draw a network flow model for this problem.
2. Create a spreadsheet model for this problem. And solve it using Solver.
3. What is the optimal Solution?
4. How much money could Pesola save if they were willing to drop the restriction about producing at least 400 units per month?