Required information Required information

Tableau Dashboard Activity: Calculate and Communicate $8-2($Static$)[$Exercise $8-17$; LO$8-2,$ LO$8-3,$ LO$8-4,$

LO$8-9.$ LO$8-10]$

Wheeling Company is a merchandiser that provided a balance sheet as of September $30$ as shown below:

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

Sales are budgeted at $$240,000$ for October and $$250,000$ for November. Of these sales, $35\%$ will be for cash; the

remainder will be credit sales. Forty percent of a month's credit sales are collected in the month the sales are made,

and the remaining $60\%$ is collected in the following month. All of the September $30$ accounts receivable will be

collected in October.

The budgeted cost of goods sold is always $45\%$ of sales and the ending merchandise inventory is always $30\%$ of the

following month's cost of goods sold.

All merchandise purchases are on account. Thirty percent of all purchases are paid for in the month of purchase and

$70\%$ are paid for in the following month. All of the September $30$ accounts payable to suppliers will be paid during

October.

Selling and administrative expenses for October are budgeted at $$78,000,$ exclusive of depreciation. These expenses

will be paid in cash. Depreciation is budgeted at $$2,000$ for the month. Tableau Dashboard Activity $8-2($Static$)$ Part $1$

Required:

Using the information provided, calculate or prepare the following:

a$.$ The budgeted cash collections for October.

b$.$ The budgeted merchandise purchases for October.

c$.$ The budgeted cash disbursements for merchandise purchases for October.

d$.$ The budgeted net operating income for October.

e$.$ A budgeted balance sheet at October $31.$

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

Prepare the budgeted cash collections for October.

Tableau Dashboard Activity: Calculate and Communicate $8-2($Static$)[$Exercise $8-17$; LO$8-2,$ LO$8-3,$ LO$8-4,$

LO$8-9.$ LO$8-10]$

Wheeling Company is a merchandiser that provided a balance sheet as of September $30$ as shown below:

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

Sales are budgeted at $$240,000$ for October and $$250,000$ for November. Of these sales, $35\%$ will be for cash; the

remainder will be credit sales. Forty percent of a month's credit sales are collected in the month the sales are made,

and the remaining $60\%$ is collected in the following month. All of the September $30$ accounts receivable will be

collected in October.

The budgeted cost of goods sold is always $45\%$ of sales and the ending merchandise inventory is always $30\%$ of the

following month's cost of goods sold.

All merchandise purchases are on account. Thirty percent of all purchases are paid for in the month of purchase and

$70\%$ are paid for in the following month. All of the September $30$ accounts payable to suppliers will be paid during

October.

Selling and administrative expenses for October are budgeted at $$78,000,$ exclusive of depreciation. These expenses

will be paid in cash. Depreciation is budgeted at $$2,000$ for the month.Answer is complete but not entirely correct.

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

Required $1A$

Required $1$B

Required $1$C

Required $1$D

Required $1E$

Prepare a budgeted balance sheet at October $31.$