← WLF Tool

User Guide

AFN WLF Management Tool · SOP 80-07

This tool helps AFN station managers, RMBs, and RMCs measure and track production output using the Workload Factor (WLF) system defined in SOP 80-07. It is a shared tool — data entered by one station is visible to everyone on the network. This guide explains each section of the tool, who should use it, and how.

Connection indicator: The colored dot in the top-left of the main tool shows whether your browser is connected to the shared database. ⬤ Green = connected and synced. ⬤ Red = offline or save error — check your network connection.
1
Overview
Recommended for: All users — read this first

The Overview tab explains how the WLF system works. Read it before using any other section, especially if this is your first time encountering the Producer Quotient (PQ). It covers the formula, the assumptions behind the 120 man-hour baseline, a worked numeric example, and a plain-language guide to interpreting what a high or low PQ actually means.

Nothing in this tab is interactive. It is a reference document. Return to it any time you need to explain the system to a commander, a new producer, or an IG inspector.

Key takeaway: The Producer Quotient is a signal, not a verdict. A PQ that diverges significantly from your assigned producer count is a prompt to investigate — not a number to brief without context.
2
Task Library
Recommended for: Station Managers, RMBs

The Task Library is the shared list of product types and their Workload Factors. It is pre-loaded with the 19 task types from SOP 80-07. Every station on the network reads from this same list when calculating their PQ.

This list is shared network-wide. Changes you make here affect the WLF values used by every station's calculator. Do not modify WLFs without documented justification and coordination at the appropriate level.

Modifying a WLF

Click into the WLF (MH) field for any task and type the revised value. The change saves automatically after you stop typing. When you change a WLF, the task's status automatically changes from Active to Modified. Always fill in the Justification field to explain why the value was changed — this creates an audit trail.

Task Status Flags

Active
Original SOP value. No changes have been made.
Modified
WLF has been changed from the SOP baseline. Justification should be present.
Deprecated
Task type no longer in use at this network. It will be hidden from the calculator but preserved in the library. Use this instead of deleting.
Proposed
A new task type submitted for network adoption. WLF is provisional until formally approved.

Adding a New Task Type

Click + ADD TASK to create a new row. Fill in the task name, a brief description, a proposed WLF, and a justification. New tasks start with Proposed status. An RMB or RMC should review proposed tasks before they are used in official PQ calculations — change the status to Active once approved.

Only custom (non-SOP) tasks can be permanently deleted. SOP tasks can only be deprecated.


Exporting the Task Library

Use EXPORT JSON to download a machine-readable copy of the full task library (useful for archiving or migration). Use EXPORT CSV to open the list in Excel or include it in a report.

3
Station Calculator
Recommended for: Station Managers

The Calculator lets you compute your station's Producer Quotient for a given month. Enter your staffing situation, then log how many of each product type you produced. Results update in real time as you type.

Your monthly production quantities are saved locally in your browser — they are not shared with other stations. Each station enters their own numbers. The calculator is a working pad; use the Network Rollup (Section 4) to share final monthly totals.


Staffing Panel

Producers Authorized
The number of producer billets your station is authorized, regardless of who is actually assigned. The fill rate is calculated automatically from this and Producers Assigned.
Producers Assigned
The number of producers physically present and available for duty this month. Use fractional values if a billet was filled for only part of the month (e.g., 0.5 if a producer arrived mid-month).
Non-Production Hours / Day
Hours per day per producer consumed by non-production duties: formations, mandatory training, admin, details, meetings. SOP assumes 2.0. Increase this if your station carries a heavier non-production load.
TDY / Exercise Days Lost
The total number of producer-days pulled from local production this month for TDY, exercises, or other off-station duties. If two producers were TDY for 5 days each, enter 10.
Equipment Downtime Days
The number of days your primary production equipment (edit suite, cameras) was unavailable. This reduces effective capacity proportionally across all assigned producers.
Producer Skill Modifier
A slider from 0.70 to 1.00. Represents your team's experience level relative to the fully-trained baseline used to establish the original WLFs. 1.0 = a fully experienced team. 0.85 is the network default. Reduce this for newer, less-experienced teams. This shrinks your effective capacity — a less-experienced team requires more time per task, so they can produce less in the same number of hours.

Production Input

For each task type in the library, enter the quantity your station produced this month in the Qty Produced column. The man-hours column calculates automatically (Qty × WLF). You can also override the WLF directly in the calculator if you need to use a one-time local value without changing the shared library.

Tasks marked Deprecated are hidden from this list. All others appear, including Proposed tasks.


Results Panel

Total MH Produced
The sum of all task man-hours this month. This is the numerator of the PQ formula.
Effective MH Capacity
Your station's real available capacity after accounting for fill rate, non-production hours, TDY, equipment downtime, and skill modifier.
Standard PQ
Total MH ÷ 120. The by-the-book SOP calculation. Use this for official reporting and network comparisons.
Adjusted PQ
Total MH ÷ Effective Capacity. A more honest picture of how hard your team is actually working given real-world constraints. Use this internally to understand strain.
Capacity Status
A plain-language indicator comparing your Standard PQ to your assigned producers. Green = within 15% of theoretical capacity. Yellow = 16–30% gap. Blue = greater than 30% gap.
Narrative Interpretation
A one-paragraph plain-English summary of what your numbers mean. Updates automatically. Useful for writing a monthly summary for your chain of command.
4
Network Rollup
Recommended for: RMBs, RMCs

The Network Rollup provides a consolidated view of production output across all AFN stations. All 25 stations have been pre-loaded. Each station updates their own row monthly; RMBs and RMCs use this tab to see the full network picture.

This data is shared. When any user saves a change to a station row, it is immediately visible to all other users. Stations should update their own row — RMBs and RMCs should not edit station-level entries without coordination.

How a Station Updates Their Row

  1. Open the Network Rollup tab.
  2. Find your station's card in the list. Cards are sorted by echelon (RMC first, then RMB, then Station) and then alphabetically.
  3. Update Total MH Produced with your station's total man-hours for the month. You can get this number from the Calculator (Section 3) — it is the "Total MH Produced" figure in the Results panel.
  4. Update Assigned, TDY Days Lost, Equipment Downtime, and Skill Modifier to reflect this month's actuals. Fields save automatically after you stop typing.
  5. The summary table at the bottom updates immediately.

Summary Table Columns

Echelon
Station / RMB / RMC. Determines sort order in the table.
Auth / Asgn / Fill%
Authorized producers, assigned producers, and the resulting fill rate percentage.
Total MH
Man-hours of production output this month as entered by the station.
Std PQ
Standard Producer Quotient (Total MH ÷ 120). Comparable across all stations.
Adj PQ
Adjusted Producer Quotient using the station's effective capacity. Accounts for fill rate, downtime, and skill modifier.
Gap%
The percentage difference between the Standard PQ and the number of assigned producers. A negative number means the station is producing below theoretical capacity.
Status
AT CAPACITY — within 15% of theoretical output.
MODERATE GAP — 16–30% below theoretical output.
SIGNIFICANT GAP — more than 30% below theoretical output.

Exporting the Rollup

Click EXPORT CSV to download the full network summary as a spreadsheet. This is useful for monthly reporting, commander's briefs, or trend analysis over time. The export includes all columns visible in the summary table.

5
Calibration Log
Recommended for: All stations

The Calibration Log is a shared, network-wide record of actual time-on-task data. When a producer completes a product, a manager can log how long it actually took — not what the WLF says it should take, but the real-world time from assignment to delivery.

Over time, this log becomes the evidence base for updating WLFs in the Task Library. The averages table at the top of this section shows how actual times compare to current WLFs across all logged entries, for every task type.

This log is shared. Entries from all stations are visible in the same table. This is intentional — network-level trends are only visible when all stations contribute data. The more entries logged, the more reliable the averages become.

Adding a Log Entry

  1. Select your station name from the Station Name field. Type it manually — use the official station name (e.g., "AFN Sasebo").
  2. Select the Task Type from the dropdown. This list pulls from the shared Task Library.
  3. Enter the Date the product was delivered.
  4. Enter Actual Time Spent in hours, to the nearest 0.25. This is total time from assignment to final approved delivery — not just edit time.
  5. Enter the number of Producers Involved. If a producer and a manager both worked on it, enter 2.
  6. If the product required rework after initial client approval, toggle Required Rework to Yes and enter the additional hours spent.
  7. Add any relevant Notes: equipment issues, producer experience level, unusual complexity. The more context, the more useful the data.
  8. Click ADD ENTRY. The entry saves to the shared database immediately.

Reading the Averages Table

The averages table compares the mean actual time (including rework) against the current SOP WLF for each task type that has been logged. The variance bar shows the direction and magnitude of the difference:

When a task type shows a consistent and significant variance across multiple stations and entries, that is the signal to open a conversation about updating the WLF in Section 2.


What Makes a Good Log Entry

6
Staffing Model Reference
Recommended for: RMBs, RMCs, commanders

The Staffing Model Reference is a static reference section. It displays the AFN standard station construct, explains the expected 75% fill rate and what it means in practice, and provides a side-by-side scenario comparison showing how the Producer Quotient changes at 100%, 75%, and 50% fill rates for a fixed production output.

This section is designed to support briefings and staffing discussions. Use it to explain to a commander why a PQ that looks low may actually represent a team working near full capacity given their fill rate, or why a PQ that looks healthy masks a seriously under-manned station.

Nothing in this tab is editable. The scenario comparison uses the worked example from Section 1 (139 man-hours of output) as its fixed production baseline.

Suggested steps for a station manager at the end of each month.

  1. Open the Calculator (Tab 3). Update your staffing inputs — assigned producers, TDY days, equipment downtime, skill modifier. Verify they reflect the month that just closed.
  2. Enter your production quantities. Go through each task type and enter how many you produced. The Total MH and PQ figures calculate automatically.
  3. Review the Results panel. Note your Standard PQ, Adjusted PQ, and the narrative interpretation. If the Adjusted PQ is significantly above 1.0, your team may be strained. If it is significantly below 0.5, investigate whether all productions are being counted.
  4. Open the Network Rollup (Tab 4). Find your station's card and update Total MH Produced with the number from Step 2. Update assigned producers and any modifiers that changed.
  5. Open the Calibration Log (Tab 5). For any notable products completed this month — especially new task types, unusually long jobs, or anything that required significant rework — log a timing entry. Even two or three entries per month builds the data over time.