Looking for help on this, tried a bunch but only getting numbers that aren't supposed to be the answers.

MSCI-2200 Excel Assignment 2 & 3 Instructions Fall, 2019 Assignment 2 The EJM Corp. produces 3 versions (A, B & C) of an instrument panel to install in a certain model of a customized automobile. In producing these panels it must purchase one of panel's components from one of 4 suppliers. The accompanying incomplete includes: the costs of purchasing one unit of each version from each supplier; the total number of units of each version that it needs; the total number of units that each supplier can provide; and, the minimum number of total units that EJM must order from each particular supplier if it wants to keep that supplier as a source of this component. If EJM want to minimize total purchase costs, complete this worksheet and use Solver to determine how many units of each version it should purchase from each supplier subject to the following constraints: It must purchase the number of each version that it demands It must purchase, from each particular supplier, no more than can be provided from that supplier and at least the minimum that is required from that supplier It cannot purchase any version B's from suppler 1 It must purchase at least as many total units from supplier 1 as it purchases from supplier 4 It must purchase supplier 2's capacity It must purchase at least 1000 units of versions C from supplier 3 If your problem is solved correctly, your total cost should equal $400,000 although this answer does not guarantee that your model is correctMSCI-2200 Excel Assignment 2 & 3 Instructions Fall, 2019 Assignment 2 The EJM Corp. produces 3 versions (A, B & C) of an instrument panel to install in a certain model of a customized automobile. In producing these panels it must purchase one of panel's components from one of 4 suppliers. The accompanying incomplete includes: the costs of purchasing one unit of each version from each supplier; the total number of units of each version that it needs; the total number of units that each supplier can provide; and, the minimum number of total units that EJM must order from each particular supplier if it wants to keep that supplier as a source of this component. If EJM want to minimize total purchase costs, complete this worksheet and use Solver to determine how many units of each version it should purchase from each supplier subject to the following constraints: It must purchase the number of each version that it demands It must purchase, from each particular supplier, no more than can be provided from that supplier and at least the minimum that is required from that supplier It cannot purchase any version B's from suppler 1 It must purchase at least as many total units from supplier 1 as it purchases from supplier 4 It must purchase supplier 2's capacity It must purchase at least 1000 units of versions C from supplier 3 If your problem is solved correctly, your total cost should equal $400,000 although this answer does not guarantee that your model is correct\f