Question $5.(20$ pts$)$

The production manager of Videotechnics Company is attempting to determine the upcoming $5-$month production schedule for video recorders. Past production records indicate that $2,000$ recorders can be produced per month. An additional $600$ recorders can be produced monthly on an overtime basis. Unit cost is $$10$ for recorders produced during regular working hours and $$15$ for those produced on an overtime basis. Contracted sales per month are shown as in Table $5.$ Inventory carrying costs are $$2$ per recorder per month. The manager does not want any inventory carried over past the filth month. The manager wants to know the monthly production that will minimize total production and inventory costs. The Excel Solver solution for this problem is displayed in Figure $2.$ Please review the screenshot and answer the questions provided on Page $7.$

$\backslash$table$[[$Month$,$Contracted Sales$],[1,1,200],[2,2,100],[3,2,400],[4,3,000],[5,4,000]]$

Table $5$: Contracted sales per month

$5853585750535057$

Subject to the Constraints.

$383358550135Cs$

$30535057<mn>5</mn><mn>8</mn><mn>3</mn><mn>3</mn><mn>5</mn><mn>5</mn><mn>8</mn>$

$5453-5456453156$

$5458=557$

Nod

Clang

Thet