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: Cash Accounts receivable Inventory $ 8,400 $ 23,600 $ 45,000 Building and equipment, net $ 123,600 $ 26,925 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 $ 59,000 $ 75,000 $ 80,000 $ 105,000 $ 56,000 $ 150,000 $ 23,675 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, $3,200 per month; other expenses (excluding depreciation). 6% of sales. Assume these expenses are paid monthly. Depreciation is $927 per month (Includes depreciation on new assets). g. Equipment costing $2,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 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 $ 8,400 $ 23,600 $ 45,000 Building and equipment, net $ 123,600 $ 26,925 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 $ 59,000 $ 75,000 $ 80,000 $ 105,000 $ 56,000 $ 150,000 $ 23,675 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, $3,200 per month; other expenses (excluding depreciation). 6% of sales. Assume these expenses are paid monthly. Depreciation is $927 per month (Includes depreciation on new assets). g. Equipment costing $2,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 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:
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
-
Splish Brothers Inc. borrows $86,400 on July 1 from the bank by signing a $86,400, 10%, 1-year note payable (a) Prepare the journal entry to record the proceeds of the note. (Credit account titles...
-
Steam leaves a nozzle with a pressure of 500 kPa, a temperature of 350C, and a velocity of 250 m/s. What is the isentropic stagnation pressure and temperature?
-
C. Erickson and Sons, Inc., is a Philadelphia-based construction company. Visit its home page at the following address: www.cerickson.com Instructions a. Identify three projects and/or services...
-
Show that a cubic polynomial can have at most three real zeros.
-
Using an incremental internal rate of return (IRR) analysis, the decision to replace the "current best" by the "challenger"' is based on what decision rule? a. The internal rate of return of the...
-
Management at the Kerby Corporation has determined the following aggregated demand schedule (in units): An employee can produce an average of 10 units per month. Each worker on the payroll costs...
-
The wave function associated with standing waves established in a 5.00 m long light-weight rope is y = 0.00300 sin(x)cos(110t) where x and y are in meters and t is in seconds. (a) How many...
-
For two independent exponential random variables, X, X2 (with parameter = X) and Y = g(X) with 91(x1, x2) Y = [Y, Y] (fY,Y (y, y2)). X1 x1+x 92(x1, x2) = x1 + x2, find pdf of
-
A mass-spring system as shown in Figure Q4 is driven by the external force F(t)=t-t for 0
-
A centrifuge slows down from 668 rpm to 319 rpm in 14 seconds. Assuming constant angular acceleration, determine the number of revolutions it goes through in this time. Express your answer using zero...
-
In a collection of microscopic oscillators, the temperature is high enough that the ground state and the first two excited states are occupied. a) (4 points) Which stands to all the possible energies...
-
5. A uniform string of length 1, constant density p and tension To has its equilibrium position along the x-axis, with end at x = 0 fixed and the end at x = l free to move (in a plane) perpendicular...
-
In an RC circuit, the energy stored in the capacitor decreases with time as the capacitor discharges. After how many time constants is this stored energy 31% of its initial value? A. 0.19 T B. 0.74 T...
-
Calculate the government-wide financial position ratio, the quick ratio, and the debt per capita ratio (assuming a population of 250,000) for the City of Cottonwood using the financial statements...
-
Find the inverse, if it exists, for the matrix. -1
-
Repeat problem 41 with the specimen of size \(100 \times 100 \times 10 \mathrm{~mm}^{3}\) and the dimensions of the cavity \(104 \times 104 \times 9 \mathrm{~mm}^{3}\). Elastic constants of the...
-
Repeat problem 41 with elastic constants of the plastic as \(E=10 \mathrm{GPa}\) and \(v=0.485\). Problem 42: A rectangular plastic specimen of size \(100 \times 100 \times 10 \mathrm{~mm}^{3}\) is...
-
A rectangular plastic specimen of size \(100 \times 100 \times 10 \mathrm{~mm}^{3}\) is placed in a rectangular metal cavity. The dimensions of the cavity are \(101 \times 101 \times 9...
Study smarter with the SolutionInn App