Answer this in Excel. 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