代写The Palace Theater 代写C/C++语言

- 首页 >> C/C++编程

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. Last Name starting with the letter K



站长地图