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
No comments:
Post a Comment