# The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods:...

###### Question:

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 $7,200$ 18,800 $37,800$ 123,600 $22,425$ 150,000 $14,975 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July$   47,000 63,000 68,000 93,000 44,000 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,000 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is$927 per month (includes depreciation on new assets). g. Equipment costing $1,200 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.

#### Similar Solved Questions

##### What is Phantom Inventory? Why, from your perspective, is inventory so easy to inflate without auditor...
What is Phantom Inventory? Why, from your perspective, is inventory so easy to inflate without auditor detection?...
##### Please guys l need a code ASAP which runs not tips ...l need to submit my assignment as soon as p...
please guys l need a code ASAP which runs not tips ...l need to submit my assignment as soon as possible... please help VBA simple code Criven products in a vending machine (Tahle and their respective prices (Table 2), develop VBA ende that would undertake the tollowing tasks after the customer clic...
##### Please help me 2 questions 15) Experiment: An urn contains 12 fuchsia marbles and 5 magenta...
please help me 2 questions 15) Experiment: An urn contains 12 fuchsia marbles and 5 magenta marbles. Two marbles are drawn without replacement. What is the probability that both marbles are magenta? A) 0.2206 B) 0.4983 C) 0.4853 D) 0.0865 E) 0.074 16) Experiment: An urn contains 4 blue marbles and 8...
##### Compound interest
If 8000 dollars is invested in a bank account at an interest rate of 4 per cent per year,Find the amount in the bank after 8 years if interest is compounded monthlyFinally, find the amount in the bank after 8 years if interest is compounded continuously...
##### Will Mercury eventually be pulled into the sun?
Will Mercury eventually be pulled into the sun?...
##### . Find the response voltage v) in the rut below i th independenure e isc (t)-...
. Find the response voltage v) in the rut below i th independenure e isc (t)- 12 cos 100t +16 sin 100t A peak Leave the answer for v(t) in trigonometric form. Also find the impedance presented to the independent current source. (-24 cos 100t + 8 sin 100t, 5 +/5 Ω) 20 ohm 10 ohm 100 mH 0.21,(t)...
##### Moving to another question will save this response. Question 15 The objective lens should always be...
Moving to another question will save this response. Question 15 The objective lens should always be used first when bringing an object to focus under the microscope. 4X 40X 100X 0 0 0 400X Moving to another question will save this response....
##### 1 Google Dịch 4 Ch 8: Homgo x A Player X C Search Textbox C Exercise...
1 Google Dịch 4 Ch 8: Homgo x A Player X C Search Textbox C Exercise 8-22 X ses/30198/assignments/2980997 1. Year 1. Current A C Bond Premium, En. MPUIT Progress Seattle University Dashboard Combined Effects. Google Dich Presented below is information related to Nash Company Ending Inventory (...
##### PA3-1 (Algo) Preparing a Process Costing Production Report (Weighted Average Method) (LO 3-2, 3-3, 3- Sandia...
PA3-1 (Algo) Preparing a Process Costing Production Report (Weighted Average Method) (LO 3-2, 3-3, 3- Sandia Corporation manufactures metal toolboxes. It adds all materials at the beginning of the manufacturing process. The company has provided the following information: Costs $38,000 89,000$127,0...
##### Exercise 3.72 PartA Calculate the mass percent composition of nitrogen in each of the following nitrogen...
Exercise 3.72 PartA Calculate the mass percent composition of nitrogen in each of the following nitrogen compounds. N20 Express your answer using four significant filgures. mass % N Submilt Request Answer Part B SigN4 Express your answer using four significant figures. mass % N- Submit Part C NaNH2 ...
##### (10 points) If y = f(x) is homogeneous of degreek> 2, prove that its second-order partial...
(10 points) If y = f(x) is homogeneous of degreek> 2, prove that its second-order partial Ierivatives are homogeneous of degree k-2....
##### 1) Figure 1 illustrates first and second blocks having respective masses Mi and M2. An ideal...
1) Figure 1 illustrates first and second blocks having respective masses Mi and M2. An ideal horizontal rope is connected between the blocks and both blocks are positioned on a horizontal smooth surface (i.e. no friction force is applied by the smooth surface onto either block). A horizontal pulling...
Please provide instructions on each variance and actual results. Brodrick Company expects to produce 21,700 units for the year ending December 31. A flexible budget for 21,700 units of production reflects sales of $607,600; variable costs of$65,100; and fixed costs of \$143,000. QS 21-4 Flexible bud...