Cost Per Unit Calculation And Profit And Loss Analysis

Traditional costing system

1. Calculate cost per unit of the two models of sewing machines under the current traditional costing system.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

2. Calculate cost per unit of the two models of sewing machines under Activity based Costing.

3. Sewing easy sells the advance model at a price of cost (under the current costing system) plus 20% and is willing to give the same selling price to the overseas buyer. The overseas buyer wants to purchase only the advance model. Prepare December 2017 Profit and Loss Statement for the advance model where (a) traditional costing is used to calculate the product cost (b) Activity Based Costing is used to calculate the product cost. Analyse why the overseas buyer is interested to buy only the advance model. In your discussion you should highlight the importance of accurate product costing.

4. Seldom will we see that the actual overhead and applied overhead is the same. Discuss why and state three ways to deal with under/over applied overhead costs.

5. What are the main benefits and limitations of ABC system?

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Statement of Cost- Traditional Approach

Particulars

 Basic Model

 Advance Model

Units produced and sold

              1,600

                   1,500

Direct Material cost per unit

                 325

                      560

Direct Labour cost per unit

                 150

                      260

Total Material Cost

         5,20,000

              8,40,000

Total Labour cost

         2,40,000

              3,90,000

Total Allocated Overhead cost

         1,43,750

              1,06,250

Cost related only to advance Model

   Selling and Administration expenses

                   –  

              1,40,600

   Interest Expense

                   –  

                 25,200

   Office Rent

                   –  

                 35,900

Total Cost

         9,03,750

            15,37,950

Cost Price Per unit

                 565

                   1,025

Allocation of Overhead under Traditional approach

 

Particulars

 Amount

 

Inspection

            20,000

 

Assembly

            90,000

 

Production Scheduling

         1,05,000

 

Machine set-up

            35,000

 

Total Overhead

         2,50,000

 

Total Machine Hours consumed

              8,000

 

Overhead per Machine Hour

                   31

 

   Overhead Allocated to Basic Model

         1,43,750

 

   Overhead Allocated to Advance Model

         1,06,250

 

Statement of Cost- ABC approach

Particulars

 Basic Model

 Advance Model

Units produced and sold

              1,600

                   1,500

Direct Material cost per unit

                 325

                      560

Direct Labour cost per unit

                 150

                      260

Total Material Cost

         5,20,000

              8,40,000

Total Labour cost

         2,40,000

              3,90,000

Total Allocated Overhead cost

            75,506

              1,74,494

Cost related only to advance Model

   Selling and Administration expenses

                   –  

              1,40,600

   Interest Expense

                   –  

                 25,200

   Office Rent

                   –  

                 35,900

Total Cost

         8,35,506

            16,06,194

Cost Price Per unit

                 522

                   1,071

Allocation of Overhead-ABC Approach

Particulars

Inspection

Assembly

Production Scheduling

Machine set-up

Total Cost

Cost

            20,000

                 90,000

                       1,05,000

              35,000

   2,50,000

Consumption of resource – units

                 950

                   8,000

                               550

                   350

Cost per unit

                   21

                        11

                               191

                   100

Units for Basic Model

                 200

                   4,600

                                 50

                   100

Units for Advance Model

                 750

                   3,400

                               500

                   250

Total Overhead for Basic Model

              4,211

                 51,750

                            9,545

              10,000

      75,506

Total Overhead for Advance Model

            15,789

                 38,250

                          95,455

              25,000

   1,74,494

Statement of Profit and Loss- Tradition Approach

Particulars

 Basic Model

 Advance Model

Sales

      10,84,500

            18,45,540

Less:

Total Material Cost

        5,20,000

              8,40,000

Total Labour cost

        2,40,000

              3,90,000

Total Allocated Overhead cost

        1,43,750

              1,06,250

Cost related only to advance Model

   Selling and Administration expenses

                   –  

              1,40,600

   Interest Expense

                   –  

                 25,200

   Office Rent

                   –  

                 35,900

Profit

        1,80,750

              3,07,590

 Calculation of Sales Price Per unit- Tradition Approach

Particulars

 Basic Model

 Advance Model

 Cost per unit

                565

                   1,025

 Add: profit margin 20%

                113

                      205

 Sale Price Per unit

                678

                   1,230

Statement of Profit and Loss- ABC Approach

Particulars

 Basic Model

 Advance Model

Sales

      10,02,607

            19,27,433

Less:

Total Material Cost

        5,20,000

              8,40,000

Total Labour cost

        2,40,000

              3,90,000

Total Allocated Overhead cost

           75,506

              1,74,494

Cost related only to advance Model

   Selling and Administration expenses

                   –  

              1,40,600

   Interest Expense

                   –  

                 25,200

   Office Rent

                   –  

                 35,900

Profit

        1,67,101

              3,21,239

 Calculation of Sales Price Per unit- ABC Approach

Particulars

 Basic Model

 Advance Model

 Cost per unit

                522

                   1,071

 Add: profit margin 20%

                104

                      214

 Sale Price Per unit

                627

                   1,285

The company has been using tradition costing system under which cost allocation is not done in a proper manner. The price of the advance model charged by the company is $1230, whereas if the company would have adopted ABC costing they would have charged $1285 per unit. The overseas buyer has noticed this lower price for the given company and is interested in advance model only. Since some portion of expense of advance model has been transferred to basic model, the price of that has increased from $627 to $678. This means that the basic model is overpriced and advance model is under price. This is reason because of which the overseas buyer is interested only in the advance model and not in the basic model or both.

In order to pre determine the unit cost for the manufacturing companies, the managers evaluate and budget the expenses which are likely to be expended in the production process. These expenses are then allocated over the units produced to determine the cost per unit. Based on this data the amount is recovered from the customers (Holtzman, 2013). When the production cycle starts and actual expenses start to incur, then it is found that there are variances between the budgeted and actual rates. Due to this difference the under and over recovery of overheads takes place. No treatment is required if the applied and actual overhead are same. This can be possible only when the budgeted expenses are equal to the actual expenses.

This under and over recovery are to be treated in the books of accounts. There are three common ways in which these are treated. They are as follows:

  • Carrying forward the said amount: many companies follow the rule to carry forward the under or over recovered amount to the next financial year. The adjustments are made in the following year and then the balance is carried forward to the next year.
  • Writing off in profit and loss account: the simplest ways to treat under or over recovery is to write off the amount in the profit and loss statement for that year.
  • Adjustment in the current year with existing units: this is the least commonly used ways. Under this system the under or over recovered amount is adjusted over the remaining units unsold. This is unrealistic as it increases the price of the products.

Therefore, companies can treat under and over recovery of overheads in the manner which is most suitable to them.

Activity based cost, as the name suggest is the type of costing technique under which the cost are allocated based on the activities consumed by the product. This modern costing technique which helps is better allocation of cost, so that correct costing for a product can be done. This system has both advantages and disadvantages. The advantages are:

  • Since the ABC costing requires the cost data to be collected at one place, it gives the mangers a pool of data to work and analyse on. They can process this data and make important decisions.
  • Since this system helps allocate cost as per usage, this helps eradicate the system of over and under absorption of expenses. This helps in better recovery and accountability of cast data.
  • Just as discussed above, some products are wrongly overpriced while using averages for cost apportionment. This approach helps remove this uneven distribution and helps in correct pricing of the product
  • The data collected is too much in this approach, using this data the managers can implement policies which may help them in cost saving techniques. It may also help unnecessary costs.(Menifield, 2014)

These were the advantages. Following are the few disadvantages of activity based costing:

  • In order to implement the ABC approach, too much data collection is required which requires extensive labour and time
  • This approach may result to be expensive for small manufacturing companies.
  • Since this system is most suited to manufacturing units, the service industry do not benefit from them.
  • Since the activities are the cost drivers under this approach it is important for the managers to understand the organisational processes properly. This involved too much man power.
  • It is very time consuming process.

Therefore we see that the activity based costing has both advantages and disadvantages. The companies should try to make of the system by overcoming the disadvantages. It is important that the enterprises apply the system only if it would help them simplify the processes and not the opposite.

Holtzman, M. (2013). Managerial Accounting For Dummies. Hoboken, NJ: Wiley.

Menifield, C. E. (2014). The Basics of Public Budgeting and Financial Management: A Handbook for Academics and Practitioners. Lanham, Md.: University Press of America.