Computation of working capital required, Managerial Accounting

Assignment Help:

Computation of Working Capital Required

1.

Operating Cycle Period

=

M+W+F+D-C

 

 

=

101.38 +28.07+26.07+14.60-60

 

 

=

110.12 or 110 days

 

2.       Total Cost of Sales                                              Rs

Cost of Goods Sold

5,60,000

Distribution and other Expenses

40,000

 

6,00,000

3.         Cash Working Capital          = C + (OC/N) . CS

= O + (110/365). Rs.6,00,000

= Rs.1,80,822

Illustration 5: Manekchand Ltd. Plans to sell 30,000 units subsequent year. The probable cost of goods sold is as given here:

                                                                                      Rs. (Per units)

Raw Material

100

Manufacturing Expenses

30

Selling Administration And Finance Expanses

20

Selling Price

200

The duration of different stages of the operating cycle is expected to be as given below:

Raw Material Stage                                                                    2 month

Work in Progress                                                                        1 month

Fished Goods Stage                                                                    ½ month

Debtors Stage                                                                             1 months

Suppose that the monthly sales level of 2,500 units; evaluates the gross working capital requirements if the needed cash balance is 5 percent of the gross working capital requirement.

Solution:

Statement of Gross Working Capital Requirements

Current Assets:                                                                                      Rs.                       Rs.

(i)  Raw Material (2 months) (Rs. 2,500 ? 100 ? 2)                                                          5,00,000

(ii)  Work in progress (1 month)

Raw material (Rs. 2,500 × 100 × 1)                                                      2,50,000

Mfg. Expenses (Rs. 2,500 × 30 × 1)                                                      75,500                   3,25,000

(iii) Finished goods (1/2 months)

Raw Material (Rs. 2,500 × 100 × 5)                                                      1,25,000

Mfg. Expenses (Rs. 2,500 × 30 × .5)                                                     37,500                  1,62,500

(iv) Debtors (1 month) (Rs. 2,500 × 150 × 1)                                                                     3,50,000

(v)     Cash                                                                                     13,62,500                71,711

(5percent of gross working capital that is, 13,62,500 ? 5/95)                 14,34,211                    

Gross Working Capital Required 

Working Notes:

1. Finance expenses and selling administration are not contained in the value of closing stock of finished goods although added in the cost of sales for valuing debtors.

2. It is assumed as degree of completion of work-in-progress is 100 percent as regards labour, overhead and materials and as manufacturing and material expenses for the full period are involved in the cost of work-in-progress.

3. It is assumed that each sale is credit sales.

4. Profit has not been termed as source of working capital thus fully ignored.


Related Discussions:- Computation of working capital required

List the advantages of program based budgeting, Question: (a) "Budgeta...

Question: (a) "Budgetary control comprises two distinct elements - Planning and Control''. ‘'A budget is a statement of what it is reasonable to believe can be made to ha

Determine the benefit of product life cycle costing, Benefit of product lif...

Benefit of product life cycle costing The benefits of product life cycle costing are summarized as follows: 1) The product life cycle costing results in earlier actions to g

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.

Break Even Sales in Units, Kibble Company had the following functional inco...

Kibble Company had the following functional income statement for the month of July 2011: Kibble Company Functional Income Statement For the Month Ending July 31, 2011 Sales ($40 x

Cash planning, Firms need cash to invest in inventory, receivables and fixe...

Firms need cash to invest in inventory, receivables and fixed assets and to create payments for operating expenses, so as to increase earnings and sales and make sure the smooth ru

What are the advantages of standard costing, Advantages of standard costing...

Advantages of standard costing 1) Measuring efficiency: standard costing is a yardstick for measuring efficiency. The comparison of actual costs with standard costs enables t

Applications of markov chains, Applications of Markov Chains They are a...

Applications of Markov Chains They are a particular class of probabilistic models and their applications include analysis of: Inventory systems Replacement and mainten

Adjusting entries, what do you debit and what do you credit in adjusting en...

what do you debit and what do you credit in adjusting entry for prepaid rent?

Selective inventory management, Selective Inventory Management The inve...

Selective Inventory Management The inventory of an industrial firm generally comprises thousands of items with diverse prices, usage and lead time, as well as procurement and/o

What are the features of product life cycle costing, Features of product li...

Features of product life cycle costing Product life cycle costing is important due to the following features: 1) product life cycle costing involves tracing of costs and re

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