Question

Please fill in the red boxes

Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. Sales Purchases January-- -- -- ---- - - - - PRONGHORN CORP Cash Budget For the Two Months Ending February 28, 2017 A January February Beginning casSalaries 84500 81700 Administrative expenses 1 68800 72200 T Selling expenses 79900 87900 Dividends 12800 التكلللللللل Total

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

Total receipts for January = Collections from customers + Note receivable + Sale of securities

= 332,300 + 17,100 + 0

= $349,400

Repayments in January = $0

Total receipts for February = Collections from customers + Note receivable + Sale of securities

= 378,800 + 0 + 6,500

= $385,300

Ending cash balance in February = $55,280

Borrowings in February = Ending cash balance - Excess of available cash over disbursements

= 55,280 - 44,000

= $11,280

Repayments in February = $0

Please ask if you have any query related to the question. Thank you

Add a comment
Know the answer?
Add Answer to:
Please fill in the red boxes Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budget...
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
  • Problem 7-8A Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budgets for...

    Problem 7-8A Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. Sales Purchases January $360,300 121,200 84,500 70,000 79,900 February $400,300 131,200 81,700 73,400 87,900 Salaries Administrative expenses Selling expenses All sales and purchases are on account. Budgeted collections and disbursement data are given below. All other expenses are paid in the month incurred except for administrative expenses, which include $1,200 of depreciation per month. Other data. 1. Collections from customers: January $332,300; February...

  •  Derby Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are: January February...

     Derby Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are: January February Sales $350,000 $400,000 Direct materials purchases 110,000 120,000 Direct labor 85,000 115,000 Manufacturing overhead 60,000 75,000 Selling and administrative expenses 75,000 80,000 All sales are on account. Collections are expected to be:    60% in the month of sale,   25% in the first month following the sale, and   15% in the second month following the sale. As to cash payments (disbursements):   30% of direct materials...

  • Marigold Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...

    Marigold Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $380,160 126,720 95,040 73,920 83,424 February $422,400 132,000 105,600 79,200 89,760 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60% of direct materials purchases...

  • Grouper Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...

    Grouper Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $381,600 $424,000 Direct materials purchases 127,200 132,500 Direct labor 95,400 106,000 Manufacturing overhead 74,200 79,500 Selling and administrative expenses 83,740 90,100 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...

  • TUDIM TRU IUCU1UILLIUDIJIVI Blossom Company prepares monthly cash budgets. Relevant data from operating budgets for 202...

    TUDIM TRU IUCU1UILLIUDIJIVI Blossom Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February $442,800 $492,000 147,600 153,750 Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses 110,700 86,100 123,000 92,250 97,170 104,550 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of...

  • Question 3 Sun and Company prepares monthly cash budgets. Relevant data from operating budgets for 2020...

    Question 3 Sun and Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $420,400 $476,000 Direct materials purchases 142.800 148,750 Direct labor 107,100 119,000 Manufacturing overhead 83,300 89,250 Selling and administrative expenses 94,010 101,150 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of...

  • Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....

    Crane Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses $446,400 148,800 111,600 86,800 97,960 $496,000 155,000 124,000 93,000 105,400 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...

  • Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...

    Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: February January Sales $370,800 $412,000 Direct materials purchases 123,600 128,750 Direct labor 92,700 103,000 Manufacturing overhead 77,250 72,100 Selling and administrative expenses 81,370 87,550 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...

  • Ivanhoe Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....

    Ivanhoe Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $414,000 $460,000 Direct materials purchases 138,000 143,750 Direct labor 103,500 115,000 Manufacturing overhead 80,500 86,250 Selling and administrative expenses 90,850 97,750 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...

  • Nigh Corporation prepares monthly cash budgets. Relevant data from operating budgets for 2017 Prepare cash bodget...

    Nigh Corporation prepares monthly cash budgets. Relevant data from operating budgets for 2017 Prepare cash bodget (LO 4) AP P21-3A follow: February January $400,000 $350,000 120,000 80,000 70,000 79,000 130,000 100,000 Sales Direct materials purchases Direct labour Manufacturing overhead Selling and administrative expenses 75,000 81,000 Budgetary Planning All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month followie the sale, and 20% in the second month following the sale....

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