Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The La Image Private Elementary School has resumed its enrollment for the upcoming school year. There is space for 7363 students. The proposed class sizes
The La Image Private Elementary School has resumed its enrollment for the upcoming school year. There is space for 7363 students. The proposed class sizes are as follows:- Grade 7 with 17% of the schools population Grade 6 will be 22% Grade 5 will be 15% Grade 4 will be 20% Grade 3 will be 13% There is a Grade 3 Gifted Program which will have 9% of the enrolment. The remainder of the enrolment will be reserved for students with learning difficulties/disabilities (LDD). It has been debated widely and the School Board has set up the female/male split at 50/50 or as close to 50/50 as possible. The per semester fees is fixed as follows: Grades 3,4 and 5 pays $4000.00; grade 6 and 7 pays $4750.00; Gifted program costs $6000.00 and LDD students pays $2000.00 Your task is to set up a spreadsheet that shows the breakdown by grade, by %, and showing student grade total ALSO you must show the split by % by grade and the male/female student count by grade. Your calculations must also show the school's income for the semester by grades and a total earnings for the school for the semester. Your sheet must be easy to read and easy to understand
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started