Order Now
Uncategorized

BISM7202 Excel Assignment Specification Semester 1, 2018

119 min read
Posted on 
April 18th, 2025
Home Uncategorized BISM7202 Excel Assignment Specification Semester 1, 2018
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 50   Holiday Day Holiday Date   Age Day Rate
0 0 0   55874 0.04   Director 12.50%   25 2.50%   younger than 2 years Platypus   CCB Hourly Rate 0.719   New Year’s Day #######   0 #######
18200 0 0.19   62239 0.045   Deputy Director 12.00%   35 3%   between 2 and 3 years Emu   CCB Threshold 45114   Australia Day #######   1 #######
37000 3572 0.325   68603 0.05   Senior Accountant 11.50%   45 3.50%   between 3 and 4 years Koala   CCB Threshold Modifier 6.5E-06   Good Friday #######   2 #######
87000 19822 0.37   72208 0.055   Accountant 11.00%   50 5%   between 4 and 5 years Kangaroo   CCR Rate 0.5   Easter Saturday #######   3  $ 90.00
180000 54232 0.45   77619 0.06   Chef 10.00%               CCR Max 7613   Easter Sunday #######   4  $ 85.00
        84063 0.065   Assistant Chef 9.50%                     Easter Monday #######   5  $ 80.00
        88487 0.07   Child Care Leader 10.00%                     Anzac Day #######   6  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 54  $                                  –    $                                         –    $                                          –    $               –    $                     –    $                                               –                        
Xavier Benstead Male Custodial Engineer   15-Feb-64 54  $                     35,423.00  $                                      0.10  $                                      0.05  $    6,730.37  $                     –    $                               35,422.86                      
Abby Dennis Female Volunteer Carer   18-Sep-72 45  $                                  –    $                                         –    $                                          –    $               –    $                     –    $                                               –                        
Isaac Foelsche Male Custodial Engineer   28-Oct-75 42  $                     35,423.00  $                                      0.10  $                                      0.03  $    6,730.37  $                     –    $                               35,422.88                      
Claudia Philp Female Director TRUE 19-Dec-78 39  $                     89,534.00  $                                      0.13  $                                      0.03  $  52,949.58  $                  0.07  $                               89,533.78                      
Ellie Watson Female Child Care Leader   3-Jul-79 38  $                     48,310.00  $                                      0.10  $                                      0.03  $  19,272.75  $                     –    $                               48,309.87                      
Christian Tancred Male Child Care Leader TRUE 26-Jan-81 37  $                     56,989.00  $                                      0.10  $                                      0.03  $  22,093.43  $                  0.04  $                               56,988.83                      
Madeline Strachan Female Child Care Leader   7-May-82 35  $                     52,487.00  $                                      0.10  $                                      0.03  $  20,630.28  $                     –    $                               52,486.87                      
Taylah McMahon Female Child Care Leader TRUE 11-Mar-83 35  $                     48,310.00  $                                      0.10  $                                      0.03  $  19,272.75  $                     –    $                               48,309.87                      
Sofia Goold-Adams Female Deputy Director TRUE 17-Aug-83 34  $                     74,879.00  $                                      0.12  $                                      0.03  $  27,907.68  $                  0.06  $                               74,878.80                      
Scarlett Seager Female Child Care Worker   4-Sep-85 32  $                     40,750.00  $                                      0.10  $                                      0.03  $  16,815.75  $                     –    $                               40,749.88                      
Sam Roth Female Volunteer Carer TRUE 2-Jun-88 29  $                                  –    $                                         –    $                                          –    $               –    $                     –    $                                               –                        
Rachel Mansergh Female Senior Accountant TRUE 19-Sep-88 29  $                     68,423.00  $                                      0.12  $                                      0.03  $  25,809.48  $                  0.05  $                               68,422.82                      
Nate Marian Male Child Care Worker   4-Dec-88 29  $                     40,750.00  $                                      0.10  $                                      0.03  $  16,815.75  $                     –    $                               40,749.88                      
Alex Dakin Female Child Care Leader TRUE 22-Feb-89 29  $                     56,989.00  $                                      0.10  $                                      0.03  $  22,093.43  $                  0.04  $                               56,988.84                      
Isaac Dumaresq Male Chef TRUE 10-Jul-90 27  $                     54,326.00  $                                      0.10  $                                      0.03  $  21,227.95  $                     –    $                               54,325.88                      
Indiana Gask Female Chef TRUE 4-Jul-91 26  $                     54,326.00  $                                      0.10  $                                      0.03  $  21,227.95  $                     –    $                               54,325.88                      
Ryan Loch Male Child Care Worker TRUE 31-Aug-92 25  $                     40,750.00  $                                      0.10  $                                      0.03  $  16,815.75  $                     –    $                               40,749.88                      
Alice Crawley Female Assistant Chef TRUE 29-Oct-92 25  $                     43,448.00  $                                      0.10  $                                      0.03  $  17,692.60  $                     –    $                               43,447.88                      
Mitchell Grimley Male Assistant Chef TRUE 21-Feb-93 25  $                     43,448.00  $                                      0.10  $                                      0.03  $  17,692.60  $                     –    $                               43,447.88                      
Maddison Stump Female Junior Child Care Worker   1-Oct-93 24  $                     35,862.00  $                                      0.10  $                                          –    $    6,813.78  $                     –    $                               35,861.91                      
Mason Train Male Child Care Worker   1-Oct-94 23  $                     45,876.00  $                                      0.10  $                                          –    $  18,481.70  $                     –    $                               45,875.91                      
Ashton Bethel Male Accountant TRUE 17-Apr-95 23  $                     55,232.00  $                                      0.11  $                                          –    $  21,522.40  $                     –    $                               55,231.89                      
Harry Lutwyche Male Volunteer Carer TRUE 28-Nov-95 22  $                                  –    $                                         –    $                                          –    $               –    $                     –    $                                               –                        
Victoria Lamond Female Junior Child Care Worker   10-Feb-96 22  $                     35,862.00  $                                      0.10  $                                          –    $    6,813.78  $                     –    $                               35,861.91                      
Mariam Betts Female Volunteer Carer TRUE 11-Nov-97 20  $                                  –    $                                         –    $                                          –    $               –    $                     –    $                                               –                        
Sam Wrenfordsley Female Junior Child Care Worker TRUE 12-Feb-98 20  $                     35,862.00  $                                      0.10  $                                          –    $    6,813.78  $                     –    $                               35,861.91                      
Harrison McCallum Male Junior Child Care Worker TRUE 7-Apr-99 19  $                     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 ### 4 30  $                                          55,280.00  $    1,589.60  $           2,764.00  $                               59,633.60                      
barclay-02 Barclay Lucas Barclay Rosalie Barclay ### 2 20  $                                          25,200.00  $       517.36  $           1,260.00  $                               26,977.36                      
barnard-02 Barnard Mitchell Barnard Bethany Abrahamsson ### 4 20  $                                          56,430.00  $               –    $           2,821.50  $                               59,251.50                      
bernardini-02 Bernardini Hiram Bernardini Heather Bernardini ### 1 50  $                                          18,810.00  $    1,403.45  $              940.50  $                               21,153.95                      
bruner-03 Bruner Clarence Bruner Jill Bruner ### 1 40  $                                          22,800.00  $       945.82  $           1,140.00  $                               24,885.82                      
burke-02 Burke Don Burke Norma Burke ### 1 40  $                                          16,020.00  $               –    $              801.00  $                               16,821.00                      
caya-02 Caya Villette Caya Claude Lundqvist ### 1 30  $                                                          –    $         88.52  $                     –    $                                        88.52                      
chien-03 Chien Hui Chien Kuan-Yin Burger ### 2 40  $                                          36,120.00  $               –    $           1,806.00  $                               37,926.00                      
coburn-02 Coburn Hannah Coburn Cedric Coburn ### 2 40  $                                          38,395.00  $               –    $           1,919.75  $                               40,314.75                      
course-01 Course Astolpho Course Clemence Course ### 1 40  $                                          23,760.00  $       506.72  $           1,188.00  $                               25,454.72                      
crombie-03 Crombie Justin Crombie Janis Phillips ### 4 50  $                                          72,430.00  $               –    $           3,621.50  $                               76,051.50                      
dastous-01 Dastous Fletcher Dastous Sabine Dastous ### 1 50  $                                          22,030.00  $               –    $           1,101.50  $                               23,131.50                      
dorrington-01 Dorrington Jacob Dorrington     ### 1 10  $                                                          –    $       406.26  $                     –    $                                     406.26                      
duggan-03 Duggan Jackson Duggan Marlene Duggan ### 4 30  $                                          72,705.00  $               –    $           3,635.25  $                               76,340.25                      
dumaresq-03 Dumaresq Molly Dumaresq   Erickson ### 1 40  $                                          18,180.00  $       251.71  $              909.00  $                               19,340.71                      
duranseau-01 Duranseau Fleurette Duranseau Arienne Dreher ### 1 30  $                                                          –    $       138.03  $                     –    $                                     138.03                      
eatock-01 Eatock Charlotte Eatock Robert Eatock ### 2 30  $                                                          –    $    1,597.00  $                     –    $                                  1,597.00                      
edgerton-01 Edgerton Kiara Edgerton     ### 1 10  $                                                          –    $       290.14  $                     –    $                                     290.14                      
fantl-02 Fantl Natasha Fantl     ### 2 30  $                                          21,150.00  $    2,131.17  $           1,057.50  $                               24,338.67                      
farquhar-03 Farquhar Margaret Farquhar Billy Farquhar ### 2 30  $                                          35,770.00  $    1,105.07  $           1,788.50  $                               38,663.57                      
fichter-02 Fichter Billy Fichter Peggy Fichter ### 3 40  $                                          55,515.00  $               –    $           2,775.75  $                               58,290.75                      
gallegos-03 Gallegos Bertha Gallegos Saville Gallegos ### 2 40  $                                          37,800.00  $               –    $           1,890.00  $                               39,690.00                      
gallop-03 Gallop Annabelle Gallop     ### 2 40  $                                          31,265.00  $    2,564.62  $           1,563.25  $                               35,392.87                      
garreau-01 Garreau Rene Garreau Olympia Garreau ### 1 30  $                                          18,165.00  $       511.30  $              908.25  $                               19,584.55                      
hertzog-03 Hertzog Michael Hertzog Lea Hertzog ### 1 30  $                                          19,260.00  $       493.27  $              963.00  $                               20,716.27                      
isom-01 Isom Natalie Isom     ### 1 50  $                                                          –    $    1,562.87  $                     –    $                                  1,562.87                      
jackey-02 Jackey Chelsea Jackey     ### 2 50  $                                          16,765.00  $    3,625.20  $              838.25  $                               21,228.45                      
johann-01 Johann Dominic Johann Laura Edwards ### 2 50  $                                          19,365.00  $       239.49  $              968.25  $                               20,572.74                      
kamuta-01 Kamuta Yuugou Kamuta Hatomi Kamuta ### 4 40  $                                          33,735.00  $               –    $           1,686.75  $                               35,421.75                      
kasai-03 Kasai Kazumu Kasai Itsuyo Kasai ### 1 20  $                                          20,760.00  $       383.46  $           1,038.00  $                               22,181.46                      
kouno-01 Kouno Genya Kouno Akari Kouno ### 1 40  $                                          15,480.00  $       126.47  $              774.00  $                               16,380.47                      
kraegen-01 Kraegen Taylah Kraegen     ### 1 30  $                                                          –    $    1,012.52  $                     –    $                                  1,012.52                      
langlais-02 Langlais Danielle Langlais Voleta Ponce ### 2 10  $                                          31,715.00  $       258.42  $           1,585.75  $                               33,559.17                      
leveille-02 Leveille Maurice Leveille Germaine Leveille ### 1 50  $                                          18,165.00  $       301.40  $              908.25  $                               19,374.65                      
marian-03 Marian Jai Marian Jonas Lundgren ### 1 20  $                                          16,935.00  $       178.67  $              846.75  $                               17,960.42                      
mcguirk-03 McGuirk Keira McGuirk     ### 2 50  $                                          35,135.00  $    3,793.62  $           1,756.75  $                               40,685.37                      
mckean-03 McKean Julian McKean     ### 1 40  $                                          20,100.00  $    1,573.52  $           1,005.00  $                               22,678.52                      
moore-01 Moore Rey Moore George Chu ### 2 50  $                                          33,285.00  $       829.26  $           1,664.25  $                               35,778.51                      
mowery-02 Mowery Adam Mowery Laura Foerster ### 1 40  $                                          15,120.00  $       183.32  $              756.00  $                               16,059.32                      
nixon-03 Nixon Bernie Nixon     ### 1 50  $                                          17,190.00  $    1,821.84  $              859.50  $                               19,871.34                      
obrien-01 Obrien Pat Obrien Sandra Obrien ### 2 20  $                                          17,190.00  $               –    $              859.50  $                               18,049.50                      
osburne-03 Osburne Nicholas Osburne Jennifer Osburne ### 3 30  $                                          19,500.00  $               –    $              975.00  $                               20,475.00                      
pelensky-02 Pelensky Lily Pelensky Anthony Pelensky ### 1 20  $                                          18,810.00  $       332.51  $              940.50  $                               20,083.01                      
pelsaert-03 Pelsaert Rachel Pelsaert Adam Herrmann ### 3 30  $                                          14,620.00  $               –    $              731.00  $                               15,351.00                      
penfold-02 Penfold Harrison Penfold     ### 1 30  $                                                          –    $       842.87  $                     –    $                                     842.87                      
quynh-03 Quynh Kim Quynh Chu Quynh ### 1 20  $                                                          –    $               –    $                     –    $                                               –                        
racine-03 Racine Aceline Racine Ogier Schmitt ### 1 20  $                                                          –    $               –    $                     –    $                                               –                        
rawson-02 Rawson Adam Rawson Janet Bainton ### 1 20  $                                          14,705.00  $         57.54  $              735.25  $                               15,497.79                      
revell-02 Revell George Revell     ### 2 30  $                                                          –    $    1,799.70  $                     –    $                                  1,799.70                      
robinson-03 Robinson Kristin Robinson Kent Robinson ### 1 30  $                                          20,760.00  $               –    $           1,038.00  $                               21,798.00                      
rodway-03 Rodway Austin Rodway     ### 1 40  $                                          15,480.00  $    1,354.93  $              774.00  $                               17,608.93                      
rule-02 Rule David Rule Alaina Rule ### 3 30  $                                          47,575.00  $    1,207.62  $           2,378.75  $                               51,161.37                      
scherer-03 Scherer Niklas Scherer Leah Scherer ### 1 20  $                                          14,705.00  $       105.65  $              735.25  $                               15,545.90                      
seitz-01 Seitz Patrick Seitz Frank Gordon ### 1 20  $                                          18,165.00  $               –    $              908.25  $                               19,073.25                      
shinosaki-02 Shinosaki Shuuji Shinosaki Kiyone Shinosaki ### 2 40  $                                          35,265.00  $    1,337.19  $           1,763.25  $                               38,365.44                      
stirling-01 Stirling Dennis Stirling Monika Stirling ### 1 30  $                                          22,580.00  $               –    $           1,129.00  $                               23,709.00                      
stopford-02 Stopford Brodie Stopford Natasha Stopford ### 1 40  $                                                          –    $               –    $                     –    $                                               –                        
sylvestre-01 Sylvestre Moses Sylvestre Mary Meekin ### 2 60  $                                          30,610.00  $    2,221.12  $           1,530.50  $                               34,361.62                      
tabata-02 Tabata Michie Tabata Yukihiro Tabata ### 2 50  $                                                          –    $               –    $                     –    $                                               –                        
takayama-01 Takayama Yukio Takayama Yumia Takayama ### 3 60  $                                          37,615.00  $               –    $           1,880.75  $                               39,495.75                      
tani-01 Tani Itsumi Tani Hyouma Kawamura ### 2 40  $                                          38,105.00  $    1,501.49  $           1,905.25  $                               41,511.74                      
tiller-02 Tiller Simone Tiller Marina Tiller ### 1 30  $                                          18,165.00  $       629.87  $              908.25  $                               19,703.12                      
timbery-01 Timbery Eden Timbery Ethan Bentley ### 1 30  $                                          18,920.00  $       673.88  $              946.00  $                               20,539.88                      
valencia-02 Valencia Kathy Valencia Karine Ford ### 1 20  $                                                          –    $               –    $                     –    $                                               –                        
watson-01 Watson Kyle Watson Monique Creech ### 1 10  $                                          18,165.00  $       200.38  $              908.25  $                               19,273.63                      
winterbotham-03 Winterbotham Natasha Winterbotham     ### 1 30  $                                                          –    $    1,073.88  $                     –    $                                  1,073.88                      
yoshihara-03 Yoshihara Tomoka Yoshihara Fukashi Cheng ### 2 30  $                                          37,740.00  $               –    $           1,887.00  $                               39,627.00                      
yost-02 Yost Ruby Yost Salvador Nilsson ### 4 50  $                                          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 19 9 10 5 8 51                                  
Male 11 16 21 5 12 65                                  
Grand Total 30 25 31 10 20 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 4 Kangaroo NOT ALLOWED 27 0011111  $                       3,825.00 ####### ####### ####### #######              
allman-03-04 allman-03 Regina Allman Female 9-Oct-14 mon,tues,sat 3 Koala Kangaroo 68 0011111  $                     10,260.00 ####### ####### ####### #######              
allman-03-03 allman-03 Roxanne Allman Female 2-Nov-15 mon,tues,sat 2 Emu Koala 79 0011111  $                     13,860.00 ####### ####### ####### #######              
allman-03-02 allman-03 Jeffery Allman Male 26-Dec-17 mon,tues,sat 0 Platypus Platypus 100 0011111  $                     20,280.00 ####### ####### ####### #######              
barclay-02-02 barclay-02 Jennifer Barclay Female 19-Feb-17 tues,wed 1 Platypus Emu 0 1001111  $                                  –    $       –    $       –    $       –    $       –                
barclay-02-01 barclay-02 Robert Barclay Male 19-Feb-17 tues,wed 1 Platypus Emu 0 1001111  $                                  –    $       –    $       –    $       –    $       –                
barnard-02-03 barnard-02 Brandon Barnard Male 7-Dec-14 fri,sat 3 Koala Kangaroo 61 1111011  $                     14,130.00 ####### ####### ####### #######              
barnard-02-04 barnard-02 Janis Barnard Female 7-Dec-14 fri,sat 3 Koala Kangaroo 61 1111011  $                     14,130.00 ####### ####### ####### #######              
barnard-02-02 barnard-02 Madeline Barnard Female 7-Dec-14 fri,sat 3 Koala Kangaroo 61 1111011  $                     14,130.00 ####### ####### ####### #######              
barnard-02-05 barnard-02 Robert Barnard Male 7-Dec-14 fri,sat 3 Koala Kangaroo 61 1111011  $                     14,130.00 ####### ####### ####### #######              
bernardini-02-01 bernardini-02 Heath Bernardini Male 29-Nov-16 tues,wed,thurs,fri,sat 1 Platypus Emu 152 1000011  $                     16,610.00 ####### ####### ####### #######              
bruner-03-01 bruner-03 Jonas Bruner Male 13-May-14 mon,tues,wed,sat 3 Koala Kangaroo 8 0001111  $                          900.00 ####### ####### ####### #######              
burke-02-02 burke-02 Micael Burke Male 26-Feb-15 tues,thurs,fri,sat 3 Koala Kangaroo 0 1010011  $                                  –    $       –    $       –    $       –    $       –                
caya-02-01 caya-02 Zurie Caya Female 8-May-15 mon,thurs,fri 2 Emu Koala 4 0110011  $                          630.00 ####### ####### ####### #######              
chien-03-03 chien-03 Ju Chien Female 30-Jul-15 mon,tues,wed,thurs 2 Emu Koala 53 0000111  $                       6,825.00 ####### ####### ####### #######              
chien-03-02 chien-03 Yuan Chien Male 13-Dec-16 mon,tues,wed,thurs 1 Platypus Emu 129 0000111  $                     17,710.00 ####### ####### ####### #######              
coburn-02-02 coburn-02 Karen Coburn Female 25-Jun-15 mon,thurs,fri,sat 2 Emu Koala 33 0110011  $                       4,200.00 ####### ####### ####### #######              
coburn-02-01 coburn-02 Mack Coburn Male 2-Oct-17 mon,thurs,fri,sat 0 Platypus Platypus 88 0110011  $                     13,080.00 ####### ####### ####### #######              
course-01-01 course-01 Roux Course Female 15-Jun-14 mon,tues,wed,sat 3 Koala Kangaroo 28 0001111  $                       3,060.00 ####### ####### ####### #######              
crombie-03-03 crombie-03 Jerome Crombie Male 16-Jul-14 mon,wed,thurs,fri,sat 3 Koala Kangaroo 57 0100011  $                       4,950.00 ####### ####### ####### #######              
crombie-03-04 crombie-03 Richard Crombie Male 16-Jul-14 mon,wed,thurs,fri,sat 3 Koala Kangaroo 57 0100011  $                       4,950.00 ####### ####### ####### #######              
crombie-03-01 crombie-03 Samantha Crombie Female 15-Oct-16 mon,wed,thurs,fri,sat 1 Platypus Emu 120 0100011  $                     12,980.00 ####### ####### ####### #######              
crombie-03-02 crombie-03 Joe Crombie Male 15-Oct-16 mon,wed,thurs,fri,sat 1 Platypus Emu 120 0100011  $                     12,980.00 ####### ####### ####### #######              
dastous-01-01 dastous-01 Fauna Dastous Female 26-Mar-13 mon,tues,thurs,fri,sat 5 NOT ALLOWED NOT ALLOWED 0 0010011  $                                  –    $       –    $       –    $       –    $       –                
dorrington-01-02 dorrington-01 Xander Dorrington Male 29-Jun-15 thurs 2 Emu Koala 8 1110111  $                       4,620.00 ####### ####### ####### #######              
duggan-03-02 duggan-03 Lucas Duggan Male 28-Oct-14 mon,thurs,sat 3 Koala Kangaroo 76 0110111  $                     11,520.00 ####### ####### ####### #######              
duggan-03-03 duggan-03 Shelly Duggan Female 28-Oct-14 mon,thurs,sat 3 Koala Kangaroo 76 0110111  $                     11,520.00 ####### ####### ####### #######              
duggan-03-04 duggan-03 Richard Duggan Male 28-Oct-14 mon,thurs,sat 3 Koala Kangaroo 76 0110111  $                     11,520.00 ####### ####### ####### #######              
duggan-03-05 duggan-03 Charles Duggan Male 28-Oct-14 mon,thurs,sat 3 Koala Kangaroo 76 0110111  $                     11,520.00 ####### ####### ####### #######              
dumaresq-03-01 dumaresq-03 Howard Dumaresq Male 27-Mar-14 mon,tues,fri,sat 4 Kangaroo NOT ALLOWED 0 0011011  $                                  –    $       –    $       –    $       –    $       –                
duranseau-01-01 duranseau-01 Yvon Duranseau Female 19-Apr-14 mon,wed,fri 4 Kangaroo NOT ALLOWED 0 0101011  $                                  –    $       –    $       –    $       –    $       –                
eatock-01-02 eatock-01 Lena Eatock Female 29-Jan-14 mon,fri,sat 4 Kangaroo NOT ALLOWED 0 0111011  $                                  –    $       –    $       –    $       –    $       –                
eatock-01-01 eatock-01 Mary Eatock Female 22-Apr-16 mon,fri,sat 2 Emu Koala 0 0111011  $                                  –    $       –    $       –    $       –    $       –                
edgerton-01-02 edgerton-01 Taylah Edgerton Female 7-Apr-14 fri 4 Kangaroo NOT ALLOWED 0 1111011  $                                  –    $       –    $       –    $       –    $       –                
fantl-02-02 fantl-02 Ellie Fantl Female 22-Oct-15 mon,fri,sat 2 Emu Koala 74 0111011  $                     12,915.00 ####### ####### ####### #######              
fantl-02-03 fantl-02 Alannah Fantl Female 22-Oct-15 mon,fri,sat 2 Emu Koala 74 0111011  $                     12,915.00 ####### ####### ####### #######              
farquhar-03-01 farquhar-03 Nathan Farquhar Male 27-May-13 mon,tues,fri 4 Kangaroo NOT ALLOWED 12 0011011  $                       1,700.00 ####### ####### ####### #######              
farquhar-03-02 farquhar-03 John Farquhar Male 12-Jul-15 mon,tues,fri 2 Emu Koala 32 0011011  $                       5,565.00 ####### ####### ####### #######              
fichter-02-01 fichter-02 Kelvin Fichter Male 5-May-13 mon,tues,fri,sat 4 Kangaroo NOT ALLOWED 5 0011011  $                          510.00 ####### ####### ####### #######              
fichter-02-03 fichter-02 Delia Fichter Female 25-Dec-15 mon,tues,fri,sat 2 Emu Koala 135 0011011  $                     17,745.00 ####### ####### ####### #######              
fichter-02-02 fichter-02 Mark Fichter Male 13-May-17 mon,tues,fri,sat 0 Platypus Platypus 8 0011011  $                       1,200.00 ####### ####### ####### #######              
gallegos-03-01 gallegos-03 Callum Gallegos Male 16-Jun-14 mon,tues,wed,sat 3 Koala Kangaroo 28 0001111  $                       3,150.00 ####### ####### ####### #######              
gallegos-03-02 gallegos-03 Alex Gallegos Male 16-Jun-14 mon,tues,wed,sat 3 Koala Kangaroo 28 0001111  $                       3,150.00 ####### ####### ####### #######              
gallop-03-02 gallop-03 Isabelle Gallop Female 12-Jul-13 tues,wed,thurs,fri 4 Kangaroo NOT ALLOWED 43 1000011  $                       4,505.00 ####### ####### ####### #######              
gallop-03-03 gallop-03 Tyler Gallop Male 11-Dec-15 tues,wed,thurs,fri 2 Emu Koala 128 1000011  $                     16,695.00 ####### ####### ####### #######              
garreau-01-02 garreau-01 Maurelle Garreau Female 12-Jun-15 mon,fri,sat 2 Emu Koala 19 0111011  $                       3,255.00 ####### ####### ####### #######              
hertzog-03-01 hertzog-03 Jan Hertzog Female 30-Jan-17 mon,thurs,fri 1 Platypus Emu 0 0110011  $                                  –    $       –    $       –    $       –    $       –                
isom-01-01 isom-01 Jordon Isom Male 9-Mar-14 tues,wed,thurs,fri,sat 4 Kangaroo NOT ALLOWED 0 1000011  $                                  –    $       –    $       –    $       –    $       –                
jackey-02-02 jackey-02 Dominic Jackey Male 17-Sep-13 tues,wed,thurs,fri,sat 4 Kangaroo NOT ALLOWED 101 1000011  $                       8,415.00 ####### ####### ####### #######              
jackey-02-03 jackey-02 Danielle Jackey Female 19-Jun-15 tues,wed,thurs,fri,sat 2 Emu Koala 37 1000011  $                       3,780.00 ####### ####### ####### #######              
johann-01-02 johann-01 Raison Johann Male 4-Feb-13 mon,tues,wed,thurs,fri 5 NOT ALLOWED NOT ALLOWED 0 0000011  $                                  –    $       –    $       –    $       –    $       –                
johann-01-03 johann-01 Rohan Johann Male 26-Feb-15 mon,tues,wed,thurs,fri 3 Koala Kangaroo 0 0000011  $                                  –    $       –    $       –    $       –    $       –                
kamuta-01-01 kamuta-01 Tsuyuha Kamuta Female 15-Jan-13 mon,tues,wed,fri 5 NOT ALLOWED NOT ALLOWED 0 0001011  $                                  –    $       –    $       –    $       –    $       –                
kamuta-01-04 kamuta-01 Moeka Kamuta Female 11-Oct-14 mon,tues,wed,fri 3 Koala Kangaroo 93 0001011  $                     10,440.00 ####### ####### ####### #######              
kamuta-01-03 kamuta-01 Gakuto Kamuta Male 20-Nov-15 mon,tues,wed,fri 2 Emu Koala 116 0001011  $                     15,120.00 ####### ####### ####### #######              
kamuta-01-02 kamuta-01 Sakio Kamuta Female 28-Jul-17 mon,tues,wed,fri 0 Platypus Platypus 52 0001011  $                       7,800.00 ####### ####### ####### #######              
kasai-03-01 kasai-03 Erisa Kasai Female 24-Sep-14 mon,wed 3 Koala Kangaroo 41 0101111  $                       9,360.00 ####### ####### ####### #######              
kouno-01-02 kouno-01 Shima Kouno Female 27-Feb-16 tues,thurs,fri,sat 2 Emu Koala 0 1010011  $                                  –    $       –    $       –    $       –    $       –                
kraegen-01-01 kraegen-01 Josphine Kraegen Female 18-Jul-14 thurs,fri,sat 3 Koala Kangaroo 35 1110011  $                       5,130.00 ####### ####### ####### #######              
langlais-02-02 langlais-02 Henry Langlais Male 25-Aug-13 thurs 4 Kangaroo NOT ALLOWED 15 1110111  $                       7,140.00 ####### ####### ####### #######              
langlais-02-03 langlais-02 Courtland Langlais Male 31-Oct-15 thurs 2 Emu Koala 24 1110111  $                     13,650.00 ####### ####### ####### #######              
leveille-02-02 leveille-02 Edmee Leveille Female 27-Sep-13 mon,tues,wed,thurs,sat 4 Kangaroo NOT ALLOWED 108 0000111  $                       9,095.00 ####### ####### ####### #######              
marian-03-02 marian-03 Sean Marian Male 16-Nov-14 thurs,sat 3 Koala Kangaroo 55 1110111  $                     12,780.00 ####### ####### ####### #######              
mcguirk-03-01 mcguirk-03 Donald McGuirk Male 3-Sep-13 mon,tues,thurs,fri,sat 4 Kangaroo NOT ALLOWED 91 0010011  $                       7,565.00 ####### ####### ####### #######              
mcguirk-03-02 mcguirk-03 Barry McGuirk Male 13-Aug-15 mon,tues,thurs,fri,sat 2 Emu Koala 77 0010011  $                       7,875.00 ####### ####### ####### #######              
mckean-03-02 mckean-03 Alyssa McKean Female 9-Aug-15 tues,wed,thurs,fri 2 Emu Koala 59 1000011  $                       7,665.00 ####### ####### ####### #######              
moore-01-01 moore-01 Billy Moore Male 3-Dec-12 mon,wed,thurs,fri,sat 5 NOT ALLOWED NOT ALLOWED 155 0100011  $                     12,240.00 #######  $       –    $       –   #######              
moore-01-02 moore-01 Sonja Moore Female 3-Dec-12 mon,wed,thurs,fri,sat 5 NOT ALLOWED NOT ALLOWED 155 0100011  $                     12,240.00 #######  $       –    $       –   #######              
mowery-02-01 mowery-02 Jason Mowery Male 6-Aug-14 mon,wed,thurs,sat 3 Koala Kangaroo 57 0100111  $                       6,300.00 ####### ####### ####### #######              
nixon-03-02 nixon-03 Julian Nixon Male 11-Feb-14 mon,tues,thurs,fri,sat 4 Kangaroo NOT ALLOWED 0 0010011  $                                  –    $       –    $       –    $       –    $       –                
obrien-01-01 obrien-01 Deborah Obrien Female 3-Aug-14 mon,sat 3 Koala Kangaroo 27 0111111  $                       6,210.00 ####### ####### ####### #######              
obrien-01-02 obrien-01 Kevin Obrien Male 7-May-16 mon,sat 1 Platypus Emu 2 0111111  $                          660.00 ####### ####### ####### #######              
osburne-03-02 osburne-03 Abigail Osburne Female 17-Feb-13 wed,fri,sat 5 NOT ALLOWED NOT ALLOWED 0 1101011  $                                  –    $       –    $       –    $       –    $       –                
osburne-03-03 osburne-03 Elizabeth Osburne Female 17-Feb-13 wed,fri,sat 5 NOT ALLOWED NOT ALLOWED 0 1101011  $                                  –    $       –    $       –    $       –    $       –                
osburne-03-01 osburne-03 Ryder Osburne Male 5-Dec-14 wed,fri,sat 3 Koala Kangaroo 93 1101011  $                     13,950.00 ####### ####### ####### #######              
pelensky-02-02 pelensky-02 Jake Pelensky Male 16-Dec-13 thurs,fri 4 Kangaroo NOT ALLOWED 64 1110011  $                     13,855.00 ####### ####### ####### #######              
pelsaert-03-02 pelsaert-03 Sabrine Pelsaert Female 16-Mar-16 mon,tues,thurs 2 Emu Koala 0 0010111  $                                  –    $       –    $       –    $       –    $       –                
pelsaert-03-03 pelsaert-03 Pamala Pelsaert Female 16-Mar-16 mon,tues,thurs 2 Emu Koala 0 0010111  $                                  –    $       –    $       –    $       –    $       –                
pelsaert-03-04 pelsaert-03 Bradley Pelsaert Male 16-Mar-16 mon,tues,thurs 2 Emu Koala 0 0010111  $                                  –    $       –    $       –    $       –    $       –                
penfold-02-01 penfold-02 Thomas Penfold Male 16-Jan-13 mon,wed,sat 5 NOT ALLOWED NOT ALLOWED 0 0101111  $                                  –    $       –    $       –    $       –    $       –                
quynh-03-02 quynh-03 Tinh Quynh Male 10-Feb-15 mon,tues 3 Koala Kangaroo 0 0011111  $                                  –    $       –    $       –    $       –    $       –                
racine-03-02 racine-03 Nicholas Racine Male 24-Jul-13 wed,thurs 4 Kangaroo NOT ALLOWED 24 1100111  $                       5,185.00 ####### ####### ####### #######              
rawson-02-01 rawson-02 Bill Rawson Male 5-Apr-13 tues,fri 5 NOT ALLOWED NOT ALLOWED 0 1011011  $                                  –    $       –    $       –    $       –    $       –                
revell-02-02 revell-02 Scott Revell Male 25-Jan-14 tues,thurs,fri 4 Kangaroo NOT ALLOWED 0 1010011  $                                  –    $       –    $       –    $       –    $       –                
revell-02-03 revell-02 Andrew Revell Male 27-Jul-17 tues,thurs,fri 0 Platypus Platypus 39 1010011  $                       7,680.00 ####### ####### ####### #######              
robinson-03-01 robinson-03 Kimberly Robinson Female 26-Nov-14 mon,wed,thurs 3 Koala Kangaroo 89 0100111  $                     13,320.00 ####### ####### ####### #######              
rodway-03-02 rodway-03 Angus Rodway Male 21-Jun-15 mon,tues,wed,fri 2 Emu Koala 31 0001011  $                       3,990.00 ####### ####### ####### #######              
rule-02-02 rule-02 Marcos Rule Male 27-Sep-13 mon,tues,thurs 4 Kangaroo NOT ALLOWED 64 0010111  $                       9,095.00 ####### ####### ####### #######              
rule-02-03 rule-02 Albert Rule Male 27-Sep-13 mon,tues,thurs 4 Kangaroo NOT ALLOWED 64 0010111  $                       9,095.00 ####### ####### ####### #######              
rule-02-04 rule-02 Wanda Rule Female 27-Sep-13 mon,tues,thurs 4 Kangaroo NOT ALLOWED 64 0010111  $                       9,095.00 ####### ####### ####### #######              
scherer-03-01 scherer-03 Diana Scherer Female 6-Jul-15 mon,wed 2 Emu Koala 19 0101111  $                       5,145.00 ####### ####### ####### #######              
seitz-01-02 seitz-01 Archer Seitz Male 14-Jul-15 tues,fri 2 Emu Koala 22 1011011  $                       5,775.00 ####### ####### ####### #######              
shinosaki-02-01 shinosaki-02 Jin Shinosaki Male 25-Jul-14 wed,thurs,fri,sat 3 Koala Kangaroo 50 1100011  $                       5,580.00 ####### ####### ####### #######              
shinosaki-02-02 shinosaki-02 Kiyoki Shinosaki Female 17-Nov-16 wed,thurs,fri,sat 1 Platypus Emu 114 1100011  $                     15,730.00 ####### ####### ####### #######              
stirling-01-01 stirling-01 Oscar Stirling Male 7-Apr-15 mon,fri,sat 3 Koala Kangaroo 0 0111011  $                                  –    $       –    $       –    $       –    $       –                
stopford-02-01 stopford-02 Hudson Stopford Male 30-Nov-12 mon,wed,thurs,fri 5 NOT ALLOWED NOT ALLOWED 122 0100011  $                     12,160.00 #######  $       –    $       –   #######              
sylvestre-01-02 sylvestre-01 Brendan Sylvestre Male 6-Nov-14 mon,tues,wed,thurs,fri,sat 3 Koala Kangaroo 163 0000011  $                     12,060.00 ####### ####### ####### #######              
sylvestre-01-03 sylvestre-01 Jane Sylvestre Female 24-Feb-17 mon,tues,wed,thurs,fri,sat 1 Platypus Emu 0 0000011  $                                  –    $       –    $       –    $       –    $       –                
tabata-02-01 tabata-02 Sei Tabata Male 19-Mar-17 tues,wed,thurs,fri,sat 1 Platypus Emu 0 1000011  $                                  –    $       –    $       –    $       –    $       –                
tabata-02-02 tabata-02 Sato Tabata Female 19-Mar-17 tues,wed,thurs,fri,sat 1 Platypus Emu 0 1000011  $                                  –    $       –    $       –    $       –    $       –                
takayama-01-03 takayama-01 Makito Takayama Male 29-Dec-13 mon,tues,wed,thurs,fri,sat 4 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 2 Emu Koala 60 0000011  $                       5,145.00 ####### ####### ####### #######              
takayama-01-01 takayama-01 Issei Takayama Male 16-Sep-17 mon,tues,wed,thurs,fri,sat 0 Platypus Platypus 120 0000011  $                     11,880.00 ####### ####### ####### #######              
tani-01-03 tani-01 Takato Tani Male 16-May-13 tues,wed,thurs,fri 4 Kangaroo NOT ALLOWED 10 1000011  $                       1,020.00 ####### ####### ####### #######              
tani-01-02 tani-01 Nina Tani Female 30-Jun-15 tues,wed,thurs,fri 2 Emu Koala 36 1000011  $                       4,725.00 ####### ####### ####### #######              
tiller-02-02 tiller-02 Andrew Tiller Male 4-Jun-16 mon,wed,thurs 1 Platypus Emu 16 0100111  $                       2,750.00 ####### ####### ####### #######              
timbery-01-02 timbery-01 Timothy Timbery Male 27-Jan-15 tues,wed,thurs 3 Koala Kangaroo 0 1000111  $                                  –    $       –    $       –    $       –    $       –                
valencia-02-02 valencia-02 Jordon Valencia Male 26-Oct-15 mon,tues 2 Emu Koala 49 0011111  $                     13,335.00 ####### ####### ####### #######              
watson-01-01 watson-01 William Watson Male 18-Apr-15 wed 3 Koala Kangaroo 0 1101111  $                                  –    $       –    $       –    $       –    $       –                
winterbotham-03-02 winterbotham-03 Charlotte Winterbotham Female 21-Aug-15 mon,thurs,fri 2 Emu Koala 48 0110011  $                       8,400.00 ####### ####### ####### #######              
yoshihara-03-01 yoshihara-03 Ei Yoshihara Male 15-Jul-15 thurs,fri,sat 2 Emu Koala 33 1110011  $                       5,775.00 ####### ####### ####### #######              
yoshihara-03-02 yoshihara-03 Ayuka Yoshihara Female 15-Jul-15 thurs,fri,sat 2 Emu Koala 33 1110011  $                       5,775.00 ####### ####### ####### #######              
yost-02-02 yost-02 Cynthia Yost Female 8-May-13 mon,tues,thurs,fri,sat 4 Kangaroo NOT ALLOWED 7 0010011  $                          510.00 ####### ####### ####### #######              
yost-02-03 yost-02 Juan Yost Male 8-May-13 mon,tues,thurs,fri,sat 4 Kangaroo NOT ALLOWED 7 0010011  $                          510.00 ####### ####### ####### #######              
yost-02-04 yost-02 Catherine Yost Female 8-May-13 mon,tues,thurs,fri,sat 4 Kangaroo NOT ALLOWED 7 0010011  $                          510.00 ####### ####### ####### #######              
yost-02-05 yost-02 Angelica Yost Female 16-Nov-17 mon,tues,thurs,fri,sat 0 Platypus 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 7   0.8 5     2.5 0.4    $  2,15,040.00                          
1 13     10            $  3,66,080.00                          
2 30     24            $  8,06,400.00                          
3 31     24            $  7,14,240.00                          
4 25     20            $  5,44,000.00                          
5 10     8            $  2,04,800.00                          
                                               
                  Total  $28,50,560.00                          
                                               
                                               
                                               
                                               
                                               
                                               
  Scenarios Current Low Mild Increase Medium Increase Major Increase Major Increase                                
  Change 1 0.8 1.1 1.2   1.4                                
  Average Days 3.5 2.5 3.5 4   4.5                                
  Saturday 0.6 0.4 0.6 0.6   0.7                                
                                               
                                               
                                               
Sunshine Investment Planning                              
Account Investment Return Matuarity Risk Rating Tax-Free                              
Central Brisbane Finance   0.08 Short 1 Low 0 Yes 1                              
North Brisbane Finance   0.09 Short 1 High 1 No 0                              
East Brisbane Finance   0.09 Long 0 Low 0 No 0                              
South Brisbane Finance   0.09 Long 0 High 1 Yes 1                              
West Brisbane Finance   0.095 Long 0 High 1 Yes 1                              
                                               
Total Investments   Total Short Term Total High Risk Total Tax Free                              
100000   1 50000 0 0 1 30000                              
Available Funds                                            
                                             
  Total Return         Tax-Free Return                              
  0.3 30000         0.08 2400                              

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Calculate the price
Pages (275 words)
$0.00
Course Scholars
Company
Legal
How Our Service is Used:
Course Scholars essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Course Scholars does not endorse or condone any type of plagiarism.
Subscribe
No Spam
© 2025 Course Scholars. All rights reserved.
Course Scholars will be listed as ‘Course Scholars’ on your bank statement.

Order your essay today and save 15% with the discount code GINGER

Order Now