Please answer using EXCEL:

During the next two months General Cars must meet (on time) the following demands for trucks and cars: Month 1, 400 trucks and 800 cars; Month 2, 300 trucks and 300 cars. During each month, at most 1000 vehicles (trucks and cars) can be produced. Each truck uses 2 tons of steel and each car uses 1 ton of steel. During month 1, steel costs $400 per ton and during month 2 steel cost $600 per ton. At most, 2500 tons of steel can be purchased each month. Steel can be used only during the month in which it is purchased. At the beginning of month 1, 100 trucks and 200 cars are available in inventory. At the end of each month, a holding cost of $150 per vehicle is assessed. Each car gets 20 mpg and each truck gets 10 mpg. During each month, the vehicles produced by the company must average at least 16 mpg. Determine how to meet the demand and mileage requirements at a minimum total cost. Solve this problem using excel solver.

Q1A)

Maximum Profit

?