The Effectiveness of Electronic Scheduling Template Case Study on Composite Based Products Company - Comparing Manual Calculation vs Electronic Scheduling System

Sep 3, 2026

The case study evaluates scheduling and material planning effectiveness by contrasting manual calculations with an electronic scheduling system for a composite-based products company. It compares how cycle time and material usage estimation, accessibility, and visibility of information differ between approaches. The electronic system shortens estimation time drastically, broadens who can perform the estimates, and provides clearer outputs via graphs and charts. Efficiency is assessed through accuracy, quality, and flexibility, with results indicating higher efficiency and better monitoring of plan versus actual usage across ancillary and chemical materials.

LanguageEnglish

CategoryPresentations

FormatPDF

Pages7

Reading Time3 min

AccessFree to download

Capacity and Scheduling Overview

Scheduling Constraints and Performance

Shop Status and Floor Management

Planning and Data Functions

Production Planning and Master Scheduling

Material Requirements and Capacity Planning

Inputs and Execution Flow

Data Collection

Job Loading and Orders/Demand Forecast

Dispatching

Manual vs Electronic Scheduling Comparison

Time, Capability, and Information Visibility

Efficiency Outcomes

System Sheets and Purposes

Data Entry and Material Estimation

Monitoring for Ancillary and Chemical Materials

Time Data and BOM Data

Data Page for Monitoring Summaries

| Capacity Status
Scheduling Constraints
Schedule performance
Shop status
Shop floor management
Dispatching
Scheduling and Rescheduling

Production Planning, master scheduling
Material requirements, planning, capacity planning

Data Collection

Job Loading
Shopfloor | Orders, demand forecast
Material Requirements | | --- | --- | | Element | Manual Calculation | Electronic Scheduling System | | --- | --- | --- | | Time | Time required to estimate a cycle time and usage of material more than 1 hours. | Time required to estimated cycle time and usage of material below than 1 minute. | | Capability /
accessibility | Only experienced people able to calculate cycle time and the usage of material. | Whosoever able to use the system to estimate the cycle time and the usage of material. | | Direct Information | Usage of the material unable to seen clearly. | Usage of the material visible through graph and chart generate by the system. | | Efficiency | Low rate efficiency in term of the accuracy, quality and flexibility. | High rate efficiency in term of the accuracy, quality and flexibility. | | Sheet | Usage | Purposes | | --- | --- | --- | | DATA ENTRY | Estimate duration time | As a main sheet of the system. The sheet linked with TIME DATA and MATERIAL. | | MATERIAL | Estimate material usage | Shows the usages of material require for completing the panel. It linked with DATA ENTRY, MONITORING ANCILLARY, MONITORING CHEMICAL and BOM DATA. | | MONITORING ANCILLARY | Generate an actual versus plan usage of ancillary material | Its shows the different of material usage between plan and actual usage. The summary of the results shows in graph and pie chart. It was linked with MATERIAL and DATA PAGE. | | MONITORING CHEMICAL | Generate an actual usage versus plan usage of chemical material. | Its shows the different of material usage between plan and actual usage. The summary of the results shows in graph and pie chart. It was linked with MATERIAL and DATA PAGE. | | TIME DATA | As a database of estimate duration time. | It was linked with DATA ENTRY | | BOM DATA | As a database of estimate Material usage. | It was linked with MATERIAL | | DATA PAGE | As a database to estimate Monitoring Material Usage. | It was linked with MONITORING ANCILLARY and MONITORING CHEMICAL |

FAQs

How does the electronic scheduling system change the time needed for cycle time and material usage estimation?

It reduces estimation time from requiring more than 1 hour manually to below 1 minute with the electronic scheduling system.

Who can perform material and cycle time estimation in each approach?

Manual calculation requires experienced people, while the electronic system allows anyone able to use the system to estimate cycle time and material usage.

How does the electronic system improve visibility and monitoring of material usage compared with manual calculation?

Material usage becomes visible through graphs and charts, and monitoring sheets generate actual versus plan differences for ancillary and chemical materials with summary visuals such as graphs and pie charts.

Sep 3, 2026

Upload by Ethan Miller