# Production Time Report - User Guide

## What This Report Does

The Production Time Report analyzes how much time your production resources spend on work for different customers and connects that time to actual sales revenue. It answers four key business questions:

1. **Where is my production time going?** - Shows time distribution across resources and customers
2. **Which customers generate the most revenue per production hour?** - Correlates work time with sales
3. **What is the efficiency of my production resources?** - Measures resource utilization
4. **What is our revenue per kilogram of product?** - Calculates €/kg for each customer and overall

## Main Features

### 1. Time Period Selection

- Choose any date range to analyze
- Default shows current month
- Visual warning if selected dates exceed available data

### 2. Three-View Layout

#### Summary View (Top Panel)

**What it shows:**

- Each production resource (machine/work center) as a row
- For each customer: percentage of resource time and actual hours
- Totals for all resources and customers
- Revenue and efficiency metrics

**Key insights you get:**

- Which resources are most utilized
- Customer concentration per resource
- Total production hours and their distribution
- Sales revenue per production hour

#### Invoice Rows View (Middle Panel)

**What it shows:**

- All customer invoices within selected period
- Product details, weights, and prices
- Delivery dates and sales information

**Use for:**

- Verifying which orders are included in analysis
- Understanding product mix per customer
- Checking invoice details

#### Actual Work Phases View (Bottom Panel)

**What it shows:**

- All production work completed within period
- Actual start/end times and durations
- Resources used and products manufactured
- Setup time vs. production time

**Use for:**

- Seeing detailed work activities
- Understanding production flow
- Identifying specific work records

### 3. Smart Customer Display

The report automatically determines the best way to display customer names:

- If most customer IDs are numbers → shows "ID + Name" format
- If customer IDs are text → shows "Name (ID)" format
- Corrects common name variations (e.g., "Ramtec" → "RAMTEC")

### 4. Comprehensive Metrics

#### Production Metrics

- **Total Hours**: Sum of all work time per resource
- **Percentage**: Each resource's share of total production time
- **Customer Distribution**: How each resource's time is split among customers

#### Financial Metrics

- **Total Sales**: Revenue per customer
- **Sales per Hour**: Revenue generated per production hour
- **Weight Analysis**: Product weight distribution and revenue per kilogram (€/kg)

#### Summary Calculations

- Overall production efficiency
- Customer revenue concentration
- Resource utilization rates

## How to Use This Report

### Step 1: Select Time Period

1. Use the date pickers at the top of the page
2. Choose start and end dates for your analysis
3. Click "Update" to generate the report

### Step 2: Analyze the Summary View

- Look at total hours to understand overall production volume
- Check customer percentages to see concentration
- Identify which resources are most/least utilized
- Review sales per hour to gauge efficiency

### Step 3: Drill Down with Detail Views

- Use Invoice View to see specific orders driving the numbers
- Use Work View to understand actual production activities
- Cross-reference between views for complete picture

### Step 4: Business Insights

**Resource Planning:**

- Identify underutilized resources (low total hours)
- Spot resource bottlenecks (high utilization)
- Plan capacity based on customer demand patterns

**Customer Analysis:**

- See which customers generate most revenue per hour
- Identify high-maintenance vs. high-value customers
- Understand customer resource requirements

**Efficiency Improvements:**

- Compare setup vs. production time ratios
- Identify resources with low sales-per-hour
- Find opportunities to improve throughput

## What Data Is Included

### Included in Analysis

- Production work with completed dates within selected period
- Invoice rows with delivery dates within period
- Actual production hours (setup + work time)
- Sales revenue from delivered products

### Excluded from Analysis

- Packing materials and related costs
- Work without completed dates
- Invoices outside selected date range
- Internal or non-billable work

## Understanding the Results

### Column Meanings (Summary View)

- **Load Group**: Production resource/machine name
- **Total Hours**: All time spent on this resource
- **Total %**: Percentage of all production time
- **Customer Columns**: Show % and hours per customer
- **Summary Rows**: Totals, sales, weight analysis, and efficiency metrics (including €/kg)

### Color Coding

- **Right borders**: Separate customer groups visually
- **Warning colors**: Date range issues
- **Grid separation**: Different data types clearly distinguished

## Typical Use Cases

### Monthly Performance Review

- Select last month
- Review which resources were most active
- Check customer distribution changes
- Compare sales per hour trends

### Customer Profitability Analysis

- Select quarter-to-date
- Identify high-revenue-per-hour customers
- Spot customers requiring excessive resource time
- Plan customer-specific improvements

### Capacity Planning

- Select busy period
- Identify resource constraints
- Plan for upcoming demand
- Justify new equipment purchases

### Production Efficiency

- Analyze setup vs. production time ratios
- Identify improvement opportunities
- Compare resource performance
- Benchmark against targets

## Tips for Effective Use

1. **Start with Summary**: Get the big picture first
2. **Use Appropriate Periods**:
   - Monthly for routine tracking
   - Quarterly for strategic analysis
   - Weekly for detailed operational review
3. **Cross-Reference**: Always check detail views to understand summary numbers
4. **Look for Patterns**: Compare across periods to spot trends
5. **Focus on Efficiency**: Sales per hour is a key performance indicator

## Limitations to Consider

- Only includes completed production work
- Revenue allocated by delivery date, not production date
- Doesn't account for work in progress
- Customer name corrections may need updates for new customers

## Export and Sharing

The report can be printed for sharing with:

- Management summaries (use Summary view)
- Detailed operational reviews (include all views)
- Customer meetings (focus on specific customer columns)
