The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: 7,400 19,600 Cash Accounts receivable Inventory Building and equipment, net Accounts payable $ 39,000 $ 126,000 $ 23,175 $ 150,000 $ 18,825 Common stock Retained earnings a. The gross margin is 25% of sales. b. Actual and budgeted sales data: $ 49,000 $ 65,000 $ 70,000 $ 95,000 $ 46,000 March (actual) April Мay June July c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. f. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,200 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $945 per month (includes depreciation on new assets). g. Equipment costing $1,400 will be purchased for cash in April. h. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: Using the preceding data: 1. Complete the schedule of expected cash collections. 2. Complete the merchandise purchases budget and the schedule of expected cash disbursements for merchandise purchases. 3. Complete the cash budget. 4. Prepare an absorption costing income statement for the quarter ended June 30. 5. Prepare a balance sheet as of June 30. The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: 7,400 19,600 Cash Accounts receivable Inventory Building and equipment, net Accounts payable $ 39,000 $ 126,000 $ 23,175 $ 150,000 $ 18,825 Common stock Retained earnings a. The gross margin is 25% of sales. b. Actual and budgeted sales data: $ 49,000 $ 65,000 $ 70,000 $ 95,000 $ 46,000 March (actual) April Мay June July c. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales. d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The accounts payable at March 31 are the result of March purchases of inventory. f. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,200 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $945 per month (includes depreciation on new assets). g. Equipment costing $1,400 will be purchased for cash in April. h. Management would like to maintain a minimum cash balance of at least $4,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Required: Using the preceding data: 1. Complete the schedule of expected cash collections. 2. Complete the merchandise purchases budget and the schedule of expected cash disbursements for merchandise purchases. 3. Complete the cash budget. 4. Prepare an absorption costing income statement for the quarter ended June 30. 5. Prepare a balance sheet as of June 30.
Expert Answer:
Answer rating: 100% (QA)
Answer to Part 1 Schedule of Expected Cash Collections April May June Quarter Cash Sales Collectio... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $8,000 Accounts receivable $20,000 Inventory $36,000...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: (a) The gross margin in 25% of sales (b) Actual and budgeted sales data: (c) Sales are 60%...
-
What constant should replace the question mark in this system so that the solution set is {(1, 1, 1)}? 2x - 3y + -5x + 2y z = 0 - 2 = x + y + 2z = ? 4 -4
-
Analyze the following events and complete the requirements. A. Yarber Industries purchased buildings costing $ 240,000 and land costing $ 190,000 by paying $ 43,000 in cash and signing a note payable...
-
In your experience, do younger individuals differ from older individuals in their plans to remain with one employer for a long time? Do you think these differences, if you believe they exist, are due...
-
Table B. 15 presents data on air pollution and mortality. Use the all-possibleregressions selection on the air pollution data to find appropriate models for these data. Perform a thorough analysis of...
-
A by- product of phosphate fertilizer production is pyrite waste, which contains arsenic and lead. From 1884 to 1906, seven phosphate fertilizer plants operated on a forty- three- acre operated on a...
-
Provide the solution below in A4 sheet. and i will give you upvote Given Data :- Ap = 1777 mm 2. As 2 = 500 mm A's = 314 mm 2 fpk = 1700 MPa fp 0,1k 1530 MPa fy = 400 MPa Pre tensioned 900x500 mm...
-
You are a profitable conglomerate thinking about getting into the gelati business by acquiring the firm Alati Gelati (AG). Current info for you, AG and their similar comp is listed below. You...
-
Organizational Ethics is extremely important to the success of any organization. In your MBA program you learned about globalization, sustainability, and technology. Consider that the company that...
-
Use a symmetry argument to determine the electric flux through a Gaussian surface that encloses both charged particles that form an electric dipole. Does the value calculated for the flux depend on...
-
Henredon purchases a high-precision programmable router for shaping furniture components for \($190,000.\) It is expected to last 12 years and have a salvage value of \($5,000.\) It will produce...
-
Consider the hydrodynamic flow of nitrogen at \(400 \mathrm{~K}\) through the porous diaphragm described in Example 1.24. It is desired to achieve a superficial gas velocity through the diaphragm of...
-
This problem examines the generalization mentioned in Section 7-3, that the Lee-Kesler generalized approach should not be applied to highly polar compounds. A. Choose three temperatures and three...
-
A thin plate of solid salt, \(\mathrm{NaCl}\), measuring 15 by \(15 \mathrm{~cm}\), is to be dragged through seawater at a velocity of \(0.6 \mathrm{~m} / \mathrm{s}\). The \(291 \mathrm{~K}\)...
-
If someone offered to give you a $500,000 noninterest-bearing note that was due 5 years from today (you will receive only one $500,000 payment three years from today) how much would you loan them if...
-
Cornell and Roberts are partners who agree to admit Stanley to their partnership. Cornell has a capital balance of $80,000 and Roberts has a capital balance of $120,000. Cornell and Roberts share net...
-
What effect, if any, would you expect poor-quality materials to have on direct labor variances?
-
Pixel Studio, Inc., is a small company that creates computer-generated animations for films and television. Much of the companys work consists of short commercials for television, but the company...
-
Refer to the data for The Terminator Inc. in Exercise 106. A management intern has suggested that the budgeted revenues and costs should be adjusted for the actual level of activity in April before...
-
The preferred stock of the Luxemburg Mining Corporation pays a $3.25 dividend. What is the value of the stock if your required rate of return is 8 percent?
-
What is the value of Brunei Petroleum Companys preferred stock when the dividend rate is 18 percent on a $100 par value? The appropriate discount rate for a stock of this risk level is 14 percent.
-
What is the value of Queens Park PLCs preferred stock when the dividend rate is 10 percent on a $100 par value? The appropriate discount rate for a stock of this risk level is 16 percent.
Study smarter with the SolutionInn App