... fixed assets are due in February and amount to £260,000 Using the Excel Soft Ware I wrote these formulas: Debtor = £381,000 ÷ 12 = £31,750 Creditors for Material = £55,800 ÷ 12 (months) = £4,650 (through out the year) Wages = £77,040 ÷ 12 (months) = £6,420 ÷ 4 (week) = £1,605 (wages per week) Therefore, in January is going to be one week kept in hand, therefore the wages will be £1,605 x 3 (weeks) = £4,815 But, in February to June is going to £1,605 x 4 (weeks) = £6,420 Administration Cost = £24,600 ÷ 12 (months) = £2,050 Selling Cost = £41,400 ÷ 12 (months) = £3,450 Distribution Cost = £41,640 ÷ 12 (months) = £3,470 Fixed cost = we have been told that the payments for fixed cost assets are due in February and amount to £260,000 Production Over Heads (Less Depreciation) = £68,520 - £12,000 (depreciation including in production overhead is £12,000) = £56,520 ...

See this essay or coursework document in full right now