Hello. Please answer this question using EXCEL. You MUST use excel

During the next 2 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 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; during month 2, steel costs $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 in the 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 minimum total cost. How sensitive is the total cost to the 16-mpg requirement?

27 Production capacity 28 23 Constraints on steel usage 30 Month 1 Month 2 31 Steel used 32 Steel purchased 34 35 Maximum purchase 36 37 Mpg constraint Month 1 Month 2 Avg mpg obtained 40 41 Required avg mpg 42 43 Summary of costs 44 Steel cost 45 Holding cost 46 Total cost 47A E F G H J K L 1 General Cars 2 Steel usage (tons per vehicle) Steel costiton Month 1Month 2 Mpg Cars Cars Trucks Trucks Avg required -J 8 Initial inventory Cars Unit holding cost 10 Trucks 11 12 Production schedule 13 Month 1 Produc Onhand after Deman Ending 14 ed production d inventory 15 Cars 16 Trucks 17 Total vehicles 18 13 Production capacity 20 21 Month 2 Produc Onhand after Deman Ending 22 ed production d inventory 23 Cars 24 Trucks 25 Total vehicles 26 27 Production capacity 28 23 Constraints on steel usage