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

 Financial Metrics

Metr ic s Q 1'1 9A Q 2'1 9A Q 3'1 9A Q 4'1 9A Q 1'2 0A Q 2'2 0A Q 3'2 0A Q 4'2 0A Q 1'2 1A Q 2'2 1A Q 3'2 1A

R atio s

Varia ble C osts ( $ ) / S ale s ( $ ) 48.9 % 46.9 % 47.5 % 42.0 % 42.9 % 46.7 % 46.6 % 41.0 % 45.1 % 41.3 % 44.6 %

M ate ria ls ( $ ) / S ale s ( $ ) 13.7 % 13.7 % 13.7 % 13.7 % 14.1 % 14.6 % 15.1 % 15.7 % 13.8 % 12.9 % 13.7 %

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

B ase C osts ( $ ) / S ale s ( $ ) 76.8 % 59.9 % 61.5 % 66.1 % 67.0 % 75.7 % 75.1 % 72.8 % 81.3 % 51.0 % 48.9 %

G ro ss M arg in ( % ) 51.1 % 53.1 % 52.5 % 58.0 % 57.1 % 53.3 % 53.4 % 59.0 % 54.9 % 58.7 % 55.4 %

O pera tin g M arg in ( % ) -2 5.7 % -6 .9 % -9 .0 % -8 .2 % -9 .9 % -2 2.5 % -2 1.7 % -1 3.8 % -2 6.4 % 7.7 % 6.5 %

D uP ont R atio s

Retu rn o n S ale s ( R O S) -1 2.9 % -3 .4 % -4 .5 % -4 .1 % -5 .0 % -1 1 .5 % -1 1 .6 % -7 .9 % -1 4.4 % 2.7 % 2.0 %

A sse t T urn s 0.9 8 1.1 0 1.2 5 1.3 9 1.2 9 1.1 0 1.0 6 0.9 6 1.2 9 1.2 0 0.9 3

R etu rn o n A sse ts ( R O A) -1 2.6 % -3 .8 % -5 .6 % -5 .7 % -6 .4 % -1 2.6 % -1 2.3 % -7 .6 % -1 8.5 % 3.3 % 1.9 %

F in ancia l L eve ra ge 1.0 0 1.0 0 1.0 0 1.0 0 1.2 2 1.8 7 2.9 0 5.1 0 78.4 0 23.8 6 6.9 5

R etu rn o n E quity ( R O E) -1 2.6 % -3 .8 % -5 .6 % -5 .7 % -7 .8 % -2 3.6 % -3 5.6 % -3 8.7 % -1 ,4 46.7 % 78.1 % 12.9 %

M ark e tin g & A dve rtis in g

M ark e tin g ( $ ) / S ale s ( $ ) [% o f S ale s] 11 .7 % 10.8 % 10.0 % 10.4 % 10.3 % 10.5 % 10.6 % 10.1 % 11 .8 % 3.1 % 2.5 %

A dve rtis in g ( $ ) / S ale s ( $ ) [% o f S ale s] 1 3.5 % 12.5 % 11 .7 % 12.0 % 5.3 % 6.4 % 7.0 % 6.8 % 2.8 % 2.4 % 2.0 %

Q ualit y E ngin eerin g

Qualit y ( $ ) / S ale s ( $ ) [% o f S ale s] 4 .9 % 4.5 % 4.2 % 5.5 % 7.3 % 8.3 % 11 .3 % 9.2 % 9.9 % 7.3 % 5.8 %

Q ualit y ( $ ) / U nits P ro duce d $30.4 $ 28.8 $ 23.0 $ 29.9 $ 41.7 $ 47.2 $ 64.3 $ 36.0 $ 48.1 $ 27.1 $ 24.4

L ean S ix S ig m a

Lean S ix S ig m a ( $ ) / S ale s ( $ ) [% o f S ale s] 6 .0 % 5.6 % 5.2 % 6.1 % 9.4 % 8.9 % 8.0 % 5.5 % 4.1 % 3.2 % 2.6 %

Lean S ix S ig m a ( $ ) / U nits P ro duce d $37.5 $ 35.4 $ 28.3 $ 33.2 $ 53.3 $ 50.3 $ 45.7 $ 21.4 $ 20.0 $ 11 .9 $ 11 .1

R ese arc h E xp ense & P ro je ct F undin g

 Reginald Whimbush /

Metr ic s Q 1'1 9A Q 2'1 9A Q 3'1 9A Q 4'1 9A Q 1'2 0A Q 2'2 0A Q 3'2 0A Q 4'2 0A Q 1'2 1A Q 2'2 1A Q 3'2 1A

R ese arc h ( $ ) / S ale s ( $ ) [% o f S ale s] 0 .0 % 0.0 % 0.0 % 0.0 % 7.3 % 8.3 % 8.8 % 9.9 % 9.5 % 0.0 % 0.0 %

C ash F lo w A naly sis

C ash C onve rs io n C ycle ( C CC) in D ays 3 1.1 3 0.5 5 4.0 6 8.0 8 8.4 1 02.7 1 09.9 1 36.2 1 06.1 1 35.9 1 21.1

T e rm s to C usto m er 30.0 3 0.0 3 0.0 3 0.0 6 0.0 6 0.0 6 0.0 6 0.0 3 5.0 3 0.0 4 0.0

A ve ra ge C olle ctio n P erio d in D ays 3 0.0 3 0.1 3 9.9 4 0.0 5 5.9 6 4.0 6 3.1 6 4.4 4 0.4 3 2.3 4 0.6

D ays In ve nto ry O uts ta ndin g 1.1 0 .3 1 4.1 2 8.0 3 2.5 3 8.7 4 6.8 7 1.7 6 5.8 1 03.6 1 25.3

D ays P aya ble O uts ta ndin g 0.0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 4 4.8

S upplie r T e rm s 0.0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 0 .0 3 0.0

C ash F lo w fr o m O pera tin g A ctiv itie s ( C FO A) ($ 124,3 31) ($ 16,6 72) ($ 76,9 14) ($ 40,7 85) ($ 94,1 33) ($ 105,3 90) ($ 92,8 68) ($ 136,1 98) ($ 84,5 55) ($ 161,5 24) ($ 278,3 32)

In te re st C ove ra ge [O M $ / In te re st $ ] - - - - - -4 5.1 - 1 5.0 - 6 .8 - 1 1 .2 3 .5 2 .6

C ash F lo w C ove ra ge - - - - - -2 .2 - 0 .6 - 0 .6 - 0 .2 - 0 .3 - 0 .4

D istr ib uto r F in ancia ls

Reta il Pric e ( $ ) $700 $700 $700 $700 $678 $656 $633 $611 $ 644 $656 $667

D istr ib uto r M arg in ( % ) 10.0 % 10.0 % 10.0 % 10.0 % 10.0 % 10.0 % 10.0 % 10.0 % 10.0 % 10.0 % 10.0 %

D istr ib uto r M arg in ( $ ) $70.0 $ 70.0 $ 70.0 $ 70.0 $ 67.8 $ 65.6 $ 63.3 $ 61.1 $ 64.4 $ 65.6 $ 66.7

T o ta l D istr ib uto r M arg in ( $ ) $29,5 40 $31,9 90 $34,3 00 $36,1 90 $37,8 88 $40,0 54 $44,2 07 $50,6 61 $67,5 38 $87,3 20 $105,4 67

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