Need to Make Cash Budget Based on Following Data

Dear Sir ..i m from shimla (meettomanish@gmail.com) 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 Rs Rs Rs Rs Rs R Rs Rs Rs 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

_______________________________________________________________

Request by Founder of Svtuition

Donate to SvTuition  www.svtuition.com/donate/

We are on a mission to provide a free world-class education to anyone anywhere.

_______________________________________________________________

More Like This

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>