Week 6 Final Assignment - HISCO Summary Annual ReportPLEASE DO NOT SUBMIT A BID FOR THIS ASSIGNMENT IF YOU DO NOT HAVE EXPERIENCE WITH GRADUATE LEVEL WRITING TERMS AND CONCEPTS. ALL DIRECTIONS MUST BE

/ "Growing Your Business" - A Management Simulation Executive Summary Quarter Variance to Plan Graphics Quarter Variance to Plan and SRO OM Levers Current Decisions Market Forecast as of Q1'22 (90% Confidence Level) * * Market forecast now includes impact of Project #3 being introduced to the marketplac e 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 * Pla n Actu al S ale s $4,3 11 ,5 00.0 0 $3,4 96,9 60.0 0 N et In co m e $396,4 86.0 2 $25,1 1 3.1 0 C ash F lo w * * $ 2,5 94.3 6 ($ 607,5 33.1 0) * 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-T ax Income: Year Plan vs. Actual Q4'21 - Pre-tax NI W alk Q4'21 - Cash Flow W alk Q4'21 - OM Levers *  Quarterly Decisions  Reginald Whimbush 0 7,500 15,000 22,500 30,000 Q3.2 1 Q 4.2 1 Q 1.2 2 Q 2.2 2 Q 3.2 2 Q 4.2 2 8,407 11,693 $0 $481.8K $963.6K $1.4M $1.9M Ye a r P la n G ro w th M ark e t Sh are P ric e VC ( I) VC ( P ) B ase C ost 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 ** % V olume Increase Required T o Maintain CM $ Facing a 1% Price Reduction *** % Improvement (Decrease) Required T o Maintain CM $ Facing a 1% Price Reduction Decis io n Q 4'2 0A Q 1'2 1A Q 2'2 1A Q 3'2 1A Q 4'2 1A S ale s  To ta l M ark e t D em and [U nits] 2 ,4 85 3,2 34 4,1 60 8,4 07 11 ,6 93 Lost S ale s [U nits] 0 0 0 0 0 U nits S old [U nits] 8 29 1,0 48 1,3 32 1,5 82 1,7 70 P ric e [$ ] $550.0 0 $580.0 0 $590.0 0 $600.0 0 $652.0 0 Te rm s [D ays] 6 0 35 30 40 25 A ve ra ge C olle ctio n P erio d [D ays] 6 4.4 4 0.4 3 2.3 4 0.6 2 7.5 P ro ductio n  R aw M ate ria l O n O rd er [U nits] 1 ,0 00 2,1 00 2,2 50 2,5 00 2,9 00 C om mite d R aw M ate ria l O n O rd er [U nits] N /A 1 ,9 00 2,1 50 0 0 U nits P ro duce d [U nits] 1 ,1 66 1,2 48 2,1 00 2,2 50 2,5 00 Labor F orc e H ire s [P eople ] 5 17 15 18 12 Labor F orc e L ayo ff s [P eople ] 0 0 0 0 0 Lin es O n O rd er [U nits] 0 5 5 3 5 P la nned T im e 1.2 8 0.8 8 0.9 3 0.8 2 0.8 0 E ff e ctiv eness 8 5.4 % 77.6 % 60.3 % 66.1 % 73.6 % $0 $69.9K $139.9K $209.8K $279.8K Q3'2 1 Ac tu al G ro w th M ark e t Sh are P ric e VC ( I) VC ( P ) B ase C ost In te re st Q 4'2 1 Ac tu al $37.7K $205.6K $-143.1K $92K $-267 $-25.5K $-15.8K $-6.7K $144.1K $-1M $-773.7K $-515.8K $-257.9K $0 B eg Q tr C ash /D eb t N et I n co m e Dep re cia tio n R ece iv a b le s In ve n to ry AP P & E Com mon St ock E n d Q tr C ash /D eb t $-806.7K $72.1K $0 $75.6K $-238K $7.2K $0 $0 $-889.8K 0% 2% 4% 6% 8 Price V olume 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 Decis io n Q 4'2 0A Q 1'2 1A Q 2'2 1A Q 3'2 1A Q 4'2 1A D iscre tio nary C osts  Q ualit y E ngin eerin g E xp ense $ 42,0 00.0 0 $60,0 00.0 0 $57,0 00.0 0 $55,0 00.0 0 $50,0 00.0 0 R ese arc h F undin g E xp ense $ 0.0 0 $23,0 00.0 0 $0.0 0 $0.0 0 $0.0 0 P ro je ct 0 1 F undin g $0.0 0 $0.0 0 $0.0 0 $0.0 0 $0.0 0 P ro je ct 0 2 F undin g $45,0 00.0 0 $35,0 00.0 0 $0.0 0 $0.0 0 $0.0 0 P ro je ct 0 3 F undin g $0.0 0 $0.0 0 $0.0 0 $0.0 0 $0.0 0 In ve nto ry R ew ork C ost $ 0.0 0 $0.0 0 $9,9 90.0 0 $0.0 0 $0.0 0 M ark e tin g E xp ense $ 41,0 00.0 0 $17,0 00.0 0 $19,0 00.0 0 $19,0 00.0 0 $15,0 00.0 0 A dve rtis in g E xp ense $ 31,0 00.0 0 $17,0 00.0 0 $19,0 00.0 0 $19,0 00.0 0 $15,0 00.0 0 Lean S ix S ig m a E xp ense $ 25,0 00.0 0 $25,0 00.0 0 $25,0 00.0 0 $25,0 00.0 0 $15,0 00.0 0 B uild ing L ease a nd U tilit ies $79,9 53.0 0 $91,7 83.0 4 $122,4 17.2 4 $129,9 17.5 9 $141,4 61.2 4 R eports  M ark e tin g R eport B usin ess In te llig ence D ash board 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/)