TESM E104 Draft Budget Assignment You will be assembling a draft budget for the SHRM (Society for Human Resources Management) annual conference and expo. It's understood you don't know 100% of the info for a FINAL budget. The event will be in Chicago June 20-23, 2021. It's an event for industry professionals drawing 15,000+ people globally. It has education sessions, trade show, networking events, and special events. Become aware of the offerings/elements: https:[(annual.shrm.org[ Your draft budget must meet the following requirements: / J '/ \\\\ Excel file with only the one worksheet, named 2021 Budget on the tab All info within one 8.5x11 page with one-inch margins print ready It should contain AT LEAST three columns with the following titles and formats: / Budget Item {text format) / Budget Amount (currency format with two decimal places) v' Percentage of Total (percentage format with one decimal place) Freeze the row that contains the column names Budget Section One Revenue, should include: Title of Revenue on first row At least 4 types of revenue, one on each row, in the Budget Item column Each type of revenue should have a made up dollar amount, in the Budget Amount column Each type of revenue should also have a percentage of total revenue, in the Percentage of Total column, this cell must include a formula for the calculation A row titled Total Revenue where the budget amounts of the revenue rows are totaled, this cell must contain a formula for SUM Budget Section Two Variable Expenses, should include: Title of Variable Expenses on first row At least 2 types of variable expenses, one on each row, in the Budget Item Column Each type of variable expense should have a made up dollar amount, in the Budget Amount column Each type of variable expense should also have a percentage of TOTAL EXPENSES, in the Percentage of Total column, this cell must include a formula for the calculation V' A row titled Total Variable Expenses where the budget amounts of the variable expense rows are totaled, this cell must contain a formula for SUM Budget Section Three Fixed Expenses, should include: i!\" Title of Fixed Expenses in first row i!\" At least 10 types of fixed expenses, one on each row, in the Budget Item Column v' Each type of fixed expense should have a made up dollar amount, in the Budget Amount column V' Each type of fixed expense should also have a percentage of TOTAL EXPENSES, in the Percentage of Total column, this cell must include a formula for the calculation V' A row titled Total Fixed Expenses where the budget amounts of the variable expense rows are totaled, this cell must contain a formula for SUM Budget Section Four Total Expenses, should include: i!\" A row titled Total Expenses in the Budget Item Column y\" In this row, in the Budget Amount Column, the budget amounts of total variable expenses AND total fixed expenses are totaled, this cell must contain a formula for SUM Budget Section Five Net Income/Loss, should include: / A row titled Net Income/Loss in the Budget Item Column / In this row, in the Budget Amount column, the cell should contain the formula to calculate net income/loss in dollars V' In this row, in the Percentage of Total column, the cell should contain the formula to calculate profit margin in a percentage (net income/loss divided by total revenue} \\'\\'\\'\\ "\\ \\'\\'\\'\\