PLEASE SOLVE (B) (C) AND (D), AND USE EXCEL AND SHOW FORMULAS.(I WILL LEAVE A GOOD RATING IN RETURN)

A beverage can manufacturer makes 3 sizes of soft drink cans-Small Medium and Large. Production is limited by machine availability, with a combined maximum of 90 production hours per day, and the daily supply of metal, no more than 120 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans for each size Cans Large Medium Small Maximum 9 6 5 120 Metal (kg) batch Machines' Time (hr) batch 4.4 4.2 4 90 Profit batch $50 $45 $42 a. Develop a linear programming model to maximize profit b. Develop a spreadsheet model and find the optimal solution using Excel Solver and determine how many batches of each can size should be produced. c. If you increased the available metal supply by 1 kg, how much profit would you make? (Hint: Generate Sensitivity Report). d. If you increased the available machine time by 5 hours, how much profit would you make