Growing Your Business" $-$ A Management Simulation

Sonya Harrell $-$ NBP$2439$E

Hisco

QTRLY DASHBOARD

Financial Statements

Supply Chain Mgt

R&D

ROLE$-$PLAY

QTRLY DECISIONS

Quarterly Decisions

Original Plan

OM Levers

Current Decisions

Market Forecast as of Q$1\text{'}25(90\%$ Confidence Level$)$

Financial Metrics $-2025$ Plan and YTD $2025-$Q$1+$SRO $*$

$2025$ Plan YTD $2025-$Q$1+$SRO

Sales $$3,540,475\mathrm{.}00$ $$3,540,475\mathrm{.}00$

Net Income $$241,763\mathrm{.}41$ $$241,763\mathrm{.}41$

Cash Flow $**($$$91,058\mathrm{.}87)($$$91,058\mathrm{.}87)$

$*$ 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$.$ YTD $2025-$Q$1+$SRO

Q$1\text{'}25-$ Expected Pre$-$tax NI Walk

Q$1\text{'}25-$ Expected Cash Flow Walk

Q$1\text{'}25-$ 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

Plan Q$4\text{'}24$A Q$1\text{'}25$ Q$2\text{'}25$ Q$3\text{'}25$ Q$4\text{'}25$

Sales

Total Market Demand $[$Units$]2,485$

$3,047$

$3,891$

$5,044$

$6,637$

Lost Sales $[$Units$]0$

$0$

$0$

$0$

$0$

Units Sold $[$Units$]829$

$1,005$

$1,322$

$1,665$

$2,190$

Price $[$$$]$ $$550\mathrm{.}00$

$$550\mathrm{.}00$

$$575\mathrm{.}00$

$$575\mathrm{.}00$

$$580\mathrm{.}00$

Terms $[$Days$]60$

$45$

$40$

$40$

$30$

Average Collection Period $[$Days$]64\mathrm{.}4$

$47\mathrm{.}0$

$44\mathrm{.}0$

$44\mathrm{.}0$

$34\mathrm{.}0$

Production

Raw Material On Order $[$Units$]1,000$

$900$

$1,825$

$3,550$

$3,000$

Units Produced $[$Units$]1,166$

$600$

$1,400$

$1,900$

$3,400$

Labor Force Hires $[$People$]5$

$0$

$10$

$0$

$17$

Labor Force Layoffs $[$People$]0$

$0$

$0$

$0$

$0$

Lines On Order $[$Units$]0$

$3$

$3$

$3$

$0$

Planned Time $1\mathrm{.}28$

$1\mathrm{.}20$

$1\mathrm{.}10$

$1\mathrm{.}00$

$0\mathrm{.}90$

Effectiveness $85\mathrm{.}4\%$

$96\mathrm{.}8\%$

$72\mathrm{.}7\%$

$90\mathrm{.}0\%$

$92\mathrm{.}0\%$

Discretionary Costs

Quality Engineering Expense $$42,000\mathrm{.}00$

$$40,000\mathrm{.}00$

$$45,000\mathrm{.}00$

$$90,000\mathrm{.}00$

$$80,000\mathrm{.}00$

Research Funding Expense $$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

Project $01$ Funding R&D Decision $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$

Project $02$ Funding $$45,000\mathrm{.}00$ $$35,000\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$

Project $03$ Funding $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$ $$0\mathrm{.}00$

Inventory Rework Cost $$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

Marketing Expense $$41,000\mathrm{.}00$

$$46,000\mathrm{.}00$

$$72,000\mathrm{.}00$

$$135,000\mathrm{.}00$

$$142,000\mathrm{.}00$

Advertising Expense $$31,000\mathrm{.}00$

$$28,000\mathrm{.}00$

$$30,000\mathrm{.}00$

$$40,000\mathrm{.}00$

$$25,000\mathrm{.}00$

Lean Six Sigma Expense $$25,000\mathrm{.}00$

$$25,000\mathrm{.}00$

$$32,000\mathrm{.}00$

$$38,000\mathrm{.}00$

$$25,000\mathrm{.}00$

Building Lease and Utilities $$79,953\mathrm{.}00$

$$70,951\mathrm{.}00$

$$75,015\mathrm{.}00$

$$84,293\mathrm{.}00$

$$87,350\mathrm{.}00$

Reports

Marketing Report

Business Intelligence Dashboard