| |
TEXTUAL SUMMARY REPORT |
|
|
|
|
| |
|
|
| |
Date prepared: |
31-Dec-03 |
|
|
| |
|
|
|
|
| |
The
following three operational & financial reports for ANY CORP INC cover |
|
|
| |
the
months and years commencing in Feb 2005. They have been derived |
|
|
| |
from the detailed assumptions in
Exl-Plan's Monthly, Quarterly and Annual |
|
|
| |
Reports. |
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
| |
1. FIRST-YEAR OPERATIONAL REPORT - ANY CORP INC |
|
|
| |
|
|
| |
This
First-Year Operational Report covers the twelve months to end Jan 2006 |
|
|
| |
based on detailed monthly
projections and assumptions. The |
|
|
| |
following table summarizes quarterly
sales projections for the year: |
|
|
| |
|
|
| |
|
Quarter
Ends in Year to Jan 2006 |
|
Annual |
|
|
| |
Sales |
1 Qtr |
2 Qtr |
3 Qtr |
4 Qtr |
Total |
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
Product Group: |
|
|
|
|
| |
-
Group1 |
305.0 |
330.0 |
370.0 |
430.0 |
1,435.0 |
|
|
| |
-
Group2 |
160.9 |
231.3 |
308.3 |
341.7 |
1,042.2 |
|
|
| |
-
Group3 |
79.3 |
114.0 |
151.9 |
168.3 |
513.5 |
|
|
| |
-
Group4 |
285.0 |
320.0 |
345.0 |
380.0 |
1,330.0 |
|
|
| |
Total sales |
830.2 |
995.3 |
1,175.2 |
1,320.0 |
4,320.7 |
|
|
| |
% Quarterly changes |
NA |
19.9 |
18.1 |
12.3 |
|
|
|
| |
|
|
| |
This
shows that Group1 will account for 33% of projected sales; that Group2 will
account for |
|
|
| |
a
further 24%; that Group3 will account
for 12%; and that Group4 will account
for 31%. |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Projected inventory levels for the
four quarters are as follows: |
|
|
| |
|
|
| |
|
Opening |
Quarter Ends in Year to Jan 2006 |
|
|
| |
Inventories |
Levels |
1st |
2nd |
3rd |
4th |
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Finished goods |
125.0 |
165.6
|
195.4
|
225.3
|
244.8
|
|
|
| |
Materials/goods |
120.0 |
120.0 |
120.0 |
120.0 |
120.0 |
|
|
| |
Total inventory |
245.0 |
285.6
|
315.4
|
345.3
|
364.8
|
|
|
| |
|
|
| |
The projected average
materials/goods cost percentages for the four quarters are |
|
|
| |
as follows: |
|
|
| |
|
|
| |
|
Quarterly Averages for Year
to Jan 2006 |
Annual |
|
|
| |
Product Groups |
1st |
2nd |
3rd |
4th |
Averages |
|
|
| |
|
% Sales |
% Sales |
% Sales |
% Sales |
% Sales |
|
|
| |
|
|
|
|
|
| |
Group1 |
38.3
|
35.0
|
39.5
|
36.4
|
37.3
|
|
|
| |
Group2 |
46.2
|
40.5
|
39.5
|
38.7
|
40.5
|
|
|
| |
Group3 |
42.5
|
37.3
|
36.4
|
35.6
|
37.3
|
|
|
| |
Group4 |
35.2
|
31.3
|
30.8
|
30.7
|
31.8
|
|
|
| |
Based on Cost of
Materials (Assumption Report No. 2) as % Sales (Report No. 1) |
|
|
| |
|
|
| |
The projected headcounts at quarter
ends are as follows: |
|
|
| |
|
|
| |
|
|
Quarter Ends in Year to Jan 2006 |
|
|
| |
Functions |
|
1st |
2nd |
3rd |
4th |
|
|
| |
|
|
Nos |
Nos |
Nos |
Nos |
|
|
| |
Direct labor: |
|
|
|
|
| |
-
Group1 |
|
12 |
15 |
18 |
21 |
|
|
| |
-
Group2 |
|
11 |
13 |
14 |
16 |
|
|
| |
-
Group3 |
|
5 |
10 |
10 |
10 |
|
|
| |
-
Group4 |
|
10 |
13 |
16 |
19 |
|
|
| |
Total direct labor |
|
38 |
51 |
58 |
66 |
|
|
| |
Indirect labor |
|
10 |
10 |
10 |
10 |
|
|
| |
Supervisory staff |
|
5 |
5 |
5 |
5 |
|
|
| |
Sales |
|
5 |
5 |
5 |
5 |
|
|
| |
Clerical |
|
10 |
10 |
10 |
10 |
|
|
| |
Management |
|
10 |
10 |
10 |
10 |
|
|
| |
Research
& development |
5 |
5 |
5 |
5 |
|
|
| |
Total headcount |
|
83 |
96 |
103 |
111 |
|
|
| |
|
|
| |
Direct costs and overhead expenses
are summarized below. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Cost Analysis |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Materials/packaging/goods |
299.5 |
333.8 |
411.5 |
453.9 |
1,498.6
|
|
| |
Direct labor |
|
108.3 |
140.4 |
170.3 |
202.9 |
621.9
|
|
| |
Other direct |
|
76.2 |
97.7 |
107.8 |
124.4 |
406.1
|
|
| |
Total Cost of sales |
|
484.0
|
571.9
|
689.6
|
781.1
|
2,526.6 |
|
| |
Overhead expenses: |
|
|
|
|
| |
Operational (indirect) |
|
88.5 |
88.5 |
88.5 |
88.5 |
354.0 |
|
| |
Selling & freight |
|
89.3 |
94.1 |
99.8 |
102.3 |
385.3 |
|
| |
Management/admin staff |
150.0 |
150.0 |
150.0 |
150.0 |
600.0 |
|
| |
Research
& development |
63.0 |
63.0 |
63.0 |
63.0 |
252.0 |
|
| |
Administration |
|
27.0 |
27.0 |
27.0 |
27.0 |
108.0 |
|
| |
Occupancy/general |
|
43.5 |
43.5 |
43.5 |
43.5 |
174.0 |
|
| |
Total overhead expenses |
461.3 |
466.1 |
471.8 |
474.3 |
1,873.3
|
|
| |
Total direct costs &
expenses |
945.3
|
1,037.9
|
1,161.3
|
1,255.4
|
4,399.9
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Proposed capital expenditure
(excluding leasing) is summarized in the next table. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Capital Expenditure |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Land,
buildings & improvements |
|
|
150.0 |
|
150.0 |
|
| |
Plant,
equipment & machinery |
|
|
150.0 |
|
150.0 |
|
| |
Automobiles,
vehicles etc. |
|
|
|
50.0 |
50.0 |
|
| |
Total capital
expenditure |
|
|
300.0 |
50.0 |
350.0 |
|
| |
|
|
| |
Changes in longterm debt and leasing
are summarized below. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Debt & Leasing |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Increase in longterm
debt/notes |
50.0 |
|
250.0 |
250.0 |
550.0 |
|
| |
Longterm debt/note
repayments |
25.0 |
25.0 |
25.0 |
25.0 |
100.0 |
|
| |
Net changes in longterm
debt/notes |
25.0 |
(25.0) |
225.0 |
225.0 |
450.0 |
|
| |
|
|
|
|
|
| |
Increases in 'other
loans' |
|
125.0 |
|
|
125.0 |
|
| |
'Other loan' repayments |
|
|
|
|
25.0 |
25.0 |
|
| |
Net changes in 'other
loans' |
|
125.0 |
|
(25.0) |
100.0 |
|
| |
|
|
|
|
|
| |
Increases in leases |
|
|
135.0 |
|
|
135.0 |
|
| |
Lease repayments |
|
30.0 |
40.0 |
40.0 |
10.0 |
120.0 |
|
| |
Net changes in leases |
|
(30.0) |
95.0 |
(40.0) |
(10.0) |
15.0 |
|
| |
|
|
|
|
|
| |
Overall changes in loans
& leases |
(5.0) |
195.0 |
185.0 |
190.0 |
565.0 |
|
| |
|
|
| |
Other significant transactions
during the year include the following: |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Jan 2006 |
Annual |
|
| |
Other Transactions |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Proceeds of share issues |
25.0 |
|
300.0 |
|
325.0 |
|
| |
|
|
|
|
|
| |
Proceeds of fixed asset
sales |
25.0 |
|
|
50.0 |
75.0 |
|
| |
|
|
|
|
|
| |
Dividends declared |
|
|
|
|
|
|
|
| |
|
|
| |
|
|
|
| |
2. FIRST-YEAR FINANCIAL REPORT - ANY CORP INC |
|
|
|
| |
|
|
| |
This
First-Year Financial Report covers the twelve months to end Jan 2006 |
|
|
| |
based on detailed monthly
projections and assumptions. |
|
|
| |
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
|
|
| |
The following table analyses sales
and gross margins by |
|
|
| |
main product group for the full
year: |
|
|
| |
|
|
| |
|
Total |
Gross |
Gross |
|
|
| |
Year
to end Jan 2006 |
Sales |
Margin |
Margin |
|
|
| |
|
$000 |
$000 |
% Sales |
|
|
| |
Product Group: |
|
|
|
|
| |
-
Group1 |
1,435.0 |
593.3
|
41.3 |
|
|
| |
-
Group2 |
1,042.2 |
369.8
|
35.5 |
|
|
| |
-
Group3 |
513.5 |
177.3
|
34.5 |
|
|
| |
-
Group4 |
1,330.0 |
653.7
|
49.2 |
|
|
| |
Total |
4,320.7 |
1,794.1 |
41.5 |
|
|
| |
|
|
| |
This
shows that Group1 will account for 33% of projected sales |
|
|
| |
(33%
of total gross margin); that Group2 will account for a further |
|
|
| |
24%
of sales (21% of total gross margin); that Group3 will account |
|
|
| |
for
12% of sales (10% of total gross margin); that Group4 will account |
|
|
| |
for
the balance of 31% of sales (36% of total gross margin). |
|
|
| |
|
|
| |
The
projected overall gross margin is 42%. |
|
|
| |
|
|
| |
Based
on projected sales of $4321 000, ANY CORP INC |
|
|
| |
expects
to report a LOSS of $272 000 for the year. |
|
|
| |
The following table analyses these
projections: |
|
|
| |
|
|
| |
Year to end Jan 2006 |
|
$000 |
% Sales |
|
|
| |
Sales |
|
4,320.7 |
100 |
|
|
|
|
| |
Cost of sales |
|
2,526.6
|
58 |
|
|
|
|
| |
Gross Margin |
|
1,794.1
|
42 |
|
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
|
|
| |
-Operational
(indirect) |
|
354.0 |
8 |
|
|
|
|
| |
-Selling & freight |
|
385.3
|
9 |
|
|
|
|
| |
-Management/admin staff |
600.0 |
14 |
|
|
|
|
| |
-Research & development |
252.0 |
6 |
|
|
|
|
| |
-Administration |
|
108.0 |
2 |
|
|
|
|
| |
-Occupancy/general |
|
174.0 |
4 |
|
|
|
|
| |
Bad debts |
|
21.6 |
1 |
|
|
|
|
| |
Depreciation |
|
87.6
|
2 |
|
|
|
|
| |
Operating lease payments |
66.0 |
2 |
|
|
|
|
| |
Total operating expenses |
2,048.5
|
47 |
|
|
|
|
| |
Income from operations |
(254.4) |
(6) |
|
|
|
|
| |
Other income/expenses: |
|
|
|
|
|
|
| |
-Profit (loss) disposal of fixed assets |
60.0 |
1 |
|
|
|
|
| |
-Intangible asset amortization |
60.0 |
1 |
|
|
|
|
| |
-Miscellaneous income |
120.0 |
|