Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

0 Graham Company has prepared the following schedules and additional information (Chok the icon to view the cash receipts schedule) (Click the icon to view

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
0 Graham Company has prepared the following schedules and additional information (Chok 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 all input fields Enter a "O" for any zero balances Round all amounts entered into budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses) Manutacturing overhead Selling and administrative expenses 7.160 Interestepenso 12.460 Total cash payments Ending cash balance before financing (6,000) Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Totects of financing Ending cash balance 0 Graham Company has prepared the following schedules and additional information (Chok 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 all input fields Enter a "O" for any zero balances Round all amounts entered into budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses) Manutacturing overhead Selling and administrative expenses 7.160 Interestepenso 12.460 Total cash payments Ending cash balance before financing (6,000) Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Totects of financing Ending cash balance 2.400 2,400 Property taxes on plant Total payments for manufacturing overhead 2,400 450 450 3,300 650 650 Selling and Administrative Expenses: Utilities for office Property taxes on office Olice salaries Total payments for Selling and Admin. expenses 2. 160 5,000 1,300 2,160 15,000 18,460 5,000 5,000 5,650 7,160 5,650 S 12.460 $ 13,500 5 40,060 14,100 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 3.420 4,300 $ 5 1.100 Print Done TEXTOges e eference February March January Total Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March $ 3.600 5 4,400 4,400 3,600 8,000 Total payments for direct materials Direct Labor: Total payments for direct labor 2.900 3,800 3,600 10,300 Manufacturing Overhead: Utilities for plant 450 450 900 Print Done Text Toges OK mework B -eference lere $ 8640 1080 100 Accounts Receivable balance January 1 January-Cash sales JanuaryCredit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credits collection of February sales in February Februar-Create Collection of February sale in Mich Marc Cash sales March-Credits collection of Marches in March Total cash receipts from customers 1610 1510 350 1.110 9.720 515 570 11500 S 36 890 5 10 Accounts Receivable balance, March 31: Matic - Credits coedion och sales in or Print Done mm Cages OK More Info Graham's beginning cash balance is $6,000 and Graham desires to maintain a minimum ending cash balance of $6,000. 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 17% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done then click Check Answer Pages Get More Help - 0 Graham Company has prepared the following schedules and additional information (Chok 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 all input fields Enter a "O" for any zero balances Round all amounts entered into budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses) Manutacturing overhead Selling and administrative expenses 7.160 Interestepenso 12.460 Total cash payments Ending cash balance before financing (6,000) Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Totects of financing Ending cash balance 0 Graham Company has prepared the following schedules and additional information (Chok 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 all input fields Enter a "O" for any zero balances Round all amounts entered into budget to the nearest whole dollar Enter a cash deficiency with a minus sign or parentheses) Manutacturing overhead Selling and administrative expenses 7.160 Interestepenso 12.460 Total cash payments Ending cash balance before financing (6,000) Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Principal repayments Totects of financing Ending cash balance 2.400 2,400 Property taxes on plant Total payments for manufacturing overhead 2,400 450 450 3,300 650 650 Selling and Administrative Expenses: Utilities for office Property taxes on office Olice salaries Total payments for Selling and Admin. expenses 2. 160 5,000 1,300 2,160 15,000 18,460 5,000 5,000 5,650 7,160 5,650 S 12.460 $ 13,500 5 40,060 14,100 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ 3.420 4,300 $ 5 1.100 Print Done TEXTOges e eference February March January Total Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March $ 3.600 5 4,400 4,400 3,600 8,000 Total payments for direct materials Direct Labor: Total payments for direct labor 2.900 3,800 3,600 10,300 Manufacturing Overhead: Utilities for plant 450 450 900 Print Done Text Toges OK mework B -eference lere $ 8640 1080 100 Accounts Receivable balance January 1 January-Cash sales JanuaryCredit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credits collection of February sales in February Februar-Create Collection of February sale in Mich Marc Cash sales March-Credits collection of Marches in March Total cash receipts from customers 1610 1510 350 1.110 9.720 515 570 11500 S 36 890 5 10 Accounts Receivable balance, March 31: Matic - Credits coedion och sales in or Print Done mm Cages OK More Info Graham's beginning cash balance is $6,000 and Graham desires to maintain a minimum ending cash balance of $6,000. 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 17% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done then click Check Answer Pages Get More Help

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_2

Step: 3

blur-text-image_3

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

Accounting Understanding And Practice

Authors: Robert Perks

4th Edition

0077139135, 978-0077139131

More Books

Students also viewed these Accounting questions

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

Briefly explain the advantages of 'Management by Objectives'

Answered: 1 week ago