Akha Ama Limited is a specialist manufacturer in the tea and coffee industry. It produces and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Akha Ama Limited is a specialist manufacturer in the tea and coffee industry. It produces and sells two products: speciality Thai tea and Thai coffee. Akha Ama Limited is a small family-owned company. It is run by the Suwan family. Akha Ama Limited has low gearing but currently has no additional cash available for Investment. This means that the company has to borrow if it wishes to invest in new machinery and/or processes. The sales forecast for the business for the next year is as follows: 2023 budget Sales (units) The cost of raw materials is as follows: Material Sustainable Cloth To manufacture a tea box, it requires 15sqcm of sustainable cloth, 500g of tea, and 20 linen bags from a supplier are required. For coffee, 15sqcm of paper, 700g of coffee, and 20 plastic pouches bought from a supplier are required. Tea is packaged for sale at a cost of £3.00 per unit, coffee is packaged for sale at a cost of £2.00 per unit. Packaging costs are to be included in labour costs. Tea Paper Linen bags Coffee Tea (000s) Plastic pouches 4,800 Cost £2.00 per kilogram (kg) £0.50 per square centimetre (sqcm) Coffee (000s) £0.10 per bag 9.600 £0.20 per square centimetre (sqcm) £3.00 per kilogram (kg) EO.10 per bag • Each tea box spends 0.75 labour hours in conversion and 1.1 labour hours in assembling and packing. Each coffee bag spends 0.5 labour hours in conversion and 0.75 labour hours in the assembly and packing. Labour is paid £17.00 per hour in the conversion department and £9.00 per hour in the assembly and packing department. Total overheads of Akha Ama Limited are £50,000 Akha Ama Limited is considering investing in an automated robotic process that will allow them to save on labour costs and allow the company to supply a new retail chain. From a cost perspective, it is expected that 8% of the assembly and packing labour cost, which is currently estimated at around £150,000 a year, can be saved by the new robotic process. In addition, this cost saving is expected to increase by 5% year-on-year, so that in year 2 it is expected to be 20% of the costs. To explore the viability (or otherwise) of supplying the new retail chain, the company paid a market research firm £20,000 for credible information. The cost of the robotic process is £220,000 and it will have a 4-year lifespan and an estimated scrap value of £20,000. Depreciation is to be charged at £50,000 a year. In addition, the project will also be allocated costs of £500 a year relating to its share of the company's overhead. These costs will be incurred by the company irrespective of whether the project goes ahead. If the project to implement the new robotic process is approved, the expected cash inflows from supplying the new retail chain is as follows. Expected cash inflows £ 50,000 55,000 65,000 85,000 Year 1 Year 2 Year 3 Year 4 Each year, the new business will have to maintain a working capital requirement equivalent to 15% of its expected cash inflows (of the new business). This working capital should be put in place a year before it is required. Note that the working capital requirement calculations after the initial year is based on incremental differences in expected cash flows. For this question, you can assume that all cash savings and other cash flows arise at the end of each year and ignore cash flows after this four-year period. The company uses a discount rate of 11%. Akha Ama Limited will accept projects with a payback of two (2) years or less. Question 1 Calculate the following: Produce a budgeted profit and loss account for each product. Assume that the company adds a mark-up of 25% on each product it sells. In order to accomplish this, you will need to calculate the following: • The budgeted quantity of each raw material the company will need to purchase for each product. • The budgeted cost of these materials for each product. The amount of labour hours that are required for each product. The budgeted cost of this labour for each product • A blanket overhead absorption rate, this should be based on labour hours The total unit cost of each product • The selling price of each product sales materials labour overheads budgeted gross profit Tea E Coffee £ Question 2 Calculate the net present value (NPV) and payback period of the project. (To answer the question, fill in the blanks. When entering your answers, please supply either a whole number - the nearest if you need to round up or down - or a number with two decimal points. Either way is acceptable and worth the same number of marks. Remember, you will also need to submit your calculations at the end of the exam. If you are unable to complete all the steps, we will look at your workings to award method marks.) NPV is £ Payback period is years and 25 pts months Question 3 Comment on whether the project should be accepted or not and provide reasons for your decision. Outline at least two limitations in making such decision. Question 4 In the context of the information given in the question, what are the main considerations that the company should take into account when deciding how to finance the purchase of the new robotics process? What advice would you give to the company? Question 5 As a further innovation, the company is thinking of redesigning their budgeting process. Outline at least 4 issues with budgets to reflect why they might not be suitable for a modern business. Akha Ama Limited is a specialist manufacturer in the tea and coffee industry. It produces and sells two products: speciality Thai tea and Thai coffee. Akha Ama Limited is a small family-owned company. It is run by the Suwan family. Akha Ama Limited has low gearing but currently has no additional cash available for Investment. This means that the company has to borrow if it wishes to invest in new machinery and/or processes. The sales forecast for the business for the next year is as follows: 2023 budget Sales (units) The cost of raw materials is as follows: Material Sustainable Cloth To manufacture a tea box, it requires 15sqcm of sustainable cloth, 500g of tea, and 20 linen bags from a supplier are required. For coffee, 15sqcm of paper, 700g of coffee, and 20 plastic pouches bought from a supplier are required. Tea is packaged for sale at a cost of £3.00 per unit, coffee is packaged for sale at a cost of £2.00 per unit. Packaging costs are to be included in labour costs. Tea Paper Linen bags Coffee Tea (000s) Plastic pouches 4,800 Cost £2.00 per kilogram (kg) £0.50 per square centimetre (sqcm) Coffee (000s) £0.10 per bag 9.600 £0.20 per square centimetre (sqcm) £3.00 per kilogram (kg) EO.10 per bag • Each tea box spends 0.75 labour hours in conversion and 1.1 labour hours in assembling and packing. Each coffee bag spends 0.5 labour hours in conversion and 0.75 labour hours in the assembly and packing. Labour is paid £17.00 per hour in the conversion department and £9.00 per hour in the assembly and packing department. Total overheads of Akha Ama Limited are £50,000 Akha Ama Limited is considering investing in an automated robotic process that will allow them to save on labour costs and allow the company to supply a new retail chain. From a cost perspective, it is expected that 8% of the assembly and packing labour cost, which is currently estimated at around £150,000 a year, can be saved by the new robotic process. In addition, this cost saving is expected to increase by 5% year-on-year, so that in year 2 it is expected to be 20% of the costs. To explore the viability (or otherwise) of supplying the new retail chain, the company paid a market research firm £20,000 for credible information. The cost of the robotic process is £220,000 and it will have a 4-year lifespan and an estimated scrap value of £20,000. Depreciation is to be charged at £50,000 a year. In addition, the project will also be allocated costs of £500 a year relating to its share of the company's overhead. These costs will be incurred by the company irrespective of whether the project goes ahead. If the project to implement the new robotic process is approved, the expected cash inflows from supplying the new retail chain is as follows. Expected cash inflows £ 50,000 55,000 65,000 85,000 Year 1 Year 2 Year 3 Year 4 Each year, the new business will have to maintain a working capital requirement equivalent to 15% of its expected cash inflows (of the new business). This working capital should be put in place a year before it is required. Note that the working capital requirement calculations after the initial year is based on incremental differences in expected cash flows. For this question, you can assume that all cash savings and other cash flows arise at the end of each year and ignore cash flows after this four-year period. The company uses a discount rate of 11%. Akha Ama Limited will accept projects with a payback of two (2) years or less. Question 1 Calculate the following: Produce a budgeted profit and loss account for each product. Assume that the company adds a mark-up of 25% on each product it sells. In order to accomplish this, you will need to calculate the following: • The budgeted quantity of each raw material the company will need to purchase for each product. • The budgeted cost of these materials for each product. The amount of labour hours that are required for each product. The budgeted cost of this labour for each product • A blanket overhead absorption rate, this should be based on labour hours The total unit cost of each product • The selling price of each product sales materials labour overheads budgeted gross profit Tea E Coffee £ Question 2 Calculate the net present value (NPV) and payback period of the project. (To answer the question, fill in the blanks. When entering your answers, please supply either a whole number - the nearest if you need to round up or down - or a number with two decimal points. Either way is acceptable and worth the same number of marks. Remember, you will also need to submit your calculations at the end of the exam. If you are unable to complete all the steps, we will look at your workings to award method marks.) NPV is £ Payback period is years and 25 pts months Question 3 Comment on whether the project should be accepted or not and provide reasons for your decision. Outline at least two limitations in making such decision. Question 4 In the context of the information given in the question, what are the main considerations that the company should take into account when deciding how to finance the purchase of the new robotics process? What advice would you give to the company? Question 5 As a further innovation, the company is thinking of redesigning their budgeting process. Outline at least 4 issues with budgets to reflect why they might not be suitable for a modern business.
Expert Answer:
Answer rating: 100% (QA)
Ans A calculation for budgeted profit loss screenshot 2 BTo calculate the NPV net present value and payback period of the project we will consider the ... View the full answer
Related Book For
Business Statistics For Contemporary Decision Making
ISBN: 978-1118749647
8th edition
Authors: Black Ken
Posted Date:
Students also viewed these accounting questions
-
The schedule for the Killers next year is as follows (refer to Problem 2-24): Game 1: The Machos Game 2: Mama's Boys (a) What is the probability that the Killers will win their first game? (b) What...
-
In accumulating raw materials costs, companies add the cost of raw materials purchased in a perpetual system to: a. Raw Materials Purchases. b. Raw Materials Inventory. c. Purchases. d. Work in...
-
Honeyville Hardware produces and sells two products for professional landscapers: shovels and rakes. Revenue and cost information relating to the products follow: Common fixed expenses in the company...
-
Taxpayer sold the following capital assets during the year: Asset # 1: $60,000 long-term capital gain Asset # 2: $10,000 long-term capital loss Asset # 3: $50,000 short-term capital gain Asset # 4:...
-
Choose the right word for each sentence. 1. Many Canadian (companies, companys) are competing effectively in the global market. 2. We can move your (families, familys) furniture safely and...
-
1. What strategies are being followed by the main NTOs? 2. Which strategic options are available to NTOs (at the time of the case study)? 3. How might these strategic options be evaluated? 4. What...
-
Lauren is flying in her spaceship at 0.3c. If she doubles her speed to 0.6c, her momentum A. Doubles. B. More than doubles. C. Less than doubles.
-
The manager of Fast Break Sports, Inc., prepared the companys balance sheet as of March 31, 2014, while the accountant was ill. The balance sheet contains numerous errors. In particular, the manager...
-
At K.T. West Communications, supervisors meet with employees at the beginning of their employment and also on an annual basis to review the employees' roles and discuss their jobs, skills, knowledge,...
-
The founder of Frenza asks us to assist her in accounting and analysis of the corporations bonds, which have an annual contract rate of 8%. She wants to know the business and accounting implications...
-
Consider the following variation of the ultimatum game we have seen in class. Two player, Vince and Jules have to split a suitcase with M $ in it. Vince moves first and makes an offer a e [0,1]. Then...
-
Alpha paid $12,000 cash in advance for rent and recorded it as a debit to Rent Expense and a credit to Cash. Only 25% of the rent was used during the year. Alpha recorded the following "normal" AJE:...
-
how to determine congruence of objects A and B by defining an isometry between them.?
-
Monitoring and Controlling Process Groups consists of those processes required to track, review, and regulate the progress and performance of the project. True False
-
A business process outsourcing firm's legal team has checked into the regulations and legalities of operating in Australia. Who in the firm would be responsible for customer research, identifying...
-
Find the data inputs of the following multiplexer that implement the function F. F(A,B,C,D,E,F)= m(1,4,7,8,12,14,30,33,40,44) + d(3,6,1 1,15,41,45) Io I 12 13 4 to 1 Mux 11 EF
-
For a item of recurring need, the demand per year is 87. The ordering cost is $90 per order and the holding cost rate is $300 per unit per year. The company uses a safety stock of 20 to protect...
-
A certain Christmas tree ornament is a silver sphere having a diameter of 8.50 cm. Determine an object location for which the size of the reflected image is three-fourths the size of the object. Use...
-
Use the following data to develop a curvilinear model to predict y. Include both x1 and x2 in the model in addition to x21 and x22, and the interaction term x1x2. Comment on the overall strength of...
-
Most supermarkets across the United States have invested heavily in optical scanner systems to expedite customer checkout, increase checkout productivity, and improve product accountability. These...
-
Use the following data for parts (a) through (f). a. Determine the equation of the least squares regression line to predict y by x. b. Using the x values, solve for the predicted values of y and the...
-
A small block of mass \(m\) and a weight of mass \(M\) are connected by a string of length \(D\). The string has been threaded through a small hole in a tabletop, so the block can slide without...
-
In certain situations, it is possible to incorporate frictional effects in a simple way into a Lagrangian problem. As an example, consider the Lagrangian (a) Find the equation of motion for the...
-
Consider a vertical circular hoop of radius \(R\) rotating about its vertical symmetry axis with constant angular velocity \(\Omega\). A bead of mass \(m\) is threaded onto the hoop, so is free to...
Study smarter with the SolutionInn App