Can you help me with this problem. So far none of the tutor can get it right. Please compute the cash budget for January and February in columnar form.
?
Student | St X Unit 6: Chap X WileyPLUS X y! Prepare a cc X *Chapter 21 X C Prepare A C X C Prepare A C X + X -) C edugen.wileyplus.com/edugen/Iti/main.uni AD Apps Bookmarks a Amazon.com y! Yahoo eBay f Facebook YouTube Please Log Into My. Course Hero Consumer Toolkit -... WileyPLUS Kimmel, Accounting, 6e Help | System Announcements CALCULATOR PRINTER VERSION BACK NEXT ASSIGNMENT RESOURCES AC202 - Chapter 21 Problem 21-4A (Part Level Submission) Assignment Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: Problem 21-2A (Part Level Submission) January February Problem 21-3A (Part Level Submission) Sales $390,960 $434,400 Problem 21-4A (Part Direct materials purchases 130,320 135,750 Level Submission) Direct labor 97,740 108,600 Exercise 21-20 (Part Level Submission) Manufacturing overhead 76,020 81,450 Problem 21-6A (Part Selling and administrative expenses 85,794 92,310 Level Submission) 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 Review Score the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the Review Results by Study balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and Objective administrative expenses that include $1,086 of depreciation per month. Other data: 1. Credit sales: November 2016, $271,500; December 2016, $347,520. 2. Purchases of direct materials: December 2016, $108,600. 3. Other receipts: January-Collection of December 31, 2016, notes receivable $16,290; EEEEEE O WileyPLUS - . Topic: Unit 6:. Document1 -.. Desktop 6:51 PM 9/21/2020Student | St X Unit 6: Chap X WileyPLUS X y! Prepare a cc X *Chapter 21 X C Prepare A C X C Prepare A C X + X -) C edugen.wileyplus.com/edugen/Iti/main.uni AD Apps Bookmarks a Amazon.com y! Yahoo meBay f Facebook YouTube Please Log Into My. Course Hero Consumer Toolkit -... WileyPLUS Kimmel, Accounting, 6e Help | System Announcements CALCULATOR PRINTER VERSION 1 BACK NEXT ASSIGNMENT RESOURCES 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 AC202 - Chapter 21 the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the Assignment balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and Problem 21-2A (Part administrative expenses that include $1,086 of depreciation per month. Level Submission) Problem 21-3A (Part Other data: Level Submission) Problem 21-4A (Part 1. Credit sales: November 2016, $271,500; December 2016, $347,520. Level Submission) 2. Purchases of direct materials: December 2016, $108,600. Exercise 21-20 (Part 3, Level Submission) Other receipts: January-Collection of December 31, 2016, notes receivable $16,290; Problem 21-6A (Part February-Proceeds from sale of securities $6,516. Level Submission) 4. Other disbursements: February-Payment of $6,516 cash dividend. Review Score The company's cash balance on January 1, 2017, is expected to be $65,160. The company wants to maintain a minimum cash balance of Review Results by Study $54,300. Objective (e) Your answer is correct. https://edugen.wileyplus.com/edugen/Iti/Itiheadenuni#les for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and WileyPLUS - . Topic: Unit 6:. Document1 -.. Desktop O 6:52 PM 9/21/2020Student | St X Unit 6: Chap X WileyPLUS X y! Prepare a cc X *Chapter 21 X C Prepare A C X C Prepare A C X + X -) C edugen.wileyplus.com/edugen/Iti/main.uni AD Apps Bookmarks a Amazon.com y! Yahoo eBay Facebook YouTube Please Log Into My. Course Hero Consumer Toolkit -... WileyPLUS Kimmel, Accounting, 6e Help | System Announcements CALCULATOR PRINTER VERSION BACK NEXT ASSIGNMENT RESOURCES AC202 - Chapter 21 (a) Assignment Problem 21-2A (Part Your answer is correct. Level Submission) Problem 21-3A (Part Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases for January and Level Submission) February. Problem 21-4A (Part Level Submission) Expected Collections from Customers Exercise 21-20 (Part Level Submission) January February Problem 21-6A (Part V Level Submission) November 54,300 Review Score December 104256 69504 Review Results by Study Objective January 195480 117288 February 217200 Total collections 354036 403992 EEEEEE WileyPLUS - . Topic: Unit 6:. Document1 -... BEBEEE Desktop 6:53 PM 9/21/2020Student | St X Unit 6: Chap X WileyPLUS X y! Prepare a cc X *Chapter 21 X C Prepare A C X C Prepare A C X + X -) C edugen.wileyplus.com/edugen/Iti/main.uni AD Apps Bookmarks a Amazon.com y! Yahoo meBay Facebook YouTube Please Log Into My. Course Hero Consumer Toolkit -... WileyPLUS Kimmel, Accounting, 6e Help | System Announcements CALCULATOR PRINTER VERSION BACK NEXT ASSIGNMENT RESOURCES Total collections 354036 403992 AC202 - Chapter 21 Assignment Problem 21-2A (Part Expected Payments for Direct Materials Level Submission) Problem 21-3A (Part January February Level Submission) Problem 21-4A (Part December 43440 Level Submission) Exercise 21-20 (Part Level Submission) January 78192 52128 Problem 21-6A (Part V Level Submission) February 81450 Review Score Total payments 121632 133578 Review Results by Study Objective Click if you would like to Show Work for this question: Open Show Work SHOW ANSWER LINK TO TEXT VIDEO: SIMILAR PROBLEM EEEEEE Topic: Unit 6:. Document1 -.. Desktop > 6:54 PM 9/21/2020Student | St X Unit 6: Chap X WileyPLUS X y! Prepare a cc X *Chapter 21 X C Prepare A C X C Prepare A C X + X $3 S Cling TO edugen.wileyplus.com/edugen/Iti/main.uni O X AD Contro : Apps New Bookmarks a Amazon.com Full Shot y! Yahoo eBay f Facebook YouTube Please Log Into My... Course Hero Snipping Color : Consumer Toolkit -.. Custom WileyPLUS Kimmel, Accounting, 6e Help | System Announcements CALCULATOR PRINTER VERSION 1 BACK NEXT ASSIGNMENT RESOURCES AC202 - Chapter 21 Total Disbursements Assignment Problem 21-2A (Part Excess (Deficiency) of Available Cash Over Cash Disbursements Level Submission) Problem 21-3A (Part Total Available Cash Level Submission Problem 21-4A (Part Add Borrowings Level Submission) Exercise 21-20 (Part Level Submission) Less Repayments Problem 21-6A_(Part Level Submission) Ending Cash Balance COBRA $ Review Score Click if you would like to Show Work for this question: Open Show Work Review Results by Study Objective LINK TO TEXT VIDEO: SIMILAR PROBLEM Attempts: 0 of 3 used SAVE FOR LATER SUBMIT ANSWER EEEEEE WileyPLUS - . Topic: Unit 6:. 9 Document1 -. BEE Desktop 6:55 PM 9/21/2020
