BISM7202 Excel Assignment Specification Essay

Prior Familiarity

This assignment required you to create a professional business application using Microsoft Excel 2016 / Microsoft Excel 365. The purpose of this assignment is to test the student’s ability to operate and manage business data in spreadsheets. The assignment requires no prior technical background. Moreover, it is designed for business student in general to appreciate basic IS applications.

Prior familiarity with the software tool could be beneficial but will not guarantee a significant advantage or higher marks. Through tutorials, students are exposed to practical exercises like those in the assignment and develop the skills to manage business data in Excel and use these skills to complete this assignment It is essential that students carry out the required readings and preparation for each tutorial before attending/attempting each tutorial and this assignment. The assignment is worth 30% of your grade in this course.

This is an individual assignment – group work or any collaboration on the assignment is not permitted. This assignment consists of several tasks to be completed in Excel. 2 Templates The Excel template of the expected worksheets are available on the BISM7202 Blackboard site. The Excel template provided must be used as the basis for the assignment. You may change the visual formatting (colour, fonts, data format presentation, etc) to provide a professional finished product, but nothing else (e.g. its structure except when you are asked to do so).

3 Your Task This assignment requires you to complete an Excel workbook file using Microsoft Excel 2016 / Microsoft Excel 365 based on the specification in this document. The Excel workbook contains several sheets you should develop.

4 Background and Scenario Sunshine is a childcare centre located in Brisbane. It provides childcare for children aged between 0 and 6 years old. The Director, Claudia Philip, has asked you to improve their information system for managing their employees, families and children. She has provided you with a sample of the business files. She would like you to complete the workbook along with developing a future planning sheet for the following year and an investment portfolio.

5 Documentation Sheet First enter your details: Student name and student number. In addition, list any assumptions that you have made when you developed your assignment. The assumptions allow examiners to understand your work in context. If you do not make any assumptions, please leave the section empty. Assumptions to be considered when marking must be logical. BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page | 2 6 Constants This sheet contains all the lookup tables that you will need to use in the assignment. When using lookup tables in your formulas, please make sure they are accessed using appropriate named ranges.

Task Description

6.1 Annual Tax Table Tax is withheld using the following tax rates for 2017-18. This information has been entered for you in the Constants Sheet. Table 1: Australian Taxable Income Table for 2017-18 Taxable Income Tax on this Income $0 - $18,200 Nil $18,201 - $37,000 19c for each $1 over $18,200 $37,001 - $87,000 $3,572 plus 32.5c for each $1 over $37,000 $87,001 - $180,000 $19,822 plus 37c for each $1 over $87,000 $180,001 and over $54,232 plus 45c for each $1 over $180,000 6.2 HELP Repayment Table Employees with HELP debts have income withheld based on the following repayment rates for 2017-18. The income withheld is calculated based on their total taxable income. This information has been entered for you in the Constants Sheet. Table 2: Help Repayment Rates for 2017-18 Taxable Income Repayment Rate Below $55,874 Nil $55,874 - $62,238 4.0% $62,239 - $68,602 4.5% $68,603 - $72,207 5.0% $72,208 - $77,618 5.5% $77,619 - $84,062 6.0% $84,063 - $88,486 6.5% $88,487 - $97,377 7.0% $97,378 - $103,765 7.5% $103,766 and above 8.0%

6.3 Employer Superannuation Table Employees of Sunshine are paid a different level of employer superannuation contribution depending on their position within the company. The superannuation is on top of their standard salary. The employer superannuation contribution is listed below. You are required to complete the table of information on the Constant Sheet. Table 3: Employer Superannuation Contribution Table Position Percentage Director 12.5% Deputy Director 12.0% Senior Accountant 11.5% Accountant 11.0% Chef 10.0% Assistant Chef 9.5% Child Care Leader 10.0% Child Care Worker 9.5% Junior Child Care Worker 9.5% Custodial Engineer 9.5% BISM7202 Excel Assignment Specification Semester 1, 2018 Version.

1 Feb 2018 Page | 3 6.4 Employee Superannuation Table Employees of Sunshine have collectively agreed to contribute a percentage of their post-tax annual salary to their superannuation fund based on their age at the beginning of the financial year. You are required to complete the data entry of the table in the workbook on the Constant Sheet. o Employees aged 25 and over have elected to sacrifice 2.5%. o Employees aged 35 and over have elected to sacrifice 3%. o Employees aged 45 and over have elected to sacrifice 3.5%. o Employees aged 50 and over have elected to sacrifice 5%. 6.5 Child Care Rooms Table At Sunshine, there are several different rooms that are split up into different age groups. You are required to enter the details in the workbook on the Constant Sheet.

Background and Scenario

Babies aged younger than 2 years are cared for in the Platypus Room. o Young children aged between 2 and 3 years are cared for in the Emu Room. o Children aged between 3 and 4 years are cared for in the Koala Room. o Older children aged between 4 and 5 years are cared for in the Kangaroo Room. 6.6 Family Child Care Info Families can receive several benefits and rebates from the government for having them in childcare while they work. The values for these have been entered for you in the Constant Sheet. 6.6.1 Childcare Benefit Maximum Hours Families can receive the childcare benefit for a max of 50 hours per child per week in childcare. 6.6.2 Childcare Benefit Rate Families can receive up to $0.719 per hour for each child.

The rate is paid directly to Sunshine, it is not paid to the family nor does the family pay the value of the benefit. This rate can be reduced based on benefit threshold explained below. 6.6.3 Childcare Benefit Threshold Family income under $45,114 receives full Childcare Benefit. Otherwise, family income over $45,114 per year is subject to Childcare Benefit Threshold Modifier explained below. To sum up, families can earn up to $45,114 per year before deductions will be applied to the childcare benefit rate. 6.6.4 Childcare Benefit Threshold Modifier For every dollar over the threshold value that the family earns the childcare benefit rate is reduced by $0.0000065.

To be more clear, Childcare Benefit Threshold Modifier is multiplied to the difference between family income and threshold value to reduce Childcare Benefit Rate. Detailed explanation of childcare benefits: For example, if family income is $46,114 and they have two children and they spent 90 hrs in total in childcare centre then childcare benefit will be 90 hrs *52 weeks* (0.719-(46,114-45,114) *0.0000065). Keep in mind that childcare benefit cannot be a negative value. If it is negative, it is assumed that it is 0. 6.6.5 Childcare Rebate Rate Families can receive a childcare rebate of 50% per dollar spent on annual childcare cost after childcare benefit is deducted. 6.6.6 Childcare Rebate Maximum Families can receive a rebate up to $7613 per child per year.

The rebate is paid directly to Sunshine, it is not paid to the family nor does the family pay the value of the rebate. BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page | 4 6.7 Holidays Table There are several holidays in which Sunshine is closed. During these days families are not required to pay for childcare. These days have been entered for you in the Constant Sheet. Table 4: Public Holidays in Australia during 2018 Holiday Day Holiday Date New Year's Day 1 January 18 Australia Day 26 January 18 Good Friday 30 March 18 Easter Saturday 31 March 18 Easter Sunday 1 April 18 Easter Monday 2 April 18 Anzac Day 25 April 18 Labour Day 7 May 18 Ekka Wednesday 15 August 18 Queen's Birthday 1 October 18 Christmas Day 25 December 18 Boxing Day 26 December 18 6.8 Child Care Costs Table Families need to pay for the childcare at Sunshine at a different rate depending on the age of the child. The below table details the pay rates for children.

Documentation Sheet

Children aged 6 and older cannot be cared for at Sunshine as they will be school aged. There is a penalty rate for childcare on a Saturday which is paid in addition to the age rate. This information has been entered for you in the Constant Sheet. Table 5: Child Care Costs Table Age of Child Day Rate 0 $120 1 $110 2 $105 3 $90 4 $85 5 $80 6 Not Allowed Saturday Penalty $10 7 Employees & Volunteers Sheet The Employees & Volunteers Sheet keeps track of the employees who currently work at Sunshine. Your first task on this sheet is to insert a lookup based formula to calculate the employer and employee superannuation contributions. Please note that volunteer carers are not taxed or liable for superannuation.

Employer superannuation is not included in the employee’s annual salary. Using a lookup based formula calculate the annual tax withheld from employees based on their salary. Many employees have a HELP debt; for these employees, calculate the HELP amount that is withheld from the employee salary. Finally calculate the net annual banked salary for each employee. To easily identify the volunteer carers, apply a conditional formatting to the table to show the entire row of data for volunteer carers as pale red background with red text.

BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page | 5 8 Children Sheet On the Children Sheet you will calculate details surrounding the children in the Sunshine childcare centre. First you need to calculate the age of the children at the beginning of the year. Using this determine the initial room that the child will be cared for in and the room that they will be in following their birthday during 2018. Using a formula determine the number of days that a child will be in childcare. Using functions construct a weekday string (seven-character string containing binary values) to use in the NetWorkDays.INTL function. In the string have Saturday and Sunday as non-working days, even if child attends the childcare centre. Have the days the children are in childcare as working days.

For instance, if a child attends childcare centre on Tuesday, Wednesday, and Saturday, the weekday string will be 1001111. The sequence of zeros and ones in the weekday string represents Monday, Tuesday, Wednesday, Thursdays, Friday, Saturday, and Sunday respectively. If during working business days (Monday to Friday) a child is in childcare centre, then those days must be assigned to be 0, otherwise 1. However, if a child is in the childcare centre during weekend (Saturday), the value should still be assigned to 1 regardless they attend childcare centre or not, because you will calculate Saturday cost separately. Therefore, weekend attendance should not impact your weekday string function. One more example, if attendance is on Wednesday, Thursday, and Friday, then the weekday string will be 1100011.

Constants

You will need to use logical and string search and concatenation functions to complete this task. The reason behind this calculation is to be used as weekend parameter in NetWorkDays.INTL function. Calculate the costs of childcare for the child separately for the weekday costs before their birthday, Saturday costs before their birthday, weekday costs after their birthday, and Saturday costs after their birthday. When calculating costs, take into consideration that Sunshine is closed on public holidays. Finally calculate the total annual cost. 1. Weekday cost pre birthday = child’s childcare attendance days between start of the calendar year and a day before birthday excluding public holidays and weekends (Part A) * childcare cost for that age (Part B). Part A is calculated using NetWorkdays.INTL function.

This function includes start date, end date, weekends and public holidays value. You already know start date, weekend dates (weekday string) and public holidays. The challenging part is the calculation of end date, which is a day before birthday. Considering the age of a child you can easily calculate it for the current year. So, in your calculation if child’s birthdate is 6/30/2013, then a day before birthday will be 6/29/2018 for the current year. Hint: you may need to use EDATE or MONTH function to calculate a day before birthday. 2. Saturday cost pre birthday = child’s childcare attendance on Saturdays between start of the calendar year and a day before birthday excluding public holidays (Part C) * childcare cost for that age(Part D) with weekend penalty. Part C is calculated using NetWorkdays.INTL function, but make in mind that your weekend value of this function is no longer a weekday string. You will need to construct a manual weekday string which displays Saturday as the only working day.

Hint the last two values of your seven-character weekend string will be “01”. You can copy your Networkdays function from weekend cost pre birthday column, just make sure to replace weekend parameter with the manually set weekend string. 3. Your post birthday costs will be calculated in a similar way you did in your above calculations. Just be careful of start and end dates of your NetWorkDays function. Your birthday value of the current year will be the start date and end date will be end of the year value. When calculating costs consider the fact that children are one year older now. Using two named ranges (Database and Criteria), set up an advanced filtering section which uses AND based filtering for the filter criteria entered in the Criteria named range. Using the same named ranges use database functions to calculate the total, minimum, average and maximum values for the listed headings.

Annual Tax Table

The formulas should be robust and not display errors. BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page | 6 When you submit your assignment, have the criteria set to show all children who attend for 5 or more days. Have advanced filtering turned on based on these criteria. Apply conditional formatting to the rows of children to highlight the entire row where a child is in the same room before and after their birthday. Highlight the row with a pale green background and green text. 9 Families Sheet On the Families Sheet you will keep track of the different families that have children at Sunshine.

This also calculates the childcare benefits and childcare rebate for the family. Using conditional statistics functions calculate the number of children and weekly hours a family has children in childcare for per week. For each day, a child is in childcare, they are there for 10 hours. Calculate the annual cost of childcare for the family, along with the childcare benefit, childcare rebate and annual payable amount (annual cost less benefits less rebates) for childcare. Calculate these values based on the details in the Children Sheet and Constant Sheet.

Childcare needs to be paid for the entire 52 weeks of a year even if the child is not there each week. 10 Children Analysis Using the information on the Children Sheet create a PivotTable on a new sheet to analyse the number of male and female children in each room. Using the PivotTable, show the gender of the children verse the room and age that the children are cared for in at the beginning of the year. Using the created PivotTable, create a PivotChart and place it on a new Chart Sheet. Format the chart as a clustered column chart. 11 2019 Planner Sheet You are required to conduct a What-If analysis to predict the total income from childcare in 2019. You need to construct the necessary information to conduct the analysis on this sheet. Use the number of children in 2018 and their ages are the beginning of the year. Do not consider the age increase of children.

There are five scenarios to consider in the prediction. Save the results of the scenarios to a new sheet, which contains meaningful labels for each of the values. Based on current scenario fill empty cells and calculate the number of children before and after change, income (childcare cost per year) and total amount. For income calculation you will assume that the age of children does not change during the year. You may need to use Constant and Children Sheets. 11.1.1 Current Situation There is no change to the number of children. Children attend on average 3.

HELP Repayment Table

5 weekdays per week. On average 60% of children attend childcare on Saturday. 11.1.2 Low Decline There is a decline of 20% to the number of children. Children attend on average 2.5 weekdays per week. On average 40% of children attend childcare on Saturday. 11.1.3 Mild Increase There is an increase of 10% to the number of children. Children attend on average 3.5 weekdays per week. On average 60% of children attend childcare on Saturday.

11.1.4 Medium Increase There is an increase of 20% to the number of children. Children attend on average 4 weekdays per week. On average 60% of children attend childcare on Saturday. BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page | 7 11.1.5 Major Increase There is an increase of 40% to the number of children. Children attend on average 4.5 weekdays per week. On average 70% of children attend childcare on Saturday. 12 Investment Planning Sheet On the Investment Planning Sheet, you need to perform a Solver evaluation on an investment planning option for Sunshine. Sunshine has $100,000 to invest and needs to determine the best way to invest to maximise the annual return.

Consider the following investment options with finance companies around Brisbane. Table 6: Brisbane Finance Firms Investment Table Account Annual Return Maturity Risk Rating Tax-Free Central Brisbane Finance 8.0% Short Low Yes North Brisbane Finance 9.0% Short High No East Brisbane Finance 9.0% Long Low No South Brisbane Finance 9.0% Long High Yes West Brisbane Finance 9.5% Long High Yes You are required to ensure that at least 50% of the money is invested in short-term accounts and no more than 50% in high-risk accounts.

At least 30% of the funds should go in tax-free investments, and at least 30% of the total annual returns should be tax-free. Save the results of Solver to an answer sheet and restore the original values before submitting. 13 Implementation Guidance, Formatting and Professionalism You must use Microsoft Excel 2016 (or Microsoft Excel 365) for this assignment. Any of the previous Microsoft Excel versions (e.g. Microsoft Excel 2007) might cause some unnecessary problems. It is highly recommended that, prior to assignment submission, you check that your solution works on the university machines if you have developed it on your own machine. Please develop your solution based on the provided files.

In general, you are not allowed to insert any other columns or tables. If you modify any existing features (excepted were explicitly instructed), please specify and explain them in the assumption section on the student details sheet. When you develop your solution, you should use (but are not limited to) the functions and features you were taught in the tutorials. If you need functions or techniques that are not addressed explicitly in tutorial exercises, you should explore your pretutorial reading materials and preparation exercises or refer to the help component of Excel.

Employer Superannuation Table

Aspects of the assignment have purposefully been designed to train and test a student’s self-learning ability with a software application, and thus, has not been included directly in a tutorial exercise. Sunshine is operated in a professional manner and it is expected that your Excel workbook will be used by other staff, and potentially updated in the future by others.

Therefore, you would be well advised to make your work of the highest quality (e.g. apply screen freezing to long pages, use name references where appropriate, use lookup functions instead of nested ifs where a data table exists, do not hardcode changeable data, use appropriate fonts and colours, graph axes and titles, etc). Keep in mind, however, that your work will be judged primarily on the quality of your solution, less on their appearance. BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page | 8 14 Plagiarism It is understandable that students talk with each other regularly, and discuss problems and potential solutions. However, it is expected that the submitted assignment is a unique document – all parts of the assignment are to be completed solely by the individual student.

The best practice to avoid misconduct is to not look at another student’s file and not show your solution to another student. In case where an assignment is perceived to not be a unique work, a loss of marks and other implications can result. For further information about academic integrity, plagiarism and consequences, please student-integrity-and-misconduct. 15 Submission To be done through Blackboard Assignment Submission. Your Excel Workbook file MUST be named in the format of BISM7202_StudentLastName_StudentID.xlsx. If your ID is 41724943 and your surname is Smith, the name of your files would be BISM7202_Smith_41724943.xlsx. 16 Consultation Sessions To ensure that an equal and sufficient amount of time is allocated for every student who attends consultation sessions regarding the practical aspects of BISM7202, the average consultation time (during busy consultation times) will be limited to 5 minutes per student.

The main aim of this restriction during busy periods is to ensure equality to students and minimise waiting time. However, in circumstances where no other students are waiting, longer consultation times will be provided. Tutors have advised you of their consultation times during tutorials – these details are also available on the BISM7202 Blackboard site under “Contacts”. Please note that course staff are not allowed to look at your assignment files to provide feedback or answer questions. Questions regarding your assignment can be answered if they are related to the understanding of the concepts and/or techniques of Excel. For convenience, you may email the tutors with questions.

Tutor email addresses have been advised in tutorials and are available on the BISM7202 Blackboard site under “Contacts”. Tutors will endeavour to respond to all questions within 2 business days. 17 Important Date Submission Date 25 May 2018 at 17:00. (5pm). 18 Late Submissions Request for extension of the assignment due date will need to be done via the submission of an online application at this link: https://my.uq.edu.au/node/218/0#0 Neither course coordinators nor lecturers can grant assessment extensions to students. BISM7202 Excel Assignment Specification Semester 1, 2018 Version 1 Feb 2018 Page |

9 Non-permissible circumstances Extensions will not be granted where the School is not satisfied you took reasonable measures to avoid the circumstances that contributed to you not submitting by the due date. The following are not grounds for an extension: o holiday arrangements (including overseas travel); o misreading a due date; o social and leisure events; o moving house; o pressure of work/competing deadlines; o computer issues. You will incur penalties.

if your work is submitted late (i.e. after the due date and without an approved extension). Assignments (for which no extension has been granted) submitted after the due date and time, incur a late submission penalty. The penalty is at the rate of 5% of the total available marks for that particular piece of assessment, for each calendar day or part thereof that the item is overdue. The penalty once calculated is deducted from the marks awarded for the assessment. Assessment submitted more than 10 days after the due date will receive zero marks.

BISM7202 Assignment - Semester 1, 2018

Sunshine Childcare

Assignment Template

Documentation

Student Information

Note: Student numbers are eight digits and do not begin with an 's'.

Student ID

Family Name

Given Name

Assumptons

Leave blank if no assumptions made.

I add age new column in Employees & Volunteers worksheet to caluculate age according to the requirmnts.

Tip: To switch to the next line in one cell, use the key combination 'Alt+Enter'.

Sunshine Constants

Tax Table

HELP Repayment Table

Employer Superannuation Contribution

Employee Superannuation Contribution

Child Care Rooms

Family Child Care Info

Holidays

Child Care Costs

Income

Fixed Tax

Tax Percentage

Repayable Income

Repayment Rate

Position

Percentage

Age

Percentage

Age

Rooms

CCB Max Hours

Holiday Day

Holiday Date

Age

Day Rate

55874

0.04

Director

12.50%

2.50%

younger than 2 years

Platypus

CCB Hourly Rate

0.719

New Year's Day

#######

18200

0.19

62239

0.045

Deputy Director

12.00%

between 2 and 3 years

Emu

CCB Threshold

45114

Australia Day

#######

37000

3572

0.325

68603

0.05

Senior Accountant

11.50%

3.50%

between 3 and 4 years

Koala

CCB Threshold Modifier

6.5E-06

Good Friday

#######

87000

19822

0.37

72208

0.055

Accountant

11.00%

between 4 and 5 years

Kangaroo

CCR Rate

0.5

Easter Saturday

#######

$ 90.00

180000

54232

0.45

77619

0.06

Chef

10.00%

CCR Max

7613

Easter Sunday

#######

$ 85.00

84063

0.065

Assistant Chef

9.50%

Easter Monday

#######

$ 80.00

88487

0.07

Child Care Leader

10.00%

Anzac Day

#######

Not Allowed

97378

0.075

Child Care Worker

9.50%

Labour Day

#######

Saturday Penalty

$ 10.00

103766

0.08

Junior Child Care Worker

9.50%

Ekka Wednesday

#######

Custodial Engineer

9.50%

Queen's Birthday

#######

Christmas Day

#######

Boxing Day

#######

Sunshine Employees & Volunteers

First Name

Last Name

Gender

Position

HELP Debt

DOB

Age

Annual Income

Employer Superannuation

Employee Superannuation

Annual Tax

HELP Withheld

Net Salary

Jorja

Arnott

Female

Volunteer Carer

19-Oct-63

$ -

Xavier

Benstead

Male

Custodial Engineer

15-Feb-64

$ 35,423.00

$ 0.10

$ 0.05

$ 6,730.37

$ -

$ 35,422.86

Abby

Dennis

Female

Volunteer Carer

18-Sep-72

$ -

Isaac

Foelsche

Male

Custodial Engineer

28-Oct-75

$ 35,423.00

$ 0.10

$ 0.03

$ 6,730.37

$ -

$ 35,422.88

Claudia

Philp

Female

Director

TRUE

19-Dec-78

$ 89,534.00

$ 0.13

$ 0.03

$ 52,949.58

$ 0.07

$ 89,533.78

Ellie

Watson

Female

Child Care Leader

3-Jul-79

$ 48,310.00

$ 0.10

$ 0.03

$ 19,272.75

$ -

$ 48,309.87

Christian

Tancred

Male

Child Care Leader

TRUE

26-Jan-81

$ 56,989.00

$ 0.10

$ 0.03

$ 22,093.43

$ 0.04

$ 56,988.83

Madeline

Strachan

Female

Child Care Leader

7-May-82

$ 52,487.00

$ 0.10

$ 0.03

$ 20,630.28

$ -

$ 52,486.87

Taylah

McMahon

Female

Child Care Leader

TRUE

11-Mar-83

$ 48,310.00

$ 0.10

$ 0.03

$ 19,272.75

$ -

$ 48,309.87

Sofia

Goold-Adams

Female

Deputy Director

TRUE

17-Aug-83

$ 74,879.00

$ 0.12

$ 0.03

$ 27,907.68

$ 0.06

$ 74,878.80

Scarlett

Seager

Female

Child Care Worker

4-Sep-85

$ 40,750.00

$ 0.10

$ 0.03

$ 16,815.75

$ -

$ 40,749.88

Sam

Roth

Female

Volunteer Carer

TRUE

2-Jun-88

$ -

Rachel

Mansergh

Female

Senior Accountant

TRUE

19-Sep-88

$ 68,423.00

$ 0.12

$ 0.03

$ 25,809.48

$ 0.05

$ 68,422.82

Nate

Marian

Male

Child Care Worker

4-Dec-88

$ 40,750.00

$ 0.10

$ 0.03

$ 16,815.75

$ -

$ 40,749.88

Alex

Dakin

Female

Child Care Leader

TRUE

22-Feb-89

$ 56,989.00

$ 0.10

$ 0.03

$ 22,093.43

$ 0.04

$ 56,988.84

Isaac

Dumaresq

Male

Chef

TRUE

10-Jul-90

$ 54,326.00

$ 0.10

$ 0.03

$ 21,227.95

$ -

$ 54,325.88

Indiana

Gask

Female

Chef

TRUE

4-Jul-91

$ 54,326.00

$ 0.10

$ 0.03

$ 21,227.95

$ -

$ 54,325.88

Ryan

Loch

Male

Child Care Worker

TRUE

31-Aug-92

$ 40,750.00

$ 0.10

$ 0.03

$ 16,815.75

$ -

$ 40,749.88

Alice

Crawley

Female

Assistant Chef

TRUE

29-Oct-92

$ 43,448.00

$ 0.10

$ 0.03

$ 17,692.60

$ -

$ 43,447.88

Mitchell

Grimley

Male

Assistant Chef

TRUE

21-Feb-93

$ 43,448.00

$ 0.10

$ 0.03

$ 17,692.60

$ -

$ 43,447.88

Maddison

Stump

Female

Junior Child Care Worker

1-Oct-93

$ 35,862.00

$ 0.10

$ -

$ 6,813.78

$ -

$ 35,861.91

Mason

Train

Male

Child Care Worker

1-Oct-94

$ 45,876.00

$ 0.10

$ -

$ 18,481.70

$ -

$ 45,875.91

Ashton

Bethel

Male

Accountant

TRUE

17-Apr-95

$ 55,232.00

$ 0.11

$ -

$ 21,522.40

$ -

$ 55,231.89

Harry

Lutwyche

Male

Volunteer Carer

TRUE

28-Nov-95

$ -

Victoria

Lamond

Female

Junior Child Care Worker

10-Feb-96

$ 35,862.00

$ 0.10

$ -

$ 6,813.78

$ -

$ 35,861.91

Mariam

Betts

Female

Volunteer Carer

TRUE

11-Nov-97

$ -

Sam

Wrenfordsley

Female

Junior Child Care Worker

TRUE

12-Feb-98

$ 35,862.00

$ 0.10

$ -

$ 6,813.78

$ -

$ 35,861.91

Harrison

McCallum

Male

Junior Child Care Worker

TRUE

7-Apr-99

$ 35,862.00

$ 0.10

$ -

$ 6,813.78

$ -

$ 35,861.91

Sunshine Families

Family Code

Family Name

Parent/Guardian 1 Given Name

Parent/Guardian 1 Family Name

Parent/Guardian 2 Given Name

Parent/Guardian 2 Family Name

Family Income

Number of Children

Weekly Hours

Annual Cost

Annual CCB

Annual CCR

Annual Payable

allman-03

Allman

Jessica

Allman

Grant

Allman

###

$ 55,280.00

$ 1,589.60

$ 2,764.00

$ 59,633.60

barclay-02

Barclay

Lucas

Barclay

Rosalie

Barclay

###

$ 25,200.00

$ 517.36

$ 1,260.00

$ 26,977.36

barnard-02

Barnard

Mitchell

Barnard

Bethany

Abrahamsson

###

$ 56,430.00

$ -

$ 2,821.50

$ 59,251.50

bernardini-02

Bernardini

Hiram

Bernardini

Heather

Bernardini

###

$ 18,810.00

$ 1,403.45

$ 940.50

$ 21,153.95

bruner-03

Bruner

Clarence

Bruner

Jill

Bruner

###

$ 22,800.00

$ 945.82

$ 1,140.00

$ 24,885.82

burke-02

Burke

Don

Burke

Norma

Burke

###

$ 16,020.00

$ -

$ 801.00

$ 16,821.00

caya-02

Caya

Villette

Caya

Claude

Lundqvist

###

$ -

$ 88.52

$ -

$ 88.52

chien-03

Chien

Hui

Chien

Kuan-Yin

Burger

###

$ 36,120.00

$ -

$ 1,806.00

$ 37,926.00

coburn-02

Coburn

Hannah

Coburn

Cedric

Coburn

###

$ 38,395.00

$ -

$ 1,919.75

$ 40,314.75

course-01

Course

Astolpho

Course

Clemence

Course

###

$ 23,760.00

$ 506.72

$ 1,188.00

$ 25,454.72

crombie-03

Crombie

Justin

Crombie

Janis

Phillips

###

$ 72,430.00

$ -

$ 3,621.50

$ 76,051.50

dastous-01

Dastous

Fletcher

Dastous

Sabine

Dastous

###

$ 22,030.00

$ -

$ 1,101.50

$ 23,131.50

dorrington-01

Dorrington

Jacob

Dorrington

###

$ -

$ 406.26

$ -

$ 406.26

duggan-03

Duggan

Jackson

Duggan

Marlene

Duggan

###

$ 72,705.00

$ -

$ 3,635.25

$ 76,340.25

dumaresq-03

Dumaresq

Molly

Dumaresq

Erickson

###

$ 18,180.00

$ 251.71

$ 909.00

$ 19,340.71

duranseau-01

Duranseau

Fleurette

Duranseau

Arienne

Dreher

###

$ -

$ 138.03

$ -

$ 138.03

eatock-01

Eatock

Charlotte

Eatock

Robert

Eatock

###

$ -

$ 1,597.00

$ -

$ 1,597.00

edgerton-01

Edgerton

Kiara

Edgerton

###

$ -

$ 290.14

$ -

$ 290.14

fantl-02

Fantl

Natasha

Fantl

###

$ 21,150.00

$ 2,131.17

$ 1,057.50

$ 24,338.67

farquhar-03

Farquhar

Margaret

Farquhar

Billy

Farquhar

###

$ 35,770.00

$ 1,105.07

$ 1,788.50

$ 38,663.57

fichter-02

Fichter

Billy

Fichter

Peggy

Fichter

###

$ 55,515.00

$ -

$ 2,775.75

$ 58,290.75

gallegos-03

Gallegos

Bertha

Gallegos

Saville

Gallegos

###

$ 37,800.00

$ -

$ 1,890.00

$ 39,690.00

gallop-03

Gallop

Annabelle

Gallop

###

$ 31,265.00

$ 2,564.62

$ 1,563.25

$ 35,392.87

garreau-01

Garreau

Rene

Garreau

Olympia

Garreau

###

$ 18,165.00

$ 511.30

$ 908.25

$ 19,584.55

hertzog-03

Hertzog

Michael

Hertzog

Lea

Hertzog

###

$ 19,260.00

$ 493.27

$ 963.00

$ 20,716.27

isom-01

Isom

Natalie

Isom

###

$ -

$ 1,562.87

$ -

$ 1,562.87

jackey-02

Jackey

Chelsea

Jackey

###

$ 16,765.00

$ 3,625.20

$ 838.25

$ 21,228.45

johann-01

Johann

Dominic

Johann

Laura

Edwards

###

$ 19,365.00

$ 239.49

$ 968.25

$ 20,572.74

kamuta-01

Kamuta

Yuugou

Kamuta

Hatomi

Kamuta

###

$ 33,735.00

$ -

$ 1,686.75

$ 35,421.75

kasai-03

Kasai

Kazumu

Kasai

Itsuyo

Kasai

###

$ 20,760.00

$ 383.46

$ 1,038.00

$ 22,181.46

kouno-01

Kouno

Genya

Kouno

Akari

Kouno

###

$ 15,480.00

$ 126.47

$ 774.00

$ 16,380.47

kraegen-01

Kraegen

Taylah

Kraegen

###

$ -

$ 1,012.52

$ -

$ 1,012.52

langlais-02

Langlais

Danielle

Langlais

Voleta

Ponce

###

$ 31,715.00

$ 258.42

$ 1,585.75

$ 33,559.17

leveille-02

Leveille

Maurice

Leveille

Germaine

Leveille

###

$ 18,165.00

$ 301.40

$ 908.25

$ 19,374.65

marian-03

Marian

Jai

Marian

Jonas

Lundgren

###

$ 16,935.00

$ 178.67

$ 846.75

$ 17,960.42

mcguirk-03

McGuirk

Keira

McGuirk

###

$ 35,135.00

$ 3,793.62

$ 1,756.75

$ 40,685.37

mckean-03

McKean

Julian

McKean

###

$ 20,100.00

$ 1,573.52

$ 1,005.00

$ 22,678.52

moore-01

Moore

Rey

Moore

George

Chu

###

$ 33,285.00

$ 829.26

$ 1,664.25

$ 35,778.51

mowery-02

Mowery

Adam

Mowery

Laura

Foerster

###

$ 15,120.00

$ 183.32

$ 756.00

$ 16,059.32

nixon-03

Nixon

Bernie

Nixon

###

$ 17,190.00

$ 1,821.84

$ 859.50

$ 19,871.34

obrien-01

Obrien

Pat

Obrien

Sandra

Obrien

###

$ 17,190.00

$ -

$ 859.50

$ 18,049.50

osburne-03

Osburne

Nicholas

Osburne

Jennifer

Osburne

###

$ 19,500.00

$ -

$ 975.00

$ 20,475.00

pelensky-02

Pelensky

Lily

Pelensky

Anthony

Pelensky

###

$ 18,810.00

$ 332.51

$ 940.50

$ 20,083.01

pelsaert-03

Pelsaert

Rachel

Pelsaert

Adam

Herrmann

###

$ 14,620.00

$ -

$ 731.00

$ 15,351.00

penfold-02

Penfold

Harrison

Penfold

###

$ -

$ 842.87

$ -

$ 842.87

quynh-03

Quynh

Kim

Quynh

Chu

Quynh

###

$ -

racine-03

Racine

Aceline

Racine

Ogier

Schmitt

###

$ -

rawson-02

Rawson

Adam

Rawson

Janet

Bainton

###

$ 14,705.00

$ 57.54

$ 735.25

$ 15,497.79

revell-02

Revell

George

Revell

###

$ -

$ 1,799.70

$ -

$ 1,799.70

robinson-03

Robinson

Kristin

Robinson

Kent

Robinson

###

$ 20,760.00

$ -

$ 1,038.00

$ 21,798.00

rodway-03

Rodway

Austin

Rodway

###

$ 15,480.00

$ 1,354.93

$ 774.00

$ 17,608.93

rule-02

Rule

David

Rule

Alaina

Rule

###

$ 47,575.00

$ 1,207.62

$ 2,378.75

$ 51,161.37

scherer-03

Scherer

Niklas

Scherer

Leah

Scherer

###

$ 14,705.00

$ 105.65

$ 735.25

$ 15,545.90

seitz-01

Seitz

Patrick

Seitz

Frank

Gordon

###

$ 18,165.00

$ -

$ 908.25

$ 19,073.25

shinosaki-02

Shinosaki

Shuuji

Shinosaki

Kiyone

Shinosaki

###

$ 35,265.00

$ 1,337.19

$ 1,763.25

$ 38,365.44

stirling-01

Stirling

Dennis

Stirling

Monika

Stirling

###

$ 22,580.00

$ -

$ 1,129.00

$ 23,709.00

stopford-02

Stopford

Brodie

Stopford

Natasha

Stopford

###

$ -

sylvestre-01

Sylvestre

Moses

Sylvestre

Mary

Meekin

###

$ 30,610.00

$ 2,221.12

$ 1,530.50

$ 34,361.62

tabata-02

Tabata

Michie

Tabata

Yukihiro

Tabata

###

$ -

takayama-01

Takayama

Yukio

Takayama

Yumia

Takayama

###

$ 37,615.00

$ -

$ 1,880.75

$ 39,495.75

tani-01

Tani

Itsumi

Tani

Hyouma

Kawamura

###

$ 38,105.00

$ 1,501.49

$ 1,905.25

$ 41,511.74

tiller-02

Tiller

Simone

Tiller

Marina

Tiller

###

$ 18,165.00

$ 629.87

$ 908.25

$ 19,703.12

timbery-01

Timbery

Eden

Timbery

Ethan

Bentley

###

$ 18,920.00

$ 673.88

$ 946.00

$ 20,539.88

valencia-02

Valencia

Kathy

Valencia

Karine

Ford

###

$ -

watson-01

Watson

Kyle

Watson

Monique

Creech

###

$ 18,165.00

$ 200.38

$ 908.25

$ 19,273.63

winterbotham-03

Winterbotham

Natasha

Winterbotham

###

$ -

$ 1,073.88

$ -

$ 1,073.88

yoshihara-03

Yoshihara

Tomoka

Yoshihara

Fukashi

Cheng

###

$ 37,740.00

$ -

$ 1,887.00

$ 39,627.00

yost-02

Yost

Ruby

Yost

Salvador

Nilsson

###

$ 65,025.00

$ 2,874.24

$ 3,251.25

$ 71,150.49

Age

(All)

Count of Gender

Column Labels

Row Labels

Emu

Kangaroo

Koala

NOT ALLOWED

Platypus

Grand Total

Female

Male

Grand Total

116

Sunshine Children

Child Code

Family Code

Given Name

Family Name

Gender

DOB

Days

Age

Initial Room

Final Room

Number of Days

Weekday String

Weekday Cost Pre Birthday

Saturday Cost Pre Birthday

Weekday Cost Post Birthday

Saturday Cost Post Birthday

Annual Cost

>=5

Weekday Cost Pre Birthday

Saturday Cost Pre Birthday

Weekday Cost Post Birthday

Saturday Cost Post Birthday

Annual Cost

Total

$ 7,34,715.00

########

Minimum

$ -

Average

$ 6,333.75

########

Maximum

$ 20,280.00

########

Child Code

Family Code

Given Name

Family Name

Gender

DOB

Days

Age

Initial Room

Final Room

Number of Days

Weekday String

Weekday Cost Pre Birthday

Saturday Cost Pre Birthday

Weekday Cost Post Birthday

Saturday Cost Post Birthday

Annual Cost

allman-03-05

allman-03

Molly

Allman

Female

30-Jun-13

mon,tues,sat

Kangaroo

NOT ALLOWED

0011111

$ 3,825.00

#######

allman-03-04

allman-03

Regina

Allman

Female

9-Oct-14

mon,tues,sat

Koala

Kangaroo

0011111

$ 10,260.00

#######

allman-03-03

allman-03

Roxanne

Allman

Female

2-Nov-15

mon,tues,sat

Emu

Koala

0011111

$ 13,860.00

#######

allman-03-02

allman-03

Jeffery

Allman

Male

26-Dec-17

mon,tues,sat

Platypus

100

0011111

$ 20,280.00

#######

barclay-02-02

barclay-02

Jennifer

Barclay

Female

19-Feb-17

tues,wed

Platypus

Emu

1001111

$ -

barclay-02-01

barclay-02

Robert

Barclay

Male

19-Feb-17

tues,wed

Platypus

Emu

1001111

$ -

barnard-02-03

barnard-02

Brandon

Barnard

Male

7-Dec-14

fri,sat

Koala

Kangaroo

1111011

$ 14,130.00

#######

barnard-02-04

barnard-02

Janis

Barnard

Female

7-Dec-14

fri,sat

Koala

Kangaroo

1111011

$ 14,130.00

#######

barnard-02-02

barnard-02

Madeline

Barnard

Female

7-Dec-14

fri,sat

Koala

Kangaroo

1111011

$ 14,130.00

#######

barnard-02-05

barnard-02

Robert

Barnard

Male

7-Dec-14

fri,sat

Koala

Kangaroo

1111011

$ 14,130.00

#######

bernardini-02-01

bernardini-02

Heath

Bernardini

Male

29-Nov-16

tues,wed,thurs,fri,sat

Platypus

Emu

152

1000011

$ 16,610.00

#######

bruner-03-01

bruner-03

Jonas

Bruner

Male

13-May-14

mon,tues,wed,sat

Koala

Kangaroo

0001111

$ 900.00

#######

burke-02-02

burke-02

Micael

Burke

Male

26-Feb-15

tues,thurs,fri,sat

Koala

Kangaroo

1010011

$ -

caya-02-01

caya-02

Zurie

Caya

Female

8-May-15

mon,thurs,fri

Emu

Koala

0110011

$ 630.00

#######

chien-03-03

chien-03

Chien

Female

30-Jul-15

mon,tues,wed,thurs

Emu

Koala

0000111

$ 6,825.00

#######

chien-03-02

chien-03

Yuan

Chien

Male

13-Dec-16

mon,tues,wed,thurs

Platypus

Emu

129

0000111

$ 17,710.00

#######

coburn-02-02

coburn-02

Karen

Coburn

Female

25-Jun-15

mon,thurs,fri,sat

Emu

Koala

0110011

$ 4,200.00

#######

coburn-02-01

coburn-02

Mack

Coburn

Male

2-Oct-17

mon,thurs,fri,sat

Platypus

0110011

$ 13,080.00

#######

course-01-01

course-01

Roux

Course

Female

15-Jun-14

mon,tues,wed,sat

Koala

Kangaroo

0001111

$ 3,060.00

#######

crombie-03-03

crombie-03

Jerome

Crombie

Male

16-Jul-14

mon,wed,thurs,fri,sat

Koala

Kangaroo

0100011

$ 4,950.00

#######

crombie-03-04

crombie-03

Richard

Crombie

Male

16-Jul-14

mon,wed,thurs,fri,sat

Koala

Kangaroo

0100011

$ 4,950.00

#######

crombie-03-01

crombie-03

Samantha

Crombie

Female

15-Oct-16

mon,wed,thurs,fri,sat

Platypus

Emu

120

0100011

$ 12,980.00

#######

crombie-03-02

crombie-03

Joe

Crombie

Male

15-Oct-16

mon,wed,thurs,fri,sat

Platypus

Emu

120

0100011

$ 12,980.00

#######

dastous-01-01

dastous-01

Fauna

Dastous

Female

26-Mar-13

mon,tues,thurs,fri,sat

NOT ALLOWED

0010011

$ -

dorrington-01-02

dorrington-01

Xander

Dorrington

Male

29-Jun-15

thurs

Emu

Koala

1110111

$ 4,620.00

#######

duggan-03-02

duggan-03

Lucas

Duggan

Male

28-Oct-14

mon,thurs,sat

Koala

Kangaroo

0110111

$ 11,520.00

#######

duggan-03-03

duggan-03

Shelly

Duggan

Female

28-Oct-14

mon,thurs,sat

Koala

Kangaroo

0110111

$ 11,520.00

#######

duggan-03-04

duggan-03

Richard

Duggan

Male

28-Oct-14

mon,thurs,sat

Koala

Kangaroo

0110111

$ 11,520.00

#######

duggan-03-05

duggan-03

Charles

Duggan

Male

28-Oct-14

mon,thurs,sat

Koala

Kangaroo

0110111

$ 11,520.00

#######

dumaresq-03-01

dumaresq-03

Howard

Dumaresq

Male

27-Mar-14

mon,tues,fri,sat

Kangaroo

NOT ALLOWED

0011011

$ -

duranseau-01-01

duranseau-01

Yvon

Duranseau

Female

19-Apr-14

mon,wed,fri

Kangaroo

NOT ALLOWED

0101011

$ -

eatock-01-02

eatock-01

Lena

Eatock

Female

29-Jan-14

mon,fri,sat

Kangaroo

NOT ALLOWED

0111011

$ -

eatock-01-01

eatock-01

Mary

Eatock

Female

22-Apr-16

mon,fri,sat

Emu

Koala

0111011

$ -

edgerton-01-02

edgerton-01

Taylah

Edgerton

Female

7-Apr-14

fri

Kangaroo

NOT ALLOWED

1111011

$ -

fantl-02-02

fantl-02

Ellie

Fantl

Female

22-Oct-15

mon,fri,sat

Emu

Koala

0111011

$ 12,915.00

#######

fantl-02-03

fantl-02

Alannah

Fantl

Female

22-Oct-15

mon,fri,sat

Emu

Koala

0111011

$ 12,915.00

#######

farquhar-03-01

farquhar-03

Nathan

Farquhar

Male

27-May-13

mon,tues,fri

Kangaroo

NOT ALLOWED

0011011

$ 1,700.00

#######

farquhar-03-02

farquhar-03

John

Farquhar

Male

12-Jul-15

mon,tues,fri

Emu

Koala

0011011

$ 5,565.00

#######

fichter-02-01

fichter-02

Kelvin

Fichter

Male

5-May-13

mon,tues,fri,sat

Kangaroo

NOT ALLOWED

0011011

$ 510.00

#######

fichter-02-03

fichter-02

Delia

Fichter

Female

25-Dec-15

mon,tues,fri,sat

Emu

Koala

135

0011011

$ 17,745.00

#######

fichter-02-02

fichter-02

Mark

Fichter

Male

13-May-17

mon,tues,fri,sat

Platypus

0011011

$ 1,200.00

#######

gallegos-03-01

gallegos-03

Callum

Gallegos

Male

16-Jun-14

mon,tues,wed,sat

Koala

Kangaroo

0001111

$ 3,150.00

#######

gallegos-03-02

gallegos-03

Alex

Gallegos

Male

16-Jun-14

mon,tues,wed,sat

Koala

Kangaroo

0001111

$ 3,150.00

#######

gallop-03-02

gallop-03

Isabelle

Gallop

Female

12-Jul-13

tues,wed,thurs,fri

Kangaroo

NOT ALLOWED

1000011

$ 4,505.00

#######

gallop-03-03

gallop-03

Tyler

Gallop

Male

11-Dec-15

tues,wed,thurs,fri

Emu

Koala

128

1000011

$ 16,695.00

#######

garreau-01-02

garreau-01

Maurelle

Garreau

Female

12-Jun-15

mon,fri,sat

Emu

Koala

0111011

$ 3,255.00

#######

hertzog-03-01

hertzog-03

Jan

Hertzog

Female

30-Jan-17

mon,thurs,fri

Platypus

Emu

0110011

$ -

isom-01-01

isom-01

Jordon

Isom

Male

9-Mar-14

tues,wed,thurs,fri,sat

Kangaroo

NOT ALLOWED

1000011

$ -

jackey-02-02

jackey-02

Dominic

Jackey

Male

17-Sep-13

tues,wed,thurs,fri,sat

Kangaroo

NOT ALLOWED

101

1000011

$ 8,415.00

#######

jackey-02-03

jackey-02

Danielle

Jackey

Female

19-Jun-15

tues,wed,thurs,fri,sat

Emu

Koala

1000011

$ 3,780.00

#######

johann-01-02

johann-01

Raison

Johann

Male

4-Feb-13

mon,tues,wed,thurs,fri

NOT ALLOWED

0000011

$ -

johann-01-03

johann-01

Rohan

Johann

Male

26-Feb-15

mon,tues,wed,thurs,fri

Koala

Kangaroo

0000011

$ -

kamuta-01-01

kamuta-01

Tsuyuha

Kamuta

Female

15-Jan-13

mon,tues,wed,fri

NOT ALLOWED

0001011

$ -

kamuta-01-04

kamuta-01

Moeka

Kamuta

Female

11-Oct-14

mon,tues,wed,fri

Koala

Kangaroo

0001011

$ 10,440.00

#######

kamuta-01-03

kamuta-01

Gakuto

Kamuta

Male

20-Nov-15

mon,tues,wed,fri

Emu

Koala

116

0001011

$ 15,120.00

#######

kamuta-01-02

kamuta-01

Sakio

Kamuta

Female

28-Jul-17

mon,tues,wed,fri

Platypus

0001011

$ 7,800.00

#######

kasai-03-01

kasai-03

Erisa

Kasai

Female

24-Sep-14

mon,wed

Koala

Kangaroo

0101111

$ 9,360.00

#######

kouno-01-02

kouno-01

Shima

Kouno

Female

27-Feb-16

tues,thurs,fri,sat

Emu

Koala

1010011

$ -

kraegen-01-01

kraegen-01

Josphine

Kraegen

Female

18-Jul-14

thurs,fri,sat

Koala

Kangaroo

1110011

$ 5,130.00

#######

langlais-02-02

langlais-02

Henry

Langlais

Male

25-Aug-13

thurs

Kangaroo

NOT ALLOWED

1110111

$ 7,140.00

#######

langlais-02-03

langlais-02

Courtland

Langlais

Male

31-Oct-15

thurs

Emu

Koala

1110111

$ 13,650.00

#######

leveille-02-02

leveille-02

Edmee

Leveille

Female

27-Sep-13

mon,tues,wed,thurs,sat

Kangaroo

NOT ALLOWED

108

0000111

$ 9,095.00

#######

marian-03-02

marian-03

Sean

Marian

Male

16-Nov-14

thurs,sat

Koala

Kangaroo

1110111

$ 12,780.00

#######

mcguirk-03-01

mcguirk-03

Donald

McGuirk

Male

3-Sep-13

mon,tues,thurs,fri,sat

Kangaroo

NOT ALLOWED

0010011

$ 7,565.00

#######

mcguirk-03-02

mcguirk-03

Barry

McGuirk

Male

13-Aug-15

mon,tues,thurs,fri,sat

Emu

Koala

0010011

$ 7,875.00

#######

mckean-03-02

mckean-03

Alyssa

McKean

Female

9-Aug-15

tues,wed,thurs,fri

Emu

Koala

1000011

$ 7,665.00

#######

moore-01-01

moore-01

Billy

Moore

Male

3-Dec-12

mon,wed,thurs,fri,sat

NOT ALLOWED

155

0100011

$ 12,240.00

#######

$ -

#######

moore-01-02

moore-01

Sonja

Moore

Female

3-Dec-12

mon,wed,thurs,fri,sat

NOT ALLOWED

155

0100011

$ 12,240.00

#######

$ -

#######

mowery-02-01

mowery-02

Jason

Mowery

Male

6-Aug-14

mon,wed,thurs,sat

Koala

Kangaroo

0100111

$ 6,300.00

#######

nixon-03-02

nixon-03

Julian

Nixon

Male

11-Feb-14

mon,tues,thurs,fri,sat

Kangaroo

NOT ALLOWED

0010011

$ -

obrien-01-01

obrien-01

Deborah

Obrien

Female

3-Aug-14

mon,sat

Koala

Kangaroo

0111111

$ 6,210.00

#######

obrien-01-02

obrien-01

Kevin

Obrien

Male

7-May-16

mon,sat

Platypus

Emu

0111111

$ 660.00

#######

osburne-03-02

osburne-03

Abigail

Osburne

Female

17-Feb-13

wed,fri,sat

NOT ALLOWED

1101011

$ -

osburne-03-03

osburne-03

Elizabeth

Osburne

Female

17-Feb-13

wed,fri,sat

NOT ALLOWED

1101011

$ -

osburne-03-01

osburne-03

Ryder

Osburne

Male

5-Dec-14

wed,fri,sat

Koala

Kangaroo

1101011

$ 13,950.00

#######

pelensky-02-02

pelensky-02

Jake

Pelensky

Male

16-Dec-13

thurs,fri

Kangaroo

NOT ALLOWED

1110011

$ 13,855.00

#######

pelsaert-03-02

pelsaert-03

Sabrine

Pelsaert

Female

16-Mar-16

mon,tues,thurs

Emu

Koala

0010111

$ -

pelsaert-03-03

pelsaert-03

Pamala

Pelsaert

Female

16-Mar-16

mon,tues,thurs

Emu

Koala

0010111

$ -

pelsaert-03-04

pelsaert-03

Bradley

Pelsaert

Male

16-Mar-16

mon,tues,thurs

Emu

Koala

0010111

$ -

penfold-02-01

penfold-02

Thomas

Penfold

Male

16-Jan-13

mon,wed,sat

NOT ALLOWED

0101111

$ -

quynh-03-02

quynh-03

Tinh

Quynh

Male

10-Feb-15

mon,tues

Koala

Kangaroo

0011111

$ -

racine-03-02

racine-03

Nicholas

Racine

Male

24-Jul-13

wed,thurs

Kangaroo

NOT ALLOWED

1100111

$ 5,185.00

#######

rawson-02-01

rawson-02

Bill

Rawson

Male

5-Apr-13

tues,fri

NOT ALLOWED

1011011

$ -

revell-02-02

revell-02

Scott

Revell

Male

25-Jan-14

tues,thurs,fri

Kangaroo

NOT ALLOWED

1010011

$ -

revell-02-03

revell-02

Andrew

Revell

Male

27-Jul-17

tues,thurs,fri

Platypus

1010011

$ 7,680.00

#######

robinson-03-01

robinson-03

Kimberly

Robinson

Female

26-Nov-14

mon,wed,thurs

Koala

Kangaroo

0100111

$ 13,320.00

#######

rodway-03-02

rodway-03

Angus

Rodway

Male

21-Jun-15

mon,tues,wed,fri

Emu

Koala

0001011

$ 3,990.00

#######

rule-02-02

rule-02

Marcos

Rule

Male

27-Sep-13

mon,tues,thurs

Kangaroo

NOT ALLOWED

0010111

$ 9,095.00

#######

rule-02-03

rule-02

Albert

Rule

Male

27-Sep-13

mon,tues,thurs

Kangaroo

NOT ALLOWED

0010111

$ 9,095.00

#######

rule-02-04

rule-02

Wanda

Rule

Female

27-Sep-13

mon,tues,thurs

Kangaroo

NOT ALLOWED

0010111

$ 9,095.00

#######

scherer-03-01

scherer-03

Diana

Scherer

Female

6-Jul-15

mon,wed

Emu

Koala

0101111

$ 5,145.00

#######

seitz-01-02

seitz-01

Archer

Seitz

Male

14-Jul-15

tues,fri

Emu

Koala

1011011

$ 5,775.00

#######

shinosaki-02-01

shinosaki-02

Jin

Shinosaki

Male

25-Jul-14

wed,thurs,fri,sat

Koala

Kangaroo

1100011

$ 5,580.00

#######

shinosaki-02-02

shinosaki-02

Kiyoki

Shinosaki

Female

17-Nov-16

wed,thurs,fri,sat

Platypus

Emu

114

1100011

$ 15,730.00

#######

stirling-01-01

stirling-01

Oscar

Stirling

Male

7-Apr-15

mon,fri,sat

Koala

Kangaroo

0111011

$ -

stopford-02-01

stopford-02

Hudson

Stopford

Male

30-Nov-12

mon,wed,thurs,fri

NOT ALLOWED

122

0100011

$ 12,160.00

#######

$ -

#######

sylvestre-01-02

sylvestre-01

Brendan

Sylvestre

Male

6-Nov-14

mon,tues,wed,thurs,fri,sat

Koala

Kangaroo

163

0000011

$ 12,060.00

#######

sylvestre-01-03

sylvestre-01

Jane

Sylvestre

Female

24-Feb-17

mon,tues,wed,thurs,fri,sat

Platypus

Emu

0000011

$ -

tabata-02-01

tabata-02

Sei

Tabata

Male

19-Mar-17

tues,wed,thurs,fri,sat

Platypus

Emu

1000011

$ -

tabata-02-02

tabata-02

Sato

Tabata

Female

19-Mar-17

tues,wed,thurs,fri,sat

Platypus

Emu

1000011

$ -

takayama-01-03

takayama-01

Makito

Takayama

Male

29-Dec-13

mon,tues,wed,thurs,fri,sat

Kangaroo

NOT ALLOWED

207

0000011

$ 14,535.00

#######

takayama-01-02

takayama-01

Tomo

Takayama

Female

6-Jul-15

mon,tues,wed,thurs,fri,sat

Emu

Koala

0000011

$ 5,145.00

#######

takayama-01-01

takayama-01

Issei

Takayama

Male

16-Sep-17

mon,tues,wed,thurs,fri,sat

Platypus

120

0000011

$ 11,880.00

#######

tani-01-03

tani-01

Takato

Tani

Male

16-May-13

tues,wed,thurs,fri

Kangaroo

NOT ALLOWED

1000011

$ 1,020.00

#######

tani-01-02

tani-01

Nina

Tani

Female

30-Jun-15

tues,wed,thurs,fri

Emu

Koala

1000011

$ 4,725.00

#######

tiller-02-02

tiller-02

Andrew

Tiller

Male

4-Jun-16

mon,wed,thurs

Platypus

Emu

0100111

$ 2,750.00

#######

timbery-01-02

timbery-01

Timothy

Timbery

Male

27-Jan-15

tues,wed,thurs

Koala

Kangaroo

1000111

$ -

valencia-02-02

valencia-02

Jordon

Valencia

Male

26-Oct-15

mon,tues

Emu

Koala

0011111

$ 13,335.00

#######

watson-01-01

watson-01

William

Watson

Male

18-Apr-15

wed

Koala

Kangaroo

1101111

$ -

winterbotham-03-02

winterbotham-03

Charlotte

Winterbotham

Female

21-Aug-15

mon,thurs,fri

Emu

Koala

0110011

$ 8,400.00

#######

yoshihara-03-01

yoshihara-03

Yoshihara

Male

15-Jul-15

thurs,fri,sat

Emu

Koala

1110011

$ 5,775.00

#######

yoshihara-03-02

yoshihara-03

Ayuka

Yoshihara

Female

15-Jul-15

thurs,fri,sat

Emu

Koala

1110011

$ 5,775.00

#######

yost-02-02

yost-02

Cynthia

Yost

Female

8-May-13

mon,tues,thurs,fri,sat

Kangaroo

NOT ALLOWED

0010011

$ 510.00

#######

yost-02-03

yost-02

Juan

Yost

Male

8-May-13

mon,tues,thurs,fri,sat

Kangaroo

NOT ALLOWED

0010011

$ 510.00

#######

yost-02-04

yost-02

Catherine

Yost

Female

8-May-13

mon,tues,thurs,fri,sat

Kangaroo

NOT ALLOWED

0010011

$ 510.00

#######

yost-02-05

yost-02

Angelica

Yost

Female

16-Nov-17

mon,tues,thurs,fri,sat

Platypus

143

0010011

$ 17,040.00

#######

Number of Children By Age

Change

Number of Children after change

Average Number of Weekdays Per Week

Attends Sunday

Income

0.8

2.5

0.4

$ 2,15,040.00

$ 3,66,080.00

$ 8,06,400.00

$ 7,14,240.00

$ 5,44,000.00

$ 2,04,800.00

Total

$28,50,560.00

Scenarios

Current

Low

Mild Increase

Medium Increase

Major Increase

Change

0.8

1.1

1.2

1.4

Average Days

3.5

2.5

3.5

4.5

Saturday

0.6

0.4

0.6

0.7

Sunshine Investment Planning

Account

Investment

Return

Matuarity

Risk Rating

Tax-Free

Central Brisbane Finance

0.08

Short

Low

Yes

North Brisbane Finance

0.09

Short

High

East Brisbane Finance

0.09

Long

Low

South Brisbane Finance

0.09

Long

High

Yes

West Brisbane Finance

0.095

Long

High

Yes

Total Investments

Total Short Term

Total High Risk

Total Tax Free

100000

50000

30000

Available Funds

Total Return

Tax-Free Return

0.3

30000

0.08

2400

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). BISM7202 Excel Essay, Semester 1, 2018.. Retrieved from https://myassignmenthelp.com/free-samples/bism-7202-information-system-for-management.

"BISM7202 Excel Essay, Semester 1, 2018.." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/bism-7202-information-system-for-management.

My Assignment Help (2020) BISM7202 Excel Essay, Semester 1, 2018. [Online]. Available from: https://myassignmenthelp.com/free-samples/bism-7202-information-system-for-management
[Accessed 21 November 2024].

My Assignment Help. 'BISM7202 Excel Essay, Semester 1, 2018.' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/bism-7202-information-system-for-management> accessed 21 November 2024.

My Assignment Help. BISM7202 Excel Essay, Semester 1, 2018. [Internet]. My Assignment Help. 2020 [cited 21 November 2024]. Available from: https://myassignmenthelp.com/free-samples/bism-7202-information-system-for-management.