Operating Model Cost Calculator

B Mode Cycle → Monthly Production Qty → Allocate Monthly Labour / Electricity / Fixed → Cost per Unit → Suggested Selling Price

1) Basic Info

Product

Date

Machine Type

Packaging Type

2) Production Capacity (Cycle → Monthly Qty)

Cycle (sec)

Base cycle time per shot

% Cycle Loss

Downtime / delay inside cycle (0–100)

Cavity

Machine Qty

Running Hours / Day

Working Days / Month

Efficiency %

Quality yield / performance (0–100)

Order Quantity (pcs)

Expected Daily Production (pcs/day)

Auto calculated (you can overwrite if needed)

3) Material (M1–M5)

Weight (g) (Inc Runner?)

% Weight Loss

Add loss due to scrap/trim (e.g., 2)

Net Weight (kg/pc)

Material blend: calculator auto-normalizes M1–M5 % to 100% (if total ≠ 100%).

Material	RM/kg	%	Contrib (RM/kg)	Per Unit (RM)

4) Labour (Monthly Pool → Allocate by Monthly Qty)

People per shift

Hours per shift

Rate per hour (RM)

Shifts per day (day+night)

Default matches: 9p × 11h × RM13/h × 2 shifts

Override Monthly Labour Cost (RM/month)

If checked, calculator will use this value instead of shift formula.

5) Fixed / Electricity (Hourly → Monthly Pool → Allocate)

Fixed Cost per hour (RM/hr)

Electricity per hour (RM/hr)

Auto monthly = rate/hr × hours/day × days/month × machineQty

Override Fixed & Elec (Monthly)

Monthly Fixed Override (RM/month)

Monthly Elec Override (RM/month)

If checked, monthly fixed/elec uses override values (instead of hourly formula).

Monthly Labour (RM)

Monthly Fixed (RM)

Monthly Elec (RM)

Allocated by Monthly Production Qty

6) Packaging & Transport

Packing Qty (pcs per carton/bag)

Carton/BAG Cost (RM)

Reuse %

Packaging (RM/pc)

If bag packaging: set cost=0 and reuse=0 if not used.

Transport mode

Direct: Transport per bag Lorry: per trip

Transport per bag (RM/bag)

Used in Direct mode

pcs per bag

Used in Direct mode

Lorry per trip (RM)

Used in Lorry mode

Carton in 1 lorry

Used in Lorry mode

Transport (RM/pc)

7) Mold Fee / Testing Mold Fee (Allocate by Mold Life Qty)

Mold Fee (RM)

Testing Mold Fee (RM)

Mold Life Qty (pcs)

If unknown, use large number or set 0 to ignore

8) Assembly / Sticker

Assembly Into A Set (labour RM)

Assembly Into A Set (Qty)

If you key RM and Qty, it converts to RM/pc

Sticker Per Unit (RM/pc)

9) Margin & Results

Divide by Margin (Gross Margin %) — e.g., 30

SellingPrice = CostPerUnit / (1 - Margin%)

Breakdown	RM / unit	Notes