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:...
-
Diagram a formal organizational chart that reflects the following positions: a president, 2 executive officers, 4 middle managers, and 18 lower-level managers. Now, diagram three overlapping and...
-
A 500-m long pipeline carries oil (sp. gr. = 0. 85) from a storage tank to the bold of an oil tanker. The 0.5-m-diameter steel pipe has expansion joints and a wall thickness of 2.5 cm. The normal...
-
\(\sqrt{75}\) Simplify the square root by expressing it in lowest terms.
-
1. Ethan just hit the jackpot in Las Vegas and won $ 35,000! If he invests it now at a 10% interest rate, how much will it be worth in 15 years? 2. Trent would like to have $ 3,500,000 saved by the...
-
Champion Contractors completed the following transactions involving equipment. Year 1 January 1 Paid $322,000 cash plus $12,880 in sales tax and $1,600 in transportation (FOB shipping point) for a...
-
The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of...
-
$ in 000s, unless otherwise noted Historical Projected 2021A 2022A 2023E 2024F 2025F 2026F 2027F 2028F 2029F 2030F Income Statement Total Premiums $599,909 $669,595 $751,933 % Growth (YoY) 8.0% 6.5%...
-
Suppose that the zero-coupon yield curve is as follows: Maturity Yield to maturity 1 4% 2 5% 3 6% 4 7% Calculate the price of a 3-year 5% annual coupon bond with a par value of $1,000 ?
-
Unit sales of Product 1 are currently 20,000, while unit sales of Product 2 are currently double those of Product 1. What will the company's sales forecast be assuming sales of Product 1 increase by...
-
Can you find a priority list that yields an optimal schedule? 12 13 10 3 15 1, 4, 2, 5, 3, . 1, 2, 3, 4, 5, 6. , 3, 2, 4, 5, 1. 6, 3, 5, 2, 4, 1. 4 6 20 (Choose the optimal schedule from the list...
-
This is the part four of your Risk Management assignment. You will be looking at your business and typical contracts used in it. How to Proceed Using the business and Risk Management Template from...
-
Ralph's existing mortgage has an interest rate of 6 percent and an outstanding balance of $179,950.43. His currently monthly payment on this loan is $1,088.19. Ralph expects to move in 12 months, but...
-
'Id','Clear','Antibo','Age','Ear' 1,1,1,1,1 2,1,1,1,1 3,1,1,1,1 4,0,1,1,1 5,0,1,1,1 6,0,1,1,1 7,0,1,1,1 8,0,1,1,1 9,0,1,1,1 10,0,1,1,1 11,0,1,1,1 12,0,1,1,1 13,1,1,2,1 14,1,1,2,1 15,1,1,2,1...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Given its mission of providing information to the world, should Google censor searches in China?
-
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...
-
Question: A police department supplied its officers with pagers for text-messaging. The department did not have an official policy on text-messaging, but its e-mail policy stated that: "The use of...
-
Question: In 1572, during the reign of Queen Elizabeth I of England, a patent application was filed for a knife with a bone handle rather than a wooden one. Would this patent be granted under current...
-
Question: Craigslist, Inc., runs a Web site for classified ads, including ads for the sale and rental of houses and apartments. Some of the posted ads were discriminatory (although not consistent),...
Study smarter with the SolutionInn App