Please answer question (d) Thank You!

The following are the costs incurred on the center for putting on this event: Rental cost for the auditorium: $1000 for up to 150 "total registered", but $4000 for more than 150 "total registered" Registration Processing: $8.50 per person "registered" Speaker Costs: 3@$500$1,500 Continental Breakfast: $4.00 per person "registered" if catered for 120 registered people or less, $480 total (not per person any more) for more than 120 registered people Lunch: $7.00 per person "registered" if catered for 120 people registered or less, $6.00 per person registered if catered for more than 120 people registered Parking: $5.00 per person "attended" calculations, make sure that you are referring to the above 6 cells as needed. Hint: Some of the calculations of total cost components require using IF function. What would be the total profit if the center sells 127 tickets to non-members instead? (Round your answer to 2 decimal places) make sure that your formulas in part (a) are correctly linked to the cells containing numbers such as the number of registered members and non-members) What would be the profit if the above best number of non-member tickets were sold? , attendees becomes fractional, these numbers represent average number of people attended. If required, round your answer to two decimal places. What would be the total profit if the center sells 127 tickets to non-members instead? (Round your answer to 2 decimal places) What would be the profit if the above best number of non-member tickets were sold