80.2K

Verified Solution

Link Copied!

As a Senior Sales Engineer working in a company producing Automated Bottling Machine, you have been approached by Berkat Enterprise enquiring the use of your product. Berkat Enterprise is a company operating in Tumpat, Kelantan producing a local traditional fish sauce. Since the company is targetting the European Market, certain processes in making the sauce has to comply with GMP for international certification. The company processes 3,000 kg of ikan bilis per day and requires the use of the main ingredient salt at 1,000 kg per day. The fish is fermented between 6 to 12 months in 200 large containers at 5,000 kg of fish mixture per container. The fish mixture is then boiled and bottled. The bottling process is at the rate of 30,000 bottles a day with a weekly target of 150,000. The bottling process is handled by, 2 workers prepare the bottles before bottling 4 workers for filling 4 workes for capping and labelling 2 workers pack the bottles into crates for delivery Your machine does the filling, capping and labelling at a speed of 20 - 40 pcs per minute in a sterile chamber. The machine costs RM 70,000 with a guaranteed use of 7 years. The machines operates on 240V AC and 12 Amp. The current cost per unit is RM 1.00 with a sale price of RM 1.30. You are also required to prepare a weekly cash flow table for the first 24 months using Microsoft Excel. Here are some functions in Microsoft Excel, that can be used to assist calculation using various methods in determining profitability of any cashflows, such as: Present Worth (PW) values = Net Present Values : NPV(rate, value 1, [Value2],...) Internal Rate of Return (IRR) : IRR(values, (guess]) and many more. Please explore these functions. In your cashflow report, you must define your company's MARR value and show; a) Costs comparison between current operations with new automated system b) List down all possible cash-out (all possible costs, such as material cost, rental, shipping, etc.) and cash-in (such as revenues, profit, cost saving, market values, etc.) of all options. c) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability of each option. (You may create multiple options, consist of profitable, and also non-profitable option. Learn how the evaluation can be done using Microsoft Excel for both options.) d) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability of each option. (You may create multiple options, consist of profitable, and also non-profitable option. Learn how the evaluation can be done using Microsoft Excel for both options.) e) Then on new tab of the same Microsoft Excel file, evaluate all options, to decide which option is the best. Use both methods: Equivalent Worth Method, and by using Incremen- tal Analysis Method. Provide conclusion and justification based on all PW and IRR values. f) Comment and conclude Please assume that wages comply to minimum wage of RM 1,000 per month. Business financing loan (if there is any) is at 4%. Please also check the electricity tariffs with TNB for commercial premises. You may use only one Microsoft Excel file for this whole assignment. Use multiple tabs in the file, to separate your task and evaluation. Start with tab 1, for task number 1) and other tabs for other tasks. Make sure presentation of your assignment is clear and all flows in your evaluation can be understood by the lecturer. As a Senior Sales Engineer working in a company producing Automated Bottling Machine, you have been approached by Berkat Enterprise enquiring the use of your product. Berkat Enterprise is a company operating in Tumpat, Kelantan producing a local traditional fish sauce. Since the company is targetting the European Market, certain processes in making the sauce has to comply with GMP for international certification. The company processes 3,000 kg of ikan bilis per day and requires the use of the main ingredient salt at 1,000 kg per day. The fish is fermented between 6 to 12 months in 200 large containers at 5,000 kg of fish mixture per container. The fish mixture is then boiled and bottled. The bottling process is at the rate of 30,000 bottles a day with a weekly target of 150,000. The bottling process is handled by, 2 workers prepare the bottles before bottling 4 workers for filling 4 workes for capping and labelling 2 workers pack the bottles into crates for delivery Your machine does the filling, capping and labelling at a speed of 20 - 40 pcs per minute in a sterile chamber. The machine costs RM 70,000 with a guaranteed use of 7 years. The machines operates on 240V AC and 12 Amp. The current cost per unit is RM 1.00 with a sale price of RM 1.30. You are also required to prepare a weekly cash flow table for the first 24 months using Microsoft Excel. Here are some functions in Microsoft Excel, that can be used to assist calculation using various methods in determining profitability of any cashflows, such as: Present Worth (PW) values = Net Present Values : NPV(rate, value 1, [Value2],...) Internal Rate of Return (IRR) : IRR(values, (guess]) and many more. Please explore these functions. In your cashflow report, you must define your company's MARR value and show; a) Costs comparison between current operations with new automated system b) List down all possible cash-out (all possible costs, such as material cost, rental, shipping, etc.) and cash-in (such as revenues, profit, cost saving, market values, etc.) of all options. c) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability of each option. (You may create multiple options, consist of profitable, and also non-profitable option. Learn how the evaluation can be done using Microsoft Excel for both options.) d) Using Microsoft Excel, evaluate every option, by using Equivalent Worth Method, and through Internal Rate of Return Method. Then comment and make conclusion on profit- ability of each option. (You may create multiple options, consist of profitable, and also non-profitable option. Learn how the evaluation can be done using Microsoft Excel for both options.) e) Then on new tab of the same Microsoft Excel file, evaluate all options, to decide which option is the best. Use both methods: Equivalent Worth Method, and by using Incremen- tal Analysis Method. Provide conclusion and justification based on all PW and IRR values. f) Comment and conclude Please assume that wages comply to minimum wage of RM 1,000 per month. Business financing loan (if there is any) is at 4%. Please also check the electricity tariffs with TNB for commercial premises. You may use only one Microsoft Excel file for this whole assignment. Use multiple tabs in the file, to separate your task and evaluation. Start with tab 1, for task number 1) and other tabs for other tasks. Make sure presentation of your assignment is clear and all flows in your evaluation can be understood by the lecturer

Answer & Explanation Solved by verified expert

See Answer