Web Costing Template - Google Sheet Ready

Google Sheet Connection

Google Apps Script Web App URL

Connection

Paste your Apps Script Web App URL once, then click Save Local Draft so this computer remembers it.

Product Header

Costing ID

Company / Customer

Product Code

Product Name

Revision No.

Costing Date

Prepared By

Status

Previous Revision

Reason for Revision

1) Setup Cost

Mould Setup Cost (RM)

Machine Tonnage

Machine Setup Cost (RM)

Material Setup Cost (RM)

Total Setup Cost (RM)

2) Manufacturing Cost

Cavity

Cycle Time / Shot (sec)

Output / Hour (pcs)

Machine Usage Cost / Hour (RM)

Machine Cost / Pc (RM)

Manpower Type

Manpower Cost / Hour (RM)

Manpower Cost / Pc (RM)

Secondary Process

Ultrasonic Cost / Pc

Fixing Cost / Pc

Special QC Cost / Pc

Total Manufacturing Cost / Pc

3) Material + Pigment Cost

Material

Material Cost / KG (RM)

Product Weight / Pc (g)

Runner Weight / Shot (g)

Shot Weight incl. Runner (g)

Material Cost / Pc (RM)

Masterbatch / Pigment Cost / KG (RM)

Usage % / KG Material

Pigment Cost / Pc (RM)

Total Material Cost / Pc

4) Packaging Cost

Per Bag PCS

Cost Per Bag (RM)

Bag Cost / Pc

Per Carton PCS

Cost Per Carton (RM)

Carton Cost / Pc

Total Packaging Cost / Pc

5) Rejection, Overhead & Selling Price

Base Cost / Pc

Rejection %

Rejection Cost / Pc

Overhead %

Overhead Cost / Pc

Total Unit Cost

Profit Margin %

Selling Price / Pc

MOQ

Total Order Value

Remarks

Final Cost Summary

Total Material / Pc

RM0.0000

Total Manufacturing / Pc

RM0.0000

Total Unit Cost

RM0.0000

Selling Price / Pc

RM0.0000