Data

Production Plan

Production Plan Chart

Sheet$3$

$\backslash$table$[[,,,],[$Input Data $($Demand$),,$Input Data $($Costs etc.$),]]$

$\backslash$table$[[$Month$,$Demand$],[$January$,1,000],[$February$,1,100],[$March$,1,000],[$April$,1,200],[$May$,1,500],[$June$,1,600],[$July$,1,600],[$August$,900],[$September$,1,100],[$October$,800],[$November$,1,400],[$December$,1,700],[,],[,]]$

$\backslash$table$[[$Item$,$Cost,$],[$Materials cost$/$unit$,20,$component costs for each cell phone$],[$Inventory holding cost$/$unit$/$month$,3\mathrm{.}0,$euros per phone per month$],[$Marginal cost of stockout$/$unit$/$month$],[$Hiring and training cost$/$worker$],[$Layoff cost$/$worker$],[$Labor hours required$/$unit$,0\mathrm{.}1667,],[$Regular time cost$/$hour$,20\mathrm{.}0,$euros per hour$],[$Over time cost$/$hour$,30\mathrm{.}0,$because $50\%$ premium for overtime$],[$Marginal subcontracting cost$/$unit$],[$Initial Workforce size,$1250,],[$Maximum overtime per worker per month,$20,$hours per month per employee$],[$Starting inventory $(\text{'}000$s$),50,$thousand units$],[$Ending inventory $(\text{'}000$s$),50,$thousand units$]]$