HISCO Summary Annual Report
clw0dq8
QuarterallyDecision.pdf
/
"Growing Your Business" - A Management Simulation
Executive SummaryQuarter Variance to Plan GraphicsQuarter Variance to Plan and SROOM LeversCurrent Decisions
Market Forecast as of Q1'22 (90% Confidence Level) *
* Market forecast now includes impact of Project #3 being introduced to the marketplace this past quarter. To get an estimate of the base market (for those w/o project 3 divide by 1.5)
Financial Metrics – Plan and Actual *
Plan Actual
Sales $4,311,500.00 $3,496,960.00
Net Income $396,486.02 $25,113.10
Cash Flow ** $2,594.36 ($607,533.10)
* Plan is annual commitment, SRO is Short Range Outlook and represents Decisions for Qtrs. To be played (the SRO may have changed from original plan for the Qtr.).
** Operating
Pre-Tax Income: Year Plan vs. Actual
Q4'21 - Pre-tax NI Walk Q4'21 - Cash Flow Walk Q4'21 - OM Levers *
Quarterly Decisions
Reginald Whimbush
0
7,500
15,000
22,500
30,000
Q 3.
21
Q 4.
21
Q 1.
22
Q 2.
22
Q 3.
22
Q 4.
22 8,407
11,693
$0
$481.8K
$963.6K
$1.4M
$1.9M
Ye ar
P la
n
Gr ow
th M
ar ke
t S ha
re
Pr ic e
VC ( I)
VC ( P)
Ba se
C os
t
In te
re
$793K
$882.9K
$-1.4M
$155.6K
$-116.6K
$170.3K
$-382.6K $-4
/
* All Ceteris Paribus * Variable/Base Cost Improvements Imply Cost Reduction ** % Volume Increase Required To Maintain CM $ Facing a 1% Price Reduction *** % Improvement (Decrease) Required To Maintain CM $ Facing a 1% Price Reduction
Decision Q4'20A Q1'21A Q2'21A Q3'21A Q4'21A
Sales
Total Market Demand [Units] 2,485 3,234 4,160 8,407 11,693
Lost Sales [Units] 0 0 0 0 0
Units Sold [Units] 829 1,048 1,332 1,582 1,770
Price [$] $550.00 $580.00 $590.00 $600.00 $652.00
Terms [Days] 60 35 30 40 25
Average Collection Period [Days] 64.4 40.4 32.3 40.6 27.5
Production
Raw Material On Order [Units] 1,000 2,100 2,250 2,500 2,900
Commited Raw Material On Order [Units] N/A 1,900 2,150 0 0
Units Produced [Units] 1,166 1,248 2,100 2,250 2,500
Labor Force Hires [People] 5 17 15 18 12
Labor Force Layoffs [People] 0 0 0 0 0
Lines On Order [Units] 0 5 5 3 5
Planned Time 1.28 0.88 0.93 0.82 0.80
Effectiveness 85.4% 77.6% 60.3% 66.1% 73.6%
$0
$69.9K
$139.9K
$209.8K
$279.8K
Q 3'
21 A
ct ua
l
Gr ow
th M
ar ke
t S ha
re
Pr ic e
VC ( I)
VC ( P)
Ba se
C os
t
In te
re st
Q 4'
21 A
ct ua
l
$37.7K
$205.6K
$-143.1K
$92K
$-267
$-25.5K $-15.8K $-6.7K
$144.1K
$-1M
$-773.7K
$-515.8K
$-257.9K
$0
Be g
Q tr
C as
h/ De
bt Ne
t I nc
om e
De pr
ec ia
tio n
Re ce
iv ab
le s
In ve
nt or
y AP P& E
Co m
m on
S to
ck En
d Q tr
C as
h/ De
bt
$-806.7K
$72.1K $0
$75.6K
$-238K
$7.2K $0 $0
$-889.8K
0% 2% 4% 6% 8
Price
Volume
Variable Cost
Base Cost
Volume **
Variable Cost ***
/
Production Problem: - Requested: 2,900 units - Raw Material : available for only 2,500 units
Production Problem: - Requested: 2,400 units - Raw Material : available for only 2,250 units
Decision Q4'20A Q1'21A Q2'21A Q3'21A Q4'21A
Discretionary Costs
Quality Engineering Expense $42,000.00 $60,000.00 $57,000.00 $55,000.00 $50,000.00
Research Funding Expense $0.00 $23,000.00 $0.00 $0.00 $0.00
Project 01 Funding $0.00 $0.00 $0.00 $0.00 $0.00
Project 02 Funding $45,000.00 $35,000.00 $0.00 $0.00 $0.00
Project 03 Funding $0.00 $0.00 $0.00 $0.00 $0.00
Inventory Rework Cost $0.00 $0.00 $9,990.00 $0.00 $0.00
Marketing Expense $41,000.00 $17,000.00 $19,000.00 $19,000.00 $15,000.00
Advertising Expense $31,000.00 $17,000.00 $19,000.00 $19,000.00 $15,000.00
Lean Six Sigma Expense $25,000.00 $25,000.00 $25,000.00 $25,000.00 $15,000.00
Building Lease and Utilities $79,953.00 $91,783.04 $122,417.24 $129,917.59 $141,461.24
Reports
Marketing Report
Business Intelligence Dashboard
Q4'21:
Cash Problem: exceeded credit line $329,978.92 - Credit Line : $559,846.13 - Current Debt: $889,825.04
Q3'21:
Cash Problem: exceeded credit line $272,879.85 - Credit Line : $533,823.86 - Current Debt: $806,703.71
/
Production Problem: - Requested: 2,350 units - Raw Material : available for only 2,100 units
Production Problem: - Requested: 1,600 units - Raw Material : available for only 1,248 units
Q2'21:
Cash Problem: exceeded credit line $203,371.51 - Credit Line : $425,000.00 - Current Debt: $628,371.51
Q1'21:
Cash Problem: exceeded credit line $41,847.33 - Credit Line : $425,000.00 - Current Debt: $466,847.33
Contact Us (mailto:[email protected]) © 1991-2020, Tri Corporation. (http://www.tri-simulation.com/)
