Question

HASF PVT.LTD
BUDGETED INCOME STATEMENT
FOR 1st QUARTER 1999
Description JANUARY FEBRUARY MARCH
Sales 285,000 323,000 221,000
Purchases 129,000 168,000 95,000
Wages 35,000 37,000 30,000
Supplies 26,000 23,000 21,500
Utilities 6,500 8,700 7,200
Rent 15,000 12,800 13,600
Insurance 12,000 12,000 12,000
Advertising 24,500 28,500 18,000
Depreciation 20,000 20,000 20,000
Net Profit 17,000 13,000 3,700
Required:
a. Please make a cash budget for the months of January, February and March 1999 based on
the data for: (5 Marks)
View Receivable Trend:
• 30% of Sales are collected in the month of sale
• 30% of Sales are collected after the month of sale
• 40% of Sales are collected two months after the sale is made
View Payable Trend:
• 10% of Purchases are paid for in the month of purchase
• 35% of Purchases are paid after the month of purchase
• 55% of Purchases are paid two months after the purchase is made
Additional Information:
• Rent and Insurance expense were prepaid at the end of 1998

Answer 1

Cash Budget January February March (12,900 19,050 Particulars Opening balance Reciepts: Cash Sales 85,500 96,900 66,300 Collection from debtors 85,500 210,900 Total A 85,500 169,500 296,250 Payment / Disbursement Cach purchase 12900 16800 Creditors payment 9,500 45,150 129,750 Wages 35,000 37,000 30,000 Supplies 26,000 23,000 Advertising 21,500 24,500 28,500 18.000 Total B 198,400/150,450 208,750 closing balance -(12,900) 19,050 87.500 11.com

*Sales and purchase collected in same month considered as Cash sales and Cash purchase.

*Rent and insurance expense prepaid in 1998 considered as all three month payment is prepaid in 1998.