MHPlanner+

Variance Analysis

Required Hours:	3,136	2,849	3,291
Variance:	-494	-461	-649
Variance %:	-15.8%	-16.2%	-19.7%

Variance Analysis

Required Hours:	4,200.5	3,808	4,402.5
Variance:	+211.5	+182	+9.5
Variance %:	+5.0%	+4.8%	+0.2%

Approval Signatures

🎯 Quick Start

1. Dashboard Tab: View instant KPIs and quarterly summary at a glance
2. Qualified Staff Tab: Enter/modify resources and forecasted tasks for engineers
3. Admin & Mechanics Tab: Enter/modify resources and tasks for support staff
4. Report Tab: Auto-generated executive report with status and mitigation recommendations
5. All calculations are LIVE: Changes update instantly across all tabs

⚙️ How to Use Each Tab

📊 Dashboard Tab

• View real-time Key Performance Indicators (KPIs)

• Monitor quarterly variance for both staff categories

• Check alert notifications for critical/warning statuses

• Review color-coded status legend

👨‍✈️ Qualified Staff Tab

Resource Planning Section:

• Enter unit name (e.g., "Line Maintenance Engineers")

• Enter staff count for each unit

• Enter shift hours per day (typically 8 or 12 hours)

• Enter working days for each month (account for weekends and holidays)

• Click "+ Add Unit" to add more units

• Click "×" to delete unwanted units

Loss of Manhour Resources:

• Daily break time and sick leave (2%) are AUTO-CALCULATED

• Enter planned training hours for each month

• Enter vacation hours for each month

• NET AVAILABLE HOURS calculated automatically

Forecasted Workload:

• Enter task description (e.g., "Daily Pre-flight Inspections")

• Assign unit responsible for task

• Enter estimated hours per task

• Enter task frequency for each month

• Required hours AUTO-CALCULATED (Hours × Frequency)

• Variance analysis shows shortage or surplus automatically

🔧 Admin & Mechanics Tab

• Same structure as Qualified Staff tab

• Enter mechanics, technicians, coordinators, and support staff

• Enter maintenance and operational tasks

• All calculations work identically

📄 Report Tab

• AUTO-GENERATED executive report

• Shows overall status (Critical/Warning/OK)

• Detailed findings for both staff categories

• Recommended mitigation actions based on status

• Compliance statement and approval signatures

• Use "Print Report" button to generate PDF

📊 Understanding Status Levels

💡 Best Practices

✓ Update working days at the start of each quarter

✓ Account for Kuwait weekends (Friday-Saturday) and public holidays

✓ Review and adjust count factors based on actual performance (industry standard: 1.5-2.5x MPD baseline)

✓ Include buffer time for unscheduled maintenance and AOG situations

✓ Document variance reasons monthly for continuous improvement

✓ Coordinate with Operations for accurate flight schedule forecasting

✓ Validate training hours against annual training plan

✓ Consider environmental factors (temperature, facility conditions) when planning

✓ Save data regularly using the "Save Data" button

✓ Review KPIs weekly, full report monthly, and present quarterly to management

📊 Understanding the Calculations

Gross Available Hours Formula:

Staff Count × Shift Hours/Day × Working Days = Gross Hours

Net Available Hours Formula:

Gross Hours - Break Time - Sick Leave - Training - Vacation = Net Hours

Auto-Calculated Deductions:

• Break Time: Automatically calculated at 1 hour per 8-hour shift (12.5% of gross hours)

• Sick Leave: Fixed at 2% of gross hours (industry standard per EASA guidelines)

Variance Calculation:

Variance = Net Available Hours - Required Hours
Variance % = (Variance / Required Hours) × 100

Note: Negative variance indicates shortage; positive indicates surplus capacity

🔧 Advanced Features

Count Factor Application:

When planning tasks, consider applying a count factor to MPD-specified hours based on your organization's performance:

• Count Factor 1.5: Highly efficient organization with optimal conditions
• Count Factor 2.0: Standard organization (recommended starting point)
• Count Factor 2.5: Organization with challenging environmental conditions

Example: MPD task shows 0.5 MH, your organization typically takes 1.0 MH → Count Factor = 2.0

Capacity Utilization Optimization:

Target utilization rates for optimal efficiency:

• 85-95%: Optimal range for qualified staff
• 90-100%: Acceptable for admin/mechanics with buffer
• >100%: Requires overtime or temporary staff
• <75%: Consider resource reallocation or increased workload

Fatigue Risk Management:

Per EASA requirements and FRMS best practices:

• Maximum 48 hours per week per Kuwait labor law
• Plan adequate rest periods between shifts
• Monitor overtime patterns to prevent fatigue-related errors
• Adjust shift patterns during high-workload periods

❓ Troubleshooting & FAQ

Q: Why are my calculations not updating?

A: Click "🔄 Recalculate All" button or refresh the page. All inputs trigger automatic recalculation.

Q: What if I need more than 3 months planning?

A: Save each quarter separately. This tool is designed for quarterly rolling plans per MOE requirements.

Q: How do I account for overtime?

A: Add overtime as additional staff hours or increase shift hours/day. Note: Maximum 48 hours/week per Kuwait law.

Q: Can I add more resource units or tasks?

A: Yes! Use "+ Add Unit" or "+ Add Task" buttons. Use "×" button to remove rows you don't need.

Q: What should I do if variance exceeds -25%?

A:
1. Immediately notify QM and AM per regulatory requirements
2. Review Report tab for mitigation recommendations
3. Consider: overtime authorization, training acceleration, temporary staff, or work deferral
4. Document actions taken and expected resolution timeline

Q: How accurate should my forecasts be?

A: Aim for ±10% accuracy. Use historical data, flight schedule, and fleet planning. Review monthly and adjust for next quarter.

Q: What's included in "Required Hours" for tasks?

A: Include all associated work: actual maintenance, supervision, planning, tooling prep, documentation, and quality monitoring.