Level



Monthly BudgetIn any business there will be money made (revenue) and money spent (expenses). A good business person will keep track of these two things so that they can understand how their business is doing.The goal is to have more revenue than expenses!In this task, you will be asked to keep track of these things. You will have to research the cost of each item. A good source of information about expenses is your own parents or guardians. They have been paying for things for the family for a long time.Task 1Open a new Excel file name it Revenue. Revenue comes from selling your products or services.Place the heading, Items Sold, in cell A1.Below the heading, list all of the products and services that you sell. (there should be 10 – as created in Part 2)Guess how many of each items you may have sold in a one month period and place in the next column. Use the heading, Amount Sold.In the next column, enter the Price of each item. (selling price from task 2)In the next column, calculate, the Total Amount using a formula with cell references.Calculate, using a formula with cell references, the Total Revenue, below your items.Add your name and the date to the footer.Add the sheet name to the header. Save the workbook.Task 2In this task you will be determining if your business makes money or loses money.Add another spreadsheet, sheet2. Rename it budget. This spreadsheet shows your monthly revenue as well as the costs that you will experience when you run a business. These costs are called Expenses.In cell A1, type Total Monthly Revenue. Adjust column width. Enter the number you calculated from task 1 and place in B1.In cell A3, type Monthly Expenses.Here are a list of the MONTHLY expenses I would like you to investigate (search the internet or ask your parents) and place below A3:Rent (search the internet for ‘retail monthly lease in Oshawa ontario’)Water and electricity billGas billCompany vehicle (car or truck) (one month of lease or loan payment )InternetPhone (land line)Cell PhoneEmployee Salary – you make $3000 per month (for now you are the only employee)In cells B4 to B11, enter the amounts you have investigated.Below the last expense, type Total Monthly Expenses. Calculate the total using a formula. Place beside this label.Leave a blank row.In column A, type Balance. In the next column, enter a formula to calculate the difference between the Total Monthly Revenue and the Total Monthly Expenses.Add your name and the date to the footerAdd the sheet name to the header. Save the workbook.Your are done! Print all sheets – one copy showing numbers, one copy showing formulas (remember: use ctrl+~ to display formulas)RubricNAME:______________________________Level480-100%370-79%260-69%150-59%R / I< 50%Thinking and InquiryAble to interpret instructions and put information into spreadsheet tasks accordingly Expectations are followed for all the creation of all spreadsheets. Headings are relevantUnit price seem realistic, some research was shown in this area.Formulas/functions are used properlyall criteria have been addressed to a high degreeall criteria have been addressed to a moderate degreesome criteria have been addressed to a moderate degreefew criteria have been addressed and/or in a limited capacityinsufficient evidence of required criteriaApplicationAbility to different create working spreadsheetsName and date in header/footer as requestedUses proper format when creating spreadsheets.Ability to create all aspects of a pie chart as requestedall criteria have been addressed to a high degreeall criteria have been addressed to a moderate degreesome criteria have been addressed to a moderate degreefew criteria have been addressed and/or in a limited capacityinsufficient evidence of required criteria ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download