Question

Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please give positive ratings so I can keep answering. Thanks!
Timpco
Budgeted Sales October November December Note
Cash sale 120,000.00      99,000.00      97,000.00 A
Credit sale 120,000.00 118,800.00 106,700.00 B
Budgeted Sales 240,000.00 217,800.00 203,700.00 C=A+B
Budgeted Cash Receipts October November December
Credit sale 120,000.00 118,800.00 106,700.00 See B
95% of Credit sale are collectible 114,000.00 112,860.00 101,365.00 D=B*95%
60% of collectible credit sale in the same month      68,400.00      67,716.00      60,819.00 E= 60% of D
40% of collectible credit sale in the next month                    -        45,600.00      45,144.00 F= 40% of D of previous month
Cash sale 120,000.00      99,000.00      97,000.00 See A
Total Cash Receipts before discount 188,400.00 212,316.00 202,963.00 G=E+F+A
75% of collectible credit sale      85,500.00      84,645.00      76,023.75 H=D*75%
Cash discount of 1.5% on 75% of collectible credit sale        1,282.50        1,269.68        1,140.36 I=H*1.5%
Total Cash Receipts after discount 187,117.50 211,046.33 201,822.64 J=G-I
So budgeted total Cash Receipts 187,117.50 211,046.33 201,822.64 See J
Cost of goods sold Budget October November December January
Budgeted Sales 240,000.00 217,800.00 203,700.00 193,000.00 See C
Less: Gross profit @ 30%      72,000.00      65,340.00      61,110.00      57,900.00 K= C*30%
Cost of goods sold Budget 168,000.00 152,460.00 142,590.00 135,100.00 L=C-K
Material Purchase Budget October November December January
Cost of goods sold Budget 168,000.00 152,460.00 142,590.00 135,100.00 See L
Material to be Purchased 152,460.00 142,590.00 135,100.00 M= 100% of L of next month
Budgeted cash disbursements October November December January
Material Purchase Budget 152,460.00 142,590.00 135,100.00 See M
20% paid in the same month      30,492.00      28,518.00      27,020.00 N= M*20%
80% paid in the next month 121,968.00 114,072.00 O= 80% of M of previous month
Budgeted cash disbursements 150,486.00 141,092.00 P= N+O
Add a comment
Know the answer?
Add Answer to:
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...
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
  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 125,000 $ 103,000 $ 99,000 Credit sales 125,000 123,600 108,900 Total $ 250,000 $ 226,600 $ 207,900 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November $ 95,000 114,000 209,000 December $ 95,000 104,500 Cash sales 115,000 115,000 230,000 Credit sales 199,500 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: November $59,000 October December $ 65,000 65,000 $130,000 $77,000 Cash sales Credit sales 70,800 $ 129,800 84,700 $161,700 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 115,000 $ 95,000 $ 95,000 Credit sales 115,000 114,000 104,500 Total $ 230,000 $ 209,000 $ 199,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 155,000 $ 127,000 $ 111,000 Credit sales 155,000 152,400 122,100 Total $ 310,000 $ 279,400 $ 233,100 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 150,000 $ 123,000 $ 109,000 Credit sales 150,000 147,600 119,900 Total $ 300,000 $ 270,600 $ 228,900 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  • Timpco, a retailer, makes both cash and credit sales (ie, sales on open account). Information regarding...

    Timpco, a retailer, makes both cash and credit sales (ie, sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 100,00 160,000 5 200.000 November $ 120.000 150,000 $ 270, eee December $ 80,000 90,000 $ 170,000 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40%...

  • Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales...

    Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 140,000 $ 115,000 $ 105,000 Credit sales 140,000 138,000 115,500 Total $ 280,000 $ 253,000 $ 220,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  • Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales...

    Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 115,000 115,800 $ 230,000 November $ 95,000 114,000 $ 209,000 December $ 95,000 104,500 $ 199,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...

  • please solve all the queations, thanks. [LO 10-4) 10-26 Budgeted Cash Receipts and Cash Disbursements Timpco,...

    please solve all the queations, thanks. [LO 10-4) 10-26 Budgeted Cash Receipts and Cash Disbursements Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales Credit sales $100,000 100,000 $200,000 $ 120.000 150,000 $ 270,000 $ 80,000 90,000 $ 170,000 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are...

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