Question

The Model Company is to begin operations in April. It has budgeted April sales of $46,000,...

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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.

Add a comment
Know the answer?
Add Answer to:
The Model Company is to begin operations in April. It has budgeted April sales of $46,000,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Artec Company sells its product for $190 per unit. Its actual and budgeted sales follow. April...

    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...

    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....

    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.   ...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT