REQUIREMENTS You are required to create on the 1" spreadsheet (Commissions) a spreadsheet-based decision support model that allows the CEO of Victory Holdings Group of Companies to understand how the economic climate will affect the revenue earned at Victory Realty to compare different scenarios (e.g. Varying percentages collected from owners: 79%, 9%, 11% for the 1: $200,000; the 2.2% is fixed for all scenarios). Rather than having a separate model for each scenario, you are expected to design a single model and employ "scenarios" to change only those aspects of the model that varies with the scenarios being considered. At the same time, he is able to use the same workbook to forecast income for his group of companies. Use advanced M5 Excel built-in functions (IF, HLOOKUP, VLOOKUP, etc.) in your spreadsheet wherever you see fits. Also use pivot tables to organise Realtor's commission by month with total commission for the first half of the year for each realtor. Also in another separate pivot table, organise your data to reflect the net profit by house and by month