Compute the operating cycle, Managerial Accounting

Assignment Help:

Under this method, approximation is made of payments and cash receipts in the ensuring period. The dissimilarity of these payments and receipts indicates deficiency or surplus of cash. The management formulates plans to procure the amount of deficit. This method, in a way, is a form of cash budget.

Illustration: Compute the operating cycle and the working capital requirements from the subsequent figures:

 

Balance as at

Balance as at

 

1st January

31st December

 

Rs.

Rs.

Raw Material

80,000

1,20,000

Work-in-Progress

20,000

60,000

Finished goods

60,000

20,000

Sundry Debtors

40,000

40,000

Wages and Manufacturing Expenses

-

2,00,000

Distribution and Other Expenses

-

40,000

Purchases of Materials

-

4,00,000

Total Sales

-

10,00,000

 

(i)  The Company acquires a credit for 60 days from its suppliers.

(ii)  All goods were sold for credit.

Solution:

Computation of Operating Cycle

(i)                 Material Storage Period:

=   Average Stock of Raw Materials/Daily Average Consumption

= ((Rs.80,000 + 1,20,000) / 2)/(Rs.3,60,000 / 365)

= Rs.1,00,000/ Rs.986.3

= 101.38 days

Material Consumed = Opening Stock + Purchases - Closing Stock

= Rs. 80,000 + 4,00,000-1,20,000

= Rs. 3,60,000

(ii) Conversion or Processing Period

= Average Stock of Work - in - progress/Daily Average Factory Cost

=  ((Rs.20,000 + 60,000) / 2)/( Rs.5,20,000 / 365)

=  (Rs.40,000) / (Rs.1,424.65)

= 28.07days

Factory Cost:                                                    Rs.

Opening Work-Progress                                20,000

Material Consumed (as above)                    3,60,000

Wages and Mfg. Expenses                            2,00,000

          5,80,000

Less: Closing Work-in-Progress                   60,000

5,20,000

(iii) Finished Goods Storage Period

= Average Stock of Finished Good/Daily Average Cost of Goods Sold

=   ((Rs.60,000 +20,000) / 2)/(Rs.5,60,000 / 365)

=  (Rs.40,000)/ Rs.1,534.25

= 26.07days

Cost of Goods sold                                                          Rs.

Opening Stock of Finished Goods

60,000

Factory Cost (as above)

5,20,200

 

5,80,000

Less: Closing Stock of Finished Goods

20,000

 

5,60,000

(iii)    Debtors Collection period

=   Average Debtors/Daily Average Sales

=   ((Rs.40,000 + 40,000) / 2)/(Rs.10,00,000 / 365)

=   (Rs.40,000) / Rs. 2,739.7

 = 14.6 days


Related Discussions:- Compute the operating cycle

Explain the investment versus speculation, Explain the Investment versus Sp...

Explain the Investment versus Speculation? In brief describes the following terms: a) Investment versus Speculation. b) Active and Passive Equity Management c) Systematic v

Overhead analysis sheet, Ask question #1.The annual overhead costs for Mona...

Ask question #1.The annual overhead costs for Mona Claire Holdings which has three production centres and two service centres as follows; Indirect wages and supervision Machine

Cost advantage and value chain , Cost Advantage and Value Chain Cost a...

Cost Advantage and Value Chain Cost advantage is one of the two types of competitive advantage a firm may possess. Cost is also of vital significance to differentiation strate

Decision making special order, MNO Ltd produces and sells for $25 an office...

MNO Ltd produces and sells for $25 an office machine for which there is a heavy demand which the company is prevented from meeting because of a shortage of skilled labour. The dire

Cost-volume-profit assumptions, Cost-Volume-Profit assumptions The main...

Cost-Volume-Profit assumptions The main assumptions required in C-V-P analysis are: 1) The relationship holds merely within the appropriate range. The relevant range is a ba

Excel formulas, I only need the formulas in excel put in.

I only need the formulas in excel put in.

Ranking of decision packages , Ranking of Decision Packages The rankin...

Ranking of Decision Packages The ranking procedure is employed to establish a rank priority of decision packages in the organization. Throughout the ranking procedure managers

Illustration of abc analysis, Illustration: ABC analysis Combine items ...

Illustration: ABC analysis Combine items on the basis of their relative value to form three categories—A, B and C. The data in the table below illustrates the ABC analysis.

Maximum Price company would pay, Cause Company is planning to invest in a m...

Cause Company is planning to invest in a machine with a useful life of five years and no salvage value. The machine is expected to produce cash flow from operations of $20,000 in e

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