Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i Reference Marlin Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to

image text in transcribedimage text in transcribedimage text in transcribed

i Reference Marlin 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.) January February March Total Complete a cash budget for M More Info Cash payments: Purchases of direct materi Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Direct labor $ 3,400 Marlin's beginning cash balance is $9,000 and Marlin desires to maintain a minimum ending cash balance of $9,000. Marlin 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 13% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Manufacturing overhead Selling and administrative $ 3,700 3,700$ 3,400 7,100 Total payments for direct materials Interest expense Direct Labor: Total cash payments Ending cash balance before fi Print Done Total payments for direct labor 3,300 3,400 4,100 10,800 Minimum cash balance desired Manufacturing Overhead: Projected cash excess (deficiency) Financing: Borrowing Utilities for plant 750 750 1,500 3,600 Property taxes on plant Total payments for manufacturing overhead 3,600 5,100 Principal repayments 3,600 750 750 Total effects of financing Selling and Administrative Expenses: Ending cash balance Marlin 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.) January February March $ 10,800 $ 11,300 $ 11,100 $ January February March Total 33,2 Total sales Complete a cash budget for Marlin Company. (Complete all answer boxes. Enter a "0" for any zero balances. Round a Total Cash payments: Purchases of direct materials Cash Receipts from Customers: Accounts Receivable balance, January 1 $ Direct labor Manufacturing overhead Selling and administrative expenses 8,640 1,080 $ Interest expense 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 1,080 9,040 1,130 Total cash payments Ending cash balance before financing $ Minimum cash balance desired Projected cash excess (deficiency) 1,130 8,880 1,110 11,120$ March-Credit sales, collection of March sales in March Financing: $ 9,720 $ 11,250 $ 32,0 Total cash receipts from customers Borrowing Principal repayments Accounts Receivable balance, March 31: Total effects of financing March-Credit sales, collection of March sales in April $ 1,110 Ending cash balance brint one Print Marlin Company has prepared the following schedules and additional information: Click the icon to view the cash receipts schedule.) 3 (Click the icon to view the cash payments schedule.) A (Click the icon to view the additional information.) Complete a cash budget for Marlin Company. (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 deficie Marlin Company Cash Budget January, February, and March January February March Total Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing

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

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, Maureen Sterling

7th Canadian Edition

1260065952, 978-1260065954

More Books

Students also viewed these Accounting questions