Question
Caba Corporation’s sales budget for the first half of the year is as follows: Budgeted Sales...
Caba Corporation’s sales budget for the first half of the year is as follows: Budgeted Sales January $ 115,000 February $ 198,000 March $ 220,000 April $ 250,000 May $ 210,000 June $ 290,000 Total: $ 1,283,000 Sales are 30% cash and 70% on account. Sales on account are to be collected over a three-month period, with 20% collected in the month of the sale, 65% collected in the first month following the sale, and 15% collected in the second month following the sale. What is the budgeted balance in the Accounts Receivable account as of June 30?
Would you please show the calculations how you will solve this question
Homework Answers
Answer #2
Accounts Receivables Balance as on June: $184,450
Accounts receivables balance as on June will constitute with the accounts receivables of the june and May Sales, Since any sales will collect in two months.
Accounts REceivables balance as on june:
Accounts Receivables from june
Credit Sales Sales in June : $290,000 *0.70 = $203,000
Cash Collected in the month of june ( June Sales ) = $203,000*0.20 = $40,600
Accounts Receivables balance in june sales = $203,000-$40,600 = $162,400
Accounts Receivables from May Sales :
Credit Sales Sales in May : $210,000 *0.70 = $147,000
Cash Collected in the month of May ( MAy Sales ) = $147,000*0.20 = $29,400
Cash collected in the month of june ( MAy sales) =$ 147,000*.0.65 = $95,550
Accounts Receivables balance in May Sales ( $147,000-$29,400-$95,550) = $22,050
Total Accounts Receivables Blance as on June : $ 162,400+$22,050 =$ 184,450 (ANswer)
answered by: anonymous
Not the answer you're looking for?
Similar Questions
The company’s sales manager prepared the following sales forecast for the first half of the year....
The company’s sales manager prepared the following sales
forecast for the first half of the year.
January
$235,000
February
198,000
March
211,000
April
285,000
May
300,000
June
305,000
Historically, the cash collection of sales has been as
follows:
47% of sales collected in the month of sale
50% of sales collected in the month following the sale
3% of sales collected in the second month following the
sale
All sales are on account
Prepare the schedule of the cash
collection...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for
the first half of the current year:
Cash Sales
Credit Sales
January
$
60,000
$
160,000
February
$
65,000
$
180,000
March
$
33,000
$
140,000
April
$
28,000
$
113,000
May
$
38,000
$
210,000
June
$
90,000
$
70,000
The company is in the process of preparing a cash budget and
must determine the expected cash collections by month. To this end,
the following information has been assembled:
Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for
the first half of the current year:
Cash Sales
Credit Sales
January
$
70,000
$
170,000
February
$
75,000
$
190,000
March
$
49,000
$
150,000
April
$
44,000
$
129,000
May
$
54,000
$
220,000
June
$
100,000
$
230,000
The company is in the process of preparing a cash budget and
must determine the expected cash collections by month. To this end,
the following information has been assembled:
Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for
the first half of the current year:
Cash Sales
Credit Sales
January
$
70,000
$
170,000
February
$
75,000
$
190,000
March
$
27,000
$
150,000
April
$
22,000
$
107,000
May
$
32,000
$
220,000
June
$
100,000
$
10,000
The company is in the process of preparing a cash budget and
must determine the expected cash collections by month. To this end,
the following information has been assembled:
Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for
the first half of the current year:
Cash Sales
Credit Sales
January
$
60,000
$
160,000
February
$
65,000
$
180,000
March
$
44,000
$
140,000
April
$
39,000
$
124,000
May
$
49,000
$
210,000
June
$
90,000
$
180,000
The company is in the process of preparing a cash budget and
must determine the expected cash collections by month. To this end,
the following information has been assembled:
Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for
the first half of the current year: Cash Sales Credit Sales January
$ 40,000 $ 140,000 February $ 45,000 $ 160,000 March $ 42,000 $
120,000 April $ 37,000 $ 122,000 May $ 47,000 $ 190,000 June $
70,000 $ 160,000 The company is in the process of preparing a cash
budget and must determine the expected cash collections by month.
To this end, the following information has been assembled:
Collections...
Mitchell Company had the following budgeted sales for the first half of next year: Cash...
Mitchell Company had the
following budgeted sales for the first half of next year:
Cash
Sales
Credit
Sales
January
$70,000
$170,000
February
$75,000
$190,000
March
$32,000
$150,000
April
$37,000
$132,000
May
$47,000
$220,000
June
$100,000
$220,000
The company is in the process of preparing a cash budget and
must determine the expected cash collections by month. To this end,
the following information has been assembled:
Collections on
credit sales:
50% in...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for
the first half of the current year:
Cash Sales
Credit Sales
January
$
50,000
$
150,000
February
$
55,000
$
170,000
March
$
29,000
$
130,000
April
$
24,000
$
109,000
May
$
34,000
$
200,000
June
$
80,000
$
30,000
The company is in the process of preparing a cash budget and
must determine the expected cash collections by month. To this end,
the following information has been assembled:
Collections...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars
Budgeted sales of The Music Shop for the first six months of 2010
are as follows:
Month
Unit Sales
Month
Unit Sales
January
140,000
April
200,000
February
140,000
May
160,000
March
200,000
June
220,000
Beginning inventory for 2010 is 60,000 units. The budgeted
inventory at the end of a month is 30 percent of units to be sold
the following month. Purchase price per unit is $4.
Prepare a purchases budget in units and...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars
Budgeted sales of The Music Shop for the first six months of 2010
are as follows:
Month
Unit Sales
Month
Unit Sales
January
140,000
April
200,000
February
140,000
May
160,000
March
200,000
June
220,000
Beginning inventory for 2010 is 60,000 units. The budgeted
inventory at the end of a month is 30 percent of units to be sold
the following month. Purchase price per unit is $4.
Prepare a purchases budget in units and...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 13 minutes ago
asked 16 minutes ago
asked 27 minutes ago
asked 31 minutes ago
asked 37 minutes ago
asked 47 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago