HISCO Summary Annual Report

/

"Growing Your Business" - A Management Simulation

 Financial Metrics Metrics Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21A Q2'21A Q3'21A

Ratios

Variable Costs ($) / Sales ($) 48.9% 46.9% 47.5% 42.0% 42.9% 46.7% 46.6% 41.0% 45.1% 41.3% 44.6%

Materials ($) / Sales ($) 13.7% 13.7% 13.7% 13.7% 14.1% 14.6% 15.1% 15.7% 13.8% 12.9% 13.7%

Labor ($) / Sales ($) 35.2% 33.3% 33.9% 28.4% 28.8% 32.1% 31.5% 25.4% 31.3% 28.4% 30.9%

Base Costs ($) / Sales ($) 76.8% 59.9% 61.5% 66.1% 67.0% 75.7% 75.1% 72.8% 81.3% 51.0% 48.9%

Gross Margin (%) 51.1% 53.1% 52.5% 58.0% 57.1% 53.3% 53.4% 59.0% 54.9% 58.7% 55.4%

Operating Margin (%) -25.7% -6.9% -9.0% -8.2% -9.9% -22.5% -21.7% -13.8% -26.4% 7.7% 6.5%

DuPont Ratios

Return on Sales (ROS) -12.9% -3.4% -4.5% -4.1% -5.0% -11.5% -11.6% -7.9% -14.4% 2.7% 2.0%

Asset Turns 0.98 1.10 1.25 1.39 1.29 1.10 1.06 0.96 1.29 1.20 0.93

Return on Assets (ROA) -12.6% -3.8% -5.6% -5.7% -6.4% -12.6% -12.3% -7.6% -18.5% 3.3% 1.9%

Financial Leverage 1.00 1.00 1.00 1.00 1.22 1.87 2.90 5.10 78.40 23.86 6.95

Return on Equity (ROE) -12.6% -3.8% -5.6% -5.7% -7.8% -23.6% -35.6% -38.7% -1,446.7% 78.1% 12.9%

Marketing & Advertising

Marketing ($) / Sales ($) [% of Sales] 11.7% 10.8% 10.0% 10.4% 10.3% 10.5% 10.6% 10.1% 11.8% 3.1% 2.5%

Advertising ($) / Sales ($) [% of Sales] 13.5% 12.5% 11.7% 12.0% 5.3% 6.4% 7.0% 6.8% 2.8% 2.4% 2.0%

Quality Engineering

Quality ($) / Sales ($) [% of Sales] 4.9% 4.5% 4.2% 5.5% 7.3% 8.3% 11.3% 9.2% 9.9% 7.3% 5.8%

Quality ($) / Units Produced $30.4 $28.8 $23.0 $29.9 $41.7 $47.2 $64.3 $36.0 $48.1 $27.1 $24.4

Lean Six Sigma

Lean Six Sigma ($) / Sales ($) [% of Sales] 6.0% 5.6% 5.2% 6.1% 9.4% 8.9% 8.0% 5.5% 4.1% 3.2% 2.6%

Lean Six Sigma ($) / Units Produced $37.5 $35.4 $28.3 $33.2 $53.3 $50.3 $45.7 $21.4 $20.0 $11.9 $11.1

Research Expense & Project Funding

 Reginald Whimbush

/

Metrics Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21A Q2'21A Q3'21A

Research ($) / Sales ($) [% of Sales] 0.0% 0.0% 0.0% 0.0% 7.3% 8.3% 8.8% 9.9% 9.5% 0.0% 0.0%

Cash Flow Analysis

Cash Conversion Cycle (CCC) in Days 31.1 30.5 54.0 68.0 88.4 102.7 109.9 136.2 106.1 135.9 121.1

Terms to Customer 30.0 30.0 30.0 30.0 60.0 60.0 60.0 60.0 35.0 30.0 40.0

Average Collection Period in Days 30.0 30.1 39.9 40.0 55.9 64.0 63.1 64.4 40.4 32.3 40.6

Days Inventory Outstanding 1.1 0.3 14.1 28.0 32.5 38.7 46.8 71.7 65.8 103.6 125.3

Days Payable Outstanding 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 44.8

Supplier Terms 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 30.0

Cash Flow from Operating Activities (CFOA) ($124,331) ($16,672) ($76,914) ($40,785) ($94,133) ($105,390) ($92,868) ($136,198) ($84,555) ($161,524) ($278,332)

Interest Coverage [OM $ / Interest $] - - - - - -45.1 -15.0 -6.8 -11.2 3.5 2.6

Cash Flow Coverage - - - - - -2.2 -0.6 -0.6 -0.2 -0.3 -0.4

Distributor Financials

Retail Price ($) $700 $700 $700 $700 $678 $656 $633 $611 $644 $656 $667

Distributor Margin (%) 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%

Distributor Margin ($) $70.0 $70.0 $70.0 $70.0 $67.8 $65.6 $63.3 $61.1 $64.4 $65.6 $66.7

Total Distributor Margin ($) $29,540 $31,990 $34,300 $36,190 $37,888 $40,054 $44,207 $50,661 $67,538 $87,320 $105,467

Contact Us (mailto:[email protected]) © 1991-2020, Tri Corporation. (http://www.tri-simulation.com/)

(*) To condense view, click on column title for any quarter. This will hide previous quarter data. To view all columns again, click on statement title