company was established since 2012, and will be celebrating its 10th anniversary next year. With that in mind, the board of directors proposed that NK Sdn Bhd to introduce Smart water Apps. The new product will be known as e-water. In order to provide E-water, NK Sdn Bhd needs to invest on E-water development which cost RM200,000 with required rate of return of 20%. The details of the new product line is as follows: Year Initial Cost and Book Value Annual Net After Tax Annual Net Income Cash flows 0 $ 200,000 $ 30,000 $ 18,000 2 $ 50,000 $ 30,000 $ 80,000 $ 48,000 4 $ 160,000 $ 96,000 5 $ 200,000 $ 120,000 The financial year end for NK Sdn Bhd is December 31 every year. The company' Operational flows is as follows: 1 O Nm 3 Process Inbound Bottle • Bottle Cap Printed Label Outbound 6 bottles pack 500ml mineral water Water Bottling Labeling Packing Main Operations Activities Register Design Trial Period Subscription Re-ordering E-water (Planning Year 2022) Ordering for Labeling for 6 Packing Customized Labeling Water Bottle Printing pck Mineral Water General Administrative, Finance, Human Resource Marketing & Promotion Research & Development Information Technology & Infrastructure Supporting Activities
Planning & Budget for financial year 2022 For financial year 2021, Sales Department was assigned to achieve budgeted sales of 1,000,000 2 Page units and 30,000 subscribers respectively for 6pack Mineral Water and Customised Label. It is also assumed that the selling price, direct material and direct labour cost remains the same as prior period, however overhead has been identified as follows: Overhead Total Cost Cost Behavior*** Depreciation of Computer & Equipments* $300,000 Fixed Cost Depreciation of Building* $40,000 Fixed Cost Utilities* (Note A) $700,000 Semi Variable Cost Production cost (including water) ** $100,000 Variable Cost Maintenance & Upkeep of Applications and Software** $400,000 Variable Cost Indirect Labour $100,000 Fixed Cost Indirect Material $200,000 Variable Cost Other staff cost $200,000 Fixed Cost Marketing and promotion $30,000 Fixed Cost Research & Development $200,000 Fixed Cost General administrative expenses $230,000 Fixed Cost Training cost* $100,000 Fixed Cost
*75% of the company's computer & equipment, building, and utilities devoted to main operation activities, the remaining 25% used for selling and administrative function. ** 100% of the company's maintenance and upkeep of Production Facility and applications & software is for main operation. *** Each overhead cost are allocated according to total sales of respective products. Note A - Utilities Ledger and Cost Driver Month Utilities Cost ($) Machine hours Jan 30,000 10,000 Feb 40,000 15,000 Mar 50,000 18,000 Apr 70,000 25,000 May 60,000 22,000 Jun 85,000 30,000 Jul 90,000 34,000 Aug 95,000 35,000 Sep 55,000 20,000 Oct 45,000 13,000 Nov 50,000 18,000 Dec 30,000 10,000 700,000 250,000
NK Sdn Bhd Accounting Records ending 31 December 2021. NK Sdn Bhd kept their financial records using cloud based accounting system, the following information was extracted. Based on Built of Material Dec 2020 summary. Each of 6pck Water Bottles 6 bottles, 6 bottle caps, 6 individual labels and 1 printed Opek label. Cost of respective material are $0.50, $0.10, $0.20 per bottle. Furthermore, the summary also included direct labour cost per hour $30 per hour except designer's labour cost is $100 per hour. The Direct Labour hours for each unit (Opck Water bottles) taken by respective process. The processes are as follows: 6pck Water Bottle processes are as follows: Processes Direct Labour Hour Water Bottling 5 minutes Labeling 3 minutes Packing 2 minutes Customised Label processes are as follows: Processes Duration Design 2 hours Ordering 30 minutes Labeling 3 minutes Packing 2 minutes Production Head of Department also alerted CEO's office, that, the current facility maximum capacity for bpck Mineral Water is at 1,100,000 unit. Furthermore, Services Department also identified the maximum capacity for Customised Labeling is only for 50,000 Subscriber per year. Selling price was $12.00 and $500 per unit for opek Mineral Water and Customised Labelling respectively. Note: In your responses, you are allowed to improvise or add to the case study details provided earlier. However, the case study should not be changed or compromised in any way. Any assumptions made, must be stated clearly.
QUESTIONS: As an external consultant, you have been asked by Management of company to prepare a written briefing paper for their next Management meeting. NK Sdn Bhd profitability improved over the years. Management identified potential of expansion opportunities through introduction of new product line. Drawing upon research and current practice, you are asked to cover the following issues: 1. NK Sdn Bhd competitor VC Sdn Bhd provided the same services as the company. BOD identifying this issue, decides to analyse opek Water Bottle and Customized Labelling Management Costing Report for Financial Year End 2021. Analyse the Cost Volume Profit Analysis for financial year ending 31 December 2021 using your chosen costing statements by product and services (complete and/or excerpts whichever is relevant) (12 marks) 2. Analyse the cost behavior of direct and supporting overhead for financial year ending 31 December 2021 (1 marks) 3. Appraise the New Investment using time invariant technique. (2 marks)
NEW INVESTMENT The NEW INVESTMENT The company was established since 2012, and will be celebrating its 10th anniversary next year. With that
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am