skills.rest
ha-giwan1203
ha-giwan1203COMMUNITY
Explore all skills by this author →
GitHub

sp3-production-plan

Automate SP3 production planning by reflecting ERP plans into D+1/D+2 schedules.

Updated Jul 23, 2025
Search Tags:#macros#manufacturing#erp#workflow-automation#stock-management#production-planning
One-click install
npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill sp3-production-plan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sp3-production-plan
Source: https://github.com/ha-giwan1203/GIWANOS_AgentOS/tree/main/90_%EA%B3%B5%ED%86%B5%EA%B8%B0%EC%A4%80/%EC%8A%A4%ED%82%AC/sp3-production-plan
Command: npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill sp3-production-plan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SP3 production planning automation addresses the daily, error-prone manual process of reflecting ERP plans into D+1/D+2 schedules, incorporating on-hand stock, night carryover, and manual sequencing to generate a ready-to-execute production plan.

Core Features & Use Cases

  • ERP plan reflection and D+1/D+2 scheduling based on current stock
  • Night carryover handling (approximately 3,900 EA) and weekly adjustments
  • Automatic 13-step sort, final plan assembly, and support for manual sequencing
  • Macro-driven workflow with APPLY_TO_PLAN, PREVIEW_BUILD, APPLY_MANUAL_SEQ, RESTORE_PLAN
  • Backups, validation, and safe recovery of the final production plan

Quick Start

Run the APPLY_TO_PLAN macro to generate and apply the daily SP3 production plan, then review the final output and adjust manual sequences if needed.

Frequently Asked Questions about sp3-production-plan

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate ERP production planning for D+1 and D+2 schedules?▼

Automating ERP production planning for D+1/D+2 schedules is done by reflecting ERP plans against current stock data. The APPLY_TO_PLAN macro generates the daily production sheet, applying an automatic 13-step sort and night carryover adjustments.

What is the best way to handle night carryover stock in daily manufacturing production plans?▼

Handling night carryover stock in daily manufacturing production plans requires adjusting approximately 3,900 EA from the previous shift. The automation workflow incorporates this carryover data into the final D+1/D+2 schedule assembly alongside current stock surveys.

How can I manually adjust the production sequence after applying an automated ERP plan?▼

Manually adjusting the production sequence after applying an ERP plan uses the APPLY_MANUAL_SEQ macro. This allows you to override the automatic 13-step sort for specific daily scheduling needs while keeping critical columns validated and safe.

Can I safely edit critical columns during macro-driven production planning without losing data?▼

Safely editing critical columns during macro-driven production planning is enforced through built-in validation and backup mechanisms. The RESTORE_PLAN macro allows you to recover the final production plan if manual edits or sequencing cause data conflicts.

Does the production planning workflow support previewing the final schedule before application?▼

Previewing the final schedule before application is supported by the PREVIEW_BUILD macro. This lets you review the generated D+1/D+2 production plan, including stock surveys and automatic sorts, before committing the changes to the daily sheet.

Related Skills

Explore More Data & Analytics Skills→
DavidsonGomesDavidsonGomes

int-omie

Access Omie ERP clients, products, orders, invoices, and stock via REST API.

Community
Advanced
BdM-15BdM-15

subcontractor-sow-builder

Generate compliant subcontractor SOWs/PWSs using Theseus knowledge graph requirements.

Community
Advanced
tomtoto757tomtoto757
14

erp-integration

Sync orders, inventory, and customer data between e-commerce stores and ERP systems.

Community
Advanced
augustoheissaugustoheiss

agency-supply-chain-strategist

Optimize China-based supplier networks and procurement strategies with qualification plans and risk assessments.

Community
Advanced