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
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
Share above Content to Your Friends


accounting Accounting Concepts Accounting Course Accounting Education accounting equation Accounting Solutions Algebra Answer the Questions and Become Master Balance Sheet bank Bodybuilding Education Business Business Education Business Environment Business Solutions CA Calculus cameras car Car Driving Course Career Solutions carpentry Class 10 Maths Class 9 Maths Computer Computer Basics Computer Hardware Computer Networking Computer Software Computer Solutions cooking education Corporate Accounting Corporate Law cost cost accounting CSE Dailymotion depreciation determinant drawing Driving Education e-accounting earn money Economics Education Education Education Solutions Electronics Email Events Examination Finance Education Finance Solutions financial Financial Accounting FIR Football Gambling Gambling Addiction Goldsmith Google Adsense GST Guest Writers Health Education Help History Home Building Home Maintenance amp; Repair Index Number India Indian Language Inspiration insurance internal audit Internet Internet Forum Jobs amp; Careers Journal journal entries journal entry Kenya Laptop Basics Law Education Law Solutions Learning Lecture Legal Education Linear algebra Linear Programming Malaysia Management Accounting Management Education Management Solutions Marketing Education Mathematics Education matrices Medical and Surgery Education Mobile motivation MS Excel Nepal Nigeria organisation Other Pakistan Personal Finance Philippines Photography Photoshop Software Picture Plumbing Education Probability Profiles provision real estate rectification Relationships amp; Family Religious Studies Result Sahas Saudi Arabia Science Education Self-Learning Skating Slideshow Solution Spiritual Education Sports Statistics Statistics Education stock Story svtuition Tablet Education Tally Tally Solutions Tally.ERP 9 tax Tax Solutions teaching Teaching Education Tech Simplify Test Testimonials Travel Trigonometry tuition TV Shows UK USA variance analysis VAT vector Video Video on Demand videos Vocational Education Web design website Welding Skills Wife Window Movie Maker Wordpress working capital Youth youtube
Svtuition: Need to Make Cash Budget Based on Following Data
Need to Make Cash Budget Based on Following Data
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock