90.2K

Verified Solution

Link Copied!

please help

Armand Company has prepared the following schedules and additional information Click the loon 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 cah budget for Armand Company for January February and March (Complete all input fields. Enter a "o for any zero balances. Round all amounts entered into the cash budget to the nearest while dollar. Enter a cash deficiency with a minus sign or parentheses) S Armand Company Cash Budget January, February, and March January Beginning cash balance Cash receipts Cash availablo Cash payments Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Inhas AAA Cash Receipts from Customers Total Total sales January February March $ 10,600 $ 12,300 $ 13,400 $ January February March 36,300 Total $ 7,420 1,590 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 $ 1,590 8,610 1,845 $ 1,845 March-Cash sales 9,380 March-Credit sales, collection of March sales in March 2,010 13,235$ $ 12,045$ 9,010 $ Total cash receipts from customers 34,290 ONDEN EMO2 emiar - X Reference January February March Total ng $ 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 $ 3,600 S 3,600 0 3,600 3,600 S 7,200 Direct Labor: Total payments for direct labor 2,600 3,600 3,500 9,700 550 550 1,100 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,720 3,720 3,720 550 550 4,820 Armand 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 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Beginning cash balance Cash receipts 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 Principal repayments Total effects of financing Ending cash balance ICICLUB Cash Receipts from Customers Total Total sales January February March $ 10,600 $ 12,300 $ 13,400 $ January February March 36,300 Total $ 7,420 1,590 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 $ 1,590 8.610 1,845 $ 1,845 9,380 March-Credit sales, collection of March sales in March 2,010 13,235 $ 9,010 $ 12,045 $ 34,290 Total cash receipts from customers Reference January February March Total Cash Payments Direct Materials: $ 0 Accounts Payablo balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March $ 3,600 $ 3,600 3,600 $ 3,600 7,200 Total payments for direct materials Direct Labor: Total payments for direct labor 2,600 3,600 3,500 9,700 550 550 1,100 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,720 3,720 3,720 550 550 4,820 More info Armand's beginning cash balance is $9,000 and Armand desires to mainfain a minimum ending cash balance of $9,000. Armand 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 Armand Company has prepared the following schedules and additional information Click the loon 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 cah budget for Armand Company for January February and March (Complete all input fields. Enter a "o for any zero balances. Round all amounts entered into the cash budget to the nearest while dollar. Enter a cash deficiency with a minus sign or parentheses) S Armand Company Cash Budget January, February, and March January Beginning cash balance Cash receipts Cash availablo Cash payments Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Inhas AAA Cash Receipts from Customers Total Total sales January February March $ 10,600 $ 12,300 $ 13,400 $ January February March 36,300 Total $ 7,420 1,590 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 $ 1,590 8,610 1,845 $ 1,845 March-Cash sales 9,380 March-Credit sales, collection of March sales in March 2,010 13,235$ $ 12,045$ 9,010 $ Total cash receipts from customers 34,290 ONDEN EMO2 emiar - X Reference January February March Total ng $ 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 $ 3,600 S 3,600 0 3,600 3,600 S 7,200 Direct Labor: Total payments for direct labor 2,600 3,600 3,500 9,700 550 550 1,100 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,720 3,720 3,720 550 550 4,820 Armand 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 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Beginning cash balance Cash receipts 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 Principal repayments Total effects of financing Ending cash balance ICICLUB Cash Receipts from Customers Total Total sales January February March $ 10,600 $ 12,300 $ 13,400 $ January February March 36,300 Total $ 7,420 1,590 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 $ 1,590 8.610 1,845 $ 1,845 9,380 March-Credit sales, collection of March sales in March 2,010 13,235 $ 9,010 $ 12,045 $ 34,290 Total cash receipts from customers Reference January February March Total Cash Payments Direct Materials: $ 0 Accounts Payablo balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March $ 3,600 $ 3,600 3,600 $ 3,600 7,200 Total payments for direct materials Direct Labor: Total payments for direct labor 2,600 3,600 3,500 9,700 550 550 1,100 Manufacturing Overhead: Utilities for plant Property taxes on plant Total payments for manufacturing overhead 3,720 3,720 3,720 550 550 4,820 More info Armand's beginning cash balance is $9,000 and Armand desires to mainfain a minimum ending cash balance of $9,000. Armand 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

Answer & Explanation Solved by verified expert

See Answer