Check the math on the attached spreadsheet. It is a Feasibility Model for a program for restaurants that is intended to increase the net revenue of the restaurant. Needs to be completed as soon as possible.
Restaurants that sign up for the program give a 50% discount on entrees to customers that sign up for the program. The restaurant receives $15/month for members of the program that signed up at their restaurant. The Feasibility Model calculates the change in profit for the restaurant based on joining the program.
In the Feasibility - Before Correction worksheet, check formula in row 33, compare to Row 33 in Feasibility Example worksheet. Which is more accurate (I think it is the Feasibility Example worksheet, please confirm or come up with a better formula)?
In the Feasibility Example worksheet, which formula better determines the change in Net Revenue (technically, change in EBIT) row 35 or row 45? If it is row 45, please redesign the spreadsheet to contain the correct formula and descriptions.
If you see any formulas or other areas of the spreadsheet that you think could be improved, please make the changes, and highlight and have a list of changes made.
Budget: $10 - $20