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 Common stock Accounts payable Retained earnings Total liabilities and stockholders' equity $ 70,600 118,000 51,300 244,000 $ 483,900 $ 119,900 216,000 148,000 $ 483,900 The company is in the process of preparing a budget for October and assembled the following data: 1. Sales are budgeted at $380,000 for October and $390,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. 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 $79,600, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,440 for the month. Required: 1. Using the information provided, 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. The budgeted net operating income. e. An-end-of-month budgeted balance sheet. 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% are collected in the following month 2. The ending merchandise inventory is always 10% of the following month's cost of goods sold 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 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. Complete this question by entering your answers in the tabs below. 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 Common stock Accounts payable Retained earnings Total liabilities and stockholders' equity $ 70,600 118,000 51,300 244,000 $ 483,900 $ 119,900 216,000 148,000 $ 483,900 The company is in the process of preparing a budget for October and assembled the following data: 1. Sales are budgeted at $380,000 for October and $390,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. 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 $79,600, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,440 for the month. Required: 1. Using the information provided, 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. The budgeted net operating income. e. An-end-of-month budgeted balance sheet. 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% are collected in the following month 2. The ending merchandise inventory is always 10% of the following month's cost of goods sold 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 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. Complete this question by entering your answers in the tabs below.
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Using the original information provided a Budgeted Cash Collections Cash Sales in October 380000 35 133000 Credit Sales in October 380000 65 ... 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...
-
Write a detailed executive summary about the appropriation and advancement of Information and Communication Technology (ICT)
-
In your own words, define dog fooding. Do you think dog fooding is likely to predict product success? Why or why not? When would dog fooding not predict product success?
-
In a co-flowing (same direction) heat exchanger 1 kg/s air at 500 K flows into one channel and 2 kg/s air flows into the neighboring channel at 300 K. If it is infinitely long what is the exit...
-
Which method of estimating uncollectible receivables focuses on net credit sales? a. Aging approach b. Percent-of-sales approach C. Net realizable value approach d. All of the above
-
Clover Dairy Products Corp. buys one input, full-cream milk, and refines it in a churning process. From each gallon of milk Clover produces three cups of butter and nine cups of buttermilk. During...
-
1. A common saying in our culture is to "forgive and forget." Do you think that this is possible, and if so, is it desirable? Why, or why not? 2. Can anything be forgiven, in your view? Why or why...
-
Some simple way to manage your estate and reduce costs Question 29 options: prepay your phone bill prepay your funeral prepay your mortgage prepay your credit
-
In transonic airfoil flow, how to control the strength and stability of shock wave on the upper airfoil?
-
What is the concept of entropy and why is dq/T a function of state?
-
Explain the physical phenomenon that the total temperature of a system remains unchanged and the total pressure decreases. Explain a physical phenomenon in which the total temperature and total...
-
Please point out the main measures to increase the drag divergence Mach number?
-
What is the Mach wave when passing through the compression angle? Why does the Mach wave line converge?
-
Define and compare and contrast the UCR, NIBRS, and the National Crime Victimization Survey. How does each system serve a purpose in collecting and reporting data? What is their value in fighting...
-
Stephen Schor, an accountant in New York City, advised his client, Andre Romanelli, Inc., to open an account at J. P. Morgan Chase Bank, N.A., to obtain a favorable interest rate on a line of credit....
-
For a long time, you have been wondering how to convert your passion for rock climbing into a business opportunity. During a recent climbing trip you met Chris, a climbing-gear designer. He agreed to...
-
Continuing the worked exercise above, make the necessary adjustments for the following transactions: (a) On day 3, Mobius Inc invests $500 of cash by acquiring a new computer. (b) On day 4, Mobius...
-
State which of the following items could appear as an asset on the statement of financial position of Goblin Combe plc, a leading premium drinks business: \($150,000\) of product sold during the...
Study smarter with the SolutionInn App