Hillside School Case Study Require Document Example | Topics and Well Written Essays - 1000 words

Hillside School Require Document - Case Study Example in while with the after care system, fees that pupils pay in the drop-in basis vary dep peculiaritying on the length of time a student will stay and the level of stage a student is. For instance for preschoolers, time blocks exists from noonday to 130 p.m., noon to 330 p.m. and noon to530 p.m. For kindergarten students, time blocks exist from 130 to 330 p.m. and 130 for 530 p.m. For primary school students, the time is from 330530 p.m. Even much complications exist in the sense that for pre-registered students not registered for the entire afternoon, the 130 to 330 p.m. blocks and 330 to 530 p.m. blocks can be utilized on a drop-in basis.The payment and for that matter billing system does not end with the above discussion. With the payment system, there are different payment options whereby parents who pay the entire amount by August 1 prior to the generate of the school year enjoy a 5 per centum discount on the total fee. P arents who pay over a 10-month period, starting July 1 prior to the start of the school year do not enjoy such discount. Discount also exists for parents who have more than one child enrolled at Hillside School. Because the payment system is generally cumbersome, the billing system is also very(prenominal) cumbersome and complicated. Presently, monthly bills for fees and drop-in care are due on the first of the month, and are distributed to parents one week prior to their being due. Parents with more than one child receive separate bills. The billing is done by the vice principal who is Susan. Susan does the billing using Microsoft Excel whereby she sets up a new workbook for for each one academician year. Within the workbook, she creates monthly worksheets to contain payment records. The Excel worksheet contains one line per student and looks somewhat alike(p) the diagram below.Manual entry is made for each student as and when payment is done. The entry for each student is upd ated twice each month, once to prepare the bills and once to record payment.