The Model Company is to begin operations in April. It has
budgeted April sales of $46,000, May sales of $50,000, June sales
of $56,000, July sales of $58,000, and August sales of $54,000.
Note that 10% of each month's sales is expected to represent cash
sales; 75% of the balance is expected to be collected in the month
following the sale, 17% the second month, 6% the third month, and
the balance is expected to be uncollectible.
What is the amount of cash to be collected in the month of
July?
Multiple Choice
$48,082.
$53,734.
$59,000.
$53,110.
Correct Answer:
Cash collected in the month of July |
$ 53,734.00 |
Working:
April |
May |
June |
July |
August |
|
budgeted sales |
$ 46,000 |
$ 50,000 |
$ 56,000 |
$ 58,000 |
$ 54,000 |
Total cash sales (10% of budgeted sales) |
$ 4,600 |
$ 5,000 |
$5,600 |
$ 5,800 |
$ 5,400 |
Total credit sale (budgeted sale – cash sales) |
$ 41,400 |
$ 45,000 |
$ 50,400 |
$ 52,200 |
$ 48,600 |
Cash collected in the month of July |
|
Total cash sale in the month of July |
$ 5,800.00 |
75% of Total credit sale for the month of June |
$ 37,800.00 |
17% of the total credit sale for the month of May |
$ 7,650.00 |
6% of the total credit sale for the month of April |
$ 2,484.00 |
Cash collected in the month of July |
$ 53,734.00 |
End of answer.
Please give a thumbs-up, it will be highly appreciated.
Thanks.
The Model Company is to begin operations in April. It has budgeted April sales of $46,000,...
Artec Company sells its product for $190 per unit. Its actual and budgeted sales follow. April (actual) May (actuan June (budgeted) July (budgeted) August (budgeted) Units 9,500 2,800 8,000 7,500 4,100 Dollars $1,805,000 532,000 1,520,000 1,425,000 779,000 All sales are on credit Recent experience shows that 24% of credit sales is collected in the month of the sale, 46% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible The...
The following information is from Tejas WindowTint's financial records. Month April May June July Sales $77,000 72,000 61,000 73,000 Purchases $60,000 58,000 46,000 64,000 Collections from customers are normally 68 percent in the month of sale, 16 percent in the month following the sale, and 15 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 1 percent discount allowed on purchases paid for...
Aztec Company sells its product for $190 per unit its actual and budgeted sales to low. Units Dollars $950,000 Aprill (actual) May (actual) June (budgeted) July (budgeted) August (budgeted) 5.000 2,000 7,500 6,000 4,300 380,000 1.425,000 1.140,000 817,000 All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
Aztec Company sells its product for $190 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 8,000 $1,520,000 May (actual) 2,600 494,000 June (budgeted) 7,500 1,425,000 July (budgeted) 8,000 1,520,000 August (budgeted) 4,000 760,000 All sales are on credit. Recent experience shows that 28% of credit sales is collected in the month of the sale, 42% in the month after the sale, 27% in the second...
Artec Company is its product for $190 per unit is actual and budgeted sales follow April (actual) May (actual) 7,500 1,300 .000 6,500 Dollars $1,425,000 342.000 1.140,000 1,235,000 July hodgeted) budgeted) August (budgeted) 5.900 7 41.000 All sales are on Credit Recent experience shows that 24% of credit ses collected in the month of the sale 46% in the month after the sale, in the second month after the sale and 2 proves to be uncollectible. The product's purchase price...
Aztec Company sells its product for $150 per unit. Its actual
and budgeted sales follow.
Units
Dollars
April (actual)
4,500
$
675,000
May (actual)
2,600
390,000
June (budgeted)
6,000
900,000
July (budgeted)
5,000
899,000
August (budgeted)
4,200
630,000
All sales are on credit. Recent experience shows that 30% of credit
sales is collected in the month of the sale, 40% in the month after
the sale, 26% in the second month after the sale, and 4% proves to
be uncollectible....
Ed’s Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 32,000 June $ 36,000 April 38,000 July 44,000 May 27,000 August 46,000 Sales in January and February were $35,000 and $34,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a....
Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July = 3,000 units; August = 2,500 units. June ending inventory = 1,200 units. Budgeted ending inventory must equal 40% of next month's budgeted sales. Production budgeted for July would equal units = ? units ------ 2) ABC Company's budgeted production is as follows: January = 5,000 units; February = 8,000 units. Each unit produced requires 3 pounds of raw material. January beginning inventory...
Cash receipts A firm has actual sales of $62,000 in April and $59,000 in May. It expects sales of $70,000 in June and $104,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are collected evenly over the following 2 months, what are the firm's expected cash receipts for June, July, and August? June July August April 62,000 $ May 59,000 $ Sales...
Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales occur. The company has requested a $40,000, 90-day loan from its bank to help meet cash requirements during the quarter. Since Herbal Care has experienced difficulty in paying off its loans in the past, the loan officer at the bank has asked the company to prepare a cash budget for the quarter. In response to this request, the following data have...