Please answer the question in excel format, thanks

Apply the best practice of Excel modeling (i.e. flexibility and readability) to develop an Excel model [10 marks for the problem below]: 1. Use meaningful headings for the decision variables and outputs/constraints; 2. Clearly indicate the decision variables using red-colored border or yellow-colored background; 3. Avoid hard coding. Problem description: Frank is running a face mask production shop in Hong Kong. Frank decided to rent instead of buying production machines. It costs $50,000 to rent one machine for a month, and it cost $4 for one face mask made. Other costs of running the shop amount to $300,000 per month. Frank sells $7 per face mask, and the shop operates 24 days per month. Each production machine can make up to 1,000,000 face masks per month. You are required to do the following: 1. [10 marks] Define range names for all the inputs in the file Assignmen1.xlsx and paste the range names in the worksheet. 2. [40 marks] Construct a model to calculate the monthly profit for any number of face mask production machines rented and with any value of daily demand. 3. [20 marks] For 1 to 5 machines rented and daily demands of 2,000 to 10,000 in increments of 2,000, use an appropriate Excel tool to find the monthly profit and then use conditional formatting to highlight the monthly profits that are positive. 4. [10 marks) If Frank rents 4 machines, what daily demand will allow him to break even? [Note: The answer does not have to be an integer value.] 5. [10 marks] Plot a line chart with markers to show the monthly profit as a function of the number of machines for a daily demand of 2,000 masks, and for a daily demand of 10,000 masks. [Note: Plot both functions in the same chart; show the chart title, axis titles, legend names (2,000 and 10,000 demands), move x-axis to the bottom of the chart.] Apply the best practice of Excel modeling (i.e. flexibility and readability) to develop an Excel model [10 marks for the problem below]: 1. Use meaningful headings for the decision variables and outputs/constraints; 2. Clearly indicate the decision variables using red-colored border or yellow-colored background; 3. Avoid hard coding. Problem description: Frank is running a face mask production shop in Hong Kong. Frank decided to rent instead of buying production machines. It costs $50,000 to rent one machine for a month, and it cost $4 for one face mask made. Other costs of running the shop amount to $300,000 per month. Frank sells $7 per face mask, and the shop operates 24 days per month. Each production machine can make up to 1,000,000 face masks per month. You are required to do the following: 1. [10 marks] Define range names for all the inputs in the file Assignmen1.xlsx and paste the range names in the worksheet. 2. [40 marks] Construct a model to calculate the monthly profit for any number of face mask production machines rented and with any value of daily demand. 3. [20 marks] For 1 to 5 machines rented and daily demands of 2,000 to 10,000 in increments of 2,000, use an appropriate Excel tool to find the monthly profit and then use conditional formatting to highlight the monthly profits that are positive. 4. [10 marks) If Frank rents 4 machines, what daily demand will allow him to break even? [Note: The answer does not have to be an integer value.] 5. [10 marks] Plot a line chart with markers to show the monthly profit as a function of the number of machines for a daily demand of 2,000 masks, and for a daily demand of 10,000 masks. [Note: Plot both functions in the same chart; show the chart title, axis titles, legend names (2,000 and 10,000 demands), move x-axis to the bottom of the chart.]