Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help with all tasks please all the information is there so don't comment that it needs more info if it does need more

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedi need help with all tasks please all the information is there so don't comment that it needs more info if it does need more info comment what it needs.

Homework: Chapter 22 Homework Save 15 of 15 (12 complete) HW Score: 51.21%, 15.36 of 30 pts Score: 0 of 5 pts E22-28 (similar to) Reference 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 ca (Click the icon to view the additional information.) January February March Total Complete a cash budget for Marcel Company for January, February and March. (Complete cash deficiency with a minus sign or parentheses.) Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February FebruaryDirect material purchases paid in March $ Marcel Company Cash Budget January, February, and March January 3,800 $ 3,800 | 3,700 3,700 $ 7,500 Total payments for direct materials Direct Labor: Total payments for direct labor 2,500 3,300 3,500 9,300 Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Manufacturing Overhead: Utilities for plant 550 550 1,100 Enter any number in the edit fields and then click Check Answer. Print Done 3 parts remaining Clear All Check Answer Score: 0 of 5 pts 15 of 15 (12 complete) HW Score: 51.21%, 15.36 of 30 pts E22-28 (similar to) - X i Reference Property taxes on plant 3,720 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 ca A (Click the icon to view the additional information.) Complete a cash budget for Marcel Company for January, February and March. (Complete cash deficiency with a minus sign or parentheses.) 3,720 3,720 Total payments for manufacturing overhead 5501 4.820 Selling and Administrative Expenses: 630 630 Marcel Company Cash Budget January, February, and March January Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 2.160 5,000 7,160|| 1,260 2160 2,160 15,000 18,420 5,000 5,000 5,630|| L 5,630|| Beginning cash balance $ 13,380 $ 13,280 S Total cash payments 13,380 $ 40,040 Cash receipts Cash available Cash payments Purchases of direct materials Acccount balances, March 31: Prepaid Property Taxes Accounts Payable $ $ 4,410 4,600 Enter any number in the edit fields and then click Check Answer. Print Done 3 parts 5 remaining Clear All Check Answer E22-28 (similar to) Reference 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 ca (Click the icon to view the additional information.) Total payments for manufacturing overhead 3,720 550 550 4,820 Complete a cash budget for Marcel Company for January, February and March (Complete cash deficiency with a minus sign or parentheses.) 630 630 1,260 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Marcel Company Cash Budget January, February, and March January 2,160 5,000 7,160 5,000 5,000 5,630 2,160 15,000 18,420 Total payments for Selling and Admin. expenses 5,630 13,380 || 3,2801 13,380 $ 40,040 Beginning cash balance Cash receipts Cash available Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable Cash payments: Purchases of direct materials $ $ $ 4,410 4,600 1,180 nilah- Enter any number in the edit fields and then click Check Answer. Print Done parts E22-28 (similar to) Question Help 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.) (Click the icon to view the additional information.) Complete a cash budget for Marcel Company for January, February and March. (Complete all answer boxes. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Cash payments: i More Info Purchases of direct materials Direct labor Manufacturing overhead Marcel's beginning cash balance is $9,000 and Marcel desires to maintain a Selling and administrative expenses minimum ending cash balance of $9,000. Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts Interest expense borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 12% per year. Interest is paid Total cash payments at the beginning of the month on the outstanding balance from the previous month. Ending cash balance before financing Minimum cash balance desired Print Done Projected cash excess (deficiency) Enter any number in the edit fields and then click Check Answer. 3 parts Clear All Check Answer Score: 0 of 5 pts 15 of 15 (12 complete) HW Score: 51.21%, 15.36 of 30 pts E22-28 (similar to) Reference 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 ca (Click the icon to view the additional information.) Total sales Complete a cash budget for Marcel Company for January, February and March. (Complete cash deficiency with a minus sign or parentheses.) January February March $ 11,200 $ 14,600 $ 12,800 $ January February March Total 38,600 Total $ Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments 1 8,960 ,120|| $ L Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February FebruaryCash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March MarchCash sales March-Credit sales, collection of March sales in March 1.120| 11,680 1,460 $ 1,460 Total effects of financing 10,240 Ending cash balance 1,280 Enter any number in the edit fields and then click Check Answer. Print Done 3 parts remaining Score: 0 of 5 pts 15 of 15 (12 complete) HW Score: 51.21%, 15.36 of 30 pts E22-28 (similar to) Reference 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 ca A (Click the icon to view the additional information.) $ Complete a cash budget for Marcel Company for January, February and March. (Complete cash deficiency with a minus sign or parentheses.) 8,960 1,120 $ Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February FebruaryCash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March MarchCash sales March-Credit sales, collection of March sales in March 1,120 11,680 1,460 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing $ 1,460 10,240 1,280 12,980$ $ 10,080$ 14,260 $ 37,320 Total cash receipts from customers Principal repayments Total effects of financing Ending cash balance Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April $ 1,280 Enter any number in the edit fields and then click Check Answer. Print Done 3 parts remaining

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools For Business Decision-Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

2nd Canadian Edition

0470833378, 978-0470833377

More Books

Students also viewed these Accounting questions