Need to Make Cash Budget Based on Following Data


Dear Sir ..I m from shimla doing PGD in Project management from Hyderabad University. Please solve the following problem based on the below data asap.
Jan Feb Mar Apr May June P October November December Total Sales of the previous year Sales forecast
Receipt  Rs.
E October 1,20,000 January 80,000

Sales 80,000 80,000 1,00,000 90,000 1,10,000 1,20,000 V 1,20,000 1,50,000 1,00,000 November 1,50,000 February 80,000
I December 1,00,000 March 1,00,000
Cash sales (0.4) 32000 32000 40000 36000 44000 48000 O 48000 60000 40000 380000 April 90,000
Credit Sales (0.6) 48000 48000 60000 54000 66000 72000 U 72000 90000 60000 570000 May 1,10,000
S June 1,20,000

Y Cash:Credit sales 0.4:0.6
Administration expense 20000 20000 20000 20000 20000 20000 E 20000 20000 20000 180000
A Collection
R
Collection 50% of the sales is collected one month later
1 month later (50%) - November 75000 25% of it is collected two months later
2 month later (25%) - December 25000 25% is collected 3 months later
3 months later (25%) - January 20000
Gross Margin 20%

Lead time between sales and purchase 1 month

Administration expenses for each month Rs. 20,000

Opening balance of cash 30,000

Capital expenditure in May 20,000

Manish sharma from India

Dear instead of solving any question, you should learn the basic of cash budget.

Please also study the solution of past cash budget problem

Vinod Kumar

Educator

Prof. Vinod Kumar is an Indian Educator, Motivational Speaker, Naturopathic Practitioner and Entrepreneur . He is the founder of Svtuition... read more »

0 comments:

Post a Comment