$($I am asked to provide the solutions in Excel, Please try to make the answers clear thank you$)$ The company is in the process of preparing a budget for May and has assembled the following data:

a$.$ Sales are budgeted at $$200,000$ for May. Of these sales, $$60,000$ 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 $$120,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 $$40,000.$

d$.$ Selling and administrative expenses for May are budgeted at $$72,000,$ exclusive of depreciation.

These expenses will be paid in cash. Depreciation is budgeted at $$2,000$ for the month.

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

the interest relates to May.$)$

f$.$ New refrigerating equipment costing $$6,500$ will be purchased for cash during May.

g$.$ During May, the company will borrow $$20,000$ 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:

Prepare a cash budget for May. Support your budget with a schedule of expected cash collections from

sales and a schedule of expected cash disbursements for merchandise purchases.

Prepare a budgeted income statement for May. Use the absorption costing income statement format as

shown in Schedule $9.$

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