$1.(5$pts$)$ Dell$$s call center is developing a staffing plan. The table below lists the minimum number of representatives required during each of the six four$-$hour periods in a day. Representatives work $8-$hour shifts, which can start every $4$ hours throughout the day.

$$A$.$FormulateaLinearProgramthatcanbeusedtodevelopastaffingplanthatminimizes the number of employees while meeting requirements. Clearly specify the decision variables, objective function, and constraints.

$$B$.$CreateaspreadsheetmodelforthisproblemandsolveitusingSolver$.$Whatisan optimal solution?

$2.(5$pts$)$ Air France$-$KLM will consider demand for air cargo shipments on its flights based on the left$-$over capacity. For today$$s flight from Paris to Denver, the left$-$over capacity in each of the aircraft$$s storage areas is shown in the following table: