Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete a cash budget for Graham Company for January, February, and March. (Complete all answer boxes. Enter a 0 for any zero balances. Round all
Complete a cash budget for Graham Company for January, February, and March. (Complete all answer boxes. 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.)
CAN SOMEONE HELP ME PLS?? I NEED THE ANSWER FOR THREE MONTHS January, February, and March.
i Reference Cash Receipts from Customers Total sales January February March $ 15,800 $ 12,200 $ 10,500||$ January February March Total 38,500 Total Cash Receipts from Customers: Accounts Receivable balance, January 1 JanuaryCash sales 9,480 3,160 January-Credit sales, collection of January sales in January $ 3,160 7,320 2,440 January-Credit sales, collection of January sales in February FebruaryCash 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 $ 2,440 6,300 2,100 10,840 $ $ 12 12,640 $ 12,920 $ Total cash receipts from customers 36,400 Accounts Receivable balance, March 31: MarchCredit sales, collection of March sales in April $ 2,100 Print Done Reference - X January February March Total Cash Payments $ 0 Direct Materials: Accounts Payable balance, January 1 JanuaryDirect material purchases paid in February FebruaryDirect material purchases paid in March $ 3,900 $ 4,200 4,200 $ Total payments for direct materials 3,900 8,100 Direct Labor: Total payments for direct labor 3,300 3,400 4,100 10,800 Manufacturing Overhead: Utilities for plant 440 440 880 2,400 Property taxes on plant Total payments for manufacturing overhead 2,400 2,400 140 440 3,280 Selling and Administrative Expenses: Utilities for office 350 350 700 Print Done Selling and Administrative Expenses: Utilities for office Property taxes on office 350| 350|| 700 1,560 Office salaries 1,560 6,500 8,060 6,5 6,500 Total payments for Selling and Admin. expenses 6,850 6,850 19,500 21,760 Total cash payments $ 13,760 $ 14,590 $ 15,590 $ 43,940 Acccount balances, March 31: Prepaid Property Taxes Accounts Payable $ $ $ 2,970 4,600 790 Utilities Payable More Info 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. Print Done Graham 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 Selling and administrative expenses Interest expense 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 balanceStep 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