Please complete the following in Excel and give simple, clear instructions on how to input everything

A manager is creating a new schedule to minimize cost.

There are two shifts that need to be covered. The cost per person working on shift 1 is $500 and the cost per person working on shift 2 is $600.

There are two offices that need to be staffed. Based on staffing requirements Office 1 needs to schedule people on both shift 1 and shift 2 and it is required to have at least 450 people working per day. Office 2 is only open during shift 2 and needs to schedule at least 100 people per day.

Each shift can have a maximum of 350 people working across both offices.

Solve using Linear Programming to determine the Minimum Cost.

The manager has then determined that more employees need to be recruited, hired, and trained. This problem then becomes nonlinear as the objective function is:

Cost=S1*400 + S2*600+S13+2*S22

Add these hiring costs to the spreadsheet and re-solve as a non-linear problem. Describe how the solution changed after adding in the hiring cost and 1 other examples of how non-linear problems are applicable to real life business situations.