Scribd
Upload
56 views9 pages

CNC Workpiece Cost Analysis Report

This document contains information about the production of two parts (Part A and Part B), including their dimensions, the tools and machining times needed to produce them, costs associated with machine time and tool wear, and a breakdown of total costs. It will take 288.58 minutes or 2 hours to machine one workpiece using 11 different tools. The total cost per workpiece is Rp. 285,577.26 and the grand total of all costs is Rp. 429,868.92.

Uploaded by

Wisman Lugiana Putra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
56 views9 pages

CNC Workpiece Cost Analysis Report

This document contains information about the production of two parts (Part A and Part B), including their dimensions, the tools and machining times needed to produce them, costs associated with machine time and tool wear, and a breakdown of total costs. It will take 288.58 minutes or 2 hours to machine one workpiece using 11 different tools. The total cost per workpiece is Rp. 285,577.26 and the grand total of all costs is Rp. 429,868.92.

Uploaded by

Wisman Lugiana Putra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Part Name

Part Number

:
:

Part
Part A
Part B

Dimension Product

Raw Material
35x45x75
40x45x75

TIME ALLOCATION
No

Description

T01
T02
T03
T04
T05
T06
T07
T08
T09
T10
T11

Center Drill 2
Drill 8
Flat EndMill 12

T12

Flat EndMill 8
Ball EndMill 6
Drill 7
Tap Machine M8x1.25
-

Time (secons)
22.00
181.00
7,357.00
129.00
7,387.00
139.00
300.00
0.00
0.00
0.00
0.00
0.00

Total cutting time:


Clamping, unclamping, etc.:

15515.00
1800.00

Total workpiece time:

17315.00

Total workpiece time (minutes)

288.58

TOOL WEAR COST PER HOUR


No.
T01
T02
T03
T04
T05
T06
T07
T08
T09
T10
T11

Description
Center Drill 2
Drill 8
Flat EndMill 12
Flat EndMill 8
Ball EndMill 6
Drill 7
Tap Machine M8x1.25
-

Designation
HSS
HSS
HSS
HSS
HSS
HSS
HSS

T12

* Assum tool life is 30 minutes.

MACHINE COSTS PER HOUR (workpiece time)


Description
Electricity costs per hour (kwh)
M & R cost for machine per hour
Operator costs per hour
M & R costs for building per hour
Machine costs per hour (workpiece time)

Machine costs per minute (workpiece time)

Unit cost
M & R cost for machine per hour

Values in Rp.
0.00
14,687.50
15,000.00
29,687.50

142,789

Life time ( hr)


Rp

0.00
#DIV/0!

COST OF A WORKPIECE
Description
Machine costs per hour (workpiece time)
Tool wear cost per hour
Set-up cost (programming, setting-up of machine, etc.)
Workpiece time in HOURS
Amount of workpieces
Total material costs
Surcharge for CNC - Department in % (without Tool wear costs and
Total material costs)
Price for one workpiece:

TOTAL PRICE:

Values
29,687.50
0.00
4.81
2.00
0.00
0.00
285,577.26

285,577.26

CLASSIFICATION OF COSTS
Electricity costs per hour

0.00

M & R costs per hour


Operator costs per hour
M & R cocts for building per hour

0.00
29,375.00
30,000.00

Description

Values in Rp.

Total electricity costs


Total M & R costs
Total operator costs (including set-up costs)
Total M & R costs for building
Total wear costs
Total material costs
Total surcharge for CNC-department
GRAND TOTAL:

0.00
0.00
141,285.59
288,583.33
0.00
0.00
0.00
429,868.92

Weight Raw Material (kg)


Price Matl/kg
0.31894
0.3645

Material Cost
0
0
0
0
0

Total Material Cost

Cutting time in %
0.14
1.17
47.42
0.83
47.61
0.90
1.93
0.00
0.00
0.00
0.00
0.00
100

Amount of

Tips price

Cost/hour

Cutting time

Cutting edge

(Rp)

%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.14
1.17
47.42
0.83
47.61
0.90
1.93
0.00
0.00
0.00
0.00

0.00

0.00
Subtotal:
Overhead cost:
TOTAL

Values in %
0.00
0.00
49.47
50.53

h,d,w,shift,Year

Plus SetUP Cost

8
117,500.00

5
587,500.00

4
2,350,000.00

Tool Wear
cost per hour
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00

25%

You might also like