Sunday, July 17, 2011

Gathering and Reporting Cost Data

The assembly department of a table manufacturer
Introduction
The purpose of this page is to demonstrate in as realistic a way as possible the collection and use of cost data. The setting is a table manufacturer; but to keep the demonstration as manageable as possible, only one department in the factory is demonstrated: the assembly department.
We are using a table manufacturer because it is relatively simple for everyone to appreciate the process of manufacture of a table: it is based on a very limited range of materials and the processes involved are non complex. Most of us can visualize the manufacture of a table!
The page begins with an overview of the manufacturing process and it does this by way of a simplified flowchart. We then take a look at the design of the table that we are working on and then build up the cost data that is the main purpose of this case study.
By the end of this case we will have worked on standard costs per unit, standard cost reports. We will also consider actual data and prepare a performance report for the assembly department.
The manufacturing process
The following diagram simplifies the processes in our imaginary furniture factory.
The following diagram helps us to appreciate what our table looks like: its design and component parts.
The above diagram tells us about the component parts of the table and the following diagram shows us the side view of the table and the bill of materials for it.
We've seen what information we need now, we know how to gather it and now we'll take a look at how to present the information we have gathered.
Working from the Assembly Department output records, the Bill of Materials and Stores Requisitions, we can prepare a report of materials used, tables completed and transferred to the Finishing Department and the efficiencies with which all of this work was completed.
Bill of materials
Material
Quantity
Cost each
Wood:
£
Table top 2m x 1m x 5cm
1
500
Long leg supports 1.6m x 5cm x 10cm
2
40
Short leg supports 0.8m x 5cm x 10cm
2
30
Legs 0.75m x 10cm x 10cm
4
50
Joint dowling
16
1
Other:
Frame brackets
4
25
Screws x 12 cm
12
1
Leg studs
4
5
Glue
n/a
1

Output for Week 1
Day
Tables
Finished
Monday
157
Tuesday
223
Wednesday
164
Thursday
300
Friday
265
Saturday
147

Activity 1: based on the above information, prepare a report for Monday showing the Standard usage of materials and the standard cost of materials based on the production data given in the Output for week 1 table.
Activity 2: once you have completed Monday's Standard Costing report, you receive Monday's actual materials usage and cost data. You are now required to present this information in as effective a way as possible for the Production Manager of this Furniture Factory.
Week 1
Actual
Monday
Cost
each
Completed tables transferred to Finishing Department
157
Wood:
£
Units
Table top 2m x 1m x 5cm
510
160
Long leg supports 1.6m x 5cm x 10cm
39
314
Short leg supports 0.8m x 5cm x 10cm
30
350
Legs 0.75m x 10cm x 10cm
50
700
Joint dowling
1.1
2500
Other:
Frame brackets
25.5
650
Screws x 12 cm
0.9
2000
Leg studs
3
628
Glue
1
157

Solutions
NOTES: Teachers or trainers using this case may withhold these solutions until their students or participants have worked through the activities.
Since the daily output is given for all other working days of the week, we could prepare performance reports for one or more of these days. We could then prepare a total weekly performance report along the lines we see here.
For teachers using this exercise as a classroom exercise, they could consider splitting their group into sub groups and have each sub group prepare the report for one day; the whole group could then prepare the weekly report by combining all six of the reports they will then have.
This is an ideal exercise for spreadsheet work.
The tables that follow come without explanation: check all of the calculations and layouts for yourself. Satisfy yourself that what you see here is what you found.
The tables may be used for discussion: now that we have these tables
  • what can we, as accountants, can do with them?


  • how can we use these tables as part of a management pack?


  • is there any way in which we can improve on the tables we see here?


  • is there any other information we would either like to receive or to give to our management colleagues?
    Solution 1
    Week 1
    Standard
    Standard
    Monday
    Cost each
    usage/table
    Completed tables transferred to Finishing Department
    157
    Wood:
    £
    Units
    Units
    £
    Table top 2m x 1m x 5cm
    500
    1
    157
    78500
    Long leg supports 1.6m x 5cm x 10cm
    40
    2
    314
    12560
    Short leg supports 0.8m x 5cm x 10cm
    30
    2
    314
    9420
    Legs 0.75m x 10cm x 10cm
    50
    4
    628
    31400
    Joint dowling
    1
    16
    2512
    2512
    Other:
    Frame brackets
    25
    4
    628
    15700
    Screws x 12 cm
    1
    12
    1884
    1884
    Leg studs
    5
    4
    628
    3140
    Glue
    1
    1
    157
    157
    Total 
    155273

    Solution 2
    Units Variance Report: Assembly
    Monday
    Completed tables transferred to Finishing Department
    157
    Wood:
    Standard
    Actual
    Variance
     
    Units
    Units
    Units
    Table top 2m x 1m x 5cm
    157
    160
    -3
    Long leg supports 1.6m x 5cm x 10cm
    314
    314
    0
    Short leg supports 0.8m x 5cm x 10cm
    314
    350
    -36
    Legs 0.75m x 10cm x 10cm
    628
    700
    -72
    Joint dowling
    2512
    2500
    12
    Other:
    Frame brackets
    628
    650
    -22
    Screws x 12 cm
    1884
    2000
    -116
    Leg studs
    628
    628
    0
    Glue
    157
    157
    0

    Cost Variance Report: Assembly
    Monday
    Completed tables transferred to Finishing Department
    157
    Wood:
    Standard
    Actual
    Variance
     
    Cost
    Cost
    Cost
    Table top 2m x 1m x 5cm
    78500
    81600
    -3100
    Long leg supports 1.6m x 5cm x 10cm
    12560
    12246
    314
    Short leg supports 0.8m x 5cm x 10cm
    9420
    10500
    -1080
    Legs 0.75m x 10cm x 10cm
    31400
    35000
    -3600
    Joint dowling
    2512
    2750
    -238
    Other:
    Frame brackets
    15700
    16575
    -875
    Screws x 12 cm
    1884
    1800
    84
    Leg studs
    3140
    1884
    1256
    Glue
    157
    157
    0
    Totals 
    155273
    162512
    -7239





  •  

    No comments:

    Post a Comment