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.

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.

A monthly budget usually has two sections — one for income and one for _____.A.wagesB.savingsC.utilitiesD.expensesSUBMITarrow_backPREVIOUS

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

Which report/s can be produced in budgeted form?Group of answer choicesIncome statement.Balance sheet.Statement of cash flows.All of the given reports can be produced in budgeted form

A(n) budget is based on one predicted amount of sales or other activity measure.