| Table 1 | Market Statistics | |||
|---|---|---|---|---|
| South | West | North | Export | |
| Managerial/professional households | 1m | 1m | 1m | 10m |
| Supervisory/clerical households | 2m | 1m | 3m | 15m |
| Other households | 4m | 2m | 9m | 55m |
| Total number of households | 7m | 4m | 13m | 80m |
| Retail trade outlets | 3000 | 2000 | 4000 | 20,000 |
| Table 2 | Marketing Costs |
|---|---|
| Salesperson's quarterly expenses | £ 3000 |
| Information on competitors' activities | £ 5000 |
| Information on market shares | £ 5000 |
| Table 3 | Manufacturing Parameters | ||
|---|---|---|---|
| Product 1 | Product 2 | Product 3 | |
| Minimum machining time per unit | 60 min. | 75 min. | 120 min. |
| Minimum assembly time per unit | 100 min. | 150 min. | 300 min. |
| Material content per unit | 1 unit | 2 units | 3 units |
| Table 4 | Maintenance Costs |
|---|---|
| Contracted maintenance per machine | £ 60 per hour |
| Uncontracted breakdown repairs (over contracted hours per machine) | £ 120 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 | Machinists needed for each machine |
| 1. Single | 576 | 4 |
| 2. Double | 1068 | 8 |
| 3. Triple | 1602 | 12 |
| Table 6 | Valuation of Rejected Products | ||
|---|---|---|---|
| Product 1 | Product 2 | Product 3 | |
| Scrap value per product unit | £ 20 | £ 40 | £ 60 |
| Table 7 | Guarantee Servicing Charges | ||
|---|---|---|---|
| Product 1 | Product 2 | Product 3 | |
| Servicing charge per product unit | £ 60 | £ 120 | £ 200 |
| Table 8 | Production Costs |
|---|---|
| Cost of supervision per shift | £ 10,000 |
| Production overheads, per machine | £ 2000 |
| Machine running cost per hour | £ 7 |
| Production planning cost per unit | £ 1 |
| Table 9 | Standard Vehicle Capacity | ||
|---|---|---|---|
| Product 1 | Product 2 | Product 3 | |
| Vehicle capacity in product units (Note: mixed loads may be carried) | 40 | 40 | 20 |
| Table 10 | Return Journey Times to - | |||
|---|---|---|---|---|
| South | West | North | Export | |
| Delivery journey time (in days) | 1 | 2 | 4 | 6 |
| Table 11 | Transport Costs |
|---|---|
| Driver's wages, maintenance, tax etc. | £7000 per vehicle |
| Own vehicle running cost | £ 50 per day |
| All-in hire cost of 1 vehicle | £ 200 per day |
| Table 12 | Warehousing and Purchasing |
|---|---|
| Factory material storage capacity | 2000 units |
| Fixed quarterly cost of factory warehouse | £ 3750 |
| Fixed quarterly administrative cost | £ 3250 |
| Cost per order placed for materials | £ 750 |
| Variable cost of external material storage | £ 1.50 per unit |
| Cost of product storage in market areas | £ 2 per unit |
| Table 13 | Calculation of Average Quarterly Stocks, and Interest |
|---|---|
| Materials | 0.5 x (opening level + closing level + quantity at each delivery) |
| Products | 0.5 x (opening level + closing level) |
| Interest | 0.5 x (opening funds + closing funds) x interest rate |
| Table 14 | Material Suppliers' Terms of Trade | |||
|---|---|---|---|---|
| Supplier | Discount allowed | Delivery charge | Minimum Delivery (units) | Minimum Order quantity (units) |
| 0 | 0% | nil | 1 | 1 |
| 1 | 10% | £ 200 | 1 | 1 |
| 2 | 15% | £ 300 | 1000 | 10,000 |
| 3 | 30% | £ 100 | n/a | 50,000 |
| This supplier makes 12 weekly deliveries - enter '0' on the Decision Form for the number of deliveries |
||||
| Table 15 | Personnel Department Costs | ||
|---|---|---|---|
| Recruitment | Dismissal | Training | |
| Salesperson | £ 1500 | £ 5000 | £ 6000 |
| Assembly worker | £ 1200 | £ 3000 | £ 4500 |
| Machinist | £ 750 | £ 1500 | n/a |
| Table 16 | 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 17 | 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 |
| Assembly worker's minimum hourly wage rate | £ 8.50 |
| Ratio of unskilled : skilled rate of pay | 65% |
| Minimum sales salary per quarter | £ 2000 |
| Minimum management budget per quarter | £ 40,000 |
| Table 18 | per Machine | per Vehicle |
|---|---|---|
| Total cost of fixed asset | £ 200,000 | £ 15,000 |
| Payable at time of order | £ 100,000 | £ 15,000 |
| Payable on installation | £ 100,000 | n/a |
| Rate of depreciation per quarter | 2.50 % | 6.25% |
| Table 19 | Methods of calculating Financial Limits |
|---|---|
| Overdraft Limit | |
| 100% of Cash Invested plus the value of Product Stocks plus 50% of the value of Machines, Vehicles, Material Stocks and Debtors plus 25% of the value of Property less 100% of Tax Due and Creditors | |
| Creditworthiness for buying machines | |
| Overdraft Limit less Bank Overdraft and any Unsecured Loans less £100,000 for each machine ordered last quarter | |
| Note: All of these values are taken from last quarter's Management Report | |
| If any limit calculated above is negative, then the limit is set to 0 | |
| Table 20 | Financial Parameters |
|---|---|
| Tax Rate per annum | 30% |
| Fixed overheads per quarter | £ 10,000 |
| Variable overhead rate per quarter | 0.25% |
| Credit control cost per unit sold | £ 1.50 |
| Interest Rates: (based on the Central Bank Rate announced last quarter) | |
| Investments (bank cash deposits) | bank rate less 2% |
| Authorised overdraft | bank rate plus 4% |
| Unsecured bank loans | bank rate plus 10% |
| Table 21 | Stock Valuations | ||
|---|---|---|---|
| Product 1 | Product 2 | Product 3 | |
| Product stock (per unit) | £ 80 | £ 120 | £ 200 |
| Materials (per unit) | 50% of last quarter's material price | ||
| TABLE 22 | 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 % | |
| Warehousing and Purchasing | 100 % | |
| External stockholding costs | 100 % | |
| Business Intelligence | 100 % | |
| Other Miscellaneous Overheads | 100 % | |
| Materials Purchased | 100 % | |
| Machines Purchased* | 50 % | 50 % |
| Interest (paid and received) | 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. | ||
| Table 23 | Customers' credit discount structure | |||
|---|---|---|---|---|
| Credit period (days) | up to 7 | 8 - 15 | 16 - 29 | 30 or more |
| Discount allowed | 10 % | 7.5 % | 5 % | nil |