Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wheeling Company is a merchandiser that provided a balance sheet as of September 3 0 as shown below: Wheeling Company Balance Sheet September 3 0

Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below:
Wheeling Company
Balance Sheet
September 30
Assets
Cash $ 61,000
Accounts receivable 170,000
Inventory 86,400
Buildings and equipment, net of depreciation 249,000
Total assets $ 566,400
Liabilities and Stockholders Equity
Accounts payable $ 217,900
Common stock 216,000
Retained earnings 132,500
Total liabilities and stockholders equity $ 566,400
The company is in the process of preparing a budget for October and has assembled the following data:
Sales are budgeted at $640,000 for October and $650,000 for November. Of these sales, 35% will be for cash; the remainder will be credit sales. Forty percent of a months 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 months 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 $96,600, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,490 for the month.
Required:
Using the information provided, calculate or prepare the following:
The budgeted cash collections for October.
The budgeted merchandise purchases for October.
The budgeted cash disbursements for merchandise purchases for October.
The budgeted net operating income for October.
A budgeted balance sheet at October 31.
Assume the following changes to the underlying budgeting assumptions:
(1)50% of a months 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 months 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. Using these new assumptions, calculate or prepare the following:
The budgeted cash collections for October.
The budgeted merchandise purchases for October.
The budgeted cash disbursements for merchandise purchases for October.
Net operating income for the month of October.
A budgeted balance sheet at October 31.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles

Authors: Jerry Weygandt, Paul Kimmel, Donald Kieso

12th edition

1119132223, 978-1-119-0944, 1118875052, 978-1119132226, 978-1118875056

Students also viewed these Accounting questions

Question

Distinguish between sympathetic and forced vibration.

Answered: 1 week ago