Question

Duiy cUpaily lls plathed the tollowing sales for the next three months: January Budgeted Sales $40,000 February $50,000 March $70,000 Sales are made 20% for cash and 80% on account. From experience, the company has learned that a month sales on account are collected according to the following pattern: Month of sale First month following sale second month following sale Uncollectible 60% 30% 8% 2%
The company requires a minimum cash balance of $5,000 to start a month. The beginning cash balance in March is budgeted to be $6,000. Required a) Compute the budgeted cash receipts for March. Rember to think in terms of when actual cash is planned to be received. If you are not going to receive the cash it is not part of the budget. Also pay close attention to cash vs credit sales b) The following additional information has been provided for March: Inventory purchases (all paid in cash in Operating Expenses (all paid in cash in Depreciation expense for March $28,000 $40,000 $5,000 March) March) Dividends paid in March $4,000 Prepare a cash budget in good form for the month of March, using this information and the budgeted cash receipts you computed for part a) above. The company can borrow in any dollar amount and will not pay interest until April
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

Schedule of Budgeted Cash Receipts
March
Cash sales (20% x $70000) 14000
Collection of credit sales for:
March (80% x $70000 x 60%) 33600
February (80% x $50000 x 30%) 12000
January (80% x $40000 x 8%) 2560
Total budgeted cash receipts $ 62160

b)

Cash Budget
For the Month of March
Beginning cash balance $ 6000
Add receipts:
Collections from customers 62160
Total cash available 68160
Less cash disbursements:
Inventory purchases 28000
Operating expenses 40000
Dividends 4000
Total cash disbursements 72000
Excess (deficiency) of cash available over disbursements -3840
Financing:
Borrowings 8840
Repayments 0
Interest 0
Total financing 8840
Ending cash balance $ 5000
Add a comment
Know the answer?
Add Answer to:
Duiy cUpaily lls plathed the tollowing sales for the next three months: January Budgeted Sales $40,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
  • Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales January Budgeted D.M....

    Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales January Budgeted D.M. Purchases $35,000 49,400 38,500 $266,000 286,100 251,900 February March Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...

  • Getty Company expects sales for the first three months of next year to be $190,000, $235,000...

    Getty Company expects sales for the first three months of next year to be $190,000, $235,000 and $315,000, respectively. Getty expects 40 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March February March Budgeted Cash Receipts References eBook...

  • Exercise 22-17 Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales January...

    Exercise 22-17 Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales January February March $237,000 227,300 284,800 Budgeted D.M. Purchases $36,500 43,100 42,900 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month...

  • Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...

    Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $257,000 $32,700 February 277,200 37,500 March 297,900 51,500 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale: 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...

  • Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...

    Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $251,000 $35,100 February 282,800 40,100 March 342,600 46,700 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...

  • Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted D.M. Purchases Budgeted Sales...

    Nieto Company's budgeted sales and direct materials purchases are as follows. Budgeted D.M. Purchases Budgeted Sales $251,000 $32,200 January February 238,100 45,300 March 299,600 38,300 Nieto's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto's purchases are 50% cash and 50% on account Purchases on account are paid 40% in the month of purchase,...

  • Sarasota Company's budgeted sales and direct materials purchases are as follows. January February March Budgeted Sales...

    Sarasota Company's budgeted sales and direct materials purchases are as follows. January February March Budgeted Sales $261,300 250,800 344,000 Budgeted D.M. Purchases $39,300 43,300 44,000 Sarasota's sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Sarasota's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...

  • Hagen Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...

    Hagen Company's budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $300,000 $60,000 February 330,000 70,000 March 350,000 80,000 Hagen's sales are 40% cash and 60% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Hagen's purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...

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

  • Martin Company projects the following sales for the first three months of the year: $14,300 in...

    Martin Company projects the following sales for the first three months of the year: $14,300 in January: $11,300 in February; and $15,800 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements Requirement 1. Prepare a...

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