You are working with Dewina Food Industries Private Limited as Junior Analyst. Your company is famously...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are working with Dewina Food Industries Private Limited as Junior Analyst. Your company is famously known for its brand name Brahim's and is a producer of premium quality instant retort pouched foods in Southeast Asia. You are working at their manufacturing plant located in Selangor. Your manager is considering to purchase new packaging machine and shortlisted these four machines from two different suppliers. Your manager had projected the followings cash flows and discount rates. Your company standard payback period is maximum 4 years. Assume there's no limitation / restriction on the purchase. Year 0 1 2 3 4 5 6 Discount rate Machine 123- Machine 123-A Machine 789- Machine 789-A M (RM) M (RM) (RM) (RM) -280,000 72,000 72,000 72,000 72,000 72,000 (330,000) 82,500 82,500 82,500 82,500 82,500 82,500 10% (668,500) 52,000 78,000 117,000 175,500 263,250 394,875 10% 7.5% -550,000 120,000 120,000 120,000 120,000 120,000 7.5% You are required to provide analysis in regards with these machines. Based on the above information, construct a spreadsheet in Excel. In your analysis, including the following: d) Calculation of Profitability Index. e) Based on the above results, a) [12 marks] decisions. ») Calculation of Payback Period. [8 marks] b) Calculation of Net Present Value. [8 marks] c) Calculation of Internal Rate of Return. [2 marks] [4 marks] d), explain your which The company budgeted RM1 million for this investment. Advise your manager, machine(s) should the company buy and reject? Why? How much is the total initial cost? 15 marks] From the previous question f), how would you decision change, if there's no capital limitation? State your decision and reasons. Rank your preferred machine(s). [4 marks] h) Assume this is mutually exclusive project, state your decision and reason. [2 marks] You are working with Dewina Food Industries Private Limited as Junior Analyst. Your company is famously known for its brand name Brahim's and is a producer of premium quality instant retort pouched foods in Southeast Asia. You are working at their manufacturing plant located in Selangor. Your manager is considering to purchase new packaging machine and shortlisted these four machines from two different suppliers. Your manager had projected the followings cash flows and discount rates. Your company standard payback period is maximum 4 years. Assume there's no limitation / restriction on the purchase. Year 0 1 2 3 4 5 6 Discount rate Machine 123- Machine 123-A Machine 789- Machine 789-A M (RM) M (RM) (RM) (RM) -280,000 72,000 72,000 72,000 72,000 72,000 (330,000) 82,500 82,500 82,500 82,500 82,500 82,500 10% (668,500) 52,000 78,000 117,000 175,500 263,250 394,875 10% 7.5% -550,000 120,000 120,000 120,000 120,000 120,000 7.5% You are required to provide analysis in regards with these machines. Based on the above information, construct a spreadsheet in Excel. In your analysis, including the following: d) Calculation of Profitability Index. e) Based on the above results, a) [12 marks] decisions. ») Calculation of Payback Period. [8 marks] b) Calculation of Net Present Value. [8 marks] c) Calculation of Internal Rate of Return. [2 marks] [4 marks] d), explain your which The company budgeted RM1 million for this investment. Advise your manager, machine(s) should the company buy and reject? Why? How much is the total initial cost? 15 marks] From the previous question f), how would you decision change, if there's no capital limitation? State your decision and reasons. Rank your preferred machine(s). [4 marks] h) Assume this is mutually exclusive project, state your decision and reason. [2 marks]
Expert Answer:
Answer rating: 100% (QA)
a Payback Period The rationale for the payback period is to estimate the time that a project will take to generate cash inflows that are equivalent to the cash It estimates the amount of time it takes ... View the full answer
Related Book For
Management Accounting
ISBN: 9780730369387
4th Edition
Authors: Leslie G. Eldenburg, Albie Brooks, Judy Oliver, Gillian Vesty, Rodney Dormer, Vijaya Murthy, Nick Pawsey
Posted Date:
Students also viewed these mechanical engineering questions
-
You are the controller at Star Wars, Inc., a wholesale distributor of light sabers and other interstellar weaponry. The corporation was founded in galaxy far, far away a long time ago. The company...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
At the beginning of 2019, Southwest Airlines fared third in the rankings of the best U.S. Airlines released by the Wall Street Journal. Delta Airlines ranked first and Alaska Airlines ranked second....
-
the IP address are for illustrative purposes only. Use your own IP addressing scheme (You may use classful and classless IP addresses as per your preference). Note that students need to attach the...
-
Figure gives the energy levels for an electron trapped in a finite potential energy well 450eV deep. If the electron is in the n = 3 state, what is its kineticenergy? -Nonquantized - Top of well 450...
-
A dielectric slab completely fills the space between the plates of a parallel-plate capacitor. The magnitude of the bound charge on each side of the slab is \(75 \%\) of the magnitude of the free...
-
Explain why finance has been globalised over the past 20 years.
-
A rush order was accepted by San Diego Machine Conversions for five van conversions. The labor time records for the week ended January 27 show the following: All employees are paid $10.00 per hour,...
-
The Kinbozon Co. is conducting a primary market Dutch Auction to sell 15,000,000 shares of stock. They have received six bids which are summarized below Bidder Shares Price A 3,145,000 25.65 B...
-
Values for the NASDAQ composite index during the 1,500 days preceding March 10, 2006, can be downloaded from the authors web site. Calculate the one-day 99% VaR and the one-day 99% ES on March 10,...
-
https://youtu.be/rl5ebCXe7Hw https://www.ted.com/talks/anne_milgram_why_smart_statistics_are_the_key_to_fighting_crime?language=en after watching the videos answer the questions. 1. Why knowledge...
-
Explain purchasing power parity and why it does not hold perfectly in the real world.
-
The random variable \(Y\) has a mean of 1 and a variance of 4. Let \(Z=\frac{1}{2}(Y-1)\). Show that \(\mu_{Z}=0\) and \(\sigma_{Z}^{2}=1\).
-
Compute the following probabilities: a. If \(Y\) is distributed \(N(1,4)\), find \(\operatorname{Pr}(Y \leq 3)\). b. If \(Y\) is distributed \(N(3,9)\), find \(\operatorname{Pr}(Y>0)\). c. If \(Y\)...
-
A solenoid can be treated as a series \(R L\) circuit. If such a cylindrical solenoid driven by a \(60-\mathrm{Hz}, 120-\mathrm{V} \mathrm{AC}\) source has 1200 turns of \(2 \mathrm{~cm}\) radius...
-
An \(R L C\) series circuit consists of a \(450-\Omega\) resistor, a \(3.00-\mathrm{mF}\) capacitor, and a \(1.00-\mathrm{H}\) inductor. The circuit is driven by a power source that oscillates at...
-
A 70.0 cm wire of mass 6.00 g is tied at both ends and adjusted to a tension of 43.0 N. You may want to review (Page). For related problem-solving tips and strategies, you may want to view a Video...
-
Charles owns an office building and land that are used in his trade or business. The office building and land were acquired in 1978 for $800,000 and $100,000, respectively. During the current year,...
-
Give an example of joint products in a service industry and describe the main products and by-products.
-
You are on the board of a computer software company that has three distinct divisions: home networks, small business systems and ERP systems. In a bid to encourage higher performance, it has been...
-
Outline the meaning of responsibility accounting.
-
What circumstances might influence the growth or shrinkage of the nonprofit sector?
-
Discuss what a productive collaboration between a nonprofit, a for - profit, and the public sector might look like.
-
If you wanted to establish a homeless shelter in your community, what are the decisions and choices you would have to make along the way?
Study smarter with the SolutionInn App