Question
a) Iqbal Hanif Holdings is trying to estimate its cash requirement for the second quarter of 2022. The companys forecasted sales are as follows: Month
a) Iqbal Hanif Holdings is trying to estimate its cash requirement for the second quarter of 2022. The companys forecasted sales are as follows:
Month | Sales (RM) | Month | Sales (RM) |
February | 80,000 | June | 125,000 |
March | 85,000 | July | 105,000 |
April | 90,000 | August | 130,000 |
May | 100,000 |
b) The company makes 50 percent cash sales, 40 percent is collected one month after sales, 10 percent is collected two months after sales. c) Purchases of raw materials are 70 percent of sales and are made one month before the sales occur. Payment is made equally in the two months after purchases.
d) Operating expenses will be 10 percent of the monthly sales. The company fixed monthly expenses are RM 20,000 for wages, RM 3,000 for rent, RM 13,000 for depreciation and RM2,000 for insurance.
e) A Quarterly dividend of RM 4,000 will be received at the end of each quarter.
f) Ending cash balance for March 31, 2022 is RM 55,000 and the minimum balance of RM 30,000 must be maintained at all times.
Based on the above information, prepare a cash budget for the second quarter period ending on 30 June 2022.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started