Digital Imaging has hired your Analytics Consulting Firm (SJU Analytics) to help determine how many units of each printer they should produce to maximize profit. Construct a Simple Linear Programing Analysis using Excel SOLVER Prepare a presentation to DI’s president presenting your findings and recommendations. Digital Imaging’s Leadership team has providing the following information: 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.
Digital Imaging has hired your Analytics Consulting Firm (SJU Analytics) to help determine how many units of each printer they should produce to maximize profit. Construct a Simple Linear Programing Analysis using Excel SOLVER Prepare a presentation to DI’s president presenting your findings and recommendations. Digital Imaging’s Leadership team has providing the following information:
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
