Question

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 are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,042 of depreciation per month. Other data: 1. Credit sales: November 2016, $260,500; December 2016, $333,440. 2. Purchases of direct materials: December 2016, $104,200. 3. Other receipts: January—Collection of December 31, 2016, notes receivable $15,630; February—Proceeds from sale of securities $6,252. 4. Other disbursements: February—Payment of $6,252 cash dividend. The company’s cash balance on January 1, 2017, is expected to be $62,520. The company wants to maintain a minimum cash balance of $52,100. Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and February. Prepare a cash budget for January and February in columnar form

Homework Answers

Answer #1

Answer .(AH)

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
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,...
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 $...
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....
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....
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....
All sales are on account. Collections are expected to be 50% in the month of sale,...
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 are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $1,000...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Prepare a cash budget for 2 months. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000.Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other...