Question: 3.1 a) Open a workbook on Excel and Create the type of the spreadsheet save it as '2024 Budget Statistics. Jan Feb March April

3.1 a) Open a workbook on Excel and Create the type of

3.1 a) 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 Dec Sales 20000 Cost of sales Gross Income Profit/Loss Expenditure Salary 8000 Rent 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 1500 Water & Electricity Fibre Internet Total Expenses 3.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 Expenses h. Calculate the profit /the loss. 3.1.2 Create Chart based on the sales from January to Dec namely '2024 SALES'. 3.1.3 Insert the header using your Name, Surname, ITS number.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

(Expected rate of return and risk) Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as...

Aerielle asks her stockbroker to purchase 100 shares of Publix Super Markets, Inc., but he advises her that he cannot do so because Publix is structured as what kind of company?

Project S costs $2,563 up front, and its expected net cash inflows are $817 per year for 8 years (with the first inflow occurring one year from today). If the WACC is 13%, the project's NPV is $...

Open a workbook on Excel and Create the type of the spreadsheet save it as 2 0 2 4 Budget Statistics. QUESTION 3 PRACTICALS MICROSOFT EXCEL / SPREEDSHEET ( 3 0 MARKS ) Jan Feb March April May June...

Hello, I have attached the document with the questions, it named Quiz 5. Each tab has one question. All questions need to be developed in excel and must contain formulas, except for theory questions....

Case Questions: Be Our Guest, Inc. 1. A. Reformat the income statement to clearly indicate EBITDA and EBIT. B. See footnote A Exhibit 3. Remove from "Other General and Administrative Expenses the...

I need help with this project, please. Microsoft Excel Project Purpose The purpose of this assignment is for students to demonstrate proficiency in Microsoft Excel by creating a spreadsheet that will...

----- Please write down the formulas------ MAVERICK LODGE EXCEL PROJECT (20 POINTS) Maverick Lodge is a family-run lodge in Orlando, Florida, situated near Disney World. The lodge went bankrupt in...

Use Excel worksheet Q40-41, also shown below. It is demand for apples at Big Apple Farms. Demand (1000s) Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 1 14.2 7.5 5.9 16.7 44.3 2 16.4 9.7 7 17.8...

Assortative mating is a nonrandom mating pattern where individuals with similar genotypes and/or phenotypes mate with one another more frequently than what would be expected under a random mating...

The recent Democratic and Republican presidential state primary elections were highlighted by the difference in the way winning candidates were awarded delegates. In Republican states, the winner is...

9. [X (R F)] [(X R) F] Use truth tables to determine whether the following symbolized statements are tautologous, self-contradictory, or contingent.

In the current year, 2006, Katrina's Kids (KK) anticipates a surplus of $1,100,000 based upon sales of $6,480,000. Given a very successful first year with little effort, key members of the management...

The accounts and related balances of EOC Corp. at June 30, 2020 are arranged in no particular order: Required 1. Prepare the companys classified balance sheet in report format at June 30, 2020. 2....

Why do the liquid junctions potentials 0.1 M HCl | 0.1 M KCl and 0.1 M NaOH | 0.1 M KCl have opposite signs in Table 15-2? Why is the junction potential for 0.1 M NaOH | 0.1 M KCl so much more...

Welland Fabricating borrowed $38,000 at 8% compounded quarterly to purchase a new piece of machinery. Payments of $4000 are made at the end of every quarter. a. Calculate the balance at the end of...

Contrast naked and covered call option writing.

6 Theory of Machines 5. A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and...

The width of a 95% confidence interval for is 10 units. If everything else stays the same, how wide would a 90% confidence interval be for ?

Consider the situation in problem 2-79. Three consumers are chosen randomly from among a group of potential buyers of the high-performance automobile. What is the probability that all three of them...

Thirty-eight percent of all shoppers at a large department store are holders of the store's charge card. If a random sample of 100 shoppers is taken, what is the probability that at least 30 of them...

What is an externality?

How can social, political, and economic elements be incorporated into a biophysical analysis?

Can you explain the apparent paradox that one can use complex mathematics only on a rather simple model?