1.
Ron's book store has several sales employees, who get their salary on the basis of total sales
done by them. There are different sales commission rates that are applied, depending on the
monthly sales done by an employee. The different commission rates are shown in the following
table.
Sales Amount Commission Rate
$- 0%
$70,000 2%
$100,000 5%
$150,000 6%
Ron captures weekwise sales of the employees in the Weekly Sales worksheet. The commission
rate is captured in the Commission Rate worksheet. The bonus levels are defined in the Payroll
worksheet. Help Ron to calculate the salaries of his employees.
ANS:
2.
Consider the scenario of Hewitt Automobiles, a car manufacturing company in Texas. The
manufacturing details of cars of the last financial year are stored in a Microsoft Excel worksheet.
Samantha, the Plant Head, wants to analyze the manufacturing details of last year in order to take
strategic decisions for the present year. Samantha wants to find the maximum and minimum
number of cars that were manufactured for each model. In addition, she wants to know the total
number of cars manufactured last year. Moreover, she wants to find the average production of
cars in the previous year. You are required to help Samantha to perform the tasks.
ANS:
3.
Consider a scenario of Optimystic Inc. Kathy, the Delivery Manager of the company, handles the
details of the all the projects assigned to different project managers. She maintains the details,
such as the project name, the project id, the manger's name, the team members' names, the start
date of project, and the end date of project in a Microsoft Excel worksheet. She wants to find the
number of days spent to complete the project. You are required to help Kathy to accomplish the
task.
ANS:
4.
Consider the scenario of JF KennedyAirport, which is one of the famous airports of the US. Karen,
the Air TrafficController at the JF Kennedy airport, maintains a record of all the flights ona daily
basis in a Microsoft Excel worksheet. Whenever a flight arrives ordeparts, she records down the
time. Help Karen to record the current date in acell above the flight schedule details and record the
arrival time, 11:30 PMfor British Airways - flight number 65876.
ANS:
5.
Consider the scenario of TetraGraph Steel Production Company. Due to competition in the
market, the company is facing a financial crisis. Robert, the Finance Manager, consults a loan
granting company, Quin Financial Services, to take a loan to sustain in the market. For this
purpose, he meets Frank, the Loan Officer of Quin Financial Services, to inquire about the loan
details. Quin Financial Services accepts to offer a loan of $ 3.2 million for a period of 12 year at
the annual rate of interest of 7%. Robert wants to find the monthly installments he needs to pay.
Help Robert to calculate the monthly installments.
ANS:
6.
Danny is planning to spend his summer vacation in Europe. For this purpose, he booked airline
tickets, hotel rooms, and tourist guides. After spending his money on bookings, he finds that his
digital camcorder is not working. He checks the price of the camcorder in an electronics store. Its
price is $ 375. He cannot buy a new camcorder as he does not have any money left. So, he
decides to buy it on an installment scheme. He is willing to pay $ 40 each month. The store offers
the scheme at an annual interest of 6%. You are required to help Danny calculate the duration of
time period he is required to pay the installments.
ANS:
Ron's book store has several sales employees, who get their salary on the basis of total sales
done by them. There are different sales commission rates that are applied, depending on the
monthly sales done by an employee. The different commission rates are shown in the following
table.
Sales Amount Commission Rate
$- 0%
$70,000 2%
$100,000 5%
$150,000 6%
Ron captures weekwise sales of the employees in the Weekly Sales worksheet. The commission
rate is captured in the Commission Rate worksheet. The bonus levels are defined in the Payroll
worksheet. Help Ron to calculate the salaries of his employees.
ANS:
CLICK HERE
2.
Consider the scenario of Hewitt Automobiles, a car manufacturing company in Texas. The
manufacturing details of cars of the last financial year are stored in a Microsoft Excel worksheet.
Samantha, the Plant Head, wants to analyze the manufacturing details of last year in order to take
strategic decisions for the present year. Samantha wants to find the maximum and minimum
number of cars that were manufactured for each model. In addition, she wants to know the total
number of cars manufactured last year. Moreover, she wants to find the average production of
cars in the previous year. You are required to help Samantha to perform the tasks.
ANS:
CLICK HERE
3.
Consider a scenario of Optimystic Inc. Kathy, the Delivery Manager of the company, handles the
details of the all the projects assigned to different project managers. She maintains the details,
such as the project name, the project id, the manger's name, the team members' names, the start
date of project, and the end date of project in a Microsoft Excel worksheet. She wants to find the
number of days spent to complete the project. You are required to help Kathy to accomplish the
task.
ANS:
CLICK HERE
4.
Consider the scenario of JF KennedyAirport, which is one of the famous airports of the US. Karen,
the Air TrafficController at the JF Kennedy airport, maintains a record of all the flights ona daily
basis in a Microsoft Excel worksheet. Whenever a flight arrives ordeparts, she records down the
time. Help Karen to record the current date in acell above the flight schedule details and record the
arrival time, 11:30 PMfor British Airways - flight number 65876.
ANS:
CLICK HERE
5.
Consider the scenario of TetraGraph Steel Production Company. Due to competition in the
market, the company is facing a financial crisis. Robert, the Finance Manager, consults a loan
granting company, Quin Financial Services, to take a loan to sustain in the market. For this
purpose, he meets Frank, the Loan Officer of Quin Financial Services, to inquire about the loan
details. Quin Financial Services accepts to offer a loan of $ 3.2 million for a period of 12 year at
the annual rate of interest of 7%. Robert wants to find the monthly installments he needs to pay.
Help Robert to calculate the monthly installments.
ANS:
CLICK HERE
6.
Danny is planning to spend his summer vacation in Europe. For this purpose, he booked airline
tickets, hotel rooms, and tourist guides. After spending his money on bookings, he finds that his
digital camcorder is not working. He checks the price of the camcorder in an electronics store. Its
price is $ 375. He cannot buy a new camcorder as he does not have any money left. So, he
decides to buy it on an installment scheme. He is willing to pay $ 40 each month. The store offers
the scheme at an annual interest of 6%. You are required to help Danny calculate the duration of
time period he is required to pay the installments.
ANS:
No comments:
Post a Comment