PLEASE DO AS SOON AS POSSIBLE IN EXCEL, PLEASE DO NOT FORGET TO PASTE SCREENSHOT OF THE EXCEL.

PLEASE DO THE FOLLOWING ABOVE QUESTION ON EXCEL SHEET NEED URGENT HELP ON EXCEL. I DO NOT NEED ANY EXPLANATION. NEED ONLY EXCEL SCREENSHOT SOLVED WITH DATA SOLVER. YOU WILL GET THUMBS DOWN IF YOU DON'T UPLOAD THE EXCEL SCREENSHOT.

(See Below How To Paste The Excel SHEET Screenshot for the Above Question):

4. Reconsider the third question. Upon a more thorough examination of the costs and revenues associated with producing airplanes for each customer in the third problem, it has been determined that the potential profits cannot be accurately represented using just a start-up cost and a constant net revenue per airplane produced. Instead, the profits associated with each customer are presented in the table below: (a) Formulate a BIP model for this problem. (b) Use Excel solver to solve the model formulated in part (a). What is the optimal number of airplanes produced for each customer? Note: Question 4 is a new problem. The constraints in question 3 will not be included in the mathematical model in question 4. Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth