i already begun with the sheets (Startup costs, and assumptions) i need to you continue with the excel sheet and show me the formulas.

In this project you will pick a topic of your choice (it is better to choose a realistic one). After choosing your topic, you have to conduct a lot of research and data gathering. The main aim of this project is to model all the data in an Excel workbook and in conducting the needed calculations and processing, and in decision making. Your workbook will be composed of at least one assumption sheet, at least three sheets to do computations and analysis, and a summary sheet. The provided example is a previous case study to make things easier for you. Your task is to come up with a new idea and build it using a similar process to the one presented below. For instance, suppose you need to open a fashion shop, but you are not sure about the scale and best location for your new project. You are considering three different sites: 1- In a busy city downtown that is the center of many large businesses, and house of many events. 2. Inside a mall that is the attraction of customers from all ages and in all seasons. 3- On a smaller scale, in his hometown village. Same as in this example, your duty is to do some research to be able to find some estimates about the various costs and revenues to make a study about the expected net profits in five years, and to decide accordingly how to proceed. You will design a workbook to compare the net profits returned in each of the three locations. For example, after studying the three perspective shops, we were able to put a detailed estimate on the start-up costs as shown in Figure 1. Figure 1: Start-Up Costs After setting up the start-up costs, on a new sheet you have to create the assumptions about expenses (Fixed Costs - Variable Costs). It is preferable to have different tables that will be column-based and rowbased (so when you retrieve information from them you will use VLOOKUP, HLOOKUP, INDEX/MATCH). In this example, the fixed costs are rent, electricity, insurance, etc. as shown in in Figure 2 Figure 2: Fixed Costs The variable costs are like the advertisement, the item supplies, the employees bonus, and some renovations and maintenance as shown in Figure 3. Variable Costs (as percentage from sales) Figure 3: Varioble Costs So, to this point we have filled in two sheets: the startup cost and another sheet containing the fixed and variable costs. In your case you might not include a startup cost since the topic might not require having any startup costs; however, in this presented example we were obliged to have a set of startup costs since these numbers will be used later for decision making and picking up the most appropriate location to open the fashion shop. In your project you might have a totally different organization of the assumptions; however, it is preferable to include fixed and variable costs that will be directly linked to your topic. After completing the assumption phase, your task is to make some calculations in order to have a clear vision and choose the right decision. For instance, in the discussed example, we will have three different excel sheets for the three different locations: City, Mall, Village. You can calculate the total expenses, total revenues, and net profit throughout five years, for each of the three chosen locations. One worksheet will be created for each location. However, the three sheets will follow the same template. The template can be designed as shown in figure 4 : Figure 4 shows the five-year projection for the City. This sheet has to be filled out with the needed functions/formulas (statistical, lookups, logical, etc.) using the startup and assumptions sheets already done before. Once this sheet is completed, you have to make two copies of it: one for Mall and one for Village. In these sheets you don't have to repeat all the functions/formulas again, however, you have to simply change the shop location from City to Village for example and all the data should be automatically updated with respect to the new added location. Your task is to have different excel sheets which can have the same template and will be updated the moment you are going to change one instance. Another task is to define the set of functions and formulas you are going to use. For instance, you need to do some research in order to know how the fixed and variable costs will be used in the computation process with regard to your topic. The last phase is to create a summary sheet which will summarize and compare the results of the previous sheets you have already completed alongside a graphical representation as shown in Figure 5. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Toeil FiendConth & Is & & is. & senacos & Is & \\ \hline Totel Coth & 13 & & 51 & & 3 & spiting \\ \hline Hetuecons & 11 & - & 11 & & 11 & \\ \hline & 15. & - & Is & & & lnx11 \\ \hline \end{tabular} Figure 5: Summary On a word document: - Explain the reason behind choosing your topic. - Elaborate on the set of assumptions you are going to use (preferable to use screenshots from the excel part). - Describe the way you will do your computational part. - Add any set of functions/formulas that you think will be suitable for the analysis. - Detailed analysis of the project and what is your final decision. The provided example is a sample of a previous case study. You can use the same format; however, you have to pick a totally different topic, set of fixed and variable costs, etc. Your project might be organized in a totally different way and still be correct as long as you employ the needed skills we have taken in class (from functions, graphical representation, etc.) to be able to model all the data, do the needed calculations in order to analyze and pick the right decision. Variable Costs