Three types of appliances, A, B, and C, can be manufactured on one of two machines, 1 and 2. The variable costs (that is, per unit cost) of each appliance on each machine are:___________
a. 138 on Machine 1,211 on Machine 2
B: 10 on Machine 1,127 on Machine 2
C: 264 on Machine 1,6075 on Machine 2

There is an initial setup cost (fixed cost) to make each appliance on each machine. (Each fixed cost is incurred at most once, and it is incurred only if one or more of that appliance type is made on that machine):
a ________. 5290 on Machine 1,60 on Machine 2
B: 264 on Machine 1,6075 on Machine 2
C:

The time (in hours) required to make each appliance on each machine:
a ________. 0.4 hours on Machine 1, 0.9 hours on Machine 2
B: 1.1 hours on Machine 1, 1.2 hours on Machine 2
C: 1.3 hours on Machine 1,

We have to make 4 of appliance A, 9 of appliance B, and 5 of appliance C for a customer order. We can use Machine 1 for up to 10 hours and Machine 2 for up to 7 hours.

Formulate an ILP problem that models this situation. Set it up in Excel and use solver to find the optimal solution. What is the minimum cost to make the necessary numbers of appliances?