SOLVER 7 Problems: Nonlinear Problems Frigid Air company produces three different types of industrial refrigerators; A, B and C. The production capacity of the plant is 1000 units per week. Sales department calculates the unit prices for these products as follows, A= $1000, B= $1200, C=$1500. The manufacturing costs for these products are calculated by the following formulas: For A= 200A + A2 For B = 250B + B2 For C = 350C + C2 How should the production be allocated in order to maximize profit? (Hint: Production numbers should be integers)
PLEASE DO THIS IN EXCEL AND SOLVER AND SEND IT TO ME IN FILE.