Business Decisions Recap
clw0dq8
Q2Inputs.pdf
/
"Growing Your Business" - A Management Simulation
Executive SummaryQuarter Variance to Plan GraphicsQuarter Variance to Plan and SROOM LeversCurrent Decisions
Market Forecast as of Q2'21 (90% Confidence Level) Financial Metrics – Plan and Actual+SRO *
Plan Actual+SRO
Sales $4,311,500.00 $4,880,840.00
Net Income $396,486.02 $521,928.81
Cash Flow ** $2,594.36 $362,636.97
* 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+SRO
Q2'21 - Expected Pre-tax NI Walk Q2'21 - Expected Cash Flow Walk Q2'21 - Expected OM Levers *
* 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
Quarterly Decisions
Q2'21 SRO Q4'20A Q1'21A Q2'21 Q3'21 Q4'21
Sales
Total Market Demand [Units] 2,485 3,234
Lost Sales [Units] 0 0
Units Sold [Units] 829 1,048
Price [$] $550.00 $580.00
Terms [Days] 60 35
3,891 5,044 6,637
0 0 0
2,200 2,500 2,500
$590.00 $595.00 $595.00
30 40 30
Reginald Whimbush
Hisco QTRLY DASHBOARD R&D ROLE-PLAY QTRLY DECISIONS Financial Statements Supply Chain Mgt
0
2,750
5,500
8,250
11,000
Q 4.
20
Q 1.
21
Q 2.
21
Q 3.
21
Q 4.
21
Q 1.
22
2,485 3,234
$0
$331.8K
$663.6K
$995.4K
$1.3M
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 st
Ac tu
al +
SR O
$1.1M $20.1K
$-93.2K
$22K $0
$-94 $-31.6K $-7.3K
$1M
$-200.7K
$0
$147K
$320.8K
$494.6K
Q 1'
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 2'
21 E
xp ec
te d
$-174.5K
$67.8K
$299K $22K
$-255
$39.6K
$176.5K
$-3.2K
$426.9K
$-541.9K
$-406.4K
$-270.9K
$-135.5K
$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
$-466.8K
$213.5K $0
$-217.8K
$38.1K $0 $0 $0
$-433.1K
0% 1% 2% 3% 4% 5%
Price
Volume
Variable Cost
Base Cost
Volume **
Variable Cost ***
/
Production Problem: - Requested: 2,400 units - Raw Material : available for only 2,150 units
Quarter Q3'21 Q4'21 Raw Material 2,150 2,150
Labor Capacity 4,504 4,504
Line Capacity 8,000 8,000
Production Problem: - Requested: 2,350 units - Raw Material : available for only 2,100 units
Quarter Q2'21 Q3'21 Q4'21 Raw Material 2,100 2,100 2,100
Q2'21 SRO Q4'20A Q1'21A Q2'21 Q3'21 Q4'21
Average Collection Period [Days] 64.4 40.4
Production
Raw Material On Order [Units] 1,000 2,100
Commited Raw Material On Order [Units] N/A 1,900 2,150 2,700 3,150
Units Produced [Units] 1,166 1,248
Labor Force Hires [People] 5 17
Labor Force Layoffs [People] 0 0
Lines On Order [Units] 0 5
Planned Time 1.28 0.88
Effectiveness 85.4% 77.6%
Discretionary Costs
Quality Engineering Expense $42,000.00 $60,000.00
Research Funding Expense $0.00 $23,000.00
Project 01 Funding $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
Inventory Rework Cost $0.00 $0.00
Marketing Expense $41,000.00 $17,000.00
Advertising Expense $31,000.00 $17,000.00
Lean Six Sigma Expense $25,000.00 $25,000.00
Building Lease and Utilities $79,953.00 $91,783.04
Reports
Marketing Report
Business Intelligence Dashboard
Q3'21:
Q2'21:
34.0 34.0 34.0
2,150 2,500 2,500
2,350 2,400 2,400
15 18 18
0 0 0
5 3 0
1.10 1.00 0.90
87.7% 90.0% 92.0%
$57,000.00 $55,000.00 $57,000.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$19,000.00 $19,000.00 $14,000.00
$19,000.00 $19,000.00 $14,000.00
$25,000.00 $25,000.00 $22,000.00
$70,015.00 $70,550.00 $70,550.00
/
Labor Capacity 3,057 3,057 3,057
Line Capacity 5,500 5,500 5,500
Production Problem: - Requested: 1,600 units - Raw Material : available for only 1,248 units
Guideline Check here then click the below button to submit your SRO
Model My SRO
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/)
