Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 77,800 134,000 62,100 284,000 $ 557,900 $ 225,900 216,000 116,000 $ 557,900 The company is in the process of preparing a budget for October and has assembled the following data: 1. Sales are budgeted at $460,000 for October and $470,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. 2. 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. 3. 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. 4. Selling and administrative expenses for October are budgeted at $81,400, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,840 for the month. Required: 1. 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. 2. 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% 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. Using these new assumptions, 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. Net operating income for the month of October. e. A budgeted balance sheet at October 31. 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 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 77,800 134,000 62,100 284,000 $ 557,900 $ 225,900 216,000 116,000 $ 557,900 The company is in the process of preparing a budget for October and has assembled the following data: 1. Sales are budgeted at $460,000 for October and $470,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. 2. 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. 3. 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. 4. Selling and administrative expenses for October are budgeted at $81,400, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,840 for the month. Required: 1. 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. 2. 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% 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. Using these new assumptions, 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. Net operating income for the month of October. e. A budgeted balance sheet at October 31.
Expert Answer:
Answer rating: 100% (QA)
To calculate the budgeted amounts and prepare the budgeted balance sheet we will follow the given information ... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
MGS Company reports the following for its 2023 operations: Sales Revenue: Cash Sales Credit Sales Accounts Receivable $1,200,000 300,000 150,000 Allowance for Doubtful Accounts 3,000 Debit Prepare...
-
Obtain the forces in members 1 to 10 of the truss system given below in terms of P. State whether they are in tension or compression. Give your answers as S,S2... S10. Don't change the numbering of...
-
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 $ 59,000 Accounts receivable 90,000...
-
Dream House Builders, Inc. applies overhead by linking it to direct labor. At the start of the current period, management predicts total direct labor costs of $100,000 and total overhead costs of...
-
Shockley Co. reported the following amounts in its financial statements: In making the physical counts of inventory, the following errors were made: Inventory on December 31, 2014: understated...
-
Webster Company has compiled the information shown in the following table. a. Calculate the weighted average cost of capital using book value weights. b. Calculate the weighted average cost of...
-
Explain the concept of depreciation. - Depreciation is the process of allocating the cost of a tangible depreciable capital asset to expense over the asset's useful life. - Depreciation is not an...
-
Due to changing economic conditions and to making its financial statements more comparable to those of other companies in its industry, the management of Kelsea Inc. decided on January 1, 2011, to...
-
(2 points) Consider the following trig function k(t) = -46 cos(6x + ) + 125 What is the maximum and minimum values of this function? Find an angle in [0, ) Maximum Angles that this occurs Minimum...
-
Over 1,200 bull riders from around the world are members of Professional Bull Riders (PBR) and compete in the more than 300 PBR affiliated bull riding events per year. This data set includes...
-
You buy an 8y bond that has par value of $1000, a YTM of 6% and a 5% coupon (paid annually). In a year, after the YTM declines to 4% and you also get your first coupon payment, you sell the bond....
-
A 2.50 g sample of copper (Cs copper = 0.385 J/(g C)) that had been heated to 200. C was placed in a flexible container with an initial volume of 1.5 L and an initial temperature of 25 C that was...
-
The yield curve for default-free zero-coupon bonds is currently as follows: Maturity YTM 1 10% 2 11% 3 12% Assume that the expectation hypothesis is correct. What are the implied 1-year rates in...
-
What is the concept of teamwork. Why is it important in supply chain/logistics? What are some best practices associated with teamwork? Elaborate with examples
-
The E.N.D. partnership has the following capital balances as of the end of the current year: Pineda Adams Fergie Gomez Total capital $ 130,000 110,000 100,000 90,000 $430,000 5 Answer each of the...
-
CASE ANALYSIS Read and analyze the case and answer the requirements below. 1. Jesse is a trainee accountant in his second year of training within a small practice. A more senior trainee has...
-
(8%) Problem 6: A student attaches a f= 3.5 kHz oscillator to one end of a metal rail of length L = 25 m. The student turns on the oscillator and uses a piezoelectric gauge at the other end to...
-
Explain what is meant by feedforward control and distinguish it from feedback control. R-1
-
Computing Ending Balance of Retained Earnings LO1-1 Sultan Inc. was organized on January 1, 2020. It reported the following for its first two years of operations: Required: Compute the ending balance...
-
What is meant by a variance? What is the point in analysing variances? R-2
Study smarter with the SolutionInn App