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
Please fill in the red boxes Pronghorn Corp prepares monthly cash budgets. Here are relevant data from operating budget...
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 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: 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: 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 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 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. 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: 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.
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 (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....