Posteak Furniture Costing

Total SKU0Imported from Excel

Avg. Production CostRp0per SKU

Avg. Wood CostRp0per SKU

Monthly Overhead PoolRp0master

Product Costing

Search and filter SKU by buyer or collection

SKU	Grade	Wood	Total Cost	Price 20%	FOB Price	Tags

Cushion Costing

Search and filter cushion SKU by buyer or collection

SKU	Seat Cost	Back Cost	Pillow Cost	Total Cost	Selling Price	FOB USD	Tags
Loading cushion costing…

Cost Mix

Average across loaded SKUs

SKU Furniture Type Overall L (cm) Overall W (cm) Overall H (cm) Overall CBM Pack CBM Grade Buyer Collection Exchange Rate

01

Wood Costing

Rp0⌄

Teak GradeFinished wood m³Yield / Rendemen %Raw wood m³Wood price / m³

Raw Wood = Finished Volume ÷ (Yield % ÷ 100) • Wood Cost = Raw Wood × Wood Price / m³

02

Kiln Dry

Rp0⌄

Raw wood m³KD cost / m³

Kiln Dry = Raw Wood Volume × KD Cost / m³

03

Assembling

Rp0⌄

Furniture typeRate / SKUQty

Assembling = Rate / SKU × Qty

04

Aluminum

Rp0⌄

Aluminum Cost Mode Linked Aluminum SKU

Linked Production CostRp0Select an Aluminum Costing SKU

Simple: Aluminum Cost = Usage Qty × Rate / Unit. Linked: cost is pulled automatically from the selected Aluminum Costing SKU.

05

Coating

Rp0⌄

Coating Cost = Usage Qty × Rate / Unit.

06

Batyline

Rp0⌄

Batyline Cost = (Usage meter × Price / meter) + Labor Cost by Furniture Type.

07

Rope

Rp0⌄

Rope Cost = (Usage meter × Price / meter) + Labor Cost by Furniture Type.

08

Hardware

Rp0⌄

Hardware cost / SKU

Hardware cost per SKU.

09

Finishing

Rp0⌄

Surface area m²Finish optionPrice / LCoverage m²/L/coatCoatsMaterialFinish laborSanding

Liters = Area ÷ Coverage × Coats • Total = Material + Finishing Labor + Sanding

10

Overhead

Rp0⌄

AllocationCBM / unitLabor hoursMachine hoursRate

Overhead = Allocation Basis × Master Rate

11

Box Packaging

Rp0⌄

Surface area m²Pcs / cartonCarton boxFoam sheetStyrofoamEdge protectorShrink wrapTape / staplesPacking labor

Packing = (Box + Foam + Protection Materials) ÷ Pcs/Carton + Labor. Additional packaging materials can be added from Wood Master.

12

Container

Rp0⌄

Packed CBMRate / CBM

Container = Packed CBM × Container Rate / CBM

13

FOB

Rp0⌄

Packed CBMFOB rate / CBM

FOB = Packed CBM × FOB Rate / CBM

Wood Component Calculator

Component-level timber costing from Excel logic

SKUFurniture TypeTeak GradeWood Price / m³Yield / Rendemen %

Component	L cm	W cm	T cm	Qty	Finished m³	Raw m³	Surface m²	Cost
Total					0	0	0	Rp0

SKU Furniture Type Overall L (cm) Overall W (cm) Overall H (cm) Overall CBM Packed CBM Buyer Collection USD / IDR

Aluminum Components

Build the aluminum frame BOM from profile, length, quantity, and profile weight.

Surface Area0.000 m²

Total Weight0.00 kg

Aluminum Waste % Waste Cost Total Aluminum Material

01

Fabrication

Rp0⌄

Cutting Hours Cutting Rate / Hour Welding Hours Welding Rate / Hour Machining Hours Machining Rate / Hour Grinding Hours Grinding Rate / Hour

Fabrication = Cutting + Welding + Machining + Grinding

02

Powder Coating

Rp0⌄

Coating Basis Frame Weight kg Auto Surface Area m² Coating Surface Area m²

Coating Rate

Coating = Frame Weight × Rate/kg, or Surface Area × Rate/m²

03

Assembly

Rp0⌄

Assembly Hours Assembly Rate / Hour

Assembly Cost = Assembly Hours × Assembly Rate / Hour

04

Hardware

Rp0⌄

Hardware Other Material

Hardware Cost = Hardware + Other Material

05

Packaging

Rp0⌄

Packaging Cost

06

Overhead

Rp0⌄

Overhead

07

Container & FOB

Rp0⌄

Container / CBM FOB / CBM

Logistics = Packed CBM × (Container Rate + FOB Rate)

SKU Buyer Collection USD / IDR Rate

Cushion PartsClick a row to edit the component detail

PO Number Destination Shipment / Reference

Container Type Internal L (cm) Internal W (cm) Internal H (cm) Container Rate / CBM Usable Volume Factor % Max Payload kg

Load Items

Dimensions pull from SKU packed dimensions when available and remain editable.

Auto saved

3D Load Preview

Automatic collision-checked packing using the v2.8.5 container engine.

Add SKU items to start automatic packing.

Packing updates automatically as load inputs change.

SKU Load Summary

Effective container allocation reflects unused space in the simulated load.

SKU	Requested	Loaded	Unloaded	Occupied CBM	Effective Cost / Unit

Aluminum Profile Master

Add, edit or remove aluminum profile types, dimensions in mm, alloy, weight per meter and purchase price.

Auto saved

Process Rate Master

Fabrication, coating and assembly rates. Shared costs are copied automatically from Wood Master.

Coating Master

Add, edit or remove aluminum coating types, units and cost per unit.

Auto saved

Furniture Type Fabrication Averages

Average cutting, welding, machining, grinding and assembly time per SKU. Select a Furniture Type in Aluminum Costing to pull these defaults automatically.

Auto saved

Foam Master

Block price and dimensions automatically calculate foam price per m³.

Outer Fabric Master

Fabric price per m² and waste allowance.

Other Cushion Inputs

Labor, waste, inner fabric and Batyline rates from Cushion Master.

Wood Master

Add, edit or remove teak grades and furniture yield types.

Auto saved

Kiln Dry Master

Edit batch inputs and KD rate.

Auto saved

Assembling Master

Add, edit or remove furniture types and assembly rates.

Auto saved

Batyline Master

Manage Batyline price per meter and usage by Furniture Type.

Auto saved

Rope Master

Add rope variants, unit and cost per unit.

Auto saved

Finishing Master

Add finishing materials and edit coverage, labor and sanding rates.

Auto saved

Overhead Master

Edit allocation rates and monthly overhead.

Auto saved

Packaging Master

Add packaging types and edit carton, foam, labor and protection rates.

Auto saved

Hardware Master

Edit default hardware cost per SKU.

Auto saved

Container Master

Edit container allocation rate per CBM.

Auto saved

FOB Master

Edit FOB allocation rate per CBM.

Auto saved