Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Vaughn Company expects to have a cash balance of $44,100 on January 1,2022 . Relevant monthly budget data for the first 2 months of 2022

image text in transcribedimage text in transcribed Vaughn Company expects to have a cash balance of $44,100 on January 1,2022 . Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $83,300, February $147,000. Payments for direct materials: January $49,000, February $73,500. Direct labor: January $29,400, February $44,100. Wages are paid in the month they are incurred. Manufacturing overhead: January $20,580, February $24,500. These costs include depreciation of $1,470 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $14,700, February $19,600. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11,760 in cash. Vaughn Company has a line of credit at a local bank that enables it to borrow up to $24,500. The company wants to maintain a minimum monthly cash balance of $19,600. Prepare a cash budget for January and February. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & & & & \multicolumn{2}{|c|}{ January } & \multicolumn{2}{|r|}{ Febr } \\ \hline \multicolumn{2}{|c|}{ Beginning Cash Balance } & & & $ & 44,100 & $ & \\ \hline Add & Receipts & & & & & & \\ \hline \multicolumn{2}{|c|}{ Collections from Customers } & & & & 83,300 & & \\ \hline \multicolumn{2}{|c|}{ Sale of Marketable Securities } & & & & 11,760 & & \\ \hline \multicolumn{2}{|c|}{ Total Receipts } & & & & 139,160 & & \\ \hline \multicolumn{2}{|c|}{ Total Available Cash } & & & & & & \\ \hline Less & Disbursements & & & & & & \\ \hline \multicolumn{2}{|c|}{ Direct Materials } & & & & & & \\ \hline \multicolumn{2}{|l|}{ Direct Labor } & & & & & & \\ \hline \multicolumn{2}{|c|}{ Manufacturing Overhead } & & & & & & \\ \hline \multicolumn{2}{|c|}{ Selling and Administrative Expenses } & & & & & & \\ \hline \multicolumn{2}{|c|}{ Total Disbursements } & & & & & & \\ \hline \multicolumn{3}{|c|}{ Excess (Deficiency) of Available Cash Over Cash Disbursements } & & & & & \\ \hline \multicolumn{2}{|l|}{ Financing } & & & & & & \\ \hline Add & Borrowings & & & & & & \\ \hline Less & Repayments & & & & & & \\ \hline Ending Cash & ance & & & $ & & $ & \\ \hline \end{tabular}

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

Managerial Accounting

Authors: James Jiambalvo

4th edition

9780470546888, 9780470333341, 470546883, 470333340, 978-0470578797

More Books

Students also viewed these Accounting questions