| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| |
|
THE TOPAZ MANAGEMENT
SIMULATION REPORT |
|
|
| |
|
|
|
|
| |
History |
|
Group |
1 |
|
Company |
1 |
|
|
This
is the second part |
| |
History |
|
|
|
of the History: GM05 |
|
| |
History |
|
Year |
|
2006 |
|
Quarter |
3 |
|
|
|
|
| |
History |
|
|
| |
History |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
DECISIONS in effect for
2006 Quarter 3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
Product 1 |
Product 2 |
Product 3 |
|
|
| |
Take up Major Product
Improvements |
|
0 |
|
0 |
|
1 |
|
|
|
|
|
| |
Product Prices (£): |
Export Area |
|
170 |
|
290 |
|
580 |
|
|
|
|
|
| |
|
|
Home Areas |
|
150 |
|
270 |
|
550 |
|
|
|
|
|
| |
Advertising Expenditure: |
Trade Press |
|
10 |
|
10 |
|
18 |
|
|
|
|
|
| |
(£'000) |
|
Press & TV |
|
12 |
|
14 |
|
20 |
|
|
|
|
|
| |
|
|
Merchandising |
|
8 |
|
8 |
|
10 |
|
|
|
|
|
| |
Product Assembly Times
(mins) |
|
118 |
|
165 |
|
330 |
|
|
|
|
|
| |
|
|
|
| |
Salespeople allocated to: |
|
|
Export |
|
South |
|
West |
|
North |
|
|
|
|
|
|
| |
|
|
|
13 |
|
1 |
|
1 |
|
3 |
|
|
|
|
|
|
| |
Salespeople Quarterly
Salary (£'00) |
|
50 |
|
Sales Commission % |
2 |
|
|
| |
Assembly Wages / hour
(£.p) |
|
6.95 |
|
|
| |
Maintenance Hours per
Machine |
|
50 |
|
Shift Level |
|
2 |
|
|
| |
New Machines to Order |
|
1 |
|
Machines to Sell |
|
0 |
|
|
| |
Management Budget (£'000) |
|
120 |
|
|
|
|
|
|
| |
Dividend % per £1 Share |
|
4 |
|
Credit Days Allowed |
30 |
|
|
| |
Vehicles to Buy |
|
0 |
|
Vehicles to Sell |
|
0 |
|
|
| |
Information: on company
activities |
|
1 |
|
-
on Market Shares |
0 |
|
|
| |
|
|
|
|
|
|
|
|
| |
Quantities of Product |
|
Product 1 |
Product 2 |
Product 3 |
|
|
| |
to make and deliver to: |
|
Export |
|
2800 |
|
1400 |
|
600 |
|
|
|
(Note: not delivered |
|
| |
|
South |
|
200 |
|
200 |
|
100 |
|
|
|
in full, if starred) |
|
| |
|
West |
|
100 |
|
75 |
|
75 |
|
|
|
|
|
| |
|
|
North |
|
600 |
|
350 |
|
125 |
|
|
|
|
|
| |
Product Development
(£'000) |
|
|
15 |
|
15 |
|
15 |
|
|
|
|
|
| |
|
|
|
| |
Personnel: |
|
|
Recruit |
|
Dismiss |
|
Train |
|
|
|
| |
|
Salespeople |
|
|
0 |
|
0 |
|
1 |
|
|
|
| |
|
Assembly Workers |
|
|
0 |
|
0 |
|
1 |
|
|
|
|
|
| |
|
|
|
| |
Materials to Order: |
|
|
Units |
|
Supplier |
|
Deliveries |
|
|
|
| |
|
|
|
12000 |
|
2 |
|
6 |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
AVAILABILITY and USE OF
RESOURCES |
|
|
|
PRODUCT MOVEMENTS and AVAILABILITY |
|
|
|
| |
Machines Available Last Quarter |
|
10 |
|
Quantities |
|
Product 1 |
Product 2 |
Product 3 |
| |
Machines Available for
Next Quarter |
|
10 |
|
Scheduled |
|
3700 |
|
2025 |
|
900 |
|
| |
Vehicles Available Last
Quarter |
|
17 |
|
Produced |
|
3809 |
|
2089 |
|
928 |
|
| |
|
|
|
|
|
|
Rejected |
|
109 |
|
64 |
|
28 |
|
| |
Assembly Workers Hours: |
|
|
|
|
|
Serviced |
|
|
62 |
|
38 |
|
14 |
|
| |
Total Hours Available
Last Quarter |
|
21168 |
|
Delivered to: |
|
|
|
|
|
|
|
| |
Hours of
Absenteeism/Sickness |
|
54 |
|
Export |
|
2800 |
|
1400 |
|
600 |
|
| |
Total Hours Worked Last Quarter |
|
18340 |
|
South |
|
200 |
|
200 |
|
100 |
|
| |
Notice of Strike Weeks
Next Quarter |
|
0 |
|
West |
|
100 |
|
75 |
|
75 |
|
| |
|
|
|
|
|
North |
|
|
|
600 |
|
350 |
|
125 |
|
| |
Machine Hours |
|
|
|
|
|
|
Orders from: |
|
|
|
|
|
|
|
| |
Total Hours Available
Last Quarter |
|
10920 |
|
Export |
|
2827 |
|
1482 |
|
589 |
|
| |
Hours Breakdown |
|
37 |
|
South |
|
244 |
|
179 |
|
96 |
|
| |
Hours of Planned
Maintenance |
|
463 |
|
West |
|
102 |
|
88 |
|
62 |
|
| |
Total Hours Worked Last
Quarter |
|
8671 |
|
North |
|
574 |
|
328 |
|
134 |
|
| |
Average Machine
Efficiency % |
|
95.4 |
|
Sales to: |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
Export |
|
2800 |
|
1482 |
|
589 |
|
| |
Material Units Used and
Available |
|
|
|
|
|
South |
|
244 |
|
179 |
|
96 |
|
| |
Opening Stock Available (units) |
|
3051 |
|
West |
|
102 |
|
88 |
|
68 |
|
| |
Delivered Last Quarter |
|
10000 |
|
North |
|
|
|
574 |
|
328 |
|
125 |
|
| |
Used Last Quarter |
|
10771 |
|
Order Backlog |
|
|
|
|
|
|
|
| |
Closing Stock at End of Quarter |
|
2280 |
|
Export |
|
34 |
|
0 |
|
0 |
|
| |
On Order for Next Quarter |
|
12000 |
|
South |
|
0 |
|
0 |
|
0 |
|
| |
Total Available for Next
Quarter |
|
14280 |
|
West |
|
0 |
|
0 |
|
0 |
|
| |
|
|
|
|
|
|
|
|
North |
|
|
|
0 |
|
0 |
|
4 |
|
| |
Personnel: |
Sales |
|
Assembly |
Machinists |
Warehouse Stock |
|
|
|
|
|
|
|
| |
At Start of Last Quarter |
18 |
|
36 |
|
76 |
|
Export |
|
0 |
|
13 |
|
11 |
|
| |
Recruits |
|
0 |
|
0 |
|
4 |
|
South |
|
56 |
|
36 |
|
4 |
|
| |
Trainees |
|
1 |
|
1 |
|
|
|
West |
|
75 |
|
16 |
|
7 |
|
| |
Dismissals |
0 |
|
0 |
|
0 |
|
North |
|
82 |
|
35 |
|
0 |
|
| |
Leavers |
|
1 |
|
1 |
|
3 |
|
Product |
|
|
|
|
|
|
|
|
|
| |
Available for Next Quarter |
18 |
|
36 |
|
77 |
|
Improvements |
|
NONE |
|
MAJOR |
|
NONE |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
ACCOUNTS |
|
|
|
|
|
| |
Overhead Cost Analysis |
|
£ |
|
Profit and Loss Account |
|
£ |
|
| |
Advertising |
|
110000 |
|
Sales Revenue |
|
1728020 |
|
| |
Salespeoples Salary, etc. |
|
178224 |
|
|
|
|
|
| |
Sales Office |
|
17112 |
|
Opening Stock Value |
|
126459 |
|
| |
Guarantee Servicing |
|
11080 |
|
Materials Purchased |
|
401677 |
|
| |
Transport Fleet |
|
167386 |
|
Assembly Wages |
|
139333 |
|
| |
Hired Transport |
|
0 |
|
Machinists Wages |
|
213535 |
|
| |
Product Research |
|
45000 |
|
Machine Running Costs |
|
107322 |
|
| |
Personnel Department |
|
13500 |
|
Less Closing Stock Value |
|
87151 |
|
| |
Maintenance |
|
30000 |
|
Cost of Sales |
|
901175 |
|
| |
Warehousing & Purchasing |
|
11425 |
|
|
|
|
|
| |
Business Intelligence |
|
5000 |
|
Gross Profit |
|
826845 |
|
| |
Management Budget |
|
120000 |
|
|
|
|
|
| |
Credit Control |
|
10012 |
|
Interest received |
|
0 |
|
| |
Other Miscellaneous Costs |
|
11821 |
|
Interest Paid |
|
1615 |
|
| |
Total Overheads |
|
730560 |
|
Overheads |
|
730560 |
|
| |
|
|
|
|
Depreciation |
|
50044 |
|
| |
|
|
|
|
Tax Assessed |
|
0 |
|
| |
Taxable Profit/Loss
Accumulated |
|
-5914 |
|
|
|
|
|
| |
|
|
|
Net Profit/Loss |
|
44626 |
|
| |
|
|
|
|
|
|
|
| |
|
|
|
Dividend Paid |
|
80000 |
|
| |
|
|
|
Transferred to Reserves |
|
-35374 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
| |
Balance Sheet |
|
£ |
|
Cash Flow Statement |
|
£ |
|
| |
Assets |
|
|
|
|
|
|
|
|
| |
Value of Property |
|
300000 |
|
Operating Activities: |
|
|
|
| |
Value of Machines |
|
1594818 |
|
Trading Receipts |
|
|
1713264 |
|
| |
Value of Vehicles |
|
175758 |
|
Trading Payments |
|
|
Investments Sold |
1657686 |
|
| |
Value of Product Stocks |
|
33440 |
|
Tax Paid |
|
|
|
0 |
|
| |
Value of Material Stock |
|
53711 |
|
Cash flow from operating activities |
|
55578 |
|
| |
Debtors |
|
|
604478 |
|
Investing Activities: |
|
|
|
| |
Cash Invested |
|
0 |
|
Interest Received |
|
0 |
|
| |
|
|
|
|
Capital Receipts |
|
0 |
|
| |
Liabilities |
|
|
|
Capital Payments |
|
100000 |
|
| |
Tax Assessed and Due |
|
0 |
|
Cash flow from investing activities |
|
-100000 |
|
| |
Creditors |
|
561432 |
|
Financing Activities: |
|
|
|
| |
Overdraft |
|
|
135657 |
|
Interest Paid |
|
1615 |
|
| |
Unsecured Loans |
|
0 |
|
Dividend Paid |
|
80000 |
|
| |
|
|
|
|
Cash flow from financing activities |
|
-81615 |
|
| |
Net Assets |
|
2065116 |
|
|
|
|
|
| |
|
|
|
|
Net Cash Flow |
|
-126037 |
|
| |
Ordinary Capital |
|
2000000 |
|
|
|
|
|
|
|
|
|
|
|
| |
Reserves |
|
65116 |
|
|
|
|
|
| |
Total Funding |
|
2065116 |
|
Overdraft Limit for Next Quarter |
|
761000 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
BUSINESS INTELLIGENCE |
|
|
| |
Company Number |
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
| |
Share Price (pence/share) |
116.0 |
|
116.0 |
|
116.0 |
|
116.0 |
|
116.0 |
|
116.0 |
|
116.0 |
|
116.0 |
|
| |
Dividend Paid (%) |
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
4 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
| |
All Company Balance
Sheets (£) |
|
|
| |
Assets |
|
|
NOT AVAILABLE THIS
QUARTER |
|
|
| |
Value of Property |
|
|
|
|
| |
Value of Machines |
|
|
|
|
| |
Value of Vehicles |
|
|
|
|
| |
Value of Product Stocks |
|
|
|
|
| |
Value of Material Stock |
|
|
|
|
| |
Debtors |
|
|
|
|
| |
Cash Invested |
|
|
|
|
| |
Liabilities |
|
|
|
| |
Tax Assessed and Due |
|
|
|
|
| |
Creditors |
|
|
|
|
| |
Overdraft |
|
|
|
|
| |
Unsecured Loans |
|
|
|
|
| |
Net Assets |
|
|
|
|
| |
|
|
|
| |
Ordinary Capital |
|
|
|
|
| |
Reserves |
|
|
|
|
| |
Total Funding |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| |
Business Activity - Free
Information |
|
|
| |
Company Number |
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
| |
Product 1: |
Export Price (£) |
170 |
|
170 |
|
170 |
|
170 |
|
170 |
|
170 |
|
170 |
|
170 |
|
| |
|
Home Price (£) |
150 |
|
150 |
|
150 |
|
150 |
|
150 |
|
150 |
|
150 |
|
150 |
|
| |
Product 2: |
Export Price (£) |
290 |
|
290 |
|
290 |
|
290 |
|
290 |
|
290 |
|
290 |
|
290 |
|
| |
|
Home Price (£) |
270 |
|
270 |
|
270 |
|
270 |
|
270 |
|
270 |
|
270 |
|
270 |
|
| |
Product 3: |
Export Price (£) |
580 |
|
580 |
|
580 |
|
580 |
|
580 |
|
580 |
|
580 |
|
580 |
|
| |
|
Home Price (£) |
550 |
|
550 |
|
550 |
|
550 |
|
550 |
|
550 |
|
550 |
|
550 |
|
| |
Total Number Employed |
131 |
|
131 |
|
131 |
|
131 |
|
131 |
|
131 |
|
131 |
|
131 |
|
| |
Assembly Wage Rate |
6.95 |
|
6.95 |
|
6.95 |
|
6.95 |
|
6.95 |
|
6.95 |
|
6.95 |
|
6.95 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| |
Business Activity -
Purchased Information |
|
|
| |
Company Number |
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
| |
Total Advertising (£) |
110000 |
|
110000 |
|
110000 |
|
110000 |
|
110000 |
|
110000 |
|
110000 |
|
110000 |
|
| |
Product Development (£) |
45000 |
|
45000 |
|
45000 |
|
45000 |
|
45000 |
|
45000 |
|
45000 |
|
45000 |
|
| |
Consumer Star Ratings: |
|
|
| |
|
Product 1 |
*** |
|
*** |
|
*** |
|
*** |
|
*** |
|
*** |
|
*** |
|
*** |
|
| |
|
Product 2 |
**** |
|
**** |
|
**** |
|
**** |
|
**** |
|
**** |
|
**** |
|
**** |
|
| |
|
Product 3 |
***** |
|
***** |
|
***** |
|
***** |
|
***** |
|
***** |
|
***** |
|
***** |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| |
% Share of Markets by
Products Sold |
|
NOT REQUESTED |
|
|
| |
Company
Number |
|
|
|
| |
Product 1 |
Export Area |
|
|
|
| |
|
South Area |
|
|
|
| |
|
West Area |
|
|
|
| |
|
North Area |
|
|
|
| |
Product 2 |
Export Area |
|
|
|
| |
|
South Area |
|
|
|
| |
|
West Area |
|
|
| |
|
North Area |
|
|
| |
Product 3 |
Export Area |
|
|
| |
|
South Area |
|
|
| |
|
West Area |
|
|
| |
|
North Area |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
| |
ECONOMIC INFORMATION |
|
|
| |
|
|
|
| |
|
Gross Domestic Product
Last Quarter (deseasonalised) |
|
734 |
|
|
| |
|
% Unemployed Rate Last
Quarter (deseasonalised) |
|
5 |
|
|
| |
|
% Annual Central Bank
Rate from Next Quarter |
|
5 |
|
|
| |
|
|
|
|
|
| |
|
Price of Material ordered
for Next Quarter (£ per '000) |
|
50231 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOPAZ-Vbe is an interactive Business
Simulation developed by Edit Systems Ltd. ©
2007; and distributed by Edit 515 Ltd. |
|
|
Phone: +44 (0)141 563 6906; E-mail:
dan.davidson@edit515.co.uk |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GM05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|