Prepare an approximation of working capital requirements, Managerial Accounting

Assignment Help:

On 1st January, 2005 the Board of Directors of Paushak Limited needed to identify the amount of working capital needed to meet the programme they have arranged for the year. From the subsequent information, prepare an approximation of working capital requirements.

Issued Share Capital                                            Rs. 2, 00,000

8% Debentures                                                   Rs.    50,000

Fixed Assets as on 1st January                              Rs. 1,25,000

Production throughout the earlier year was 60,000 units and this is proposed to keep the same throughout 2005. The expected ratio of cost to selling price is:

Raw Materials are 60 percent; direct wages 10 percent and Overheads 20 percent. The subsequent further information is presented:

a) Raw materials are probable to continue in the stores on an average for two months before being given to the production unit.

b) All unit of production is expected to be in process for one month.

c) Finished goods will continue in the warehouse awaiting transmit to customers for approximately three months.

d) Credit permitted through creditors is two months from the date of delivery of raw materials.

e) Credit provided to debtors is three months from the date of dispatch.

f) Selling price is Rs 5 per unit.

Solution:

Statement demonstrating working Capital Requirements:

(a)

Current Assets

Rs.

Rs.

 

(i)

 

Stock of raw material (2 months) (Rs.15,000 × 2)

 

 

30,000

 

(ii)

 

Work-in-Progress (1 month) Material (Rs.15,000 × 1) Labour (Rs.2,500 × 1) Overheads (Rs.5,000 × 1)

 

 

15,000

2,500

5000

 

 

 

 

22,500

 

(iii)

 

Stock of finished Goods (3 months) Material (Rs.15,000 × 3)

Labour (Rs.2,500 × 3) Overheads (Rs.5,000 × 3)

 

 

45,000

7,500

15,000

 

 

 

 

67,000

 

(iv)

 

Debtors (3 months) Material (Rs. 15,000 × 3) Labour (Rs. 2,500 × 3) Overheads (Rs. 5,000 × 3)

 

 

45,000

7,500

15,000

 

 

 

 

67,000

1,87,500

 

(B)

 

Current Liabilities:

Creditors for raw Material (2 months) Rs. 15,000 × 2)

Net working Capital required (A-B)

 

 

 

 

30,000

1,57,500

 

Working Notes:

1) Debtors have been valued and calculated on sales basis which would be Rs. 75,000 (60,000 ? 5 ? 3 ? 12). Hence, working capital taking Current Assets at total value

Working Capital required as per above statement    1,57,500 Rs.

Add: Increase in Debtors (Rs. 75,000-Rs.67, 500)     7,500 Rs.

                                                                                    1,65,000

2) Monthly amount of each components of cost is determined as follows:

 Total sales 60,000 . 5 = Rs. 3,00,000

(a)   Raw Materials =  (3,00,000 . 60)/(100 ×12)

= Rs.15,000

(b) Direct Labour =(3,00,000 . 10)/ (100 ×12)

= Rs.2,500

(c) Overheads       = (3,00,000 . 20)/ (100 ×12)

= Rs.5,000

3) This is assumed that labour and overhead in the starting. Thus, full amount of labour and overhead is involved in work-in-progress. If this is assumed that labour and overheads accrued equally, half of the amount will be comprised in work-in- progress.

4) Additional capital needed will be Rs. 35,500 it got from Rs. 1,57,500-1,25,000, since Rs. 1,25,000 is obtainable from long-term sources or share capital debentures- Fixed assets


Related Discussions:- Prepare an approximation of working capital requirements

Testing the slope, Testing the Slope The strong point of the relationsh...

Testing the Slope The strong point of the relationship among the dependent variable and each of the independent variables can be determined using 3 methods: 1) Correlation

Multistage decision making under risk, Multi-stage decision making under ri...

Multi-stage decision making under risk (The use of decision trees) Sequencing is concerned with the selection of an appropriate sequence or order of performing a series of jobs

Incremental analysis, What nonfinancial factors should management consider ...

What nonfinancial factors should management consider in making its decision on whether to accept or reject a special order?

State performance budgeting according to carter performance, State performa...

State performance budgeting according to carter performance According to carter performance budgets use statement of mission goals and objectives to explain why the money is be

Facets of cash management, Cash management is related along with the manage...

Cash management is related along with the management of: Cash outflows and inflows of the firm Cash flows inside the firm Cash balances as financing deficit and inve

Cindy, School problem is asking to calculate the work in progress inventory...

School problem is asking to calculate the work in progress inventory for the beginning of a month without providing previous month data.

Marginal costing, marginal costing decision making assignment questions

marginal costing decision making assignment questions

Assignment help , Excercise 2-5 Granger products had the following transac...

Excercise 2-5 Granger products had the following transactions for the just completed month. The company had no beginning inventories. a)$75,000 in raw materials were purchased

The value chain and cost analysis, The Value Chain and Cost Analysis The ...

The Value Chain and Cost Analysis The behavior of a firm's costs and its relative cost position stem from the value activities the firm performs in competing in an industry. A me

Problrm question, The std cost of chemical mixture~PQ is as follows: 40% of...

The std cost of chemical mixture~PQ is as follows: 40% of material P @rs.400/kg 60% of material Q @rs.600/kg A std loss of 10% is normally anticipated in pdn. The followinng parti

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd