Java Python EXERCISE 1 – The Palace Theater
The Palace Theater is a small movie house that shows almost-current releases at weekday evening, weekend matinee, and weekend evening screenings. Three types of tickets are sold at each presentation: general admission, senior citizen, and children. The theater management has asked you to prepare a worksheet, based on the revenue from a typical week that can be used in reevaluating its ticket structure. During an average week, weekly evening shows generate $7,540 from general admission ticket sales, $3,575 from senior citizen ticket sales, and $1,375 from children ticket sales. Weekend matinee shows make $5,500 from general admission ticket sales, $1,950 from senior citizen ticket sales, and $2,500 from children ticket sales. Weekend evening shows earn $8,540 from general admission ticket sales, $7,350 from senior citizen ticket sales, and $1,100 from children ticket sales. Prepare a worksheet that includes total revenues for each type of ticket and each presentation time. The weekend matinee staff will receive a bonus if ticket sales for that period exceeds $10,000 and the entire team will receive a bonus if the Grand Total exceeds $40,000.
EXERCISE 2 – Company Recruitment
A company evaluates new graduates for positions according to three criteria. If the candidate has a Grade Point Average (GPA) of at least 3.3, the candidate receives 1 point. On the interview, candidates who score 7 or 8 (out of 10) receive 1 point; candidates who score 9 or 10 receive 2 points. The company gives an aptitude test as well. A candidate who scores above 85 gets 1 point.
The company adds up the points to obtain a candidate’s rating. A candidate who receives a rating of 0, 1, or 2 points is not given a job offer. A candidate who receives 3 points is given an offer as a Junior Salesperson. A candidate who receives 4 points is given an offer as a Fast-Track Manager in Training.
Create a worksheet that allows the Human Resources Department to enter in a candidate’s name, GPA, interview score, and aptitude score and determines the employment decision.
Use the following information to test your formula
• John, GPA 3.5, Interview score 9, Aptitude score 86
• Lin, GPA 2.0, Interview score 8, Aptitude score 90
• Sandy, GPA 3.7, Interview score 7, Aptitude score 86
EXERCISE 3 – Woodbridge Furniture
The Woodbridge Furniture Company has decided to pay a 5% commission to its salespeople to stimulate sales. The company currently pays each employee a base salary. The management has projected each employee’s sales for the next quarter. This information - employee name, employee base salary, and projected sales – follows: Tim Baker, $6,000.00, $225,456.00; Joseph Learner, $7,500.00, $264,888.00; Barbara Albright, $8,500.00, $235,250.00; Lynn Mourissee, $7,250.00, $258,450.00; Richard Noble, $4,250.00, $325,456.00. With this data, you have been asked to develop a worksheet calculating the amount of commission and the quarterly salary for each employee.
Include a Total, Average Value, Highest Value, and Lowest Value, for Employee Base Salary, Commission Amount, and Quarterly Salary. With the Quarterly Salary, use HLOOKUP to find the rating for each employee based on the following: $0 - 16999: *, $17,000 - $17999: **, $18,000 - $18,999: ***, $19,000 – $19,999: ****, and above or equal to $20,000: *****. Save this workbook as “Furniture”.
EXERCISE 4 – Mama
Your mother gives you 600,000 Baht as a gift for your graduation. You have a job that pays you 25,000 Baht per month. You plan to buy a new house, which costs 2,000,000 Baht. However, you don’t have enough money, so you use 100,000 Baht (from your mom) as down payment towards the house and you borrow the rest from your friend. Your friend gives you a loan with 6% interest rate and lets you choose how you want to pay back the loan (annually, semi-annually, quarterly, or monthly) within 20 years. Calculate how much you have to pay annually, semi-annually, quarterly and monthly? After you have calculated, you decide to pay your friend back in monthly installments. Moreover, you want to save money for your future as well. As a result, you deposit the money that your mother gave (less the down payment) and each month what is left from your salary after paying back the loan and your expense, into the bank. The bank gives you a 5% annual interest rate. Assume that your expense is 10,000 Baht per month. How much can you save after 20 years?
Exercise 5: Personal Finance
1. If you invest $1,000,000 for 10 years with interest earned monthly, what interest rate is necessary to achieve a future value of $1,938,621?
2. You want to have $55,000 in 10 years to pay for a new car. You have committed to saving $300 per month. What stated annual interest rate will allow you to meet your goal?
3. You estimate that you will need $25,000 to take your family on a memorable vacation. Assume a stated annual interest rate of 6% and monthly contributions of $700 to a savings account. How many months will it take to achieve your goal?
4. You have taken a loan of $50,000 and have decided to pay back $1,000 per month. Interest is charged at a rate of 4%, and the payment to the loan is to be made at the beginning of each month. Calculate the number of months required for you to pay off the loan.
5. You want to purchase an insurance annuity that will pay $600 a month, for the next 20 years. At an annual interest rate of 6%, how much does the annuity cost?
Exercise 7 – Low-cost airline
Shankly Air is a new low cost airline carrier. As a new low cost airline, they offer just two routes, which are Bangkok to Liverpool and Liverpool to Bangkok. The ticket price will vary depending on the period (morning, noon, evening), package (pro, eco, flex), and destination (Liverpool or Bangkok).
Bangkok-Liverpool | Shankly Pro | Shankly Eco | Shankly Flex |
Morning | 780 | 1200 | 2200 |
Noon | 790 | 1500 | 2300 |
Evening | 830 | 1600 | 2400 |
|
|
|
|
Liverpool-Bangkok | Shankly Pro | Shankly Eco | Shankly Flex |
Morning | 800 | 1280 | 2380 |
Noon | 820 | 1680 | 2500 |
Evening | 860 | 1780 | 2580 |
Shankly Air also offers 3 additional options to choose from:
- Shankly Sure: Bag insurance - 200 Baht
- Shankly Baggage: Additional 5 kgs - 300 Baht
- Shankly Airport-to-town: Taxi from airport to town - 500 Baht
If customers have a membership card, there will receive a 25 percent discount. There will be 10 percent airport tax to calculate as well. Calculate the final ticket price for Bob Paisley:
1. He will travel from Liverpool to Bangkok in the morning with the Shankly Flex Package
2. He is a member of Shankly Air
3. He will get Shankly Sure and Shankly Airport-to-town as additional options
Exercise 8 – Fruit Sales
Copy the following data into Excel and use Advanced Filter to display the results for the questions listed below:
First Name | Last Name | Product | Sales | Continent | Quarter |
Jurgen | Klopp | Apple | 100000 | North America | Q1 |
Jordan | Henderson | Banana | 250000 | North America | Q1 |
Sadio | Mane | Strawberry | 2589641 | Asia | Q1 |
Mohamed | Salah | Banana | 2235 | Europe | Q2 |
Roberto | Firmino | Apple | 1258 | Europe | Q2 |
Virgil | Van Dijk | Strawberry | 45895 | Asia | Q1 |
Gini | Wijnaldum | Apple | 47468 | Australia | Q3 |
Trent | Alexander-Arnold | Banana | 569875 | North America | Q3 |
James | Milner | Strawberry | 23468 | Europe | Q4 |
Naby | Keita | Apple | 25984 | South America | Q4 |
1. Sales greater than 500,000
2. Salah (Last name) and Europe
3. Strawberry, Q1, and Sales greater than 50,000
4