Standard against actual cost by work order
10 work order(s): standard 29500, actual 31630, variance 2130. 4 over tolerance (1850), 2 to review, 4 within tolerance.
By cost element
| element | standard | actual | variance |
|---|---|---|---|
| material | 21600 | 22590 | 990 |
| labor | 5000 | 5880 | 880 |
| overhead | 2900 | 3160 | 260 |
By finding
| code | count | amount |
|---|---|---|
| cost_no_output | 1 | 1800 |
| labor_over | 2 | 950 |
| large_favorable | 1 | 0 |
| material_over | 1 | 600 |
| no_standard | 1 | 0 |
| overhead_over | 1 | 300 |
All rows (10)
| work order | item | status | standard | actual | variance | variance pct | reasons |
|---|---|---|---|---|---|---|---|
| WO-1001 | BRK-100 | ok | 1800 | 1830 | 30 | 1.7 | |
| WO-1002 | BRK-200 | flag | 3100 | 3730 | 630 | 20.3 | Material 2600 against standard 2000: 600 over (30%). |
| WO-1003 | HSG-300 | flag | 2700 | 3620 | 920 | 34.1 | Labor 1400 against standard 800: 600 over (75%). Overhead 700 against standard 400: 300 over (75%). |
| WO-1004 | SHF-400 | review | 4000 | 3050 | -950 | -23.7 | Total cost 3050 is 950 (23.8%) under standard 4000. Check the standard, and whether every material issue and labor ticket was charged to the work order. |
| WO-1005 | PLT-500 | review | 0 | 450 | 450 | WO-1005 has 450 actual cost and no standard cost on file. Set a standard before judging the variance. | |
| WO-1006 | BRK-100 | flag | 1800 | 1800 | 0 | 0 | WO-1006 is closed with 1800 charged and nothing completed. Find where the output went, or move the cost. |
| WO-1007 | BRK-200 | ok | 2800 | 2900 | 100 | 3.6 | |
| WO-1008 | GER-600 | ok | 800 | 1000 | 200 | 25 | |
| WO-1009 | GER-600 | ok | 11400 | 11800 | 400 | 3.5 | |
| WO-1010 | HSG-300 | flag | 1100 | 1450 | 350 | 31.8 | Labor 650 against standard 300: 350 over (116.7%). |
Limits
- Variances are actual minus standard as your export states them. The agent does not split price and usage, and does not know your costing method.
- Reads only the files you give it. It does not log in to an ERP, MES, CMMS, QMS, EDI network, bank, supplier or customer portal, and changes nothing in them.
- Not legal, tax, customs, safety or accounting advice. A person decides what to change, post, send or pay.
Written by a Fairmake agent from your files. Nothing was sent or paid.