Being the financial analyst of Javed & Co., you are required to forecast the cash requirements for the month of March and April. The sales figures of Javed & Co. for the various months are portrayed in the given table.
Month Sales (in Rs.)
January, 2010 500,000
February, 2010 600,000
March, 2010 600,000
April, 2010 1000,000
January, 2010 500,000
February, 2010 600,000
March, 2010 600,000
April, 2010 1000,000
Typically, the company collects 30 percent of its sales in the month of sale, 50 percent in subsequent month and the remaining 20 percent of sales are collected in the second month after the sale. All sales are credit sales.
The purchase of raw materials to produce the product amounts 70 percent of sales of the same month for month of March and 60 percent of sales of the same month for month of April. All the purchases are cash purchases.
Labor cost including overtime, are expected to be Rs. 80,000 in March and Rs. 200,000 in April. The other costs including selling, administrative, tax and other cash expenses are expected to be Rs. 20,000 for the month of March and 100,000 for the month of April.
The purchase of raw materials to produce the product amounts 70 percent of sales of the same month for month of March and 60 percent of sales of the same month for month of April. All the purchases are cash purchases.
Labor cost including overtime, are expected to be Rs. 80,000 in March and Rs. 200,000 in April. The other costs including selling, administrative, tax and other cash expenses are expected to be Rs. 20,000 for the month of March and 100,000 for the month of April.
Note: Assume the minimum cash balance requirements for each month to be Rs. 40,000.
Requirements:
On the basis of above information,
A) Prepare a cash budget for the month of March and April.
B) Indicate whether the company is in “cash excess” or “cash deficit” and by which amount?
On the basis of above information,
A) Prepare a cash budget for the month of March and April.
B) Indicate whether the company is in “cash excess” or “cash deficit” and by which amount?
Idea Solution:
Mar-10
Collections
30% from Mar Sales 180,000
50% from Feb Sales 300,000
20% from Jan Sales 100,000
Total receipts 580,000
Payments
Cash purchase (70% of March Sales) 420,000
Direct labor 80,000
Selling, admin & others 20,000
Total payments 520,000
Net change 60,000
Add: Opening balance (minimum requirement) Rs.40,000
Expected closing balance Rs.100,000
Less: Required closing balance Rs.40,000
Cash excess in the month of Mar by Rs.60,000/-
prepare cash budget for the month of april by yourself very similar to mar cash budget
Mar-10
Collections
30% from Mar Sales 180,000
50% from Feb Sales 300,000
20% from Jan Sales 100,000
Total receipts 580,000
Payments
Cash purchase (70% of March Sales) 420,000
Direct labor 80,000
Selling, admin & others 20,000
Total payments 520,000
Net change 60,000
Add: Opening balance (minimum requirement) Rs.40,000
Expected closing balance Rs.100,000
Less: Required closing balance Rs.40,000
Cash excess in the month of Mar by Rs.60,000/-
prepare cash budget for the month of april by yourself very similar to mar cash budget
Please do make changes in these assignment otherwise every one who copy this assignment as it is will awarded zero marks
NOTE: - These Assignments OR Quiz are just for idea, so kindly don't copy it, after viewing it make your own. Thanks We always try our best to upload 100% correct solution BUT it is requested that you kindly review it before submission, please BEST OF LUCK, Thanks to those students those send me Assignments and quizzes. If you have any Assignment and quiz kindly send at jamilbookcenter@yahoo.com
No comments:
Post a Comment