| |
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 |
30.0 |
30.0 |
30.0 |
30.0 |
120.0 |
|
|
| |
-
Group5 |
60.0 |
60.0 |
60.0 |
60.0 |
240.0 |
|
|
| |
-
Group6 |
285.0 |
320.0 |
345.0 |
380.0 |
1,330.0 |
|
|
| |
Total sales |
920.2 |
1,085.3 |
1,265.2 |
1,410.0 |
4,680.7 |
|
|
| |
% Quarterly changes |
NA |
17.9 |
16.6 |
11.4 |
|
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
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 |
150.0 |
176.6
|
206.4
|
236.4
|
255.9
|
|
|
| |
Materials/goods |
140.0 |
140.0 |
140.0 |
140.0 |
140.0 |
|
|
| |
Total inventory |
290.0 |
316.6
|
346.4
|
376.4
|
395.9
|
|
|
| |
|
|
| |
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 |
27.1
|
28.0
|
28.0
|
28.0
|
27.8
|
|
|
| |
Group5 |
25.3
|
25.0
|
25.0
|
25.0
|
25.1
|
|
|
| |
Group6 |
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 |
|
2 |
2 |
2 |
2 |
|
|
| |
-
Group5 |
|
2 |
2 |
2 |
2 |
|
|
| |
-
Group6 |
|
10 |
13 |
16 |
19 |
|
|
| |
Total direct labor |
|
42 |
55
|
62
|
70
|
|
|
| |
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 |
|
87 |
100
|
107
|
115
|
|
|
| |
|
|
| |
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 |
331.7 |
357.1 |
434.8 |
477.2 |
1,600.8 |
|
| |
Direct labor |
|
124.3 |
153.5 |
183.7 |
216.5 |
677.9 |
|
| |
Other direct |
|
78.7 |
98.0 |
108.0 |
124.5 |
409.2 |
|
| |
Total Cost of sales |
|
534.6 |
608.6 |
726.5 |
818.2 |
2,687.9 |
|
| |
Overhead expenses: |
|
|
|
|
| |
Operational (indirect) |
|
96.0 |
96.0 |
96.0 |
96.0 |
384.0 |
|
| |
Selling & freight |
|
140.0
|
144.8
|
150.5 |
153.0 |
588.1 |
|
| |
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 |
519.5 |
524.3 |
530.0 |
532.5 |
2,106.1 |
|
| |
Total direct costs &
expenses |
1,054.1
|
1,132.8
|
1,256.4
|
1,350.6
|
4,794.0
|
|
| |
|
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
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 & machinery |
|
|
|
150.0 |
|
150.0 |
|
| |
Computers
& equipment |
|
|
|
50.0 |
50.0 |
|
| |
Automobiles,
vehicles etc. |
|
|
|
50.0 |
50.0 |
|
| |
Total capital
expenditure |
|
|
300.0 |
100.0 |
400.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 |
|
|
195.0 |
|
|
195.0 |
|
| |
Lease repayments |
|
30.0 |
42.0 |
42.0 |
12.0 |
126.0 |
|
| |
Net changes in leases |
|
(30.0) |
153.0 |
(42.0) |
(12.0) |
69.0 |
|
| |
|
|
|
|
|
| |
Overall changes in loans
& leases |
(5.0) |
253.0 |
183.0 |
188.0 |
619.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 |
50.0 |
|
|
50.0 |
100.0 |
|
| |
|
|
|
|
|
| |
Purchases of intangible
assets |
|
|
|
|
|
|
| |
|
|
|
|
|
| |
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 |
602.9
|
42.0 |
|
|
| |
-
Group2 |
1,042.2 |
378.0
|
36.3 |
|
|
| |
-
Group3 |
513.5 |
181.8
|
35.4 |
|
|
| |
-
Group4 |
120.0 |
38.8
|
32.3 |
|
|
| |
-
Group5 |
240.0 |
129.4
|
53.9 |
|
|
| |
-
Group6 |
1,330.0 |
662.0
|
49.8 |
|
|
| |
Total |
4,680.7 |
1,992.8 |
42.6 |
|
|
| |
|
|
| |
The
projected overall gross margin is 43%. |
|
|
| |
|
|
| |
Based
on projected sales of $4681 000, ANY CORP INC |
|
|
| |
expects
to report a LOSS of $317 000 for the year. |
|
|
| |
The following table analyses these
projections: |
|
|
| |
|
|
| |
Year to end Jan 2006 |
|
$000 |
% Sales |
|
|
| |
Sales |
|
4,680.7 |
100 |
|
|
|
|
| |
Cost of sales |
|
2,687.9
|
57 |
|
|
|
|
| |
Gross Margin |
|
1,992.8
|
43 |
|
|
|
|
| |
Overhead expenses: |
|
|
|
|
|
|
|
| |
-Operational
(indirect) |
|
384.0 |
8 |
|
|
|
|
| |
-Selling & freight |
|
588.1
|
13 |
|
|
|
|
| |
-Management/admin staff |
600.0 |
13 |
|
|
|
|
| |
-Research & development |
252.0 |
5 |
|
|
|
|
| |
-Administration |
|
108.0 |
2 |
|
|
|
|
| |
-Occupancy/general |
|
174.0 |
4 |
|
|
|
|
| |
Bad debts |
|
23.4
|
1 |
|
|