Advanced excel lab at home 8

1.   Consider the scenario of PlayCon Corporation, which is a leading organization in manufacturing

sports related products. Roger is the Sales Manager of the organization, and he has to prepare

the sales forecast for the next financial year. This report should include the total production cost as

well as the expected profit. Roger has made the sales forecast, but he wants to check the

expected profit if it can be maximized by replacing the set of values in the report with another set

of values. He wants to show the best case that can generate maximum profit as well as the

average case, which can be achieved. For the best case scenario, he decides to change the

current quantities for Shoes, T-Shirts, Track Suits, and Pull Overs by the quantities, 240, 300, 210,

and 220. For the average case scenario, he decides to change the quantities for T-Shirts, Track

Suits, Socks, and Pull Overs by the quantities, 150, 120, 100, and 110. Help Roger to accomplish

the preceding requirements.

ANS : DOWNLOAD

2.   Philippe is a 25 years old working professional and wishes to retire at the age of 65. He invests $

150 each month into his retirement account. The average annual return on his retirement account

is 6% per annum. On the basis of the given information, perform the following tasks:

Calculate Philippe's final saving at the age of 65.

If Philippe has a goal of attaining $ 1,000,000 in his retirement account, how much should he

invest each month?

Philippe has come to know about certain mutual fund investments that will yield a higher rate of

return. If Philippe can deposit a maximum of $ 150 each month into his retirement account and

wishes to have $ 1,000,000 in his account, at what rate of return should he invest to achieve

this?

Philippe wants to evaluate a few retirement investment options available with the bank. Use

scenario manager to generate a summary report for the following options:

Investing $ 200 per month at 12% annual return for 40 years.

Investing $ 175 per month at 9% annual return for 40 years.

Investing $ 150 per month at 6% annual return for 40 years.

ANS : DOWNLOAD

3.    Consider the sales data in the following table.

On the basis of the data in the preceding table, you need to perform the following tasks:

Display the details of the purchase orders placed after 2nd Jan, 2007 for the product name

beginning with the letter "G" and the number of units sold more than 100.

Display the details of all the purchase orders placed on 01-Jan or 03-Jan and the number of units

sold is less than 150.

Display the details of all the purchase orders placed on 02-Jan for the product name ending with

the letters "ets" and the number of units sold are less than 150.

Display the details of all the purchase orders placed in the state of Florida with words South in

Zone Name having a land area greater than 500.

Display the details of all the purchase orders placed in the states of California or Colorado with

population between 200,000 and 300,000 having the number of housing units greater than

100,000.

ANS : DOWNLOAD