Question

Bramble Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January...

Bramble Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January February Sales $ 361,300 $ 401,400 Purchases 120,400 132,000 Salaries 83,000 81,100 Administrative expenses 70,200 73,600 Selling expenses 80,000 87,400 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,000 of depreciation per month. Other data. 1. Collections from customers: January $ 333,800; February $ 378,000. 2. Payments for purchases: January $ 102,600; February $ 142,300. 3. Other receipts: January: collection of December 31, 2016, notes receivable $ 18,700; February: proceeds from sale of securities $ 5,700. 4. Other disbursements: February $ 12,500 cash dividend. The company’s cash balance on January 1, 2017, is expected to be $ 48,700. The company wants to maintain a minimum cash balance of $ 63,330. Prepare a cash budget for January and February

Homework Answers

Answer #1

Cash budget for the month of January & February

Particulars January February
A Beginning Cash balance 48700
Cash receipts :
B Collection from customer 333800 378000
C . Notes received realized in cash 18700 0
D . Proceeds from sale of securities 0 5700
E. Cash available (A+B+C+D) 401200 450100
Cash payment :
F . Payment for purchases 102600 142300
G . Salaries 83000 81100
H. Administrative exp 69200 (70200-1000) 72600 (73600-1000)
I . Selling exp 80000 87400
J. Cash dividend 0 12500
K . Total cash payments (F+G+H+I+J) 334800 395900
L Cash balance after paying all exp. 66400 54200
M Min. Required balance 63330 63330
N Total borrowing required (M-L)[ignore negative value] - 9130
Know the answer?
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
Similar Questions
Bramble Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January...
Bramble Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January February Sales $ 361,300 $ 401,400 Purchases 120,400 132,000 Salaries 83,000 81,100 Administrative expenses 70,200 73,600 Selling expenses 80,000 87,400 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,000 of depreciation per month. Other data. 1. Collections from customers: January $...
Marigold Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January...
Marigold Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January February Sales $360,400 $401,700 Purchases 121,900 131,000 Salaries 83,000 81,600 Administrative expenses 71,700 74,300 Selling expenses 78,400 86,600 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,100 of depreciation per month. Other data. 1. Collections from customers: January $336,800; February $378,600. 2....
Blue Spruce Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017....
Blue Spruce Corp. prepares monthly cash budgets. Here are relevant data from operating budgets for 2017. January February Sales $360,700 $401,100 Purchases 121,500 131,400 Salaries 84,600 81,000 Administrative expenses 71,000 73,700 Selling expenses 79,000 86,900 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 $328,100;February $378,200. 2....
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: January February Sales $375,120 $416,800 Direct materials purchases 125,040 130,250 Direct labor 93,780 104,200 Manufacturing overhead 72,940 78,150 Selling and administrative expenses 82,318 88,570 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 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $ 432,000 $ 480,000 Direct materials purchases 144,000 150,000 Direct labor 108,000 120,000 Manufacturing overhead 84,000 90,000 Selling and administrative expenses 94,800 102,000 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...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $360,000 $400,000 Direct materials purchases 120,000 125,000 Direct labor 90,000 100,000 Manufacturing overhead 70,000 75,000 Selling and administrative expenses 79,000 85,000 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...
Problem 23-4A Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are...
Problem 23-4A Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:        January        February Sales       $375,840       $417,600 Direct materials purchases       125,280       130,500 Direct labor       93,960       104,400 Manufacturing overhead       73,080       78,300 Selling and administrative expenses       82,476       88,740 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale,...
Danner Company expects to have a cash balance of $59,040 on January 1, 2017. Relevant monthly...
Danner Company expects to have a cash balance of $59,040 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $111,520, February $196,800. Payments for direct materials: January $65,600, February $98,400. Direct labor: January $39,360, February $59,040. Wages are paid in the month they are incurred. Manufacturing overhead: January $27,552, February $32,800. These costs include depreciation of $1,968 per month. All other overhead costs are paid as incurred....
Wildhorse Company expects to have a cash balance of $63,300 on January 1, 2017. These are...
Wildhorse Company expects to have a cash balance of $63,300 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $88,300, February $163,300. 2. Payments to suppliers: January $57,300, February $92,300. 3. Wages: January $31,740, February $41,740. Wages are paid in the month they are incurred. 4. Administrative expenses: January $22,740, February $25,740. These costs include depreciation of $1,000 per month. All other costs are paid as...
Oriole Company expects to have a cash balance of $57,550 on January 1, 2017. These are...
Oriole Company expects to have a cash balance of $57,550 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $82,550, February $157,550. 2. Payments to suppliers: January $51,550, February $86,550. 3. Wages: January $30,850, February $40,850. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,850, February $24,850. These costs include depreciation of $1,000 per month. All other costs are paid as...