Question
Maynard Company has prepared the following schedules and additional information (Click the icon to view the cash receipts schedule.) (Click the loon to view the
Maynard Company has prepared the following schedules and additional information (Click the icon to view the cash receipts schedule.) (Click the loon to view the additional information.) (Click the icon to view the cash payments schedule.) Complete a cash budget for Maynard Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round at amounts entered into the cash budget to the nearest w dollar. Enter a cash deficiency with a minus sign or parentheses.) Maynard Company Cash Budget Beginning cash balance January, February, and March January Cash receipts Cash available Cash payments Purchases of direct materials Direct labor Enter any number in the edit fields and then click Check Answer parts remaining Clear All Check Answer dollar. Enter a cash deficiency with a minus sign or parentheses.) Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before fi nancing Minimum cash balance desired Projected cash excess (defi ciency) Financing: Borrowing Principal repayments - Enter any number in the edit fields and then click Check Answer. Toutes, End any 2816 balances. Round all amounts entered into the cash budget to the 3 parts remaining Clear All Check Answe Click the icon to view the cash receipts schedule.) (Click the icon to view the additional information.) (Click the icon to view the cash payments schedule.) 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 dollar. Enter a cash deficiency with a minus sign or parenthes Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (defi ciency) Financing: Borrowing Principal repayments Total effects of financing Ending cash balance More Info 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 11% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Enter any number in the edit fields and then click Check Answer. Print Done 3 parts remaining Clear All Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor Rece January February March Total $ 0 S 3,800 $ 3,900 3,800 3,900 $ 7,700 3,500 3,300 4,500 11,300 Manufacturing Overhead: Utibes for plant 720 720 1,440 Property taxes on plant 2,400 2,400 Total payments for manufacturing overhead 2,400 720 720 3,840 Selling and Administrative Expenses Uses for office Property taxes on office Office salaries Total payments for Selling and Admin, expenses Total cash payments 480 460 920 2,160 2.160 2.500 2,500 2,500 7,500 4,600 2,960 2,960 10,580 $ 10,560 $ 10,700 s 12,000 $ 33,420 Acccount balances, March 31: Prepaid Property Taxes $ 3,420 Accounts Payable $ 4.300 Usities Payable $ 1.180 ce 2,160 2,160 2,500 2,500 2,500 7,500 T 12/20/2020 COL Cash Receipts from Customers Ol Total sales Cash Receipts from Customers: Reference January February March Total $ 11,500 $ 11,300 $ 13,400 $ 36,200 January February March Total pots Accounts Receivable balance, January 11 January-Cash sales $ 8,050 rom 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 1,725 $ 1,725 7,910 1,695 $ 1,695 9,380 March-Credit sales, collection of March sales in March 2,010, Total cash receipts from customers $ 9.775 $ 11,330 $ 13,085 $ 34,190 from Accounts Receivable balance, March 31: vable March-Credit sales, collection of March sales in Apri $ 2,010 sales it sale it sale sh sale edit sal edit sal sales
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started