Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you solve it with using excel Question.1 Ahmed is planning to study a master's degree abroad after 5 years. Assume that he has determined

can you solve it with using excel image text in transcribed
image text in transcribed
Question.1 Ahmed is planning to study a master's degree abroad after 5 years. Assume that he has determined that he will need $150,000 at that time in order to pay for tuition, room and board, party supplies, etc. He can earn 8% per year on his investment. 1. How much money would he need to invest every month to achieve his goal $150,000 ? 2. How much money would he need to invest today as a lump sum to achieve his goal $150,000? 3. Suppose that Ahmed can afford only $90,000 to invest today and he can earn 8% per year on an investment. How long it will take him to reach his goal $150,000 ? 4. Suppose that Ahmed can afford only $90,000 to invest today and he does not want to wait more than 5 years to study. He decided to find another investment with a higher annual rate of return. How much the annual rate of return should be to reach your goal? 5. How much will his investment be worth after 5 years? If Ahmed decided to deposit $2,250 into his savings account every month for 5 years, with an annual interest rate of 6%. Would he achieve his goal? 6. Assume that Ahmed decided to invest in a project instead of studying a master's degree abroad after 5 years. He has two options with discount rate equals to 10%. The first project requires an investment of $90,000 which will give a return of $30,000 each year for 5 years. The second project requires an investment of $75,000 which will give a return of $10,000,$15,000,$20,000,$25,000 and $30,000 for the next 5 years. Which projects is better and should be invested in? Why? Question.2 A bakery bakes 6000 breads every month. Last month only 4500 breads were sold. The selling price is 5.75 per unit. The material cost is 1.25 per unit and the labor cost per unit is equal to 1.75. The total fixed cost is budgeted at 4000 per month. 1. Develop a spreadsheet model to calculate the monthly Revenue, Total Cost and Profit. 2. If the price increased by %10, Can the bakery reach the profit of 11000 ? 3. Find how many units should be sold to get a profit of 11000, If the price increased by %10? 4. Find how many units should be sold to get the maximum profit, when the ratio between units produced and units sold should be between 75% and 95% (unit sold should be at least 75% of units produced and at most 95% of units produced)? 5. Determine how Total Variable Cost varies as Unit Labor Cost varies from $1.75 to $4.25 (in $0.50 increments) and Unit Material Cost varies from $1.25 to $3 (in $0.25 increments). If the maximum Total Variable Cost the bakery can handle is $30,000, Then what are the possible ranges of Unit Labor Cost and Unit Material Cost. Question.2 A bakery bakes 6000 breads every month. Last month only 4500 breads were sold. The selling price is 5.75 per unit. The material cost is 1.25 per unit and the labor cost per unit is equal to 1.75. The total fixed cost is budgeted at 4000 per month. 1. Develop a spreadsheet model to calculate the monthly Revenue, Total Cost and Profit. 2. If the price increased by %10, Can the bakery reach the profit of 11000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Production And Operations Analytics

Authors: Steven Nahmias, Tava Lennon Olsen

8th Edition

1478639261, 9781478639268

More Books

Students also viewed these Finance questions