📄 Statement of Work (SoW)
Sign in

Statement of Work (SoW)

Project Title: SkyPlanner Implementation for IEC Plant Engineering

Prepared by: Appomax Co., Ltd.
Client: Alpha Sim Sdn. Bhd.
End-User: IEC Plant Engineering (https://iecpe.com)

1. Project Objective

The objective of this project is to implement SkyPlanner, a lightweight manufacturing planning and execution platform, to replace IEC’s manual operations with a digital system that improves visibility, traceability, scheduling efficiency, and material planning across all production lines. The solution will include custom project tracking and contextual dashboards, utilising Appsmith, to align execution with IEC’s internal project workflows.

2. Functional Scope

2.1 Modules to be Implemented

Functional Area Description
Order Management Creation of Sales & Manufacturing Orders with routing and due dates
Bill of Materials (BOM) Define materials required per product using SkyPlanner’s Materials module
Routing Management Define and sequence manufacturing steps per product line
Scheduling & Capacity Use Arcturus AI engine for Gantt-based finite capacity scheduling
Warehouse & Inventory Manage on-hand stock, transactions, and allocations
Shop Floor Execution Operators log task times and quantities using SkyPlanner’s Timer App
Built-in Reporting Production status, job tracking, order delays, and inventory levels
Project Management Organize work orders into Projects for IEC’s execution teams with Appsmith

2.2 Project Management Scope

To complement SkyPlanner’s order-based execution model, Appsmith will be used to implement a project-oriented view of manufacturing activity. This enables IEC to group multiple SkyPlanner orders into unified “Projects” aligned with internal workflow and delivery objectives.

Key Features:

  • Project creation and tracking across multiple SkyPlanner orders

  • Gantt/Kanban views of project tasks and milestones

  • Context fields (e.g. project notes, customer requirements, deadlines)

  • Real-time progress updates using SkyPlanner API data

  • Responsibility assignment and status indicators per task/phase

  • Executive dashboard with aggregated status and delays

  • Exportable reports for management and customer-facing updates

This module enables IEC to manage not only order execution but also delivery timelines, cross-departmental collaboration, and higher-level production initiatives.

3. Technical Scope

3.1 Deployment & Environment

  • SkyPlanner SaaS Platform
    • SkyPlanner is a SaaS-based platform that will be accessed by users via a web browser. No local installation or on-premise infrastructure is required for SkyPlanner.
  • Appsmith Deployment
    • Appsmith will be deployed in AWS EC2 as a containerised application. It will provide custom dashboards and project management interfaces for IEC, consuming data from SkyPlanner via its public API.
  • PostgreSQL Reporting Database
    • A local PostgreSQL database hosted in AWS (RDS) will be used as a reporting layer. Data from SkyPlanner will be periodically synchronised into this database. In addition, Appsmith will write and manage master data (CRUD operations) relevant for reporting and dashboard enrichment.
  • Serverless Sync & Integration Layer
    • A serverless job scheduler will be implemented using AWS EventBridge, Lambda, and SQS to manage the data integration between SkyPlanner’s API and the AWS reporting database. This integration will be triggered hourly to ensure near real-time visibility in reports.
  • Business Intelligence (BI) via Amazon QuickSight
    • Amazon QuickSight will be used to deliver centralised BI dashboards based on the reporting database.
      • Note: Paginated reports are not included in the current scope. If required, they can be enabled as an add-on service at an estimated AWS cost of $500/month.

3.2 Localization

  • IEC may provide a glossary to support translation and labelling within SkyPlanner’s multi-language UI features, where applicable.

4. Implementation Scope

4.1 Responsibility: Appomax

  • Configure SkyPlanner instance for IEC, including company settings, users, and permissions.

  • Import master data using SkyPlanner’s CSV import utilities:

    • Products and product groups

    • Bills of Materials (Materials)

    • Routings (Process Steps)

    • Initial stock balances by warehouse

  • Configure user roles and access control according to IEC’s operational structure.

  • Train operators to use SkyPlanner’s native Gantt scheduling view and Timer App, enabling them to log task execution and view order timelines.

  • Implement and test API integration to:

    • Appsmith will serve as the frontend platform for project-level dashboards and context-based tracking by aggregating and presenting SkyPlanner work order data.

    • AWS PostgreSQL-based reporting database, which will store synchronised operational data (via API) for historical analysis and reporting.

  • Set up a serverless scheduler using AWS EventBridge, Lambda, and SQS to automate hourly data synchronisation from SkyPlanner into the reporting database.

  • Develop custom Appsmith dashboards for project tracking, progress monitoring, and exception handling across multiple orders.

  • Configure Amazon QuickSight to connect to the PostgreSQL reporting database and provide business intelligence dashboards.

    Note: Paginated reports are out of scope but can be offered as an add-on at an estimated AWS cost of $500/month.

5. Out-of-Scope

  • CRM or quotation functions (e.g., customer tracking, sales funnel, quote generation)

  • Automated machine data capture (e.g., from PLCs, SCADA, sensors, IoT devices)

  • Barcode or RFID hardware integration (e.g., handheld scanners, tag readers)

  • Financial modules including General Ledger (GL), Accounts Payable (AP), and Accounts Receivable (AR)

  • Multi-entity or multi-site deployment (scope is limited to the initial IEC factory)

  • Integration with third-party systems beyond SkyPlanner, Appsmith, and Amazon QuickSight (e.g., ERP, MES, accounting, HRM)

  • Advanced user authentication systems (e.g., SSO, Active Directory)

  • Mobile app development or native mobile integration

  • Paginated reports in QuickSight (available as an optional add-on at additional cost)

  • Long-term data lake storage, schema cataloging, or ETL pipelines using AWS Glue or Athena

6. Deliverables

  • Configured SkyPlanner SaaS instance with up to 10 product lines, including BOMs, routings, and initial inventory

  • Validated master data imported into SkyPlanner (Products, Materials, Routings, Stock Balances)

  • SkyPlanner’s built-in Gantt view and Timer App are enabled, with operator training on their usage

  • Appsmith-based dashboards for project-level tracking and contextual views, integrating with SkyPlanner via API

  • AWS-hosted reporting database with automated sync from SkyPlanner via serverless scheduler

  • Connected reporting via Amazon QuickSight, visualising data from the reporting database

  • User training sessions, including walkthroughs of SkyPlanner, Appsmith dashboards, and QuickSight reports

  • Handover package, including configuration settings, API mappings, operating procedures, and system architecture