To prepare a master budget for January, February, and March, use the following information.

a$.$ The company's single product is purchased for $$30$ per unit and resold for $$58$ per unit. The inventory level of $4,750$ units on December $31$ is more than management's desired level, which is $20\%$ of the next month's budgeted sales units. Budgeted sales are January, $6,500$ units; February, $9,000$ units; March, $11,000$ units; and April, $10,000$ units. All sales are on credit.

b$.$ Cash receipts from sales are budgeted as follows: January, $$233,100$; February, $$722,857$; March, $$519,245.$

c$.$ Cash payments for merchandise purchases are budgeted as follows: January, $$65,000$; February, $$311,300$; March, $$141,600.$

d$.$ Sales commissions equal to $20\%$ of sales dollars are paid each month. Sales salaries $($excluding commissions$)$ are $$6,500$ per month.

e$.$ General and administrative salaries are $$11,000$ per month. Maintenance expense equals $$1,900$ per month and is paid in cash.

f$.$ New equipment purchases are budgeted as follows: January, $$40,800$; February, $$96,000$; and March, $$26,400.$ Budgeted depreciation expense is January, $$6,925$; February, $$7,925$; and March, $$8,200.$

g$.$ The company budgets a land purchase at the end of March at a cost of $$170,000,$ which will be paid with cash on the last day of the month.

h$.$ The company has an agreement with its bank to obtain additional loans as needed. The interest rate is $1\%$ per month and interest is paid at each month$-$end based on the beginning$-$month balance. Partial or full payments on these loans are made on the last day of the month. The company maintains a minimum ending cash balance of $$21,000$ at the end of each month.

i$.$ The income tax rate for the company is $37\%.$ Income taxes on the first quarter's income will not be paid until April $15.$

Prev

$1$ of $1$

Next

Required $1$

Budgeted balance sheet as of March $31.$

Note: Round your final answers to the nearest whole dollar.

Prev

$1$ of $1$

Next