Total sales $ 11,500 $ 16.100 5 13,400 $ January February March 41,000 Total rest whole dollar Enter a cash Cash Receipts from Customers: Accounts Receivable balance, January 1 $ 9.200 1.150 $ 1.150 12,880 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-Crect sales collection of February sales in March March-Cash sales March-Creat sales collection of March sales in March 1.610 $ 1610 10.720 1340 10 350 S 15,640 $13.670 $ S 39,650 Total cash receipts from customers January February March Total Fel nearest Cash Payments Direct Materials: -. s 0 Accounts Payable balance. January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March s edge sy, & 3,400 en 4,100 4,100 $ 0 inua 3,400 7,500 Total payments for direct materials Direct Labor 2,700 3.100 3,900 9,700 Total payments for direct labor Manufacturing Overhead: Untities for plant 450 450 900 wory w Total payments for manufacturing overhead 3,000 450 450 3,900 Selling and Administrative Expenses: 240 240 480 1,920 Utilities for office Property taxes on office Office salaries Total payments for Selling and Admin. expenses 1.920 4,500 6,420 4,500 4.740 4,500 4,740 13,500 15,900 $ 12,120$ 11,690 $ 13,190 S 37,000 Total cash payments Acccount balances, March 31: Prepaid Property Taxes Accounts Payable Utilities Payable $ $ 3.690 4.900 690 $ on view the cash payments schedule.) (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to More Info - X Jayson's beginning cash balance is $6,000 and Jayson desires to maintain a minimum ending cash balance of $6,000. Jayson 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 15% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Print Done Jayson Company has prepared the following schedules and additional formation lok the icon to the choice (ix the icon to view the cash as schedule Cache tow the adultono) Comecast for ayson Company Fry and Much Computer for any othered into the cast to the earth canh delency was ignorante Anary February and March February March To Beginning Cance Cine Canin payment Padre Dred Mandong Being and content En any numbe in the and the contenu 11:30 AM Selling and administrative expenses 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 balance
