Question
The Accounts Manager of Farhan Enterprise has assembled the following data to prepare the firm's cash budget for July, August and September. Cash balances on
The Accounts Manager of Farhan Enterprise has assembled the following data to prepare the firm's cash budget for July, August and September.
Cash balances on June 30, is RM10,000. Minimum cash balance required is RM10,000.
Net sales:
Actual: AprilRM 80,000Forecasted:JulyRM120,000
May90,000August140,000
June100,000September150,000
All sales are on credit. The credit manager collects 50 percent of account receivable in the month of sale, 40 percent in the month following sale, and 8 percent in the second month following sale and 2 percent are uncollected.
Cost of goods sold: 70 percent of monthly net sales.
Purchase of raw materials and component parts account for 40 percent of the cost of goods sold. The firm pays for 80 percent of purchases in the month of purchases and 20 percent of purchases the month following purchase.
Direct labor and factory overhead are 35 percent and 25 percent respectively of the cost of goods sold.
Equipment purchased RM20,000 will be paid out in August.
Prepare the cash budget of Farhan Enterprise for July, August and September.
The Accounts Manager of Farhan Enterprise has assembled the following data to prepare the firm's cash budget for July, August and September.
Cash balances on June 30, is RM10,000. Minimum cash balance required is RM10,000.
Net sales:
Actual: AprilRM 80,000Forecasted:JulyRM120,000
May90,000August140,000
June100,000September150,000
All sales are on credit. The credit manager collects 50 percent of account receivable in the month of sale, 40 percent in the month following sale, and 8 percent in the second month following sale and 2 percent are uncollected.
Cost of goods sold: 70 percent of monthly net sales.
Purchase of raw materials and component parts account for 40 percent of the cost of goods sold. The firm pays for 80 percent of purchases in the month of purchases and 20 percent of purchases the month following purchase.
Direct labor and factory overhead are 35 percent and 25 percent respectively of the cost of goods sold.
Equipment purchased RM20,000 will be paid out in August.
Prepare the cash budget of Farhan Enterprise for July, August and September.
The Accounts Manager of Farhan Enterprise has assembled the following data to prepare the firm's cash budget for July, August and September.
Cash balances on June 30, is RM10,000. Minimum cash balance required is RM10,000.
Net sales:
Actual: AprilRM 80,000Forecasted:JulyRM120,000
May90,000August140,000
June100,000September150,000
All sales are on credit. The credit manager collects 50 percent of account receivable in the month of sale, 40 percent in the month following sale, and 8 percent in the second month following sale and 2 percent are uncollected.
Cost of goods sold: 70 percent of monthly net sales.
Purchase of raw materials and component parts account for 40 percent of the cost of goods sold. The firm pays for 80 percent of purchases in the month of purchases and 20 percent of purchases the month following purchase.
Direct labor and factory overhead are 35 percent and 25 percent respectively of the cost of goods sold.
Equipment purchased RM20,000 will be paid out in August.
Prepare the cash budget of Farhan Enterprise for July, August and September.
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
Principles of managerial finance
Authors: Lawrence J Gitman, Chad J Zutter
12th edition
9780321524133, 132479540, 321524136, 978-0132479547
