Please note that your Excel file should contain all the formulas that you used to get the answer

2. Mirza Manufacturing makes four electronic products, each of which comprises three main materials: magnet, wiring, 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 should receive at least the minimum demand. The material costs/unit are magnet $0.59, wire $0.29, and casing $0.31. The following table shows the number of units of each material required in each unit of end product and the production cost per unit. 1 BDA 612 Additional information is provided in the following tables. Develop an appropriate linear optimization model to maximize net profit. (35 points)