Question

Armidale Corporation has provided the following cash budget forecasts: Month Sales   Purchases July $30,000 $10,000 August...

Armidale Corporation has provided the following cash budget forecasts:

Month Sales   Purchases

July $30,000 $10,000

August 34,000 $12,000

September 38,000 $14,000

October 42,000 $16,000

November 48,000 $18,000

December 60,000 $20,000

  • Cash is collected from customers in the following manner: Month of sale (2% cash discount)30% , Month following sale 50% ,Two months following sale 15% ,Amount uncollectible 5%.   40% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month.

  • Required:
    1. Prepare a summary of cash collections for the 4th quarter. (Marks 3)

    2. Prepare a summary of cash disbursements for the 4th quarter. (Marks 3)

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

1) Solution: $125,200

Working:

October

November

December

August

5,100

September

19,000

5,700

October

12,348

21,000

6,300

November

14,112

24,000

December

17,640

36,448

40,812

47,940

Collections of cash: $36,448 + $40,812 + $47,940 = $125,200

 

2) Solution: $50,400

Working:

October

November

December

September

8,400

October

6,400

9,600

November

7,200

10,800

December

8,000

14,800

16,800

18,800

Disbursements of cash: $14,800 + $16,800 + $18,800 = $50,400

Add a comment
Know the answer?
Add Answer to:
Armidale Corporation has provided the following cash budget forecasts: Month Sales   Purchases July $30,000 $10,000 August...
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
  • The following information pertains to Acme Corporation: Month Sales Purchases July 30,000 10,000 August 34,000 12,000...

    The following information pertains to Acme Corporation: Month Sales Purchases July 30,000 10,000 August 34,000 12,000 September 38,000 14,000 October 42,000 16,000 November 48,000 18,000 December 60,000 20,000 Cash is collected from customers in the following manner: Month of sale 35% Month following sale 50% Two months following sale 15% 40% of purchases are paid for in cash in the month of purchase, and the balance is paid the following month. How much are total cash collections for the 4th...

  • The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October...

    The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October November December Sales $13,000 16,000 18,000 23,000 22,500 28,400 Purchases $6,000 5,700 7,500 8,300 9,200 10,100 Based on past experience cash is typically collected from customers in the following manner: Collected within 10 days of sale so receive a 10% cash discount 25% Collected after 10 days but in the month of sale 10% Collected in the month following the sale 40% Collected in...

  • The following information pertains to Ko Wei Sdn Bhd: Month Sales Purchases RM RM July 30,000 10,000 August 34,000 12,000 September 38,000 14,000 October 42,000 16,000 November 48,000 18,000 December 60,000 20,000 Cash is collected from customers in the

    The following information pertains to Ko Wei Sdn Bhd:  Month Sales Purchases RM RM July 30,000 10,000 August 34,000 12,000 September 38,000 14,000 October 42,000 16,000 November 48,000 18,000 December 60,000 20,000 Cash is collected from customers in the following manner: Month of sale (2% cash discount) 30% Month following sale 50% Two months following sale 15% Amount uncollectible 5% 40% of purchases are paid for in cash in the month of purchase, and the balance is  paid the following...

  • 3) The following information pertains to Amigo Corporation:       Month    ...

    3) The following information pertains to Amigo Corporation:       Month                        Sales         Purchases       July                         $30,000             $10,000       August                      34,000               12,000       September                 38,000               14,000       October                     42,000               16,000       November                 48,000               18,000       December                  60,000               20,000 •    Cash is collected from customers in the following manner:       Month of sale                                        40%       Month following sale                             40%       Two months following sale                    20%       •    60% of purchases are paid for in cash in the month of purchase, and the other...

  • 3) The following information pertains to Amigo Corporation: Month July August September October November December Sa...

    3) The following information pertains to Amigo Corporation: Month July August September October November December Sales $30,000 34,000 38,000 42,000 48,000 60,000 Purchases $10,000 12,000 14,000 16,000 18,000 20,000 Cash is collected from customers in the following manner: Month of sale 40% Month following sale 40% Two months following sale 20% • 60% of purchases are paid for in cash in the month of purchase, and the other 40% is paid the following month. Required: Complete the cash budget for...

  • The following information pertains to Amigo Corporation:         Month                        &

    The following information pertains to Amigo Corporation:         Month                                  Sales             Purchases         July                                  $30,000                 $10,000         August                               34,000                   12,000         September 38,000                   14,000         October                             42,000                   16,000         November 48,000                   18,000         December                         60,000                   20,000 Cash is collected from customers in the following manner:         Month of sale 45%         Month following sale 40%         Two months following sale                               10%         Amount uncollectible 5% 50% of purchases are paid for in cash in the month of purchase, and the other 50% is paid the...

  • Type The following information pertains to Stark Corporation Month Jan Feb Mar Apr May June sales...

    Type The following information pertains to Stark Corporation Month Jan Feb Mar Apr May June sales and Purchases $30,000    $10000 34,000 12000 38,000 14000 42,000    16000 48,000    18000 60,000 20000 Cash is collected from customers in the following manner 30% Month of sale* 50% Month following sale 15% Two months following sale 5% Amount uncollectible *Customers paying in the month of sale receive a 2% cash discount. 40% of purchases are paid for in cash in the...

  • The following information is from Tejas WindowTint’s financial records. Month Sales Purchases April $ 77,000 $...

    The following information is from Tejas WindowTint’s financial records. Month Sales Purchases April $ 77,000 $ 61,000 May 75,000 42,000 June 73,000 30,000 July 82,000 48,000 Collections from customers are normally 70 percent in the month of sale, 18 percent in the month following the sale, and 11 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 5 percent discount allowed on purchases...

  • estion 6: Master Budgetine - Time: 40 minutes . Total: 24 marks The following information pertains...

    estion 6: Master Budgetine - Time: 40 minutes . Total: 24 marks The following information pertains to Stark Corporations Month Jan Feb Mar Apr $30,000 34.000 38.000 42,000 48,000 60,000 Purchases $10.000 12,000 24,000 16,000 18,000 20.000 May June Cash is collected from customers in the following manner: Month of sale Month following sale Two months following sale Amount uncollectible 30% 50% 15% 5 % customers paying in the month of sale receive a 2% cash disco 40% of purchases...

  • 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 75,000 74,000 78,000 Purchases $ 42,000 59,000 47,000 65,000 Collections from customers are normally 69 percent in the month of sale, 19 percent in the month following the sale, and 10 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 4 percent discount allowed on purchases paid...

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