Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I only provided table for January but please do the same thing for ffebruary march and total Cash Receipts from Customers January February March Total

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed I only provided table for January but please do the same thing for ffebruary march and total

Cash Receipts from Customers January February March Total Total sales $ 12,600 $ 14,600||$ 11,100 $ 38,300 January February March Total Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales $ 10,080 1,260 $ 1,260 11,680 January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March-Cash sales March-Credit sales, collection of March sales in March 1,460 $ 1.460 8,880 1,110 $ 10,080 1,260 $ 1,260 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 February-Cash sales February-Credit sales, collection of February sales in February February--Credit sales, collection of February sales in March March-Cash sales 11,680 1,460 $ 1,460 8.880 1.110 March-Credit sales, collection of March sales in March $ 11,340||$ 14,400||$ 11,450 $ 37,190 Total cash receipts from customers Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April $ 1,110 X More Info W Maynard's beginning cash balance is $6,000 and Maynard desires to maintain a minimum ending cash balance of $6,000. Maynard 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 14% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done January February March Total Cash Payments $ 0 Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March $ 3,000 $ 3,800 0 3,000 3,800 $ 6,800 Total payments for direct materials Direct Labor: Total payments for direct labor 3,100 3,700 4,300 11,100 Manufacturing Overhead: Utilities for plant Property taxes on plant 850 850 1,700 1,680 1.680 1.680 1.680 Property taxes on plant Total payments for manufacturing overhead 1,680 850 850 3,380 460 460 920 1,680 1,680 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 5,000 5,000 15,000 5,000 5,460 6,680 5,460 17,600 $ 11,460||$ 13,010 | $ 14,410||$ 38,880 Total cash payments $ 2,520 Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 4,390 $ 1,310 Maynard Company Cash Budget January, February, and March January Beginning cash balance Cash receipts Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Complete a cash budget for Maynard Company for January, February and March (Complete all input fields. Enter a "O" for any zero balances. Round nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses) Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Total effects of financing Ending cash balance Enter any number in the edit fields and then click Check

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

Management Accounting Principles And Applications

Authors: Hugh Coombs, D Ellis Jenkins, David Hobbs

1st Edition

1412908434, 978-1412908436

More Books

Students also viewed these Accounting questions

Question

OUTCOME 2 Describe how a training needs assessment should be done.

Answered: 1 week ago