INFORMATION SYSTEMS ON ACCOUNTANTS

information systems on accountants



information systems on accountants

Introduction

Conclusion

INPUT PAGE

Enter data in the green cells only: DO NOT CHANGE ANY OTHER CELLS!

Sales ForecastMonth

September

November

December

February

Forecasted Percentage

Forecasted Units

Recievables

In the month of sale

Following month of sale

Second month following the month of sale

Third month following the month of the sale

Bad debts

Selling price £ 97.00

per unit

Cost of Goods sold

Unit reuired

Direct materials

£ 24.78 £ 24.78

per unit

Direct labour required £ 9.50 £ 28.50

per unit

Manufacturing overhead

£ 0.30 £ 0.90

per unit

Distribution Cost

£ 4.10 £ 4.10

per unit

Sales commision

£ 97.00 £ 2.91

per unit

Total cost of goods sold

£ 61.19

per ...