Phenolic sat. film · warehouse 100
16-282013
5 x 9 1" MDF Medex · 5 x 9 PSF FSC · 5 x 9 PSF FSC
MappedPSF
YTD FOB sales
$54,390
1,295 pcs · 12,362 SF
ASP
$42.00
Target $105.13 @ 28% GM
Std cost / pc
$75.70
RM $75.70 · conv $0.00
YTD gross margin
-80.2%
-$43,637 on $54,390
Construction
Face overlay · core · back overlay
Face5 x 9 PSF FSC$1.02
Core5 x 9 1" MDF Medex$71.57
Back5 x 9 PSF FSC$3.10
PSF · 45.0 SF · AX 16-282013
- RM cost
- $75.70
- Total cost
- $75.70
- Conversion
- $0.00
- Target @ 28% GM
- $105.13
Cost build-up
IVR raw material. Labor and overhead are $0 pending mill rates.
Costed BOM
Quantities from the mapping workbook · unit cost from IVR
| Layer | AX item | Config | Raw material | Qty | Unit cost | Extended |
|---|---|---|---|---|---|---|
| Core | 20002MDF core | 216461 | 5 x 9 1" MDF Medex | 1.00 | $71.57 | $71.57 |
| Face | 20020PSF overlay | 218500 | 5 x 9 PSF FSC | 0.33 | $3.10 | $1.02 |
| Back | 20020PSF overlay | 218500 | 5 x 9 PSF FSC | 1.00 | $3.10 | $3.10 |
| Labor | PSF conversion | 1 | $0.00 | $0.00 | ||
| Overhead | 72% of labor | 1 | $0.00 | $0.00 | ||
2026 monthly FOB mill $
Phenolic Sat Film · MDF · January–August 2026
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | YTD | |
|---|---|---|---|---|---|---|---|---|---|
| Sales $ | $5,880 | $5,880 | $7,350 | $5,880 | $8,820 | $7,350 | $8,820 | $4,410 | $54,390 |
| Pcs | 140 | 140 | 175 | 140 | 210 | 175 | 210 | 105 | 1,295 |
| SF | 1,336 | 1,336 | 1,671 | 1,336 | 2,005 | 1,671 | 2,005 | 1,002 | 12,362 |
History / open book
0 pcs
Open sales
0 pcs
FG concat
16282013