Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Maynard Company has prepared the following schedules and additional information: Complete a cash budget for Maynard Company for January, February and March. (Complete all input

Maynard Company has prepared the following schedules and additional information:

Complete a cash budget for Maynard Company for January, February and March. (Complete all input fields. 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.)

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

Cash Receipts from Customers Total Total sales January February March $ 10,600 $ 13,800 $ 16,300 $ January February March 40,700 Total $ 7,420 1,590 $ 1,590 Cash Receipts from Customers: Accounts Receivable balance, January 1 JanuaryCash sales JanuaryCredit sales, collection of January sales in January JanuaryCredit sales, collection of January sales in February February-Cash sales FebruaryCredit sales, collection of February sales in February February-Credit sales, collection of February sales in March MarchCash sales March-Credit sales, collection of March sales in March 9,660 2,070 $ 2,070 11,410 2,445 15,925$ $ 9,010 $ 13,320$ 38,255 Total cash receipts from customers Accounts Receivable balance, March 31: MarchCredit sales, collection of March sales in April $ 2,445 January February March Total $ 0 Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February FebruaryDirect material purchases paid in March Total payments for direct materials $ 4,000 3,700 0 4,000 3,700$ 7,700 Direct Labor: Total payments for direct labor 3,300 3,300 4,500 11,100 640 640 1,280 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 1,200 1,200 1,200 640 640 2,480 460 460 920 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 1,440 1,440 3,500 4,940 3,500 3,500 3,960 10,500 12,860 3,960 $ 9,440 $ 11,900 $ 12,800 $ 34,140 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 1,980 4,000 $ 1,100 Maynard's beginning cash balance is $4,500 and Maynard desires to maintain a minimum ending cash balance of $4,500. 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 9% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Maynard Company Cash Budget January, February, and March January February Beginning cash balance $ 4,500 Cash receipts 9,010 Cash available 13,510 Cash payments: Purchases of direct materials 0 Direct labor 3,300 Manufacturing overhead 1,200 Selling and administrative expenses 4,940 Interest expense Total cash payments 9,440 4,070 (4,500) (430) Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Total effects of financing 1,000 0 1,000 $ 5,070 Ending cash balance

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

GAO Financial Audit Manual Volume 1 Updated April 2020

Authors: United States Government GAO

2020 Edition

B091PR8396, 979-8733135977

More Books

Students also viewed these Accounting questions

Question

@ describe some of the benefits of e-commerce to buyers

Answered: 1 week ago