please solve using excel solver

Widget company makes 18 models of widgets. There are 3 material choices (call them MI, M2 and M3): 2 choices of power (call them P1 and P2); and three colors (call them C1, C2 and C3). The 18 models and the parts that make them up are shown below and included in the data table. Production ci C2 C3 P2 1 MI 1 1 1 1 1 1 M2 M3 Pl 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 To explain the table, widget model 1 is made from purts MI, PI and Ci. This week, ABC Widget has orders for the following Demand Production 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 2 2 4 5 2 2 3 4 3 4 2 1 0 2 3 2 3 The supply department reports the following inventory of parts- Part MI M2 M3 P1 P2 C1 C2 C3 Inventory | 16 22 10 12 14 10 15 15 Based on the available parts, what is the maximum number of orders that ABC can fill. (do not exceed the demand for any widget) If the profit for each model is as shown in this table, what is the production that maximizes the profit, doesn't exceed demands and only uses the same parts inventory. Production Profit (dollars) 1 2 12 3 13 4 9 5 10 11 7 12 14 16 10 8 11 9 12 10 13 7 14 8 15 9 16 12 17 13 18 14 6 8 9