production-report

Aggregates BI results, wage-rate costs, and live assembly-cost data into a master production list.

Updated Jul 23, 2025
One-click install
npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill production-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: production-report
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/production-report
Command: npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill production-report

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the aggregation of production-related data from BI results, wage-rate costs, and live assembly-cost data to generate a single master production list, reducing manual consolidation and errors.

Core Features & Use Cases

  • Automated data integration: merges BI production results, rate data, and live API data into a single master sheet.
  • End-to-end master list generation: outputs production-management_master_list.xlsx for planning and reporting.
  • Use Case: When weekly BI exports and rate sheets update, run the automation to refresh the master list for management review.

Quick Start

Execute the build_master.py script to generate the production-management_master_list.xlsx from the latest BI results, rate data, and assembly-cost API.

Frequently Asked Questions about production-report

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

FAQPage Schema
How do I automate production reporting by aggregating BI data and cost data?

Automating production reporting involves merging BI results, wage-rate costs, and live assembly-cost API data into a single master list. This Skill executes that aggregation automatically to reduce manual consolidation errors and generate a comprehensive Excel file for management review.

What is a master production list and how is it generated from multiple plants?

A master production list is a consolidated Excel sheet combining production results, rate data, and assembly costs across multiple plants and product lines. It is generated by executing a build script that integrates BI exports and live API data into a unified file.

How do I consolidate weekly BI exports and wage-rate sheets into one Excel file?

Consolidating weekly BI exports and wage-rate sheets into one Excel file requires automated data aggregation. This Skill merges these sources with live assembly-cost data, applying input validation and error handling to output a finalized master list spreadsheet.

Can I use this automation for monthly cost tracking across different product lines?

Yes, you can use this automation for monthly cost tracking across different product lines. It is designed to handle both weekly and monthly production reporting, aggregating wage-rate costs and live assembly data to support performance reviews.

Does the master list generation process handle live API integration for assembly costs?

Yes, master list generation handles live API integration for assembly costs. The process automatically fetches live assembly-cost data, merges it with BI production results and wage rates, and applies error handling to ensure robust file generation.

What is the best way to reduce manual data consolidation errors in production management?

The best way to reduce manual consolidation errors is automating the aggregation of BI results and cost data. This Skill applies input validation and automated file handling to merge multiple data sources into a reliable master list.