You recently accepted the controller position for Java the Hut, a regional coffee chain. The owner informs you that a complete financial statement package will be required for a new bank loan package.Prior to your arrival, the company had one accountant and relied heavily on the auditors in the preparation of financial statements. With the new controller position, the expectation is that you will assume the preparation of financial statements.On your first day of work on April 1, 2012, the Java the Hut accountant informs you that there were a number of transactions in the first quarter of 2012 that she was unsure of the appropriate accounting. Consequently, she recorded the cash activity in Other Assets - Holding account as a temporary holding account. The good news is that the Java the Hut accountant maintained excellent detail of the various transactions and has a series of supporting schedules for you.Project Requirements1.Prepare the appropriate journal entries to recognize the first quarter transactions, currently reported in Other Assets - Holding in the balance sheet.2.Prepare consolidating worksheets for the income statement for the first quarter of 2012, the retained earnings for the first quarter of 2012, for the balance sheet as of March 31, 2012, and the cash flow statement for the first quarter of 2012.Adjusting entries from 1 above should be reflected in the appropriate company general ledger.All inter-company transactions and balances should be eliminated.Consolidating worksheets should utilize Excel.Calculations supporting eliminations should be included. 3.Prepare consolidated financial statements for the bank reporting, including: Income Statement for the first quarter of 2012 (Multi-Step Format)Balance Sheet as of March 31, 2012 (Classified Format)Statement of Retained Earnings as of March 31, 2012.Statement of Cash Flows for the first quarter of 2012.Financial Statements should utilize Excel.Schedules AttachedSchedule 1 Other assets - holding analysisSchedule 2 Trial Balance of New Castle Coffee as of 01/01/12.Schedule 2A New Castle Coffee Acquisition Support.Schedule 3Trial Balance of New Castle Coffee as of 03/31/12.Schedule 4Trial Balance of Java the Hut as of 12/31/11.Schedule 5Trial Balance of Java the Hut as of 03/31/12.Schedule 6Intercompany Transactions - first quarter 2012.

 

 

Dr Ho Coaching Centre gives lessons on three programming languages: Python, Java and C++. They have divided each programming language into a number of topics such as if-statement, while-loop, and for-loop. They teach each topic through a standard one-hour long lesson.

Students can request any number of additional hours on the topics that they have already studied. They can also request for any number of practice tests at the centre.

The centre charges for each standard lesson, additional hour and test according to the table below.

 

Python	$300	$200	$250
Java	$200	$150	$150
C++	$175	$175	$170

For example, if a student studying Python requests 20 topics, 10 additional hours and 5 tests the total tuition fee for him/her will be ($6,000 + $2,000 + $1,250) = $9,250.

The Principal of Dr Ho Coaching Centre (Dr Wise Ho) contracts you to build a computer system, Power of Knowledge (PK), for them in Python.

PK will ask them to input, for a student, the name of the programming language that the student wants to study, the number of topics/lessons that he/she wants to study, the number of additional hours that he/she wants to study, and the number of tests that he/she wants to sit for. Based on the inputs the program will compute and display the tuition fee for the lessons, additional hours and tests. It will also display the total tuition fee.

PK will then ask Dr Ho "Do you want to compute the tuition fee for another student?"

If Dr Ho wants to compute the tuition fee for another student (i.e. enters "Y" or "y" to the question above), PK will ask for all these inputs again for the new student, and compute and display the total tuition fee for the new student. The program will then again ask Dr Ho "Do you want to compute the tuition fee for another student?"

The above process will continue as long as they want to compute the tuition fee for another student. However, if Dr Ho does not want to compute the tuition fee for another student (i.e. he enters anything other than "Y" or "y") then the program will exit.

Dr Ho also imposes the minimum number of lessons, additional hours and tests, that a student must enrol for, as follows.

Python	5	5	5
Java	4	10	2
C++	6	7	2

If a student wants to take an invalid number of lessons, additional hours and/or tests, PK will ask to enter them again. For example, when PK prints "Enter the number of lessons:" if a student studying Python wants to enter 4 then PK will again print "Enter the number of lessons:" until a valid number of lessons is entered.

A typical example of the display of your program can be as follows. Your program MUST follow the same display style.

---------------------------------------------------------------------------------------------- 
Welcome to Dr Ho Coaching Centre
-----------------------------------------------------------------------------------------------

Enter the name of the programming language: Python
Enter the number of lessons: 4
Enter the number of lessons: 20
Enter the additional hours: 10
Enter the number of tests: 5

Tuition fee for the lessons (in dollars): 6000
Tuition fee for additional hours (in dollars): 2000
Tuition fee for the tests (in dollars): 1250

Total tuition fee (in dollars): 9250

Do you want to compute the tuition fee for another student? Y

Enter the name of the programming language: Java
Enter the number of lessons: 25
Enter the additional hours: 10
Enter the number of tests: 10

Tuition fee for the lessons (in dollars): 5000
Tuition fee for additional hours (in dollars): 1500
Tuition fee for the tests (in dollars): 1500

Total tuition fee (in dollars): 8000

Do you want to compute the tuition fee for another student? N

Good Bye.

Write an algorithm in structured English (pseudocode) that describes the steps required to perform the task specified. Some examples of pseudocode can be found athttp://www.unf.edu/~broggio/cop2221/2221pseu.htm

Select 3 sets of test data that will demonstrate the correct 'normal' operation of your program. Select another 2 sets of test data that will demonstrate the "abnormal" operation of your program. Set these out in the same format as in Assignment 1.

Implement your algorithm in Python.

Avoid duplicate code. For example, DO NOT calculate the tuition fee in multiple places in your code.

Comment your code as necessary to explain it clearly.

Run your program using the test data you have selected and save the output it produces in a text file.