CB$2203$ Data$-$Driven Business Modeling

Assignment $2$

Please save your files as Asm$2-xxxxxxxx.xls\frac{x}{.}pd\frac{f}{.}$docx as appropriate, where $xxxxxxxx$ is your student id number.

Question $1$

City Manufacturing has four machines for producing a particular computer chip. The production manager has to decide on the machine$($s$)$ to use for producing $1650$ units of the chip. Machine $1\text{'}$s production capacity is between $300$ and $1500$ units. Machine $2$ and$/$or Machine $3$ can be used only if Machine $1\text{'}$s production is greater than or equal to $1000$ units. Machine $4$ can be used with no restrictions and can make any number of units.

City Manufacturing has to pay a fixed cost if the machine is in operation. In addition, a variable cost per unit will be incurred.

$\backslash$table$[[$Machine$,$Fixed cost $($$$),\backslash$table$[[$Variable cost$],[$per unit $($$$)$