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 https://drive.google.com/open?id=0B-yL1mP3zqTbSlZfYVoxaUNHUkU
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 https://drive.google.com/open?id=0B-yL1mP3zqTbRW83MU9tSklmNUU
3.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbSFJpWkdTWkt6cWM
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbSlZfYVoxaUNHUkU
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 https://drive.google.com/open?id=0B-yL1mP3zqTbRW83MU9tSklmNUU
3.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbSFJpWkdTWkt6cWM
No comments:
Post a Comment