Case Problem $1$

Workload Balancing

Digital Imaging $($DI$)$ produces color printers for both the professional and consumer markets. The DI consumer division recently introduced two new color printers. The DI$-910$ model can produce a borderless color print in approximately $37$ seconds. The more sophisticated and faster DI$-950$ can even produce a borderless color print. Financial projections show profit contributions of $$42$ for each DI$-910$ and $$87$ for each DI$-950.$

The printers are assembled, tested, and packaged at DI$$s plant located in New Bern, North Carolina. This plant is highly automated and uses two manufacturing lines to produce the printers. Line $1$ performs the assembly operation with times of $3$ minutes per DI$-910$ printer and $6$ minutes per DI$-950$ printer. Line $2$ performs both the testing and packaging operations. Times are $4$ minutes per DI$-910$ printer and $2$ minutes per DI$-950$ printer. The shorter time for the DI$-950$ printer is a result of its faster print speed. Both manufacturing lines are in operation one $8-$hour shift per day. Solve this in a excel solver