Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please calculate the borrowings for February and the total for February as well correctly and in return I will give thumb up Martin Company expects

please calculate the borrowings for February and the total for February as well correctly and in return I will give thumb up image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Martin Company expects to have a cash balance of $136,400 on January 1, 2020. Relevant monthly budget data for the first 2. months of 2020 are as follows: . . Collections from customers: January $248,200. February $434 200. Payments for direct materials: January $156,900, February $239,900 Direct labor: January $91,300, February $135,900. Wages are paid in the month they are incurred. Manufacturing overhead: January $63,000, February $75,800. These costs include depreciation of $5,100 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $44,200, February $59,000. These costs are exclusive of depreciation. They are paid as incurred Sales of marketable securities in January are expected to realize $36,500 in cash. Martin Company has a line of credit at the local bank that enables it to borrow up to $75,200. The company wants to maintain a minimum monthly cash balance of $59.000 Martin Company Cash Budget For the Months Ending February 2020 January $ 136400 Febr Beginning Cash Balance Add Receipts Collections from Customers > 248200 Sale of Securities 36500 Total Receipts 284700 Total Available Cash > 421100 Less Disbursements Direct Materials 4156900) Direct Labor > (91300) Manufacturing Overhead (57900) Selling and Administrative Expenses (44200) Total Disbursements 1350300 Excess (Deficiency of Available Cash over Cash Disbursements 701300 Financing Sale of Securities 36500 Total Receipts 284700 > Total Available Cash 421100 Disbursements Direct Materials > (156900) Direct Labor (91300) Manufacturing Overhead (57900) Selling and Administrative Expenses I (44200) Total Disbursements (350300) Excess (Deficiency of Available Cash over Cash Disbursements 70800 Financing Add: Borrowings O Repayments including interest 0 Ending Cash Balance $ 70800 Martin Company Cash Budget For the Months Ending February 2020 January February ish Balance 136400 $ 70800 Receipts from Customers 36500 0 ots 284700 434200 Me Cash 421100 505000 Disbursements als (156900) (239900) 1913001 (135900) ring Overhead (57900) (70700) Administrative Expenses > (44200) 159000) rements > (350300) (505500) lency of Available Cash over Cash Disbursements 70800 (500) from Customers 248200 434200 urities 36500 0 ots > 284700 434200 le Cash 421100 505000 Disbursements Erials (156900) (239900) (91300) (135900) ing Overhead (57900) (70700) Administrative Expenses (44200) 159000) sements (350300) (5055002 lency of Available Cash over Cash Disbursements 70800 (500) Borrowings 0 Repayments including interest Balance 70800 $ e Textbook and Media

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

Sustainability Accounting And Accountability

Authors: Matias Laine, Helen Tregidga, Jeffrey Unerman

3rd Edition

1032023104, 9781032023106

More Books

Students also viewed these Accounting questions

Question

Explain the concept of employment at will.

Answered: 1 week ago

Question

Discuss compensation for sales representatives.

Answered: 1 week ago

Question

Explain termination of employment.

Answered: 1 week ago