Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Frank Hodge

9th edition

290-1259222138, 1259222136, 978-1259222139

Students also viewed these Accounting questions