anielle Hastings was recently hired as a cost analyst by CareNet Medical Supplies Inc. One of...

anielle Hastings was recently hired as a cost analyst by CareNet Medical Supplies Inc. One of Danielle's first assignments was to perform a net present value analysis for a new warehouse. Danielle performed the analysis and calculated a present value index of 0.75. The plant manager, Jerrod Moore, is very intent on purchasing the warehouse because he believes that more storage space is needed. Jerrod asks Danielle into his office and the following conversation takes place:

Jerrod: Danielle, you're new here, aren't you?

Danielle: Yes, I am.

Jerrod: Well, Danielle, I'm not at all pleased with the capital investment analysis that you performed on this new warehouse. I need that warehouse for my production. If I don't get it, where am I going to place our output?

Danielle: Well, we need to get product into our customers' hands.

Jerrod: I agree, and we need a warehouse to do that.

Danielle: My analysis does not support constructing a new warehouse. The numbers don't lie; the warehouse does not meet our investment return targets. In fact, it seems to me that purchasing a warehouse does not add much value to the business. We need to be producing product to satisfy customer orders, not to fill a warehouse.

Jerrod: The headquarters people will not allow me to build the warehouse if the numbers don't add up. You know as well as I that many assumptions go into your net present value analysis. Why don't you relax some of your assumptions so that the financial savings will offset the cost?

Danielle: I'm willing to discuss my assumptions with you. Maybe I overlooked something. Jerrod: Good. Here's what I want you to do. I see in your analysis that you don't project greater sales as a result of the warehouse. It seems to me that if we can store more goods, then we will have more to sell. Thus, logically, a larger warehouse translates into more sales. If you incorporate this into your analysis, I think you'll see that the numbers will work out. Why don't you work it through and come back with a new analysis. I'm really counting on you on this one. Let's get off to a good start together and see if we can get this project accepted.

What is your advice to Danielle? Consider everything that you have learned this semester and chose 1 aspect to comment on.

Solutions

Expert Solution

the statement of a larger warehouse translaes into more sales- is completely wrong. there are many factors show impact on sale of a product/ service, but not a bigger warehouse or godown. so, this assumption is completely wrong about sales. Next about assumptions of NPV, if the required rate of return is decreasing, then you can get the positive NPV from the project calculation. when the required rate (discount rate) is higher, the NPV will become down or negative. Hence, if you shown that your discounting rate is less, then your figures may postitive and you can support your statement.

The other assumption is volume of cash inflows: if you managed that the sales are increase, then the cash inflow will be increase leads to higher NPV and vice versa- the opposite is, if you are able to show that the investments are less than what you projected, the returns are same, then also your NPV will increase.

If your target is to manipulate the numbers to NPV positive or Profitablity Index more than 1, than you can manipulate the numbers, but it may not give the real picture to the stakeholders. If they realized your calculations are wrong, it becomes a threat and limiation to you in your future.

keosha answered 1 year ago

Next > < Previous

Related Solutions

Gardems was recently hired as a financial analyst by Taylor, Inc., which is a Pennsylvania based...

Gardems was recently hired as a financial analyst by Taylor, Inc., which is a Pennsylvania based company. His first task is to conduct a financial statement analysis of firm covering the past 2 years as in the table below: Q:Assess the firm's liquidity position. Balance Sheets 2012 2011 Cash $52,000 $57,000 Accounts Receivable $402,000 $351,200 Inventory $836,000 $715,200 Total Current Assets $1,290,000 $1,124,000 Gross Fixed Assets $527,000 $491,000 Less: Accumulated Depriciation $166,200 $146,200 Net Fixed Assets $360,800 344,800 Total Assets...

Phil was recently hired by Select Network Inc. as a junior budget analyst. He is working...

Phil was recently hired by Select Network Inc. as a junior budget analyst. He is working for the Venture Capital Division and has been given for capital budgeting projects to evaluate. He must give his analysis and recommendation to the capital budgeting committee. Phil has a B.S. in accounting from CWU (2007) and passed the CPA exam (2008). He has been in public accounting for 2 years. During that time he earned an MBA from Seattle U. He would like...

Phil was recently hired by Select Network Inc. as a junior budget analyst. He is working...

Ronald was recently hired by Highland Equipment Inc. as a junior budget analyst. He is working...

Ronald was recently hired by Highland Equipment Inc. as a junior budget analyst. He is working for the Venture Capital Division and has been given for capital budgeting projects to evaluate. He must give his analysis and recommendation to the capital budgeting committee. Ronald has a B.S. in accounting from CWU (2016) and passed the CPA exam (2018). He has been in public accounting for several years. During that time he earned an MBA from Seattle U. He would like...

You were recently hired by a firm as a project analyst.

You were recently hired by a firm as a project analyst. The owner of the firm is unfamiliar with financial analysis and wants to know only what the expected dollar return is per dollar spent on a given project. Which financial method of analysis will provide the information that the owner requests? a. Internal rate of return b. Modified internal rate of return c. Net present value d. Profitability index e. Payback

You are recently appointed as a centralized “Cost Control Analyst” for one of the bank in...

You are recently appointed as a centralized “Cost Control Analyst” for one of the bank in Toronto. Head of Banking operations in Toronto Mr. Horton has asked you to analyse the cost of basic stationary as Stationary in different regions of the bank seems to be one of the highest cost. He wants you to come up with your statistical analysis with two pager report. Use Central tendencies, Standard deviation and Regression analysis techniques along with graphical representation. (30 Marks...

Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost...

Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for October of the current year. The company expected to operate the department at 100% of normal capacity of 6,200 hours. Variable costs: Indirect factory wages $21,080 Power and light 11,780 Indirect materials 9,920 Total variable cost $42,780 Fixed costs: Supervisory salaries $12,690 Depreciation of plant and equipment 32,560 Insurance and property taxes 9,930 Total fixed cost 55,180 Total...

Factory Overhead Cost Variance Report Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared...

Factory Overhead Cost Variance Report Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for October of the current year. The company expected to operate the department at 100% of normal capacity of 6,200 hours. Variable costs: Indirect factory wages $21,080 Power and light 11,780 Indirect materials 9,920 Total variable cost $42,780 Fixed costs: Supervisory salaries $12,690 Depreciation of plant and equipment 32,560 Insurance and property taxes 9,930...

Factory Overhead Cost Variance Report Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared...

Factory Overhead Cost Variance Report Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for October of the current year. The company expected to operate the department at 100% of normal capacity of 6,700 hours. Variable costs: Indirect factory wages $21,440 Power and light 15,477 Indirect materials 13,467 Total variable cost $50,384 Fixed costs: Supervisory salaries $11,250 Depreciation of plant and equipment 28,860 Insurance and property taxes 8,800...

Factory Overhead Cost Variance Report Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared...

Factory Overhead Cost Variance Report Feeling Better Medical Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for October of the current year. The company expected to operate the department at 100% of normal capacity of 8,700 hours. Variable costs: Indirect factory wages $27,840 Power and light 20,706 Indirect materials 18,096 Total variable cost $66,642 Fixed costs: Supervisory salaries $16,410 Depreciation of plant and equipment 42,090 Insurance and property taxes 12,840...

Subjects