Table 1 | Market Statistics | ||
---|---|---|---|
South | West | North | |
Managerial/professional households | 1m | 1m | 1m |
Supervisory/clerical households | 2m | 1m | 3m |
Other households | 4m | 2m | 9m |
Total number of households | 7m | 4m | 13m |
Retail trade outlets | 3000 | 2000 | 4000 |
Table 2 | Marketing Costs |
---|---|
Information on competitors' activities | £ 4500 |
Salesperson's quarterly expenses | £ 2000 |
Table 3 | Manufacturing Parameters | |
---|---|---|
Product 1 | Product 2 | |
Minimum machining time per unit | 60 min. | 120 min. |
Assembly time per unit | 100 min. | 300 min. |
Material content per unit | 1 unit | 3 units |
Table 4 | Maintenance Costs |
---|---|
Contracted maintenance (12 hours per machine, per quarter) |
£ 40 per hour |
Uncontracted breakdown repairs (over 12 hours per machine) |
£ 75 per hour |
Table 5 | Maximum Hours Available per Machine per Quarter, relative to Shift Level worked |
|
---|---|---|
Shift Level | Maximum hours per quarter that each machine can work, accumulating hours to each successive level of shift | Unskilled workers needed for each machine |
1. Single | 576 | 4 |
2. Double | 1068 | 8 |
3. Treble | 1602 | 12 |
Table 6 | Valuation of Rejected Products | ||
---|---|---|---|
Product 1 | Product 2 | ||
Scrap value per product unit | £15 | £45 |
Table 7 | Guarantee Servicing Charges | |
---|---|---|
Product 1 | Product 2 | |
Servicing charge per product unit | £35 | £140 |
Table 8 | Production Costs |
---|---|
Cost of supervision per shift | £ 5000 |
Production overheads, per machine | £ 1000 |
Running cost per machine hour used | £ 4 |
Production planning cost per unit | £ 0.50 |
Table 9 | Standard Vehicle Capacity | |
---|---|---|
Product 1 | Product 2 | |
Vehicle capacity (product units) | 40 | 20 |
Table 10 | Return Journey Times to | ||
---|---|---|---|
South | West | North | |
Delivery journey time (in days) | 1 | 2 | 4 |
Table 11 | Transport Costs |
---|---|
All-in cost of 1 vehicle per day | £ 130 |
Table 12 | Warehousing |
---|---|
Fixed quarterly cost of factory warehouse | £ 2500 |
Fixed quarterly administrative cost | £ 2000 |
Variable storage cost in market areas (per product unit) | £ 1 |
Table 13 | Calculation of Average Quarterly Stock, and Interest |
---|---|
0.5 x (opening value + closing value) |
Table 14 | Personnel Department Costs | |
---|---|---|
Recruitment | Dismissal | |
Salesperson | £ 1000 | £ 3000 |
Skilled assembly worker | £ 750 | £ 2000 |
Unskilled machinist | £ 500 | £ 1000 |
Table 15 | Maximum Hours per Quarter for each Production Worker plus Shift Pay Premiums |
|||
---|---|---|---|---|
Shift Level | Hours per worker at basic rate |
Hours per worker at Saturday rate (Basic + 50%) |
Hours per Worker at Sunday rate (Basic + 100%) |
Machinists Shift Premium |
1. Single | 420 | + 84 | + 72 | 0 |
2. Double | 420 | + 42 | + 72 | 1/3 |
3. Treble | 420 | + 42 | + 72 | 2/3 |
Table 16 | Minimum Hours and Pay |
---|---|
Machinist's minimum paid hours per quarter | 400 |
Assembly worker's strike hours per week | 48 |
Assembly worker's minimum hours/quarter | nil |
Ratio of unskilled : skilled rate of pay | 65% |
Minimum sales salary per quarter | £ 1500 |
Maximum sales commission rate | 9% |
Management Budget per quarter | see Mgt. Report |
Table 17 | Cost of Machines |
---|---|
Total cost of a machine | £ 120,000 |
Payable at time of order | £ 60,000 |
Payable on installation | £ 60,000 |
Machine rate of depreciation per quarter | 2.50 % |
Table 18 | Method of calculating Overdraft Limit |
---|---|
100% of Cash Invested and the value of Product Stocks | |
PLUS 50% of the value of Machines and Debtors | |
PLUS 25% of the value of Property | |
LESS 100% of Tax Due and Creditors | |
Note: All of these values are taken from last quarter's Balance Sheet | |
If the limit calculated above is negative, then the limit is set to 0 |
Table 19 | Financial Parameters |
---|---|
Tax Rate per annum | 30% |
Fixed overheads per quarter | £ 6000 |
Variable overhead rate per quarter | 0.25% |
Credit control cost per unit sold | £ 0.75 |
Interest Rates: (based on Central Bank Rate announced last quarter) | |
Bank cash deposits | bank rate less 2% |
Authorised overdraft | bank rate plus 4% |
Unsecured bank loans | bank rate plus 10% |
Table 20 | Product Valuations | |
---|---|---|
Product 1 | Product 2 | |
Stock valuation per product unit | £45 | £130 |
TABLE 21 | Timing of Payments to Creditors | |
---|---|---|
EXTERNAL COST ITEMS ONLY (internal costs and pay omitted) |
For goods delivered, or services provided next quarter the charged amount will be paid as follows - | |
Next Quarter | Quarter after Next | |
Advertising | 100 % | |
Guarantee Servicing | 100 % | |
Hired Transport | 100 % | |
Product Development | 100 % | |
Personnel Department | 100 % | |
Maintenance | 100 % | |
Fixed warehousing costs | 100% | |
Variable stockholding costs | 100 % | |
Business Intelligence | 100 % | |
Other Miscellaneous Overheads | 100 % | |
Raw Materials | 100 % | |
Machines* | 50 % | 50 % |
Interest | 100 % | |
Note:
A 50% deposit is paid next quarter when machines are ordered. The balance is due when machines are installed in the quarter after next. |