The spreadsheet shows the monthly revenue and expenses for a new business.ABC1 MonthRevenueExpenses2 Jan400022,0003 Feb900024,0004 Mar13,00025,0005 Apr16,00027,0006 May21,00030,000Use the models to predict the month in which revenue will equal expenses. aOctober bMay cSeptember dAugust

Open a workbook on Excel and Create the type of the spreadsheet save it as ‘2024 Budget Statistics.”Jan Feb March April May June July Aug Sep Oct Nov DecSales 20000Cost of salesGross IncomeProfit /LossExpenditureSalary 8000Rent 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500Water &ElectricityFibre InternetTotal Expenses3.1.1 Merge and center “Expenditure”Using formulas calculate the following.a. Sales increase monthly by 15%b. Cost of Sale is 5.5% of Sales.c. Calculate Gross income.d. Salary will increase on the 10th Month by 6%e. Water and Electricity 5% of the salary will decrease by 2.5% in June.f. Fiber Internet 5% of the salary will increase in July by 4% and will decrease by September by 2%.g. Calculate the Total Expensesh. Calculate the profit /the loss.

The projected monthly revenue is computed by multiplying the daily income to the number of selling days in a month1 puntoTrueFalse

2.Question 2I want to create an Excel workbook to keep track of my spending by month for the year, what would be the best names to give my worksheets?1 pointJune, July, AugustSpend1, Spend2, Spend3Sheet1, Sheet2, Sheet3Budget1, Budget2, Budget3

The revenue that an apparel company earns each month for its different product lines fluctuates throughout the year. Over the course of a year, the revenue earned from clothing sales each month is modeled by function c, where x is the number of months since the beginning of the year.The revenue earned from sales of shoes and accessories each month is modeled by function s, where x is the number of months since the beginning of the year.𝑠⁡(𝑥)=0.6⁢𝑥3−10.2⁢𝑥2+32.4⁢𝑥+127.2Use this information to complete the statement.Between the 3rd and 6th months, the revenue earned from sales of shoes and accessories is at the revenue earned from sales of clothing.

You've been provided with the following information about a businessComplete a horizontal analysis for the "Revenue" account. Round the percentage change to one decimal place (1 mark).Note: Do not enter the "%" symbol when entering your answer. For example if your answer is "5.1%", only enter "5.1". Profit and loss statement Current year Prior yearRevenue 15000 10000Less Cost of sales 6500 3000Gross profit 8500 7000Less expenses Marketing Expense 2000 1800Rent Expense 1500 1500Wages Expense 800 1000Utilities Expense 1500 1500Net profit 2700 1200