Let's start a new assignment project together, Get Exclusive Free Assistance Now!

Need Help? Call Us :

Place Order

Case study-1500+10% word report and analysis

Mar 13,23

Question:

Background:
Case study — 1500 + 10% word report and analysis – Individual Assignment.
Purpose. This assessment is designed to allow students to demonstrate their ab8ity to analyse given financial information relating to a management accounting problem, and present their findings and analyse the information as it applies to accounting concepts. It relates to learning outcomes a, b, c and d.
Value. 15% Due Date. Week 10 Friday
Submission. Students must upload their submission to the Moodie Assignment Link and Tumitin on the KOI Moodie Subject Home Page no later than 9.00 am Friday of Week 10. This is the submission due date and time. A printed copy should also be handed to the Tutor during that Week’s kitorial to assist with marking. All submissions must be accompanied by a signed KOI Assignment Coversheet.
Task details. Optic Vision Pty Ltd, a manufacturer of fibre-optic communications equipment, uses a job costing system. Since the production process is heavily automated, manufacturing overhead is applied on the basis of machine hours using a predetermined overhead rate. Estimated manufacturing overfiead costs of $3 600 000 and an estimated cost driver level of 80 000 machine hours.
Operations for the current year have been completed, and all the accountinq entries have been made for the year except the application of manufaduring overhead to the jobs worked on during December, the transfer of costs from work in process to finished goods lor the jobs completed in December, and the transfer of costs from finished goobs to cost of goods sold for the jobs that have been sold during December.
Summarised data as at 30 November, and for December, are presented in the following tables. Job numbers T11-007, N11-013 and N11-015 were completed during December. All completed jobs except job number N11-013 had been turned over to customers by the dose of business on 31 December
Raw nviier *
Required.

  1. Cak:ulate manufaduring overhead rate per machine
  2. How much manufacturing overhead would Optic Vision have applied to jobs to 30 November?
  3. How much manufacturing overhead would be applied to jobs by Optic Vision during December?
  4. Determine the amount by which the manufacturing overhead is overapplied or underapplied as at 31

Determine the balance in Optic Vision’s finished goods inventory account on 31 December.
Prepare a schedule of cost of goads manufactured for Optic Vision for the year. (Hint. In calculating the cost of direct material used, remember that Dptic Vision includes both direct and indirect material in its raw material inventory account.).
Now much total cost of completed jobs T11-007, N11-013 and N11-0158
Management accountant of Opdc Vbion, Sam has noticed that some competitors have adopted ABC method for manufacturing overhead cost. Sam believed Op0c Vision should also change ils costing method. Provlde support for Sam’s proposed change.
Research requirements: Students need to support their analyses with references from the text and a minlmum of six (6) Puttable, reliable and academlcaMy acceptable soumes. Check with your tutor if you are unsure of the validity of sources. Sludena seeking Cre&I or above gradec should support their analysts wlth increaeed number of reference soumes comparable to the grade they are seeking.
Marklng Gulde:

Marks awarded will be based on the following cd1eria:

Analyses-relevant to taek spedficatlon Costlng technlquee applled and evaluated Wrltten presentatlon
Research
2546
2546
2546
2546

Answer:

Introduction

Background of the cost system used by Optic vision for overhead allocation:
Optic Vision Pty Ltd uses a job costing system and manufacturing overhead is applied based on machine-hours using a predetermined overhead rate. The job order costing method is one of the methods which is used by many businesses for allocation of cost.
Job order costing method analysis:
The job order costing method is appropriate to be used when the company is producing unique products as per the requirement of the customers where each order from the customer is considered to be different from the other customer. Like in the case of legal firms, the case of each customer is different and so will be the time spend on each case.
(Banker, Chang, Ou and Wu, 2000)
Calculation of manufacturing overhead rate per machine hour:

Estimated manufacturing overhead $3,600,000
Estimated machine hours 80,000

Overhead rate will be calculated as below:
Estimated manufacturing overhead / Estimated machine hours
= $36,00,000 / 80,000
= $45
Manufacturing overhead applied to jobs to 30 November by Optic Vision:
In the job costing method, the pre-allocated manufacturing overhead rate is applied to all the jobs based on the actual utilization of the overhead allocation base. In this case, the base is machine hours.

Actual Machine Hours till 30th Nov 73,000
Predetermined manufacturing overhead rate $45

(As calculated above)
 Therefore, the overhead application will be
Actual Machine Hours till 30th Nov X Predetermined manufacturing overhead rate
= 73,000 X $45
= $3,285,000
Manufacturing overhead during December:

Job Numbers Machine Hours Predetermined Manufacturing O/H Rate Manufacturing overhead for each job
T11-007 300  $ 45  $ 13,500
N11-013 1,000  $ 45  $ 45,000
N11-015 1,400  $ 45  $ 63,000
D12-002 2,500  $ 45  $ 112,500
D12-003 800  $ 45  $ 36,000
Total 6,000  $ 45  $ 270,000

Total Manufacturing overhead application in December is $270,000
Determination of the amount by which the manufacturing overhead is overapplied or underapplied as at 31 December:
In the job costing method, since a predetermined allocation rate is used, so in most cases, there is a mismatch between the actual overheads incurred and the allocated overheads which leads to either over applied overheads or under applied overheads.

Activity to Nov December Activity Total
Actual Overhead $3,300,000 $288,000 $3,588,000
Overhead Applied $3,285,000 $270,000 $3,555,000
Under applied manufacturing overhead = $33,000

(Job Order Costing – Guide of How to Calculate Job Order Costs)
Determination of the balance of finished goods inventory account on 31 December:
All the completed jobs except job number N11-013 had been turned over to customers by the close of business on 31 December. So, the finished goods Inventory will be only for job number N11-013

Finished Goods inventory valuation for Job No N11-013 Amount
Balance of work in process as on 30th November  $ 165,000
Add:
Direct Material  $ 12,000
Direct Labour  $ 36,000
Overheads applied (1,000 machine hours x overhead rate of $45)  $ 45,000
Total valuation of finished goods inventory on 31st Dec  $ 258,000

Schedule of cost of goods manufactured for Optic Vision for the year:
For the cost of goods manufactured, we need to first calculate the direct raw material used and the closing inventory of work in process.

Calculation of cost of goods manufactured Amount Amount
Direct Material Used  $ 2,847,000
Direct labour:
Till November 2,535,000
For December 240,000  $ 2,775,000
Manufacturing overheads applied based on machine hours
Till November – Machine hours 73,000 x overhead rate $45 3,285,000
For December – Machine hours 6,000 x overhead rate $45 270,000  $ 3,555,000
Total Manufacturing cost  $ 9,177,000
Add: Opening work in process inventory  $ 180,000
Less: Closing work in process inventory  $ (450,600)
Cost of goods manufactured 8,906,400
Calculation of direct raw materials used: Amount
Opening raw material inventory  $ 315,000
Add Purchases:
Till November  $ 2,895,000
For December  $ 294,000
Less: Closing inventory  $ (255,000)
Less: Indirect material included in direct raw materials
Till November  $ (375,000)
For December  $ (27,000)
Raw material used  $ 2,847,000

Since the raw material purchases and raw material, inventory includes both direct and indirect materials, so from the raw material purchases, we will have to reduce the amount of indirect materials to arrive at raw material used, the reason being that the indirect material is being charged to the jobs through overhead allocation.

Calculation of closing work in process inventory: Amount
Uncompleted Jobs opening work in process on 30th Nov
D12-002  $ –
D12-003  $ –
Raw material used
D12-002  $ 113,700
D12-003  $ 78,000
Direct labour
D12-002  $ 60,000
D12-003  $ 50,400
Overheads applied on machine hours
D12-002 – machine hour 2,500 x $45 overhead rate  $ 112,500
D12-003 – machine hour 800 x $45 overhead rate  $ 36,000
Closing work in process inventory  $ 450,600

The closing work in process needs to be considered only for the jobs which were not completed till the end of December. Since Job numbers T11-007, N11-013 and N11-015 were completed during December, so we need to consider only the balance jobs which are still in work in process.
Computation of total cost of completed jobs T11-007, N11-013 and N11-015:
Only three jobs were completed till December so the total cost will be direct cost and overhead allocation of December as the opening work in process includes direct and allocation till November.

Calculation of total cost T11-007 N11-013 N11-015 Total
Opening work in process on 30th Nov  $ 261,000  $ 165,000  $ –  $ 426,000
Add raw materials used in December  $ 4,500  $ 12,000  $ 76,800  $ 93,300
Add direct labour used in December  $ 13,500  $ 36,000  $ 80,100  $ 129,600
Overheads applied in December @ $45 per machine hour of Dec  $ 13,500  $ 45,000  $ 63,000  $ 121,500
Total cost  $ 292,500  $ 258,000  $ 219,900  $ 770,400

(What is job order costing – Accounting for Management)
Application of Activity Based Costing (ABC) method to Optic Vision instead of job order costing.
Activity-based costing (ABC) is a method that allocates the cost based on the volume of activity. Activity-based costing is a concept where overheads are allocated among various products or services for determination of the cost accurately and in this process, there is no elimination of any overhead cost. In the activity-based costing method, the cost of all activities and overhead is traced to a particular product or service rather than blanket use across all product lines or services by using a single overhead rate. This enables businesses to allocate overhead costs more accurately to the product and the services that consume them. The different types of activities that can be there in the ABC method are product level, batch level, unit level, customer level, etc. The drivers for cost assignment in the ABC method are activity drivers and resource drivers. ABC method should be used when the overheads are high, there is a product or customer or service diversity, and also when there is a tough competition in the market
(Activity-based costing (ABC), 2013)
(Park, 2019)
Activity-based costing provides many benefits to the organization. Some of the key advantages of using the ABC concept to allocate overhead cost are summarized below:

  • The first and the most important benefit of using the activity-based costing method is that it allocates cost based on the use of resources and does not do allocation based on a pre-determined rate like in the case of job order costing where the total overheads and total allocation basis is used and applied for all the jobs
  • To determine the selling price of any product, the accurate cost of the product must be first determined. The use of an activity-based costing method ensures that accurate cost is allocated and thus helps in the determination of correct cost of the product. It also helps in planning and forecasting of cost of the product which is required to prepare finance budgets.
  • ABC method also helps to identify where high (and low) costs are being incurred and the cause which indirectly helps managers to take cost control measures and thereby reduce overheads.
  • ABC method helps in the identification of inefficient products, allocation of more resources to profitable products, and helps in cost control at an individual level, which helps in tracking unnecessary costs.

(Durana, 2019)
Based on the above discussion on the use of ABC and its advantages, it will be appropriate for Optic vision to use the ABC method rather than the job costing method.
Conclusion:
Analytical review of the job order costing method and the ABC method and also looking at the business in which these methods will be more appropriate, it can be concluded that Optic vision should change from job costing to the ABC method.
References:
Banker, R., Chang, H., Ou, C. and Wu, A., 2000. Job Costing and Pricing: Empirical Evidence from a Printing Company. [online] Available at: <https://www.researchgate.net/publication/2383350_Job_Costing_and_Pricing_Empirical_Evidence_from_a_Printing_Company>.
Corporate Finance Institute. Job Order Costing – Guide Of How To Calculate Job Order Costs. [online] Available at: <https://corporatefinanceinstitute.com/resources/knowledge/accounting/job-order-costing-guide/>.
Accounting for Management. What Is Job Order Costing – Accounting For Management. [online] Available at: <https://www.accountingformanagement.org/what-is-job-order-costing/>.
Durana, M., 2019. Research Review on Activity-Based Costing System (ABC): ABC’s Development, Applications, Challenges, and Benefits. SSRN Electronic Journal,.
Park, C., 2019. Activity-Based Costing system in the service sector. Korean Journal of Hospitality & Tourism, 28(6), pp.195-209.
CGMA. 2013. Activity-Based Costing (ABC). [online] Available at: <https://www.cgma.org/resources/tools/essential-tools/activity-based-costing.html>.

0 responses on "Case study-1500+10% word report and analysis"

Leave a Message

Your email address will not be published. Required fields are marked *