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. 

Instruction Files

Related Questions in business category