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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648d16a77d8c_2346648d16a0a7f9.jpg)
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: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 8,000 $ 22,000 $ 42,600 $ 130,800 $ 25,425 $ 150,000 $ 55,000 $ 71,000 $ 76,000 $ 101,000 $ 52,000 $ 27,975 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,800 per month; other expenses (excluding depreciation), 6% of sales. Assume these expenses are paid monthly. Depreciation is $981 per month (includes depreciation on new assets). g. Equipment costing $2,000 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 allowing it 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 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: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 8,000 $ 22,000 $ 42,600 $ 130,800 $ 25,425 $ 150,000 $ 55,000 $ 71,000 $ 76,000 $ 101,000 $ 52,000 $ 27,975 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,800 per month; other expenses (excluding depreciation), 6% of sales. Assume these expenses are paid monthly. Depreciation is $981 per month (includes depreciation on new assets). g. Equipment costing $2,000 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 allowing it 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 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:
Posted Date:
Students also viewed these accounting questions
-
Use the following to answer questions 1-3 below The records of Teresa's Toys Co. as of December 31, 20XX. Accounts payable Insurance expense Accounts receivable s10,000 500 19,000 S60,000 12,000...
-
These items are taken from the financial statements of Finn Corporation for 2010. Retained earnings (beginning of year) ....... $31,000 Utilities expense ................. 2,000 Equipment...
-
Baker Company is trying to determine how often it needs to deposit payroll taxes for calendar year 2014. The company made the following quarterly payroll tax deposits during the last two years:...
-
For the same system as in Problem 15.D1, the high concentration \(\mathrm{C}_{\mathrm{A}, 0}=1.2 \mathrm{~kg} / \mathrm{m}^{3}\) and \(\mathrm{C}_{\mathrm{A}, \mathrm{L}}=0.9701 \mathrm{~kg} /...
-
Sub-Prime Loan Company is thinking of opening a new office, and the key data are shown below. The company owns the building that would be used, and it could sell it for $100,000 after taxes if it...
-
Question 1 Air ( 1.4, R = 287 J/(kg K)) flows from a very large reservoir through a convergent- divergent nozzle. The air in the reservoir is kept at a constant temperature of To =300 K. The exit...
-
Light of wavelength 5 8 0 nm is incident on a slit of width 0 . 3 0 0 nm. An observing screen is placed 2 . 0 0 m from the slit. Find the distance between the 1 st and 2 nd dark fringe.
-
How does the alignment between organizational climate and corporate values influence customer satisfaction and business performance, and what methods can ensure consistency in this alignment ?
-
P1) The structure presented in the video "Member with a hole - failure modes and design" is reproduced here. You may use any values calculated in the video for this structure without having to...
-
Birch Company normally produces and sells 47,000 units of RG-6 each month. The selling price is $20 per unit, variable costs are $10 per unit, fixed manufacturing overhead costs total $175,000 per...
-
Find the implicit general solution of the differential equation given. Assume x and y are non-zero. dy = (x-7)y dx x (3y7-y) An implicit general solution in the form of F(x,y) = C is = = C, where C...
-
How do organizational structures adapt to accommodate the evolving demands of a globalized marketplace, particularly in the context of diverse workforce compositions ?
-
Consider a government with a balanced primary budget. The interest rate is 5 percent. The growth rate of nominal GDP is 2 percent. The initial debt-GDP ratio is 10 percent. Over time, the debt to GDP...
-
It is possible to investigate the thermo chemical properties of hydrocarbons with molecular modeling methods. (a) Use electronic structure software to predict cHo values for the alkanes methane...
-
On January 1, 2011, Graves Company had a balance of \(\$ 200,000\) in its Common Stock account. During 2011, Graves paid \(\$ 15,000\) to purchase treasury stock. Treasury stock is accounted for...
-
The following accounts and corresponding balances were drawn from Poole Company's 2012 and 2011 year-end balance sheets: Other information drawn from the accounting records: 1. Dividends paid during...
-
Greenstein Company engaged in the following transactions during 2012. The beginning cash balance was \(\$ 86,000\) and ending cash balance was \(\$ 123,100\). 1. Sales on account were \(\$ 548,000\)....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App