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 Building and equipment, net Accounts payable Common stock Retained earnings $ 7,000 $ 18,000 $ 36,600 $ 121,200 $ 21,675 $ 150,000 $ 11,125 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 45,000 $ 61,000 $ 66,000 $ 91,000 $ 42,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, $1,800 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $909 per month (Includes depreciation on new assets). g. Equipment costing $1,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 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: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 7,000 $ 18,000 $ 36,600 $ 121,200 $ 21,675 $ 150,000 $ 11,125 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 45,000 $ 61,000 $ 66,000 $ 91,000 $ 42,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, $1,800 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $909 per month (Includes depreciation on new assets). g. Equipment costing $1,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 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:
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
-
Q2 Consider a 0.8 m x 0.8 m thin square plate in a room at 10C. One side of the plate is maintained at a temperature of 100C, while the other side is insulated, as shown in Figure APPENDIX A.1. By...
-
Histogram of Dis... Worksheet 1 Histogram of Distance Frequency 6 5 3 2 1 Golf Ball Distance 0 264 272 280 288 296 Distance
-
. If 6(x-2) = 3(x-4) - 4, then x =
-
Consider the integral where n is an integer. Using the trigonometric identity 1 + tan 2 x = sec 2 x, show that and hence obtain the recurrence relation Use this to find (Recurrence relations of this...
-
For each of the following areas, define appropriate quality characteristic(s) and parameters and indicate the hypotheses that you would test: (a) Effectiveness of a hospital in satisfying patients,...
-
A donut shop in Boston was having trouble getting the correct staffing levels. It appears that they have staff with a lot of ideal time on few days and on the other days customers must wait a long...
-
Shauna Washington started a business to sell art supplies and related curricula to home school families. The business grew quickly, with sales doubling three times during a five-year period. At that...
-
A new accountant at Netzloff Inc. is trying to identify which of the amounts shown on page 377 should be reported as the current asset Cash and cash equivalents in the year-end balance sheet, as of...
-
Run correlation analysis: - Which variable (product quality, competitive pricing, order&billing, or delivery speed) shows the highest correlation with satisfaction? - Which variable (product quality,...
-
Assume that you have a portfolio consisting of the following stocks. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Stock Investment ( $...
-
Jones Pty Ltd has a GST turnover of less than $10,000,000. Assume a monthly return is lodged and tax invoices are issued at the time of sales and purchases. In July 2022, sales including GST were...
-
The cost accountant for a medium-sized business has been asked to propose a new system of responsibility accounting. Ownership is looking for a balanced scorecard to use in performance evaluation. As...
-
Starting Right Corporation After watching a movie about a young woman who quit a successful corporate career to start a baby food company, Julia Day decided to do the same. In the movie, the baby...
-
Combine the following expression into a single, simplified, logarithm. Provide your answer below: 2 log 8 - 3 log 2
-
How the cost accounting can establish a new system of responsibility accounting? Ownership is looking for a balanced scorecard to use in performance evaluation as part of the introductory material,...
-
Write the different configaration of BJT. Explain ?
-
Tanaka Company's cost and production data for two recent months included the following: March April Production (units).........300................600 Rent.....................$1,800............$1,800...
-
Assume that an income statement contains each of the three sections listed below. Which will be the last section presented in the income statement? a. Gross profit b. Income from continuing...
-
When constructing a common-sized income statement, all amounts are expressed as a percentage of: a. net income. b. gross profit. c. net sales. d. income from operations.
-
The current ratio of Hydro Company at December 31, 2018, calculated using the above data, was 3.13 and the company's working capital was \(\$ 170,000\). Which of the following would happen if the...
Study smarter with the SolutionInn App