Question: Required ABCDE: please show show work so i can understand. table [ [ batance sneet September 3 0 ] , [ Assets ] ,

Required ABCDE: please show show work so i can understand.
\table[[batance sneet September 30],[Assets],[Cash,$ 69,800],[Accounts receivable,98,000],[Inventory,37,800],[Buildings and equipment, net of depreciation,310,000],[Total assets,$ 515,600],[Liabilities and Stockholders' Equity],[Accounts payable,$ 145,100],[Common stock,216,000],[Retained earnings,154,500],[Total liabilities and stockholders' equity,$ 515,600]]
The company is in the process of preparing a budget for October and assembled the following data:
Sales are budgeted at $280,000 for October and $290,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% are 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 $80,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $3,100 for the month.
. Assume the following changes to the underlying budgeting assumptions:
50% of a month's credit sales are collected in the month the sales are made and the remaining 50% are collected in the following month
The ending merchandise inventory is always 10% of the following month's cost of goods sold
20% of all purchases are paid for in the month of purchase and 80% are paid for in the following month.
Using these new assumptions, calculate or prepare the following for October:
a. The budgeted cash collections.
b. The budgeted merchandise purchases.
c. The budgeted cash disbursements for merchandise purchases.
d. Net operating income.
e. An end-of-month budgeted balance sheet.
Prepare a budgeted balance sheet at October 31. Assume that 50% of a month's credit sales are collected in the month the sales are made and the remaining 50% is collected in the following month, (2) the ending merchandise inventory is always 10% of the following month's cost of goods sold, and (3)20% of all purchases are paid for in the month of purchase and 80% are paid for in the following month.
Show less A
\table[[Wheeling Company],[Balance Sheet],[October 31],[Assets,],[,],[,],[,],[,],[,],[,],[Total assets,$ 0],[Liabilities and Stockholders' Equity,],[,]]
Complete this question by entering your answers in the tabs below.
\table[[Required 1A,Required 1B,Required 1C,Required 1D,Required 1E,Required 2 A,Required 2C,Required 2D,Required 2E],[Prepare the budgeted cash collections for October. Assume that 50% of a month's credit sales are collected in the month the sales are made and the remaining 50% is collected in the following month, (2) the ending merchandise inventory is always 10% of the following month's cost of goods sold, and (3)20% of all purchases are paid for in the month of purchase and 80% are paid for in the following month.],[Show less A],[Budgeted cash collections for October],[]]
e. An end-of-month budgeted balance sheet.
Complete this question by entering your answers in the tabs below.
Required 1 A
Required 1B
Required 1C
Required 1D
Required 1E
Required 2 A
Required 2B
Required 2 C
Required 2D
Required 2E
Prepare the budgeted merchandise purchases for October. Assume that 50% of a month's credit sa2. Assume the following changes to the underlying budgeting assumptions:1.50% of a month's credit sales are collected in the month the sales are made and the remaining 50% are collected in the followingmonth2. The ending merchandise inventory is always 10% of the following month's cost of goods sold3.20% of all purchases are paid for in the month of purchase and 80% are paid for in the following month.Using these new assumptions, calculate or prepare the following for October:a. The budgeted cash collections.b. The budgeted merchandise purchases.c. The budgeted cash disbursements for merchandise purchases.d. Net operating income.e. An end-of-month budgeted balance sheet.
Required ABCDE: please show show work so i can

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!