Customization RE0738
MFG Costing Report
Description of Report:
ACME needs to report Material and Labor separately for their parent company in Japan. There are several make-to-stock subassemblies which are consumed to make the finished good. All of the made items are Lot Tracked, and they use Manufacturing’s Serial-Lot Linking to tie the subassembly Lot Number to the parent Lot Number.
For example:
MO Receipt for S/A-1:
- $5.00 Purchased Material
- $3.00 Labor
- = $8.00
S/A-1 is used by S/A-2
MO Receipt for S/A-2:
- $7.00 of Purchased Material
- $4.00 Labor
- $8.00 from S/A-1
- = $19.00
S/A-2 is used by parent item (FG):
MO Receipt for FG:
- $10.00 of Purchased Material
- $20.00 Labor
- $19.00 from S/A-2
- = $49.00
When ACME enters the FG Item Number & Lot Number, or a Manufacture Order Number, they need a report to show the manufacturing costs as follows:
Item Number: FG
Lot Number: FG001
| Item Number | Lot | Material | Labor |
| S/A-1 | SA1-123 | $5.00 | $3.00 |
| S/A-2 | SA2-00 | $7.00 | $4.00 |
| FG | FG001 | $10.00 | $20.00 |
| Sub-Total | $22.00 | $27.00 | |
| Total | $49.00 |
Assumptions:
- When locating the Manufacturing Order which produced the top-level FG Item-Lot, or any of the sub-assemblies, the most recent MO Receipt for the Item-Lot will be used. “Most Recent” will be the most recent MO Receipt Date.
- MO’s must be CLOSED to perform accurate reporting.
- No fixed or variable overhead amounts are used. Or, if they are used, ACME agrees that they can be excluded from the report totals, and that the report totals will not match the actual total production cost.