Andrews Baldwin Chester Digby Erie Ferris ROS Asset Turnover ROA Leverage (Assets/Equity)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 9

Andrews Baldwin Chester Digby Erie Ferris

ROS 4.10% 4.10% 4.10% 4.10% 4.10% 4.10%

Asset Turnover 1.05 1.05 1.05 1.05 1.05 1.05

ROA 4.40% 4.40% 4.40% 4.40% 4.40% 4.40%

Leverage
2 2 2 2 2 2
(Assets/Equity)

ROE 8.70% 8.70% 8.70% 8.70% 8.70% 8.70%


Emergency
$0 $0 $0 $0 $0 $0
Loan
Sales $101,073,437 $101,073,437 $101,073,437 $101,073,437 $101,073,437 $101,073,437

EBIT $11,996,365 $11,996,365 $11,996,365 $11,996,365 $11,996,365 $11,996,365

Profits $4,188,507 $4,188,507 $4,188,507 $4,188,507 $4,188,507 $4,188,507


Cumulative
$4,188,507 $4,188,507 $4,188,507 $4,188,507 $4,188,507 $4,188,507
Profit

SG&A / Sales 8.90% 8.90% 8.90% 8.90% 8.90% 8.90%

Contrib. Margin
28.30% 28.30% 28.30% 28.30% 28.30% 28.30%
%

Primary
Name Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price
Segment

Able Trad 999 189 11/21/2018 3.1 17500 5.5 14.5 $28.00

Acre Low 1,763 39 5/25/2017 4.6 14000 3 17 $21.00

Adam High 366 40 4/18/2020 1.7 23000 8 12 $38.00

Aft Pfmn 358 78 6/30/2019 2.5 25000 9.4 15.5 $33.00

Agape Size 314 62 5/25/2019 2.6 19000 4 11 $33.00

Baker Trad 999 189 11/21/2018 3.1 17500 5.5 14.5 $28.00

Bead Low 1,763 39 5/25/2017 4.6 14000 3 17 $21.00

Bid High 366 40 4/18/2020 1.7 23000 8 12 $38.00

Bold Pfmn 358 78 6/30/2019 2.5 25000 9.4 15.5 $33.00

Buddy Size 314 62 5/25/2019 2.6 19000 4 11 $33.00

Cake Trad 999 189 11/21/2018 3.1 17500 5.5 14.5 $28.00

Cedar Low 1,763 39 5/25/2017 4.6 14000 3 17 $21.00

Cid High 366 40 4/18/2020 1.7 23000 8 12 $38.00

Coat Pfmn 358 78 6/30/2019 2.5 25000 9.4 15.5 $33.00

Cure Size 314 62 5/25/2019 2.6 19000 4 11 $33.00

Daze Trad 999 189 11/21/2018 3.1 17500 5.5 14.5 $28.00

Dell Low 1,763 39 5/25/2017 4.6 14000 3 17 $21.00

Duck High 366 40 4/18/2020 1.7 23000 8 12 $38.00

Dot Pfmn 358 78 6/30/2019 2.5 25000 9.4 15.5 $33.00

Dune Size 314 62 5/25/2019 2.6 19000 4 11 $33.00

Eat Trad 999 189 11/21/2018 3.1 17500 5.5 14.5 $28.00
Ebb Low 1,763 39 5/25/2017 4.6 14000 3 17 $21.00

Echo High 366 40 4/18/2020 1.7 23000 8 12 $38.00

Edge Pfmn 358 78 6/30/2019 2.5 25000 9.4 15.5 $33.00

Egg Size 314 62 5/25/2019 2.6 19000 4 11 $33.00

Fast Trad 999 189 11/21/2018 3.1 17500 5.5 14.5 $28.00

Feat Low 1,763 39 5/25/2017 4.6 14000 3 17 $21.00

Fist High 366 40 4/18/2020 1.7 23000 8 12 $38.00

Foam Pfmn 358 78 6/30/2019 2.5 25000 9.4 15.5 $33.00

Fume Size 314 62 5/25/2019 2.6 19000 4 11 $33.00

Revision List
Units Sold to
Name Market Share Stock Out Pfmn Coord Size Coord MTBF Age Dec.31
Seg
Date Price

Able 13% 961 11/21/2018 5.5 14.5 $28.00 17500 3.1

Baker 13% 961 11/21/2018 5.5 14.5 $28.00 17500 3.1

Cake 13% 961 11/21/2018 5.5 14.5 $28.00 17500 3.1

Daze 13% 961 11/21/2018 5.5 14.5 $28.00 17500 3.1

Eat 13% 961 11/21/2018 5.5 14.5 $28.00 17500 3.1

Fast 13% 961 11/21/2018 5.5 14.5 $28.00 17500 3.1

Acre 4% 270 5/25/2017 3 17 $21.00 14000 4.6

Bead 4% 270 5/25/2017 3 17 $21.00 14000 4.6

Cedar 4% 270 5/25/2017 3 17 $21.00 14000 4.6

Dell 4% 270 5/25/2017 3 17 $21.00 14000 4.6

Ebb 4% 270 5/25/2017 3 17 $21.00 14000 4.6

Feat 4% 270 5/25/2017 3 17 $21.00 14000 4.6


2nd Shift &
Auto mation Next Capacity Next
Material Cost Labor Cost Contr. Marg. Over- Plant Utiliz.
Round Round
time

$11.59 $7.49 29% 0% 4 1,800 66%

$7.81 $7.12 27% 30% 5 1,400 129%

$15.98 $8.57 33% 0% 3 900 45%

$15.87 $8.57 23% 0% 3 600 73%

$13.62 $8.57 30% 0% 3 600 63%

$11.59 $7.49 29% 0% 4 1,800 66%

$7.81 $7.12 27% 30% 5 1,400 129%

$15.98 $8.57 33% 0% 3 900 45%

$15.87 $8.57 23% 0% 3 600 73%

$13.62 $8.57 30% 0% 3 600 63%

$11.59 $7.49 29% 0% 4 1,800 66%

$7.81 $7.12 27% 30% 5 1,400 129%

$15.98 $8.57 33% 0% 3 900 45%

$15.87 $8.57 23% 0% 3 600 73%

$13.62 $8.57 30% 0% 3 600 63%

$11.59 $7.49 29% 0% 4 1,800 66%

$7.81 $7.12 27% 30% 5 1,400 129%

$15.98 $8.57 33% 0% 3 900 45%

$15.87 $8.57 23% 0% 3 600 73%

$13.62 $8.57 30% 0% 3 600 63%

$11.59 $7.49 29% 0% 4 1,800 66%


$7.81 $7.12 27% 30% 5 1,400 129%

$15.98 $8.57 33% 0% 3 900 45%

$15.87 $8.57 23% 0% 3 600 73%

$13.62 $8.57 30% 0% 3 600 63%

$11.59 $7.49 29% 0% 4 1,800 66%

$7.81 $7.12 27% 30% 5 1,400 129%

$15.98 $8.57 33% 0% 3 900 45%

$15.87 $8.57 23% 0% 3 600 73%

$13.62 $8.57 30% 0% 3 600 63%

Promo Cust. Aware- Cust. Access-


Dec. Cust.
Sales Budget
Survey
Budget ness ibility

$1,000 55% $1,000 54% 18

$1,000 55% $1,000 54% 18

$1,000 55% $1,000 54% 18

$1,000 55% $1,000 54% 18

$1,000 55% $1,000 54% 18

$1,000 55% $1,000 54% 18

$900 52% $900 54% 4

$900 52% $900 54% 4

$900 52% $900 54% 4

$900 52% $900 54% 4

$900 52% $900 54% 4

$900 52% $900 54% 4


Growth Rates
Round 0 Round 1 Round 2 Round 3 Round 4 Round 5 Round 6 Round 7 Round 8
Traditional 6.70% 9.80% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00%
Low 13.80% 11.20% 10.30% 10.30% 10.30% 10.30% 10.30% 10.30% 10.30%
High 20.20% 17.10% 14.10% 14.10% 14.10% 14.10% 14.10% 14.10% 14.10%
Perf 16.90% 19.80% 23.50% 23.50% 23.50% 23.50% 23.50% 23.50% 23.50%
Size 15.90% 17.30% 17.80% 17.80% 17.80% 17.80% 17.80% 17.80% 17.80%

Growth rate
25.00% 23.50%

20.20% 19.80%
20.00%
17.30%
17.10% 17.80%
16.90%
15.90%
15.00% 13.80% 14.10%

11.20% 11.00%
9.80% 10.30%
10.00%
6.70%

5.00%

0.00%
Round 0 Round 1 Round 2

Traditional Low High


Perf Size
Growth rate
25.00% 23.50% 23.50% 23.50% 23.50% 23.50% 23.50%
20.20% 19.80%
20.00% 17.80% 17.80% 17.80% 17.80% 17.80% 17.80%
16.90% 17.30%
17.10%
15.90%
15.00% 13.80% 14.10% 14.10% 14.10% 14.10% 14.10% 14.10%
11.20% 11.00%
9.80% 10.30% 11.00%
10.30% 11.00%
10.30% 11.00%
10.30% 11.00%
10.30% 11.00%
10.30%
10.00%
6.70%
5.00%

0.00%
Round 0 Round 1 Round 2 Round 3 Round 4 Round 5 Round 6 Round

Traditional Low High


Perf Size
th rate
23.50% 23.50% 23.50% 23.50% 23.50%

17.80% 17.80% 17.80% 17.80% 17.80%

14.10% 14.10% 14.10% 14.10% 14.10%


11.00%
10.30% 11.00%
10.30% 11.00%
10.30% 11.00%
10.30% 11.00%
10.30%

Round 4 Round 5 Round 6 Round 7 Round 8

Low High
Size
Primary Unit Inven Revision Age Pfmn Size
Name Units Sold MTBF Price
Segment tory Date Dec.31 Coord Coord
Adam High 625 0 3/6/2023 1.6 23000 9.5 10.9 $38.00
Bid High 743 0 7/27/2023 1.5 23000 9.3 10.5 $39.50
Cid High 684 116 5/27/2023 1.7 23500 8.7 11 $37.50
Duck High 541 28 4/17/2023 1.6 20000 8.1 10.9 $38.00

Echo High 523 0 6/23/2023 1.5 22000 9.2 10.2 $37.00

Fist High 505 0 6/20/2023 2.1 23000 9.8 10.2 $38.00


Auto
Capacity
Material Labor Contr. 2nd Shift mation Plant
Next
Cost Cost Marg. & OT Next Utiliz.
Round
$15.06 $9.02 36% 0% Round4 900 69%
$15.16 $9.39 38% 0% 3 900 83%
$14.79 $9.42 34% 0% 3 900 66%
$13.51 $8.23 41% 0% 4 675 84%

$14.96 $9.40 34% 0% 3 900 44%

$15.54 $9.46 36% 0% 3 700 45%

You might also like