Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mason Company has prepared the following schedules and additional information: (Click the icon to view the cash receipts schedule.) (Click the icon to view the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Mason 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 Mason Company for January, February and March. (Complete all input fields. 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.) Reference Mason's beginning cash balance is $9,000 and Mason desires to maintain a minimum ending cash balance of $9,000. Mason 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. \begin{tabular}{|c|c|c|c|c|} \hline & January & Fobruary & March & Total \\ \hline \multicolumn{5}{|l|}{ Cash Payments } \\ \hline \multicolumn{5}{|l|}{ Direct Materials: } \\ \hline Accounts Payable balance, January 1 & 0 & & & \\ \hline January - Direct material purchases paid in February & & 4,000 & & \\ \hline Fobruary - Direct material purchases paid in March & & & 4,000 & \\ \hline Total payments for direct materials & 0 & 4,000 & 4,000 & 8,000 \\ \hline Direct Labor: & 4 & & & \\ \hline Total payments for direct labor & 3,000 & 3,500 & 4,000 & 10,500 \\ \hline \multicolumn{5}{|l|}{ Manufacturing Overhead: } \\ \hline Utilities for plant & & 550 & 550 & 1,100 \\ \hline Property taxes on plant & 3,720 & & WI & 3.720 \\ \hline Total payments for manufacturing overhead & 3,720 & 550 & 550 & 4,820 \\ \hline \end{tabular} Mason 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 Mason Company for January, February and March. (Complete all input fields. 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.) Reference Mason's beginning cash balance is $9,000 and Mason desires to maintain a minimum ending cash balance of $9,000. Mason 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. \begin{tabular}{|c|c|c|c|c|} \hline & January & Fobruary & March & Total \\ \hline \multicolumn{5}{|l|}{ Cash Payments } \\ \hline \multicolumn{5}{|l|}{ Direct Materials: } \\ \hline Accounts Payable balance, January 1 & 0 & & & \\ \hline January - Direct material purchases paid in February & & 4,000 & & \\ \hline Fobruary - Direct material purchases paid in March & & & 4,000 & \\ \hline Total payments for direct materials & 0 & 4,000 & 4,000 & 8,000 \\ \hline Direct Labor: & 4 & & & \\ \hline Total payments for direct labor & 3,000 & 3,500 & 4,000 & 10,500 \\ \hline \multicolumn{5}{|l|}{ Manufacturing Overhead: } \\ \hline Utilities for plant & & 550 & 550 & 1,100 \\ \hline Property taxes on plant & 3,720 & & WI & 3.720 \\ \hline Total payments for manufacturing overhead & 3,720 & 550 & 550 & 4,820 \\ \hline \end{tabular}

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions