Documentation >
MAC-PAC Reference Library >
Manufacturing >
Product Costing >
Reports >
Product Cost Sheet Report
Product Cost Sheet Report
PC510
Product Cost Sheet Report for MFG Parts (PC510)
DATE 3/04/93 STEVENS ART SUPPLY PAGE 1
TIME 15:15:48 PLANT BEL
REPORT PC-510 REQUESTOR WILLIAMS
PRODUCT COST SHEET
STANDARD
COST GENERATION DATE: 3/02/93
EFFECTIVITY DATE: 3/02/93
COST WARNING: E
PART NUMBER/ PART PRD COMM A ENG CURRENT COST CURRENT COST CURRENT COST CURRENT COST
DESCRIPTION TYPE TYP CODE C REV UM MATERIAL LABOR OVERHEAD TOTAL
------------------------- --- --- --- -- --- -- --------------- --------------- --------------- ---------------
BIKETIRE MFG MRP 02 000 EA 5.0000000 .0000016 263.8887704 268.8887720 TC
BIKE TIRE .0000000 .0000016 263.8887704 263.8887720 TL
COMPONENTS
PART NUMBER/ PART PRD SCRAP QTY STANDARD COST STANDARD COST STANDARD COST STANDARD COST
SEQ DESCRIPTION TYPE TYP FACTR PER UM MATERIAL LABOR OVERHEAD TOTAL
--- ------------------------- --- --- ----- -------- -- --------------- --------------- --------------- ---------------
100 SPOKE PUR MRP 12.34 12. EA .0000000 .0000000 .0000000 .0000000
BIKE TIRE SPOKE
210 NEWRIM PUR MRP .00 1. EA 5.0000000 .0000000 .0000000 5.0000000
NEW BIKE TIRE RIM
300 RUBBERWHEEL PUR MRP .00 1. EA .0000000 .0000000 .0000000 .0000000
BIKE TIRE RUBBER WHEEL
400 NOZZLE PUR MRP .00 1. EA .0000000 .0000000 .0000000 .0000000
BIKE TIRE NOZZLE
500 SPOKE PUR MRP .00 1. EA .0000000 .0000000 .0000000 .0000000
BIKE TIRE SPOKE
OP W/C M/ OP C NO NO S SN PIECE STD LABOR/ R
NO NO L TY F PERS MACH F FC RATE BURDEN RATE C
--- --- - - - ---- ---- - -- -------------- -------------- -
150 SPO L 1 Y 2.0 .0 1.000000 .000 .0000000 .0000000 13.2000000 13.2000000
TEST 6.600
160 SP2 L 1 Y 2.0 .0 1.000005 .000 .0000000 .0000000 246.2447688 246.2447688
ASSEMBLE SPOKES 123.123
200 ASY L 1 Y 1.0 .0 1234567.123456 2.000 .0000000 .0000016 .0000016 .0000032
ATTACH RIM 2.000
300 FX1 L 6 N 2.0 .0 N 00 1.000000 .000 .0000000 .0000000 4.4440000 4.4440000
ASSEMBLE BIKE TIRE .000000 4.444
310 FX2 L 6 N 2.0 .0 N 00 .000000 .000 .0000000 .0000000 .0000000 .0000000
ALIGN WHEELS 1.000005 .000
320 FX3 M 6 N .0 2.0 N 00 1.000000 .000 .0000000 .0000000 .0000000 .0000000
--------------- --------------- --------------- ---------------
.0000000 .0000016 263.8887704 263.8887720 TL
5.0000000 .0000016 263.8887704 268.8887720 TC
** END OF REPORT **
|
Product Cost Sheet Report for JIT Parts (PC510)
DATE 3/04/93 STEVENS ART SUPPLY PAGE 1
TIME 15:20:08 PLANT BEL
REPORT PC-510 REQUESTOR JRC
PRODUCT COST SHEET
STANDARD
COST GENERATION DATE: 3/02/93
EFFECTIVITY DATE: 3/02/93
COST ERROR: I
PART NUMBER/ PART PRD COMM A ENG CURRENT COST CURRENT COST CURRENT COST CURRENT COST
DESCRIPTION TYPE TYP CODE C REV UM MATERIAL LABOR OVERHEAD TOTAL
------------------------- --- --- --- -- --- -- --------------- --------------- --------------- ---------------
JIT PART MFG JIT 02 000 EA .0000000 .0000000 .0000000 .0000000 TC
A JIT PART .0000000 .0000000 .0000000 .0000000 TL
COMPONENTS
PART NUMBER/ PART PRD SCRAP QTY STANDARD COST STANDARD COST STANDARD COST STANDARD COST
SEQ DESCRIPTION TYPE TYP FACTR PER UM MATERIAL LABOR OVERHEAD TOTAL
--- ------------------------- --- --- ----- -------- -- --------------- --------------- --------------- ---------------
001 COMPONENT 1 MFG JIT .00 1. EA .0000000 .0000000 .0000000 .0000000
JIT PARENT PART
002 COMPONENT 2 MFG JIT .00 1. EA .0000000 .0000000 .0000000 .0000000
JIT COMPONENT PART
OP W/C M/ OP OPR OPR R S SN LABOR HRS/ STD LABOR/
NO NO L TY OFF L/T C F FC MACH LOAD TOTAL BURDEN
--- --- - - --- --- - - -- -------------- --------------
010 MA1 M 8 0 N 00 .000000 8.300 .0000000 .0000000 .0000000 .0000000
MACHINE PACED STEP .000000 6.300
--------------- --------------- --------------- ---------------
.0000000 .0000000 .0000000 .0000000 TL
.0000000 .0000000 .0000000 .0000000 TC
** END OF REPORT **
|
Purpose
The Product Cost Sheet Report provides a single-level list of the components and routing operations required to manufacture a part and the calculation of their material, labor and overhead cost contribution. Current, standard or simulated cost information may be requested. If current cost information is requested, standard total costs and standard this-level costs for the parent part are also shown (2 places): for comparison purposes. If standard cost information is requested, current total costs and current this-level costs for the parent part are also shown (2 places): for comparison purposes. If simulated cost information is requested, current total costs and current this-level costs for the parent part are also shown for comparison with the simulated costs. If a part is an MRP part, the crew operation flag, number of persons and machines, and piece rate are shown for each operation. If a part is a JIT part, operation offset and leadtime days, labor hours, and machine load are shown for each operation.
Report Sequence
Product Structure Sequence Number within Plant or Operation Number within Parent Part Number.
The following codes may appear on the report in the Cost Error or Cost Warning fields. The codes are listed below along with their description and effect on processing.
Note: A code which produces a warning allows processing to continue, while a critical code ends processing.
|
Code
|
|
Description
|
|
Processing Effect
|
|
A
|
|
This-Level Material is zero
|
|
Warning
|
|
B
|
|
This-Level Labor is zero
|
|
Warning
|
|
C
|
|
Labor Hours/Piece is zero
|
|
Critical
|
|
D
|
|
Labor Rate is zero
|
|
Warning
|
|
E
|
|
Burden Rate is zero
|
|
Warning
|
|
F
|
|
No components in effect
|
|
Critical
|
|
G
|
|
Quantity Per is zero
|
|
Critical
|
|
H
|
|
Total Component Material is zero
|
|
Warning
|
|
I
|
|
Component has error
|
|
Critical
|
|
J
|
|
Overflow error for component cost
|
|
Critical
|
|
K
|
|
Mfg part with no routing
|
|
Critical
|
|
L
|
|
Mfg part with no bill of material
|
|
Critical
|
|
M
|
|
Average Order Quantity is zero
|
|
Critical
|
|
N
|
|
No effective routing exists
|
|
Critical
|
|
O
|
|
Misc cost rate equal to zero
|
|
Warning
|
|
R
|
|
This level unit cost zero for non-stocked part
|
|
Warning
|
|
S
|
|
Total component unit cost zero for non-stocked part
|
|
Warning
|
|
T
|
|
By-product material value exceeds total material cost of parent
|
|
Critical
|
|
|
|
|
|
|