Help needed with all aspects of the question

Problem 4. The following three tables show the answer report in Excel for the LP in problem 1. The decision variables are AM: number of cases of model A manufactured BM: number of cases of model B manufactured AP: number of cases of model A purchased BP: number of cases of model B purchased Answer the following question using the answer report and sensitivity report shown below. 2Answer report Objective Cell (Min) Cell Name Original $A$7 Value objective function Final Value 0 2170 Variable Cells Cell Original Name Value Final Value Integer $A$3 AM 0 100 Contin $B$3 BM 0 60 Contin $C$3 AP 0 0 Contin SD$3 BP 0 90 Contin Constraints Cell Name Cell Value Formula Status Slack SF$1 0 100 $F$10=$G$10 Binding 0 $F$1 1 150 $F$11=$G$11 Binding O $F$1 Not 2 580 $F$12