Source: https://daphnislabs.com/case-studies/allied

Internal Software & Modernisation

# Allied

Product costing, built for offline work

Define product recipes and calculate component requirements for different production quantities.

[Read the story](https://daphnislabs.com/case-studies/allied#story)

![Allied ERP — product creation with item lookup](https://daphnislabs.com/images/projects/allied/product-desktop.webp)

## The project

Allied’s earlier accounting environment dated to 1996 and used a command-prompt-style, 16-bit interface. Daphnis developed its replacement desktop application and carried out networking between the office and factory floor.

**Industry**

Masterbatches & compounds

**Our role**

Windows desktop development Office–factory networking

**Technology**

Electron React Tailwind CSS SQLite

**Operation**

Offline Windows desktop application

## Inside the desktop application

![Allied ERP — desktop login](https://daphnislabs.com/images/projects/allied/login-desktop.webp)

### Sign in to the workspace

Username and password access sits ahead of the team’s item, product and calculation tools.

![Allied ERP — item manager in its empty state](https://daphnislabs.com/images/projects/allied/items-desktop.webp)

### Maintain item records

Item Manager provides code-based search and an entry point for creating items. The documented item model stores the item name, details and rates, including GST.

![Allied ERP — user administration](https://daphnislabs.com/images/projects/allied/users-desktop.webp)

### Manage users and roles

The administration screen brings user creation, role selection, password reset and account activation into one view.

## From a product recipe to a costing sheet

A stored bill of materials supplies the base quantities for each calculation.

1.  ### Define the recipe
    
    Associate component items and their quantities with a product code and name.
    
2.  ### Scale the components
    
    Divide the requested production quantity by the product’s base quantity, then apply that multiplier to each component.
    
3.  ### Calculate the cost
    
    Review component costs, total cost and GST-inclusive cost. A profit-percentage input determines the sale price per kilogram.
    
4.  ### Save, review and print
    
    Save the item-level breakdown in the user’s calculation history. Reopen an entry or select several calculations for individual or bulk printing.
    

## Local data and everyday desktop tools

The React interface calls Electron’s preload bridge and IPC handlers to work with local SQLite data, without a hosted backend.

1.  ### Save related records together
    
    A SQLite transaction stores each calculation and its component rows together, so a failed save does not leave a partial calculation.
    
2.  ### Export master data
    
    Export items, products and product composition as CSV files through a native save dialog.
    
3.  ### Keep frequent actions on the keyboard
    
    F8 opens item creation, F9 opens product creation and F10 opens the calculator. F1 opens the shortcut reference.
    

[All case studies](https://daphnislabs.com/case-studies) [Next project**Urbanface**](https://daphnislabs.com/case-studies/urbanface)

## What are you building?

Bring us your idea. We’ll shape the next step together.

[Talk about your project](https://daphnislabs.com/contact?intent=plan-build)
