Question: use excel to solve the problem Mirza Manufacturing makes four electronic products, each of which comprises three main materials: magnet, wire, and casing. The products



use excel to solve the problem
Mirza Manufacturing makes four electronic products, each of which comprises three main materials: magnet, wire, and casing. The products are shipped to three distribution centers in North America, Europe, and Asia. Marketing has specified that no location should receive more than the maximum demand and that each location should receive at least the minimum demand. The material costs per unit are magnet-- $0.58, wire-- $0.28, and casing-- $0.30. The following tables show all of the production information, including the number of units of each material required in each unit. Develop and solve an appropriate linear optimization model to maximize net profit. Click here to view the production data. Click here to view the demand and price data. Click here to view the available raw material data. Production Data Complete the table belc (Round to the nearest v Use the model to calculate the maximum profit. Maximum Profit =$[ (Round to the nearest cent as needed.) Demand and Unit Price Data Available Raw Material Data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
