These custom Metal Stamping Companies had senior accountants working for up to  3 months preparing an item by item Contribution Margin / Gross Margin report. They would run reports in their enterprise system, download  and then cut and paste into spreadsheets.  Some data was gathered manually and numerous tabs were created with “lookup” formulae.  The majority of the report was correct, but there were always some parts that “just didn’t look right.”

Using the process developed by HKC,  the data now comes directly from the tables and is traceable back to the original entry documents. 

· Quantity produced, quantity invoiced, invoice dollars

· Surcharges, Discounts, Premium Freight, Credit Memos, Commissions

· Material, Material Freight, Outside services

· Rejects, Adjust on Hand transactions, Supplies

· Production Labor, Setup Labor, Tooling Labor,

· Tooling purchases

 

The new report has tabs for data by customer, data by part number and data by custom groupings according to client requirements

The report is now available ANY TIME and is “refreshed” with the latest data at the click of a mouse..

 

Contribution Margin Report for Metal Stamping companies

 

Customer Code

Parent

Part_No

Part_Group

Invoice Qty

 Invoice $

 Surcharge $

 Discount

 Premium Freight

 Credit Memo

 Credit Card Fees

 Material Dollars

 Scrap Recovery Dollars

 Material Freight

 Outside Sort

 Reject Dollars

 Adjustment$

 Supply$

 SubContract$

 Commission$

 Production Labor

 Setup Labor

 Tool Room Labor

 Tool Room Purchases

 Invoice Deductions

Net Invoice

Material Deductions

VA Dollars

VA Percent

Labor Deductions

Tooling Deductions

Contribution Dollars

Contribution Percent

 

 

 

 

203,300

 $  83,036

 

 

 

 

 

 $  31,857

 $  (7,539)

 $        360

 

 

 $   1,523

 $      248

 

 

 $   2,631

 $  356

 $  1,374

 

 $           -  

 $    8,740

 $    5,644

 $    3,096

35.4%

 $           -  

 $           -  

 $    3,096

35.4%

 

 

 

 

50,000

 $    8,740

 

 

 

 

 

 $    6,192

 $  (1,210)

 $          24

 

 

 $         (1)

 $         39

 $        600

 

 

 

 

 

 $           -  

 $    1,899

 $  (1,084)

 $    2,983

157.1%

 $           -  

 $           -  

 $    2,983

157.1%

 

 

 

 

1,600

 $    1,899

 

 

 

 

 

 

 

 

 

 

 $ (1,084)

 

 

 

 

 

 

 

 $           -  

 $    3,219

 $        428

 $    2,792

86.7%

 $        140

 $           -  

 $    2,652

82.4%

 

 

 

 

2,535

 $    3,219

 

 

 

 

 

 $        420

 $        (74)

 $          19

 

 

 $            5

 $         20

 $          38

 

 

 $  140

 

 

 $     (797)

 $    3,351

 $    1,445

 $    1,905

74.6%

 $        733

 $           -  

 $    1,173

45.9%

 

 

 

 

101,610

 $    2,553

 $       797

 

 

 

 

 $    1,385

 $      (205)

 $          57

 

 $      37

 $         60

 $      111

 

 

 $       500

 $  232

 

 

 $     (421)

 $    3,387

 $        703

 $    2,684

90.5%

 $        708

 $          90

 $    1,886

63.6%

 

 

 

 

100,000

 $    2,966

 $       421

 

 

 

 

 $        730

 $      (122)

 $          30

 

 

 $         34

 $         31

 

 

 $       575

 $  132

 $        18

 $          72

 $  (1,143)

 $  14,326

 $    1,716

 $  12,610

95.7%

 $        409

 $        229

 $  11,972

90.8%

 

 

 

 

72,000

 $  13,183

 $   1,143

 

 

 

 

 $    2,222

 $      (412)

 $          27

 

 

 $     (156)

 $         35

 

 

 $       409

 

 $     229

 

 $  (7,685)

 $  38,904

 $  12,468

 $  26,436

84.7%

 $    4,951

 $    1,001

 $  20,484

65.6%

 

 

 

 

1,458,800

 $  31,218

 $   7,685

 

 

 

 

 $  13,496

 $  (2,237)

 $        554

 

 $      19

 $         96

 $      540

 

 

 $   4,734

 $  216

 $     654

 $        346

 $        720

 $  12,792

 $        653

 $  12,139

89.8%

 $        542

 $           -  

 $  11,597

85.8%

 

 

 

 

11,260

 $  13,512

 

 

 

 $   720

 

 $        750

 $      (147)

 $            9

 

 

 $         33

 $           7

 

 

 $       142

 $  400

 

 

 $  (1,548)

 $  11,304

 $    2,812

 $    8,492

87.0%

 $    1,265

 $          37

 $    7,190

73.7%

 

 

 

 

126,950

 $    9,756

 $   1,548

 

 

 

 

 $    2,472

 $      (413)

 $        102

 

 $      61

 $       452

 $      138

 

 

 $       588

 $  676

 $        37

 

 $        (90)

 $    2,150

 $          96

 $    2,054

99.7%

 $           -  

 $           -  

 $    2,054

99.7%

 

 

 

 

4,000

 $    2,060

 $         90

 

 

 

 

 $        112

 $        (17)

 $            1

 

 

 

 $           1

 

 

 

 

 

 

 $  (1,105)

 $  23,697

 $    2,711

 $  20,986

92.9%

 $    1,984

 $          16

 $  18,986

84.0%

 

 

 

 

403,425

 $  22,592

 $   1,105

 

 

 

 

 $    2,554

 $      (425)

 $        105

 

 $      17

 $       310

 $      149

 

 

 $   1,567

 $  417

 $        16

 

 $     (165)

 $    4,134

 $        731

 $    3,403

85.8%

 $        742

 $        127

 $    2,534

63.9%

 

 

 

 

6,000

 $    3,968

 $       165

 

 

 

 

 $        322

 $        (57)

 $            4

 

 

 $       459

 $           3

 

 

 $       316

 $  426

 $          5

 $        122

 $  (7,310)

 $  72,056

 $  12,123

 $  59,933

92.6%

 $        641

 $        228

 $  59,064

91.2%

 

 

 

 

830,075

 $  64,746

 $   7,310

 

 

 

 

 $  13,337

 $  (2,302)

 $        548

 

 $      94

 $     (236)

 $      681

 

 

 

 $  641

 $     228

 

 $     (229)

 $    2,179

 $        291

 $    1,887

96.8%

 $          59

 $        404

 $    1,425

73.1%