Homework: M 5 Homework Question 5, EM5-28 (similar to) HW Score: 48.62%, 15.56 of 32 points E Save - X Marcel Company has prepared the followi Reference (Click the icon to view the cash receiv (Click the icon to view the additional Cash Receipts from Customers Complete a cash budget for Marcel Comp January February March Total et to the nearest whole dollar. Enter a cash deficiency with a minus sign or paret Total sales 10,800 $ 10, 100 $ 10,400 $ 31,300 January February March Total Selling and administrative expenses Cash Receipts from Customers: Interest expense Accounts Receivable balance, January 1 Total cash payments January-Cash sales 6.480 Ending cash balance before financing January-Credit sales, collection of January sales in January 2, 160 S Minimum cash balance desired January-Credit sales, collection of January sales in February 2, 160 Projected cash excess (deficiency) February-Cash sales 6,060 Financing: February-Credit sales, collection of February sales in February 2,020 Borrowing February-Credit sales, collection of February sales in March $ 2,020 Principal repayments March-Cash sales 6,240 Total effects of financing Ending cash balance Print Done Help me solve this Etext pay- Hear all Check answer O 67'F Mostly cloudy ~ D 07:33 AM Type here to search 20 02/06/22i (Click the icon to view the additional info January February March Total Complete a cash budget for Marcel Compan Cash Payments dget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parenth Direct Materials: Accounts Payable balance, January 1 S 0 Selling and administrative expenses January-Direct material purchases paid in February 3,100 Interest expense February-Direct material purchases paid in March S 3,600 Total payments for direct materials 3,100 3,600 $ 5,700 Total cash payments Ending cash balance before financing Minimum cash balance desired Direct Labor: Projected cash excess (deficiency) Total payments for direct labor 2,500 3,500 4,400 10,400 Financing: Borrowing Manufacturing Overhead: Principal repayments Utilities for plant 720 720 1,440 Total effects of financing Ending cash balance Print Done Help me solve this Etext page Clear all Check answer Type here to search 20 67'F Mostly cloudy ~ D: 07:34 AM 02/06/22Do Homework - M 5 Homework B - Graded - Google Chrome - X mathxl.com/Student/PlayerHomework.aspx?homeworkld=617984321&questionld=3&flushed=false&cld=68317288centerwin=yes ACG2071 ref 688517 Franchelle Navarro 02/06/22 7:34 AM (@ E Homework: M 5 Homework Question 5, EM5-28 (similar to) HW Score: 48.62%, 15.56 of 32 points Save X Marcel Company has prepared the following Reference (Click the icon to view the cash receipts i (Click the icon to view the additional info Property taxes on plant 4,200 4,200 Total payments for manufacturing overhead 4.200 720 720 5.640 Complete a cash budget for Marcel Compan dget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parenth Selling and Administrative Expenses: Utilities for office 450 450 900 Selling and administrative expenses Property taxes on office 1.560 1.560 Interest expense Office salaries 4,000 4,000 4,000 12,000 Total cash payments Total payments for Selling and Admin. expenses 5,560 4,450 4,450 14,460 Ending cash balance before financing Minimum cash balance desired 12,260 $ $ 37,200 Total cash payments 11,770 13, 170 $ Projected cash excess (deficiency) Acccount balances, March 31: Financing: Prepaid Property Taxes $ 4,320 Borrowing Accounts Payable $ 5,000 Principal repayments 1 470 Total effects of financing Ending cash balance Print Done Help me solve this Etext page Clear all Check answer Type here to search O 67'F Mostly cloudy 07:35 AM 02/06/22Do Homework - M 5 Homework B - Graded - Google Chrome Close mathxl.com/Student/PlayerHomework.aspx?homeworkld=617984321&questionld=3&flushed=false&cld=68317288centerwin=yes ACG2071 ref 688517 Franchelle Navarro 02/06/22 7:35 AM ? E Homework: M 5 Homework Question 5, EM5-28 (similar to) HW Score: 48.62%, 15.56 of 32 points Save X Marcel Company has prepared the following Reference (Click the icon to view the cash receipts i (Click the icon to view the additional info Total payments for manufacturing overhead 4,200 720 720 5,640 Complete a cash budget for Marcel Compan dget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parenth Selling and Administrative Expenses: Utilities for office 450 450 900 Property taxes on office 1,560 1.560 Selling and administrative expenses Office salaries 4,000 4.000 4.000 12,000 Interest expense Total payments for Selling and Admin. expenses 5,560 4,450 4,450 14,460 Total cash payments Ending cash balance before financing 12,260 Total cash payments $ 11,770 $ 13,170 $ 37,200 Minimum cash balance desired Projected cash excess (deficiency) Acccount balances, March 31: Financing: Prepaid Property Taxes $ 4,320 5.000 Borrowing Accounts Payable Utilities Payable $ Principal repayments 1,170 Total effects of financing Ending cash balance Print Done Help me solve this Etext page Clear all Check answer O 67'F Mostly cloudy 07:35 AM Type here to search 02/06/22Do Homework - M 5 Homework B - Graded - Google Chrome - X mathxl.com/Student/PlayerHomework.aspx?homeworkld=617984321&questionld=3&flushed=false&cld=68317288centerwin=yes ACG2071 ref 688517 Franchelle Navarro 02/06/22 7:35 AM ? E Homework: M 5 Homework B - Graded Question 5, EM5-28 (similar to) HW Score: 48.62%, 15.56 of 32 points Part 1 of 4 Save Points: 0 of 6 Marcel Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) i (Click the icon to view the additional information.) Complete a cash budget for Marcel Company for January, Feb d into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) - X More info Selling and administrative expenses 5 Marcel's beginning cash balance is $5,500 and Marcel desires to maintain a Interest expense minimum ending cash balance of $5,500. Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts Total cash payments 12 borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 11% per year. Interest is paid Ending cash balance before financing at the beginning of the month on the outstanding balance from the previous month. Minimum cash balance desired (5, Projected cash excess (deficiency) (3 Financing: Print Done Borrowing Principal repayments Total effects of financing Ending cash balance Help me solve this Etext pages Get more help - Clear all Check answer O 67'F Mostly cloudy 07:35 AM Type here to search gi 02/06/22a cash budget for Marcel Comp January-Cash sales $ 6,480 et to the nearest whole dollar. Enter a iency with a minus sign or parer January-Credit sales, collection of January sales in January 2,160 January-Credit sales, collection of January sales in February S 2, 160 February-Cash sales 6,060 and administrative expenses February-Credit sales, collection of February sales in February 2,020 it expense February-Credit sales, collection of February sales in March 2,020 payments March-Cash sales 6,240 sh balance before financing March-Credit sales, collection of March sales in March 2,080 cash balance desired Total cash receipts from customers 8,640 $ 10,240 $ 10,340 $ 29,220 cash excess (deficiency) ving Accounts Receivable balance, March 31: $ al repayments March-Credit sales, collection of March sales in April 2,080 cts of financing sh balance Print Done ne solve this Etext pay- fear all Check answer 67'F Mostly cloudy ~ 0 07:34 AM Type here to search MO 02/06/22