← All projects

Web Development / Manufacturing ERP

ERP Furnitur

A Laravel manufacturing ERP case study connecting customer orders, multi-level bills of materials, MRP, production, inventory, delivery, and invoicing.

Explore the use cases Discuss this project
Illustrated furniture manufacturing workflow from sales order through material planning and production to delivery and invoice
Workflow illustration based on the furniture manufacturing specification; not an application screenshot.

The context

What this project explores.

Kayu Jati ERP is a portfolio manufacturing case study for a fictional small furniture factory. Its specification follows make-to-order and make-to-stock workflows, linking each customer order to material requirements, work orders, inventory movements, production cost, and delivery.

Try the workflow / Interactive example

An order comes in. What happens next?

Change the quantities to see how available stock and production share the order.

Illustrative demo with synthetic quantities. This simplified stock-allocation example runs in your browser; it does not connect to the ERP or create real orders.

Build a sample order

Product: sample wooden chair. All quantities are whole units.

The supply plan

Unreserved stock available
12
Reserve for this order
12
New production required
12
Unreserved stock left
0

Reserve 12 chairs from available stock and plan production for the remaining 12. The 8 chairs reserved for other orders stay untouched.

Available stock = on hand − existing reservations.
Production required = order − stock allocated to this order.

Read the sales-order requirement ↓

System requirements / Use cases

How the system is used.

Explore who uses each workflow, what starts it, and the outcome defined in the specification.

Select a step to explore who uses it and what it produces.

Sales

Turn a customer order into a supply plan

When: A customer places an order with a requested delivery date.

Expected outcome: The order has a traceable production requirement and delivery reservation without allocating the same stock twice.

Read the full use case ↓

Production planning and inventory control (PPIC)

Model a product and its production steps

When: A new furniture product or production version is prepared.

Expected outcome: A consistent multi-level material and routing plan supports manufacturing and standard cost calculation.

Read the full use case ↓

PPIC, purchasing, and warehouse

Replenish missing materials and stock products

When: Open production demand or reorder rules reveal a shortage.

Expected outcome: Missing supply is linked back to demand, while purchase confirmation stays with the purchasing role.

Read the full use case ↓

Production operator and PPIC

Execute work orders and record production

When: A manufacturing order has the materials needed to start.

Expected outcome: Finished output, material usage, and production exceptions are recorded against the originating manufacturing order.

Read the full use case ↓

Warehouse and sales

Ship completed quantities and issue an invoice

When: Finished goods are ready to leave the factory.

Expected outcome: Shipment and billing remain aligned, with an order-to-delivery-to-invoice document trail.

Read the full use case ↓

The following scenarios summarize the system requirements (1 November 2026). They describe the intended business behavior; they are not a completion checklist for every requirement.

01Turn a customer order into a supply planSales

When A customer places an order with a requested delivery date.

  1. Create and confirm the sales order; check the quantity of finished goods that is actually available.
  2. Reserve existing finished goods and create linked manufacturing orders only for the shortage.

Expected outcomeThe order has a traceable production requirement and delivery reservation without allocating the same stock twice.

Requirements: FR-401–405

02Model a product and its production stepsProduction planning and inventory control (PPIC)

When A new furniture product or production version is prepared.

  1. Define the bill of materials, sub-assemblies, units, waste allowance, and operation-specific components.
  2. Define routing and work centers, validate against circular dependencies, and simulate requirements for the requested quantity.

Expected outcomeA consistent multi-level material and routing plan supports manufacturing and standard cost calculation.

Requirements: FR-201–207

03Replenish missing materials and stock productsPPIC, purchasing, and warehouse

When Open production demand or reorder rules reveal a shortage.

  1. Run MRP to calculate net requirements and propose purchase orders or make-to-stock manufacturing orders.
  2. Purchasing confirms the purchase order; warehouse receipt records incoming stock and refreshes reservations for waiting production.

Expected outcomeMissing supply is linked back to demand, while purchase confirmation stays with the purchasing role.

Requirements: FR-601–606

04Execute work orders and record productionProduction operator and PPIC

When A manufacturing order has the materials needed to start.

  1. Generate work orders from routing and use child manufacturing orders for missing sub-assemblies.
  2. Start, pause, and finish operations; record actual time, consumption, scrap, and reusable offcuts, with backorders for the remaining output.

Expected outcomeFinished output, material usage, and production exceptions are recorded against the originating manufacturing order.

Requirements: FR-501–508

05Maintain a traceable stock ledgerWarehouse

When Goods move, are reserved, or are physically counted.

  1. Record each stock change as a movement between locations and calculate available stock after reservations.
  2. Compare physical counts with ledger quantities and post differences through adjustment movements.

Expected outcomeThe stock card explains receipts, consumption, reservations, and adjustments instead of relying on direct balance edits.

Requirements: FR-301–305

06Schedule capacity and analyze production costPPIC and manager

When Production needs a feasible schedule or a completed order needs a cost review.

  1. Schedule work against work-center capacity and review the sequence in a Gantt view.
  2. Roll up standard material and routing cost, calculate actual consumption and work time, and compare the cost variance.

Expected outcomePlanning and cost review show where production uses capacity and where actual cost differs from the standard.

Requirements: FR-701–704, FR-801, FR-802

07Ship completed quantities and issue an invoiceWarehouse and sales

When Finished goods are ready to leave the factory.

  1. Warehouse validates the delivery, records outgoing stock, and creates a delivery note; partial deliveries keep a backorder.
  2. Sales creates the invoice from the quantity actually shipped and records its issued or paid status.

Expected outcomeShipment and billing remain aligned, with an order-to-delivery-to-invoice document trail.

Requirements: FR-803, FR-804

The specification covers manufacturing, inventory, purchasing, sales, and invoicing. Full general-ledger accounting, HR/payroll, multi-company operations, quality control, and machine maintenance are outside this case study's scope.

Requirement source

Spesifikasi Sistem ERP Manufaktur — Studi Kasus Pabrik Furnitur

View specification · repository access required

The approach

From problem to output.

01

Translate demand into production

Check available finished goods, reserve stock, and create manufacturing orders for the shortage using a multi-level bill of materials.

02

Plan and execute materials and work

Use MRP suggestions to purchase missing materials, schedule operations by work-center capacity, and record actual consumption, time, and scrap.

03

Deliver and understand the cost

Validate deliveries, invoice the quantities shipped, and compare standard production cost with actual cost.

Inside the repository

The deliverables.

More to explore.

Back to the collection