In: Accounting
Q3)
1] | Estimated current assets: | ||
Receivables = 1040000*20*8/52 = | $ 32,00,000 | ||
Raw materials = 1040000*8*4/52 = | $ 6,40,000 | ||
WIP = 1040000*(8+3+6*50%)*2/52 = | $ 5,60,000 | ||
[Assumed that OH is incurred uniformly over | |||
the processing period; hence taken at 50%] | |||
Finished goods = 1040000*(8+3+6)*3/52 = | $ 10,20,000 | ||
Prepaid expenses | $ 20,000 | ||
Total current assets | $ 54,40,000 | ||
Contingency 5% | $ 2,72,000 | ||
Gross working capital | $ 57,12,000 | ||
Current liabilities: | |||
Accounts payable = 1040000*8*6/52 = | $ 9,60,000 | ||
Wages payable = 1040000*3*4/52 = | $ 2,40,000 | ||
Overheads payable = 1040000*6*5/52 = | $ 6,00,000 | ||
Outstanding expenses | $ 50,000 | ||
Total current liabilities | $ 18,50,000 | ||
2] | Net working capital [5712000-1850000] | $ 38,62,000 | |
3] | Length of working capital cycle = 4+2+3+8-6 = | 11 | weeks |