BUS496 University of La Verne Initial Financial Analysis This is an individual project. Go to the Capsim home page, select “industry results” from the left

BUS496 University of La Verne Initial Financial Analysis This is an individual project. Go to the Capsim home page, select “industry results” from the left side of the screen, then, “reports” then “Capstone Courier” to find your company’s statistics. The financial analysis will be using the number from Round 0. Use ratios from your text, pgs C9-C14, to tell me if this is a healthy company. Do NOT use all the ratios for your report, 3 to 5 of them is fine if you can build a solid case from them. Use these ratios to build your case in the examination of your company and to back up your statements on the health of your company in your report. You must show the equation and the numbers you used to calculate your ratios. What strengths do you intend to build on? What needs to be improved? To be submitted in the Assignment area in Blackboard through SafeAssign. Minimum 2 pgs. The ratios for DSO and Inventory Turnover Rate are not allowed, since you cannot calculate them with the information given to you by the simulation. Round: 0
Dec. 31,
2019
C109578
Andrews
Baldwin
Chester
Digby
Erie
Ferris
Selected Financial Statistics
ROS
Asset Turnover
ROA
Leverage
ROE
Emergency Loan
Sales
EBIT
Profits
Cumulative Profit
SG&A / Sales
Contrib. Margin %
CAPSTONE ® COURIER
Andrews
4.1%
1.05
4.4%
2.0
8.7%
$0
$101,073,437
$11,996,365
$4,188,507
$4,188,507
8.9%
28.3%
Baldwin
4.1%
1.05
4.4%
2.0
8.7%
$0
$101,073,437
$11,996,365
$4,188,507
$4,188,507
8.9%
28.3%
Chester
4.1%
1.05
4.4%
2.0
8.7%
$0
$101,073,437
$11,996,365
$4,188,507
$4,188,507
8.9%
28.3%
Digby
4.1%
1.05
4.4%
2.0
8.7%
$0
$101,073,437
$11,996,365
$4,188,507
$4,188,507
8.9%
28.3%
Erie
4.1%
1.05
4.4%
2.0
8.7%
$0
$101,073,437
$11,996,365
$4,188,507
$4,188,507
8.9%
28.3%
Ferris
4.1%
1.05
4.4%
2.0
8.7%
$0
$101,073,437
$11,996,365
$4,188,507
$4,188,507
8.9%
28.3%
Page 1
Stock & Bonds
C109578
Round: 0
Dec. 31, 2019
Stock Market Summary
Company
Close
Change
Shares
Andrews
Baldwin
Chester
Digby
Erie
Ferris
$34.25
$34.25
$34.25
$34.25
$34.25
$34.25
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
MarketCap
($M)
$69
$69
$69
$69
$69
$69
Book Value
EPS
Dividend
Yield
P/E
$23.97
$23.97
$23.97
$23.97
$23.97
$23.97
$2.09
$2.09
$2.09
$2.09
$2.09
$2.09
$2.00
$2.00
$2.00
$2.00
$2.00
$2.00
5.8%
5.8%
5.8%
5.8%
5.8%
5.8%
16.4
16.4
16.4
16.4
16.4
16.4
Bond Market Summary
Company
Andrews
Series#
Face
Yield
Close$ S&P
11.0S2021 $6,950,000
12.5S2023 $13,900,000
14.0S2025 $20,850,000
11.1%
12.1%
12.6%
99.49
103.70
111.32
B
B
B
11.0S2021 $6,950,000
12.5S2023 $13,900,000
14.0S2025 $20,850,000
11.1%
12.1%
12.6%
99.49
103.70
111.32
B
B
B
11.0S2021 $6,950,000
12.5S2023 $13,900,000
14.0S2025 $20,850,000
11.1%
12.1%
12.6%
99.49
103.70
111.32
B
B
B
Baldwin
Company
Digby
Series#
Face
Yield
Close$
S&P
11.0S2021 $6,950,000
12.5S2023 $13,900,000
14.0S2025 $20,850,000
11.1%
12.1%
12.6%
99.49
103.70
111.32
B
B
B
11.0S2021 $6,950,000
12.5S2023 $13,900,000
14.0S2025 $20,850,000
11.1%
12.1%
12.6%
99.49
103.70
111.32
B
B
B
11.0S2021 $6,950,000
12.5S2023 $13,900,000
14.0S2025 $20,850,000
11.1%
12.1%
12.6%
99.49
103.70
111.32
B
B
B
Erie
Chester
Ferris
Next Year’s Prime Rate7.00%
CAPSTONE ® COURIER
Page 2
Financial Summary
Cash Flow Statement Survey
CashFlows from operating activities
Net Income(Loss)
Adjustment for non-cash items:
Depreciation
Extraordinary gains/losses/writeoffs
Changes in current assets and liablilities
Accounts payable
Inventory
Accounts Receivable
Net cash from operations
C109578
Round: 0
Dec. 31, 2019
Andrews
Baldwin
Chester
Digby
Erie
Ferris
$4,189
$4,189
$4,189
$4,189
$4,189
$4,189
$7,587
$0
$7,587
$0
$7,587
$0
$7,587
$0
$7,587
$0
$7,587
$0
$3,583
($8,617)
($307)
$6,434
$3,583
($8,617)
($307)
$6,434
$3,583
($8,617)
($307)
$6,434
$3,583
($8,617)
($307)
$6,434
$3,583
($8,617)
($307)
$6,434
$3,583
($8,617)
($307)
$6,434
Cash flows from investing activities
Plant improvements(net)
Cash flows from financing activities
Dividends paid
Sales of common stock
Purchase of common stock
Cash from long term debt issued
Early retirement of long term debt
Retirement of current debt
Cash from current debt borrowing
Cash from emergency loan
$0
$0
$0
$0
$0
$0
($4,000)
$0
$0
$0
$0
$0
$0
$0
($4,000)
$0
$0
$0
$0
$0
$0
$0
($4,000)
$0
$0
$0
$0
$0
$0
$0
($4,000)
$0
$0
$0
$0
$0
$0
$0
($4,000)
$0
$0
$0
$0
$0
$0
$0
($4,000)
$0
$0
$0
$0
$0
$0
$0
Net cash from financing activities
($4,000)
($4,000)
($4,000)
($4,000)
($4,000)
($4,000)
Net change in cash position
Balance Sheet Survey
Cash
Accounts Receivable
Inventory
Total Current Assets
$2,434
Andrews
$3,434
$8,307
$8,617
$20,358
$2,434
Baldwin
$3,434
$8,307
$8,617
$20,358
$2,434
Chester
$3,434
$8,307
$8,617
$20,358
$2,434
Digby
$3,434
$8,307
$8,617
$20,358
$2,434
Erie
$3,434
$8,307
$8,617
$20,358
$2,434
Ferris
$3,434
$8,307
$8,617
$20,358
Plant and equipment
Accumulated Depreciation
Total Fixed Assets
$113,800
($37,933)
$75,867
$113,800
($37,933)
$75,867
$113,800
($37,933)
$75,867
$113,800
($37,933)
$75,867
$113,800
($37,933)
$75,867
$113,800
($37,933)
$75,867
Total Assets
$96,225
$96,225
$96,225
$96,225
$96,225
$96,225
Accounts Payable
Current Debt
Long Term Debt
Total Liabilities
$6,583
$0
$41,700
$48,283
$6,583
$0
$41,700
$48,283
$6,583
$0
$41,700
$48,283
$6,583
$0
$41,700
$48,283
$6,583
$0
$41,700
$48,283
$6,583
$0
$41,700
$48,283
Common Stock
Retained Earnings
Total Equity
$18,360
$29,582
$47,942
$18,360
$29,582
$47,942
$18,360
$29,582
$47,942
$18,360
$29,582
$47,942
$18,360
$29,582
$47,942
$18,360
$29,582
$47,942
Total Liabilities & Owners Equity
$96,225
$96,225
$96,225
$96,225
$96,225
$96,225
Andrews
$101,073
$72,513
$7,587
$8,978
$0
$11,996
$5,421
$2,301
$85
$4,189
Baldwin
$101,073
$72,513
$7,587
$8,978
$0
$11,996
$5,421
$2,301
$85
$4,189
Chester
$101,073
$72,513
$7,587
$8,978
$0
$11,996
$5,421
$2,301
$85
$4,189
Digby
$101,073
$72,513
$7,587
$8,978
$0
$11,996
$5,421
$2,301
$85
$4,189
Erie
$101,073
$72,513
$7,587
$8,978
$0
$11,996
$5,421
$2,301
$85
$4,189
Ferris
$101,073
$72,513
$7,587
$8,978
$0
$11,996
$5,421
$2,301
$85
$4,189
Income Statement Survey
Sales
Variable Costs(Labor,Material,Carry)
Depreciation
SGA(R&D,Promo,Sales,Admin)
Other(Fees,Writeoffs,TQM,Bonuses)
EBIT
Interest(Short term,Long term)
Taxes
Profit Sharing
Net Profit
CAPSTONE ® COURIER
Page 3
C109578
Production Analysis
Price
$28.00
$21.00
$38.00
$33.00
$33.00
Material
Cost
$11.59
$7.81
$15.98
$15.87
$13.62
Labor
Cost
$7.49
$7.12
$8.57
$8.57
$8.57
Contr.
Marg.
29%
27%
33%
23%
30%
2nd
Shift
&
Overtime
0%
30%
0%
0%
0%
14.5
17.0
12.0
15.5
11.0
$28.00
$21.00
$38.00
$33.00
$33.00
$11.59
$7.81
$15.98
$15.87
$13.62
$7.49
$7.12
$8.57
$8.57
$8.57
29%
27%
33%
23%
30%
0%
30%
0%
0%
0%
4.0
5.0
3.0
3.0
3.0
1,800
1,400
900
600
600
66%
129%
45%
73%
63%
5.5
3.0
8.0
9.4
4.0
14.5
17.0
12.0
15.5
11.0
$28.00
$21.00
$38.00
$33.00
$33.00
$11.59
$7.81
$15.98
$15.87
$13.62
$7.49
$7.12
$8.57
$8.57
$8.57
29%
27%
33%
23%
30%
0%
30%
0%
0%
0%
4.0
5.0
3.0
3.0
3.0
1,800
1,400
900
600
600
66%
129%
45%
73%
63%
17500
14000
23000
25000
19000
5.5
3.0
8.0
9.4
4.0
14.5
17.0
12.0
15.5
11.0
$28.00
$21.00
$38.00
$33.00
$33.00
$11.59
$7.81
$15.98
$15.87
$13.62
$7.49
$7.12
$8.57
$8.57
$8.57
29%
27%
33%
23%
30%
0%
30%
0%
0%
0%
4.0
5.0
3.0
3.0
3.0
1,800
1,400
900
600
600
66%
129%
45%
73%
63%
3.1
4.6
1.7
2.5
2.6
17500
14000
23000
25000
19000
5.5
3.0
8.0
9.4
4.0
14.5
17.0
12.0
15.5
11.0
$28.00
$21.00
$38.00
$33.00
$33.00
$11.59
$7.81
$15.98
$15.87
$13.62
$7.49
$7.12
$8.57
$8.57
$8.57
29%
27%
33%
23%
30%
0%
30%
0%
0%
0%
4.0
5.0
3.0
3.0
3.0
1,800
1,400
900
600
600
66%
129%
45%
73%
63%
3.1
4.6
1.7
2.5
2.6
17500
14000
23000
25000
19000
5.5
3.0
8.0
9.4
4.0
14.5
17.0
12.0
15.5
11.0
$28.00
$21.00
$38.00
$33.00
$33.00
$11.59
$7.81
$15.98
$15.87
$13.62
$7.49
$7.12
$8.57
$8.57
$8.57
29%
27%
33%
23%
30%
0%
30%
0%
0%
0%
4.0
5.0
3.0
3.0
3.0
1,800
1,400
900
600
600
66%
129%
45%
73%
63%
Unit
Inven
Revision
Age
tory
Date Dec.31
189 11/20/2016
3.1
39 5/25/2015
4.6
40 4/19/2018
1.7
78 6/30/2017
2.5
62 5/25/2017
2.6
Name
Able
Acre
Adam
Aft
Agape
Primary
Segment
Trad
Low
High
Pfmn
Size
Units
Sold
999
1,763
366
358
314
Baker
Bead
Bid
Bold
Buddy
Trad
Low
High
Pfmn
Size
999
1,763
366
358
314
189 11/20/2016
39 5/25/2015
40 4/19/2018
78 6/30/2017
62 5/25/2017
Cake
Cedar
Cid
Coat
Cure
Trad
Low
High
Pfmn
Size
999
1,763
366
358
314
Daze
Dell
Dixie
Dot
Dune
Trad
Low
High
Pfmn
Size
Eat
Ebb
Echo
Edge
Egg
Fast
Feat
Fist
Foam
Fume
MTBF
17500
14000
23000
25000
19000
Pfmn
Coord
5.5
3.0
8.0
9.4
4.0
Size
Coord
14.5
17.0
12.0
15.5
11.0
3.1
4.6
1.7
2.5
2.6
17500
14000
23000
25000
19000
5.5
3.0
8.0
9.4
4.0
189 11/20/2016
39 5/25/2015
40 4/19/2018
78 6/30/2017
62 5/25/2017
3.1
4.6
1.7
2.5
2.6
17500
14000
23000
25000
19000
999
1,763
366
358
314
189 11/20/2016
39 5/25/2015
40 4/19/2018
78 6/30/2017
62 5/25/2017
3.1
4.6
1.7
2.5
2.6
Trad
Low
High
Pfmn
Size
999
1,763
366
358
314
189 11/20/2016
39 5/25/2015
40 4/19/2018
78 6/30/2017
62 5/25/2017
Trad
Low
High
Pfmn
Size
999
1,763
366
358
314
189 11/20/2016
39 5/25/2015
40 4/19/2018
78 6/30/2017
62 5/25/2017
CAPSTONE ® COURIER
Round: 0
Dec. 31, 2019
Auto
mation
Next
Round
4.0
5.0
3.0
3.0
3.0
Capacity
Next
Round
1,800
1,400
900
600
600
Plant
Utiliz.
66%
129%
45%
73%
63%
Page 4
Traditional Segment Analysis
C109578
Round: 0
Dec. 31, 2019
Traditional Statistics
Total Industry Unit Demand
Actual Industry Unit Sales
Segment % of Total Industry
7,387
|7,387
|32.4%
Next Year’s Segment Growth Rate
|9.2%
Traditional Customer Buying Criteria
Expectations
Ideal Age = 2.0
$20.00 – 30.00
Pfmn 5.0 Size 15.0
MTBF 14000-19000
1. Age
2. Price
3. Ideal Position
4. Reliability
Importance
47%
23%
21%
9%
Top Products in Traditional Segment
Name
Able
Baker
Cake
Daze
Eat
Fast
Acre
Bead
Cedar
Dell
Ebb
Feat
Market
Share
13%
13%
13%
13%
13%
13%
4%
4%
4%
4%
4%
4%
Units
Sold to
Seg
961
961
961
961
961
961
270
270
270
270
270
270
CAPSTONE ® COURIER
Revision
Date
11/20/2016
11/20/2016
11/20/2016
11/20/2016
11/20/2016
11/20/2016
5/25/2015
5/25/2015
5/25/2015
5/25/2015
5/25/2015
5/25/2015
Stock
Out
Pfmn
Coord
5.5
5.5
5.5
5.5
5.5
5.5
3.0
3.0
3.0
3.0
3.0
3.0
Size
Coord
14.5
14.5
14.5
14.5
14.5
14.5
17.0
17.0
17.0
17.0
17.0
17.0
List
Price
$28.00
$28.00
$28.00
$28.00
$28.00
$28.00
$21.00
$21.00
$21.00
$21.00
$21.00
$21.00
MTBF
17500
17500
17500
17500
17500
17500
14000
14000
14000
14000
14000
14000
Cust.
Age Promo AwareDec.31 Budget ness
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
Cust.
Dec.
Sales Access- Cust
Budget ibility
Survey
$1,000 54%
18
$1,000 54%
18
$1,000 54%
18
$1,000 54%
18
$1,000 54%
18
$1,000 54%
18
$900 54%
4
$900 54%
4
$900 54%
4
$900 54%
4
$900 54%
4
$900 54%
4
Page 5
Low End Segment Analysis
C109578
Round: 0
Dec. 31, 2019
Low End Statistics
Total Industry Unit Demand
Actual Industry Unit Sales
Segment % of Total Industry
8,960
|8,960
|39.3%
Next Year’s Segment Growth Rate
|11.7%
Low End Customer Buying Criteria
Expectations
$15.00 – 25.00
Ideal Age = 7.0
Pfmn 1.7 Size 18.3
MTBF 12000-17000
1. Price
2. Age
3. Ideal Position
4. Reliability
Importance
53%
24%
16%
7%
Top Products in Low End Segment
Name
Acre
Bead
Cedar
Dell
Ebb
Feat
Market
Share
17%
17%
17%
17%
17%
17%
Units
Sold to
Seg
1,493
1,493
1,493
1,493
1,493
1,493
CAPSTONE ® COURIER
Revision
Date
5/25/2015
5/25/2015
5/25/2015
5/25/2015
5/25/2015
5/25/2015
Stock
Out
Pfmn
Coord
3.0
3.0
3.0
3.0
3.0
3.0
Size
Coord
17.0
17.0
17.0
17.0
17.0
17.0
List
Price
$21.00
$21.00
$21.00
$21.00
$21.00
$21.00
MTBF
14000
14000
14000
14000
14000
14000
Cust.
Age Promo AwareDec.31 Budget ness
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
4.60
$900 52%
Cust.
Dec.
Sales Access- Cust
Budget ibility
Survey
$900 40%
12
$900 40%
12
$900 40%
12
$900 40%
12
$900 40%
12
$900 40%
12
Page 6
High End Segment Analysis
C109578
Round: 0
Dec. 31, 2019
High End Statistics
Total Industry Unit Demand
Actual Industry Unit Sales
Segment % of Total Industry
2,554
|2,554
|11.2%
Next Year’s Segment Growth Rate
|16.2%
High End Customer Buying Criteria
Expectations
Pfmn 8.9 Size 11.1
Ideal Age = 0.0
MTBF 20000-25000
$30.00 – 40.00
1. Ideal Position
2. Age
3. Reliability
4. Price
Importance
43%
29%
19%
9%
Top Products in High End Segment
Name
Adam
Bid
Cid
Dixie
Echo
Fist
Aft
Bold
Coat
Dot
Edge
Foam
Market
Share
14%
14%
14%
14%
14%
14%
2%
2%
2%
2%
2%
2%
Units
Sold to
Seg
366
366
366
366
366
366
41
41
41
41
41
41
CAPSTONE ® COURIER
Revision
Date
4/19/2018
4/19/2018
4/19/2018
4/19/2018
4/19/2018
4/19/2018
6/30/2017
6/30/2017
6/30/2017
6/30/2017
6/30/2017
6/30/2017
Stock
Out
Pfmn
Coord
8.0
8.0
8.0
8.0
8.0
8.0
9.4
9.4
9.4
9.4
9.4
9.4
Size
Coord
12.0
12.0
12.0
12.0
12.0
12.0
15.5
15.5
15.5
15.5
15.5
15.5
List
Price
$38.00
$38.00
$38.00
$38.00
$38.00
$38.00
$33.00
$33.00
$33.00
$33.00
$33.00
$33.00
MTBF
23000
23000
23000
23000
23000
23000
25000
25000
25000
25000
25000
25000
Cust.
Age Promo AwareDec.31 Budget ness
1.70
$800 49%
1.70
$800 49%
1.70
$800 49%
1.70
$800 49%
1.70
$800 49%
1.70
$800 49%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
Cust.
Dec.
Sales Access- Cust
Budget ibility
Survey
$800 48%
21
$800 48%
21
$800 48%
21
$800 48%
21
$800 48%
21
$800 48%
21
$700 48%
2
$700 48%
2
$700 48%
2
$700 48%
2
$700 48%
2
$700 48%
2
Page 7
Performance Segment Analysis
C109578
Round: 0
Dec. 31, 2019
Performance Statistics
Total Industry Unit Demand
Actual Industry Unit Sales
Segment % of Total Industry
1,915
|1,915
|8.4%
Next Year’s Segment Growth Rate
|19.8%
Performance Customer Buying Criteria
Expectations
MTBF 22000-27000
Pfmn 9.4 Size 16.0
$25.00 – 35.00
Ideal Age = 1.0
1. Reliability
2. Ideal Position
3. Price
4. Age
Importance
43%
29%
19%
9%
Top Products in Performance Segment
Name
Aft
Bold
Coat
Dot
Edge
Foam
Able
Baker
Cake
Daze
Eat
Fast
Market
Share
17%
17%
17%
17%
17%
17%
0%
0%
0%
0%
0%
0%
Units
Sold to
Seg
317
317
317
317
317
317
2
2
2
2
2
2
CAPSTONE ® COURIER
Revision
Date
6/30/2017
6/30/2017
6/30/2017
6/30/2017
6/30/2017
6/30/2017
11/20/2016
11/20/2016
11/20/2016
11/20/2016
11/20/2016
11/20/2016
Stock
Out
Pfmn
Coord
9.4
9.4
9.4
9.4
9.4
9.4
5.5
5.5
5.5
5.5
5.5
5.5
Size
Coord
15.5
15.5
15.5
15.5
15.5
15.5
14.5
14.5
14.5
14.5
14.5
14.5
List
Price
$33.00
$33.00
$33.00
$33.00
$33.00
$33.00
$28.00
$28.00
$28.00
$28.00
$28.00
$28.00
MTBF
25000
25000
25000
25000
25000
25000
17500
17500
17500
17500
17500
17500
Cust.
Age Promo AwareDec.31 Budget ness
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
2.50
$700 46%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
Cust.
Dec.
Sales Access- Cust
Budget ibility
Survey
$700 37%
20
$700 37%
20
$700 37%
20
$700 37%
20
$700 37%
20
$700 37%
20
$1,000 37%
0
$1,000 37%
0
$1,000 37%
0
$1,000 37%
0
$1,000 37%
0
$1,000 37%
0
Page 8
Size Segment Analysis
C109578
Round: 0
Dec. 31, 2019
Size Statistics
Total Industry Unit Demand
Actual Industry Unit Sales
Segment % of Total Industry
1,984
|1,984
|8.7%
Next Year’s Segment Growth Rate
|18.3%
Size Customer Buying Criteria
Expectations
Pfmn 4.0 Size 10.6
Ideal Age = 1.5
MTBF 16000-21000
$25.00 – 35.00
1. Ideal Position
2. Age
3. Reliability
4. Price
Importance
43%
29%
19%
9%
Top Products in Size Segment
Name
Agape
Buddy
Cure
Dune
Egg
Fume
Able
Baker
Cake
Daze
Eat
Fast
Market
Share
15%
15%
15%
15%
15%
15%
1%
1%
1%
1%
1%
1%
Units
Sold to
Seg
307
307
307
307
307
307
24
24
24
24
24
24
CAPSTONE ® COURIER
Revision
Date
5/25/2017
5/25/2017
5/25/2017
5/25/2017
5/25/2017
5/25/2017
11/20/2016
11/20/2016
11/20/2016
11/20/2016
11/20/2016
11/20/2016
Stock
Out
Pfmn
Coord
4.0
4.0
4.0
4.0
4.0
4.0
5.5
5.5
5.5
5.5
5.5
5.5
Size
Coord
11.0
11.0
11.0
11.0
11.0
11.0
14.5
14.5
14.5
14.5
14.5
14.5
List
Price
$33.00
$33.00
$33.00
$33.00
$33.00
$33.00
$28.00
$28.00
$28.00
$28.00
$28.00
$28.00
MTBF
19000
19000
19000
19000
19000
19000
17500
17500
17500
17500
17500
17500
Cust.
Age Promo AwareDec.31 Budget ness
2.60
$700 46%
2.60
$700 46%
2.60
$700 46%
2.60
$700 46%
2.60
$700 46%
2.60
$700 46%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
3.10 $1,000 55%
Cust.
Dec.
Sales Access- Cust
Budget ibility
Survey
$700 42%
27
$700 42%
27
$700 42%
27
$700 42%
27
$700 42%
27
$700 42%
27
$1,000 42%
2
$1,000 42%
2
$1,000 42%
2
$1,000 42%
2
$1,000 42%
2
$1,000 42%
2
Page 9
Market Share
C109578
Actual Market Share in Units
Trad
7,387
32.4%
Low
8,960
39.3%
Able
Acre
Adam
Aft
Agape
Total
13.0%
3.6%
16.7%
16.7%
16.7%
Baker
Bead
Bid
Bold
Buddy
Total
13.0%
3.6%
16.7%
16.7%
16.7%
Cake
Cedar
Cid
Coat
Cure
Total
13.0%
3.6%
16.7%
16.7%
16.7%
Daze
Dell
Dixie
Dot
Dune
Total
13.0%
3.6%
16.7%
16.7%
16.7%
Eat
Ebb
Echo
Edge
Egg
Total
13.0%
3.6%
16.7%
16.7%
16.7%
Fast
Feat
Fist
Foam
Fume
Total
13.0%
3.6%
16.7%
Industry Unit Sales
% of Market
16.7%
CAPSTONE ® COURIER
High
2,554
11.2%
Pfmn
1,915
8.4%
Size
1,984
8.7%
0.4%
0.1%
1.2%
14.3%
1.6%
0.3%
16.7%
0.4%
14.3%
1.6%
0.3%
16.7%
0.4%
14.3%
1.6%
0.3%
16.7%
0.4%
14.3%
1.6%
0.3%
16.7%
0.4%
14.3%
1.6%
0.3%
16.7%
0.4%
16.7%
14.3%
1.6%
0.3%
16.7%
16.5%
16.7%
15.5%
16.7%
0.1%
1.2%
16.5%
16.7%
15.5%
16.7%
0.1%
1.2%
16.5%
16.7%
15.5%
16.7%
0.1%
1.2%
16.5%
16.7%
15.5%
16.7%
0.1%
1.2%
16.5%
16.7%
15.5%
16.7%
0.1%
1.2%
16.5%
16.7%
15.5%
16.7%
Round: 0
Dec. 31, 2019
Potential Market Share in Units
Total
22,800 Units Demanded
100.0% % of Market
Trad
7,387
32.4%
Low
8,960
39.3%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Able
Acre
Adam
Aft
Agape
Total
13.0%
3.7%
16.7%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Baker
Bead
Bid
Bold
Buddy
Total
13.0%
3.7%
16.7%
16.7%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Cake
Cedar
Cid
Coat
Cure
Total
13.0%
3.7%
16.7%
16.7%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Daze
Dell
Dixie
Dot
Dune
Total
13.0%
3.7%
16.7%
16.7%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Eat
Ebb
Echo
Edge
Egg
Total
13.0%
3.7%
16.7%
16.7%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Fast
Feat
Fist
Foam
Fume
Total
13.0%
3.7%
16.7%
16.7%
High
2,554
11.2%
Pfmn
1,915
8.4%
0.5%
14.3%
1.6%
0.3%
16.7%
16.7%
16.7%
16.7%
15.5%
16.7%
16.5%
16.7%
15.5%
16.7%
1.2%
16.5%
16.7%
15.5%
16.7%
1.2%
16.5%
16.7%
0.5%
14.3%
1.6%
0.3%
16.7%
15.5%
16.7%
1.2%
0.5%
14.3%
1.6%
0.3%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
16.5%
0.5%
14.3%
1.6%
0.3%
16.7%
1.2%
1.2%
0.5%
14.3%
1.6%
0.3%
16.7%
Total
22,800
100.0%
16.5%
0.5%
14.3%
1.6%
0.3%
16.7%
Size
1,984
8.7%
15.5%
16.7%
1.2%
16.5%
16.7%
15.5%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
4.4%
7.7%
1.6%
1.6%
1.4%
16.7%
Page 10
Perceptual Map
C109578
Andrews
Name
Able
Acre
Adam
Aft
Agape
Pfmn
5.5
3.0
8.0
9.4
4.0
Name
Daze
Dell
Dixie
Dot
Dune
Pfmn
5.5
3.0
8.0
9.4
4.0
Size
14.5
17.0
12.0
15.5
11.0
Digby
CAPSTONE ® COURIER
Size
14.5
17.0
12.0
15.5
11.0
Baldwin
Revised
11/20/2016
5/25/2015
4/19/2018
6/30/2017
5/25/2017
Name
Baker
Bead
Bid
Bold
Buddy
Pfmn
5.5
3.0
8.0
9.4
4.0
Revised
11/20/2016
5/25/2015
4/19/2018
6/30/2017
5/25/2017
Name
Eat
Ebb
Echo
Edge
Egg
Pfmn
5.5
3.0
8.0
9.4
4.0
Size
14.5
17.0
12.0
15.5
11.0
Erie
Size
14.5
17.0
12.0
15.5
11.0
Round: 0
Dec. 31, 2019
Chester
Revised
11/20/2016
5/25/2015
4/19/2018
6/30/2017
5/25/2017
Name
Cake
Cedar
Cid
Coat
Cure
Pfmn
5.5
3.0
8.0
9.4
4.0
Revised
11/20/2016
5/25/2015
4/19/2018
6/30/2017
5/25/2017
Name
Fast
Feat
Fist
Foam
Fume
Pfmn
5.5
3.0
8.0
9.4
4.0
Size
14.5
17.0
12.0
15.5
11.0
Ferris
Size
14.5
17.0
12.0
15.5
11.0
Revised
11/20/2016
5/25/2015
4/19/2018
6/30/2017
5/25/2017
Revised
11/20/2016
5/25/2015
4/19/2018
6/30/2017
5/25/2017
Page 11
HR/TQM Report
C109578
Round: 0
Dec. 31, 2019
HUMAN RESOURCES SUMMARY
Needed Complement
Complement
1st Shift Complement
2nd Shift Complement
Andrews
701
700
640
60
Baldwin
701
700
640
60
Chester
701
700
640
60
Digby
701
700
640
60
Erie
701
700
640
60
Ferris
701
700
640
60
Overtime Percent
Turnover Rate
New Employees
Separated Employees
Recruiting Spend
Training Hours
Productivity Index
0.2%
10.0%
70
0
$0
0
100.0%
0.2%
10.0%
70
0
$0
0
100.0%
0.2%
10.0%
70
0
$0
0
100.0%
0.2%
10.0%
70
0
$0
0
100.0%
0.2%
10.0%
70
0
$0
0
100.0%
0.2%
10.0%
70
0
$0
0
100.0%
$70
$0
$0
$70
$70
$0
$0
$70
$70
$0
$0
$70
$70
$0
$0
$70
$70
$0
$0
$70
$70
$0
$0
$70
$21.00
2,500
2.0%
5.0%
$21.00
2,500
2.0%
5.0%
$21.00
2,500
2.0%
5.0%
$21.00
2,500
2.0%
5.0%
$21.00
2,500
2.0%
5.0%
$21.00
2,500
2.0%
5.0%
Baldwin
Chester
Digby
Erie
Ferris
Recruiting Cost
Separation Cost
Training Cost
Total HR Admin Cost
Labor Contract Next Year
Wages
Benefits
Profit Sharing
Annual Raise
Startin…
Purchase answer to see full
attachment