| |
TEXTUAL SUMMARY REPORT |
|
|
|
|
| |
|
|
| |
Date prepared: |
31-Dec-03 |
|
|
| |
|
|
|
|
| |
The
following three operational & financial reports for ANY INC cover |
|
|
| |
the
months and years commencing in Jan 2005. They have been derived |
|
|
| |
from the detailed assumptions in
Exl-Plan's Monthly and Quarterly Reports. |
|
|
| |
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
| |
1. FIRST-YEAR OPERATIONAL REPORT - ANY INC |
|
|
| |
|
|
| |
This
First-Year Operational Report covers the initial twelve months to end Dec
2005 |
|
|
| |
based on detailed monthly
projections and assumptions. |
|
|
| |
|
|
| |
The following table summarizes
quarterly sales projections for the year: |
|
|
| |
|
|
| |
|
Quarters in
Year to Dec 2005 |
|
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 |
342.8 |
1,043.3 |
|
|
| |
-
Group3 |
79.3 |
114.0 |
151.9 |
177.2 |
522.4 |
|
|
| |
-
Group4 |
30.0 |
30.0 |
30.0 |
30.0 |
120.0 |
|
|
| |
-
Group5 |
60.0 |
60.0 |
60.0 |
60.0 |
240.0 |
|
|
| |
-
Group6 |
164.4 |
166.2 |
168.0 |
168.0 |
666.7
|
|
|
| |
Total sales |
799.6
|
931.5
|
1,088.2
|
1,208.0
|
4,027.4
|
|
|
| |
% Quarterly changes |
NA |
16.5 |
16.8 |
11.0 |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Projected inventory levels for the
four quarters are as follows: |
|
|
| |
|
|
| |
|
Opening |
Quarters in Year to Dec 2005 |
|
|
| |
Inventories |
Levels |
1st |
2nd |
3rd |
4th |
|
|
| |
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
|
| |
|
|
|
|
|
| |
Finished goods |
401.3 |
158.2
|
185.8
|
214.2
|
233.8
|
|
|
| |
Materials/goods |
202.0 |
204.5
|
204.5
|
204.5
|
204.5
|
|
|
| |
Total inventory |
603.3 |
362.7
|
390.3
|
418.7
|
438.3
|
|
|
| |
|
|
| |
The projected average
materials/goods cost percentages for the four quarters are |
|
|
| |
as follows: |
|
|
| |
|
|
| |
|
Quarterly Averages for Year
to Dec 2005 |
Annual |
|
|
| |
Product Groups |
1st |
2nd |
3rd |
4th |
Averages |
|
|
| |
|
% Sales |
% Sales |
% Sales |
% Sales |
% Sales |
|
|
| |
|
|
|
|
|
| |
Group1 |
30.2
|
39.4
|
36.9
|
36.8
|
36.0
|
|
|
| |
Group2 |
39.4
|
40.0
|
41.0
|
38.4
|
39.7
|
|
|
| |
Group3 |
41.6
|
42.1
|
43.1
|
42.1
|
42.3
|
|
|
| |
Group4 |
40.0
|
40.0
|
40.0
|
40.0
|
40.0
|
|
|
| |
Group5 |
40.0
|
40.0
|
40.0
|
40.0
|
40.0
|
|
|
| |
Group6 |
37.3
|
34.7
|
35.0
|
35.3
|
35.6
|
|
|
| |
Based on Cost of
Materials (Assumption Report No. 2) as % Sales (Report No. 1) |
|
|
| |
|
|
| |
The projected headcounts at quarter
ends are as follows: |
|
|
| |
|
|
| |
|
|
Quarters in Year to Dec 2005 |
|
|
| |
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 |
|
1 |
1 |
1 |
1 |
|
|
| |
-
Group5 |
|
2 |
3 |
4 |
4 |
|
|
| |
-
Group6 |
|
8 |
8 |
8 |
8 |
|
|
| |
Total direct labor |
|
39
|
49
|
54
|
59
|
|
|
| |
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 |
|
84
|
94
|
99
|
104
|
|
|
| |
|
|
| |
Direct costs and overhead expenses
are summarized below. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Dec 2005 |
Annual |
|
| |
Cost Analysis |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Materials/packaging/goods |
416.3 |
347.7 |
406.1 |
448.3 |
1,618.4 |
|
| |
Direct labor |
|
189.3 |
139.6 |
161.6 |
186.3 |
676.8 |
|
| |
Other direct |
|
128.7 |
97.9 |
108.0 |
124.2 |
458.8 |
|
| |
Total Cost of sales |
|
734.3 |
585.1 |
675.7 |
758.9
|
2,754.0 |
|
| |
Operational (indirect) |
|
96.0 |
96.0 |
96.0 |
96.0 |
384.0 |
|
| |
Selling & freight |
|
133.5 |
137.4 |
142.1 |
145.7 |
558.8 |
|
| |
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 |
513.0 |
516.9 |
521.6 |
525.2 |
2,076.8 |
|
| |
Total direct costs &
expenses |
1,247.3
|
1,102.1
|
1,197.3
|
1,284.2
|
4,830.9
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
Proposed capital expenditure
(excluding leasing) is summarized in the next table. |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Dec 2005 |
Annual |
|
| |
Capital Expenditure |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Land,
buildings & improvements |
|
|
150.0 |
|
150.0 |
|
| |
Plant & machinery |
|
|
|
150.0 |
|
150.0 |
|
| |
Computers
& equipment |
|
|
100.0 |
|
100.0 |
|
| |
Automobiles,
vehicles etc. |
|
|
|
50.0 |
50.0 |
|
| |
Total capital
expenditure |
|
|
400.0 |
50.0 |
450.0 |
|
| |
|
|
| |
Changes in longterm debt and leasing
are summarized below |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Dec 2005 |
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 |
|
|
210.0 |
|
|
210.0 |
|
| |
Lease repayments |
|
38.0 |
48.0 |
48.0 |
48.0 |
182.0 |
|
| |
Net changes in leases |
(38.0) |
162.0 |
(48.0) |
(48.0) |
28.0 |
|
| |
|
|
|
|
|
| |
Overall changes in loans
& leases |
(13.0) |
262.0 |
177.0 |
152.0 |
578.0 |
|
| |
|
|
| |
Other significant transactions
during the year include the following: |
|
|
| |
|
|
| |
|
|
|
Quarters
in Year to Dec 2005 |
Annual |
|
| |
Other Transactions |
|
1st |
2nd |
3rd |
4th |
Total |
|
| |
|
|
$000 |
$000 |
$000 |
$000 |
$000 |
|
| |
|
|
|
|
| |
Proceeds of share issues |
1,000.0 |
|
|
|
1,000.0 |
|
| |
|
|
|
|
|
| |
Proceeds of fixed asset
sales |
25.0 |
|
|
100.0 |
125.0 |
|
| |
|
|
|
|
|
| |
Purchases of intangible
assets |
|
|
|
|
|
|
| |
|
|
|
|
|
| |
Dividends declared |
|
|
|
|
|
|
|
| |
|
|
| |
|
|
|
| |
2. FIRST-YEAR FINANCIAL REPORT - ANY INC |
|
|
|
| |
|
|
| |
This
First-Year Financial Report covers the twelve months to end Dec 2005 |
|
|
| |
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 Dec 2005 |
Sales |
Margin |
Margin |
|
|
| |
|
$000 |
$000 |
% Sales |
|
|
| |
Product Group: |
|
|
|
|
| |
-
Group1 |
1,435.0 |
577.5
|
40.2 |
|
|
| |
-
Group2 |
1,043.3 |
273.3
|
26.2 |
|
|
| |
-
Group3 |
522.4 |
78.4
|
15.0 |
|
|
| |
-
Group4 |
120.0 |
50.0
|
41.7 |
|
|
| |
-
Group5 |
240.0 |
75.9
|
31.6 |
|
|
| |
-
Group6 |
666.7
|
218.2
|
32.7 |
|
|
| |
Total |
4,027.4 |
1,273.3 |
31.6 |
|
|
| |
|
|
| |
|
|
| |
The
projected overall gross margin is 32%. |
|
|
| |
|
|
| |
Based
on projected sales of $4027 000, ANY INC |
|
|
| |
expects
to report a LOSS of $1040 000 for the year. |
|
|
| |
The following table analyses these
projections: |
|
|
| |
|
|
| |
Year to end Dec 2005 |
|
$000 |
% Sales |
|
|
| |
Sales |
|
4,027.4
|
100 |
|
|
|
|
| |
Cost of sales |
|
2,754.0
|
68 |
|
|
|
|
| |
Gross Margin |
|
1,273.3
|
32 |
|
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
|
|
| |
-Operational
(indirect) |
|
384.0 |
10 |
|
|
|
|
| |
-Selling & freight |
|
558.8
|
14 |
|
|
|
|
| |
-Management/admin staff |
600.0 |
15 |
|
|
|
|
| |
-Research & development |
252.0 |
6 |
|
|
|
|
| |
-Administration |
|
108.0 |
3 |
|
|
|
|
| |
-Occupany/general |
|
|