Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below is one of three questions i have been stuck on for 5 days now, i have one attempt left for each question and need

Below is one of three questions i have been stuck on for 5 days now, i have one attempt left for each question and need to get a 100 on each question because it is necessary for me to pass this class. Please help, I really will really appreciate it. Thank you.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Below is the screenshots of how the final answers for this question should look like since there are more steps that must be filled in.

image text in transcribedimage text in transcribedimage text in transcribed

Thank you !!!!

Homework: HW -Chapter 22 Save Score: 1.09 of 10 pts 15 of 16 (16 complete) HW Score: 87.29%, 139.67 of 160 pts 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.) Marcel Company Cash Budget January, February, and March January Beginning cash balance Cash receipts Cash available Cash payments Purchases of direct materials Enter any number in the edit fields and then click Check Answer, Clear AlI Check Answer Homework: HW - Chapte r 22 Save Score: 1.09 of 10 pts HW Score: 87.29%, 139.67 of 160 pts 15 of 16 (16 complete) Question Help NE22-28 (similar to) 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) Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before fic Minimum cash balance desired Projected cash excess (deficiency) Enter any number in the edit fields and then click Check Answer Clear All Check Answer Homework: HW - Chapter 22 Save Score: 1.09 of 10 pts HW Score: 87.29%, 139.67 of 160 pts 5 of 16 (16 complete) 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) Total cash payments Ending cash balance before fionancing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Total effects of Dfinancing Ending cash balance Enter any number in the edit tields and then click Check Answer Clear All Check Answer remaining Reference Cash Receipts from Customers ryMarch Total January Februa Total sales $ 11,200 $ 10,100$ 16,300$ 37,600 ryMarch Total January Februa Cash Receipts from Customers: unts Receivable balance, January 1 $8,960 January-Cash sales 1,120 January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February $ 1,120 February-Cash sales 8,080 1,010 February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March $ 1,010 March-Cash sales 13,040 Print Done Reference bruary March JanuaryFeb Total Cash Payments Direct Materials: ccounts Payable balance, January 1 January-Direct material purchases paid in February 3,200 Februa irect material purchases paid in March $ 4,300 3,200 4,300 S 7,500 Total payments for direct materials Direct Labor: 3,100 4,400 Total payments for direct labor 3,500 11,000 Manufacturing Overhead: 640 Utilities for plant 640 1,280- Print Done Reference Total payments for manufacturing overhead 640 3,680 2,400 640 Selling and Administrative Expenses: Utilities for office 1,300 650 650 2,160 Property taxes on office 2,160 5,000 Office salaries 5,000 5,000 15,000 7,160 Total payments for Selling and Admin. expenses 5,650 5,650 18,460 $13,060$12,590$ 14,990 $40,640 Total cash payments Acccount balances. March 31: 3,420 Prepaid Property Taxes Accounts Payable 4,100 Utilities Payable 1,290 PrintDone More Info 1 Marcel's beginning cash balance is $3,000 and Marcel desires to maintain a minimum ending cash balance of $3,000. Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is | available. The interest rate on amounts borrowed is 10% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month Print Done

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

Step: 3

blur-text-image

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

Microeconomics Theory And Applications

Authors: Edgar K. Browning, Mark A. Zupan

10th Edition

0470128917, 9780470128916

More Books

Students also viewed these Accounting questions

Question

Describe recruitment and selection for international operations.

Answered: 1 week ago