Question: What would be the answer for Jan,Feb and March please Graham Company has prepared the following schedules and additional information: (Click the icon to view

What would be the answer for Jan,Feb and March please

What would be the answer for Jan,Feb and March please Graham Companyhas prepared the following schedules and additional information: (Click the icon to

view the cash receipts schedule.) (Click the icon to view the cash

Graham Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information) Complete a cash budget for Graham Company for January, February and March (Complete al input fields. Enter a "o" for - X Reference January February March Total Cash Payments $ Graham Company Cash Budget January, February, and March January February $ 3,500 9,180 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 $ 3.700 $ 4,200 Beginning cash balance Cash receipts ol 3,700 4,200 $ 7,900 12.680 Direct Labor: Total payments for direct labor 0 3.500 3,800 4,200 11,500 3,500 3,000 7,660 440 440 880 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 0 3,000 Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing 3.000 14.160 3,000 440 440 3,880 (1.480) (3,500) 630 630 (4.980) 1.260 Selling and Administrative Expenses: Utilities for office Property taxes on office Office salaries Total payments for Seling and Admin. expenses 2,160 2. 160 5,000 5,500 16,500 5,500 7,660 5,500 6,130 0 6,130 19,920 Principal repayments Total effects of financing Ending cash balance 5,000 $ 3.520 Print Done Enter any number in the edit fields and then click Check Answer Graham Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information) Complete a cash budget for Graham Company for January, February and March (Complete al input fields. Enter a "o" for - X Reference 0 Total payments for direct materials 3,700 4,2005 7,900 Direct Labor Total payments for direct labor 3,500 3,800 4,200 11,500 Graham Company Cash Budget January, February, and March January February $ 3,500 9,180 440 440 880 Beginning cash balance Cash receipts Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,000 12.680 3,000 3,000 440 440 3,880 0 630 630 1.260 3,500 3,000 7,660 Selling and Administrative Expenses: Uties for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 2. 160 2.160 5,500 0 Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing 5,500 5,500 6,130 16.500 19,920 7,660 6,130 14.160 (1.480) (3,500) Total cash payments S 14,160 $ 14,070 $ 14,970 S 43,200 (4.980) $ 3,870 Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 4,600 5,000 0 $ 1,070 Principal repayments Total effects of financing Ending cash balance 5,000 $ 3.520 Print Done Enter any number in the edit fields and then click Check Answer Graham Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the cash payments schedule.) (Click the icon to view the additional information) Complete a cash budget for Graham Company for January, February and March. (Complete al input fields. Enter a "O" 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.) - X Reference Graham Company Cash Budget January, February, and March January February $ 3,500 9,180 Cash Receipts from Customers Beginning cash balance Cash receipts Total 12.680 Total sales January February March $ 10,800 $ 10,100 S $ 13.400$ January February March 34 300 Total More Info 0 3,500 3,000 7,660 $ 7,560 1,620 Cash available Cash payments: Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Graham's beginning cash balance is $3,500 and Graham desires to maintain a minimum ending cash balance of $3,500. Graham 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. 0 $ 14.160 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 March-Credit sales, collection of March sales in March 1,620 7.070 (1.480) (3,500) 1,515 S 1.515 Print Print Done (4.980) 9.380 5,000 2,010 12.905$ $ 9,180 $ Total cash receipts from customers 10,205 S 32 290 0 Principal repayments Total effects of financing Ending cash balance 5,000 $ 3.520 Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April $ 2,010 Enter any number in the edit fields and then click Check

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!