Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April $30$ is given below:

Minden Company

Balance Sheet

April $30$

The company is in the process of preparing a budget for May and has assembled the following data:

a$.$ Sales are budgeted at $$254,000$ for May. Of these sales, $$76,200$ will be for cash; the remainder will be credit sales. One$-$half of a month's credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April $30$ accounts receivable will be collected in May.

b$.$ Purchases of inventory are expected to total $$137,000$ during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the April $30$ accounts payable to suppliers will be paid during May.

c$.$ The May $31$ inventory balance is budgeted at $$45,000,$

d$.$ Selling and administrative expenses for May are budgeted at $$98,400,$ exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $$5,550$ for the month.

e$.$ The note payable on the April $30$ balance sheet will be paid during May, with $$350$ in interest. $($All of the interest relates to May.$)$

f$.$ New refrigerating equipment costing $$8,700$ will be purchased for cash during May.

g$.$ During May, the company will borrow $$27,400$ from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.

Required:

Calculate the expected cash collections from customers for May.

Calculate the expected cash disbursements for merchandise purchases for May.

Prepare a cash budget for May.

Prepare a budgeted income statement for May.

Prepare a budgeted balance sheet as of May $31.$

Answer is complete but not entirely correct.

Complete this question by entering your answers in the tabs below.

Req $1$ and $2$

Req $3$

Req $4$

Req $5$

Prepare a budgeted income statement for May.

$\backslash$table$[[$Minden Company$],[$Budgeted Income Statement$],[$For the Month of May,,$],[$Sales$,,254,000],[$Cost of goods sold,,$124,750],[$Gross margin,,$129,250],[$Selling and administrative expenses,,$(92,850)$