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.

Accounting theory of pricing, relevance to business owners, employees and p...

relevance to business owners, employees and public?

Game theory, Game Theory Game theory was developed for the purpose of a...

Game Theory Game theory was developed for the purpose of analyzing competitive situation involving conflicting interests. In game theory, there are assumed to be two or more pe

Example of cash discount, M/s ABC's present credit terms are 1/10 net 30 th...

M/s ABC's present credit terms are 1/10 net 30 that they are planning to change to 2/10 net 30.  The current average collection period is 20 days and the variable cost to sales rat

State material price variance, State Material price variance Difference...

State Material price variance Difference among standard price and the actual price of the material is the material price variance. This variance arises because of various facto

What are the objectives of intra company transfer pricing, What are the Obj...

What are the Objectives of Intra company transfer pricing The objectives of Intra company transfer pricing are: 1) Evolution of performance and efficiency of each division.

Costs classification, identify and explain the many classification of costs...

identify and explain the many classification of costs for planning, control.performance evaluation and decision making.

Differential analysis: The key to decision making., Exercise 12-7 sell or p...

Exercise 12-7 sell or process further

Inventory planning & control under uncertainty, Inventory planning & contro...

Inventory planning & control under uncertainty The basic EOQ model assumes that all the parameters (elements) in the model are certain (i.e. can be predicted precisely in advan

Explain about Cost centre: Meaning & definition: cost centre is defined as a location, person or item of equipment (or group of them) in respect which costs may be ascertaine

Cross elasticity of demand, what is cross elasticity of demand? is it posit...

what is cross elasticity of demand? is it positive for substitute or compliments? show in a diagram relating to the demand for the coffee to the price of tea