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
-
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...
-
Assuming a 12% annual interest rate, determine the present value of a five-period annual annuity of $6.200 under each of the following situations: Note: Use tables, Excel, or a financial calculator....
-
Medrano Ltd is a furniture manufacturer. The company is looking at three alternative specialised machines to replace its existing production line. Data for each of the machines are as follows. The...
-
You will receive $6,800 three years from now. The discount rate is 10 percent. a. What is the value of your investment two years from now? Multiply $6,800 .909 (one years discount rate at 10...
-
Campbell Corporation expects to incur indirect overhead costs of $167,475 per month and direct manufacturing costs of $15 per unit. The expected production activity for the first four months of the...
-
Farber Corporation uses a job-order costing system. The information below is from the financial records of the company for last year: Total manufacturing costs $2,500,000 Cost of goods manufactured...
-
PEM, Incorporated, is experiencing financial difficulty due to erratic sales of its only product, a high-capacity battery for laptop computers. The company's contribution format income statement for...
-
Assignment 1 requires you to calculate joint probabilities and to develop a decision tree based on the hypothetical stock prices for the major US banks provided in the dataset provided for this...
-
Larned Corporation recorded the following transactions for the just completed month. a. Purchased $80,000 of raw materials on account. b. $71,000 in raw materials were used in production. Of this...
-
Sheffield manufactures a fine wine in two departments, Fermenting and Bottling. In the Fermenting Department, grapes are aged in casks for a period of 30 days. In the Bottling Department, the wine is...
-
A house in Finland has 280 m2 of walls constructed of panels of the type shown in Figure 1. The wood is pine and the insulation has thermal conductivity kins = 0.07 W/m.K. A central heating system...
-
Go to the links below and Write a creative and effective paper on Middlesex Hospital http://healthitsecurity.com/news/patient-privacy-violated-following-employee-theft-in-oregon;...
-
Express these numbers in standard notation. a. 2.87 10-8 b. 1.78 1011 c. 1.381 10-23
-
For the original concrete composite post design of Problem 1.13, assume that the steel rods are made of 4340 steel, and that the rods are to be replacedby IM9 carbon fiber bundles of the same length...
-
Using an example of static equilibrium of an element in pure two-dimensional (2D) shear stress, prove that the shear stresses are symmetric (i.e., prove that \(\sigma_{i j}=\sigma_{j i}\) when \(i eq...
-
A representative section from a composite lamina is shown in Figure 2.7 along with the transverse stress and strain distributions across the fiber and matrix materials in the section. The composite...
Study smarter with the SolutionInn App