Data File needed for this exercise: None Durham Electronics Corporation primarily manufactures four highly technical products, which it supplies to aerospace firms that hold NASA contracts.
business
Description
This assignment should be completed individually. We take academic integrity seriously. Any student found to be involved in plagiarism or cheating will be penalized in accordance with the Ontario Tech University Calendar, Section 5.15.
To assert that you have not given or received, or used unauthorized assistance, write the following
pledge in the comment textbox when you submit your files through Canvas system.
1. Durham Electronics
Data File needed for this exercise: None
Durham Electronics Corporation primarily manufactures four highly technical products, which it supplies
to aerospace firms that hold NASA contracts. Each of the products must pass through the following
departments before they are shipped: wiring, drilling, assembly, and inspection. The time requirements in
each department (in hours) for each unit produced and its corresponding profit value are summarized in
the table below:
The production manager has the responsibility of specifying production levels for each product for the
coming month. Using Excel Solver, determine how many of each product the company should produce to
maximize profit. Be sure to select Keep the Solver Solution and generate Answer report.
