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 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) April May June July $ 61,000 $ 77,000 $ 82,000 $ 107,000 $ 58,000 $ 8,600 $ 24,400 $ 46,200 $ 118,800 $ 27,675 $ 150,000 $ 20,325 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,400 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $891 per month (includes depreciation on new assets). g. Equipment costing $2,600 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 ar for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loa 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 $ 61,000 $ 77,000 $ 82,000 $ 107,000 $ 58,000 $ 8,600 $ 24,400 $ 46,200 $ 118,800 $ 27,675 $ 150,000 $ 20,325 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,400 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $891 per month (includes depreciation on new assets). g. Equipment costing $2,600 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 ar for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loa 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)
1 Schedule of Expected Cash Collections Month Beginning Cash Balance Sales Cash Sales Credit Sales A... 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
-
Describe the flow of costs through the T-accounts in a job order cost system.
-
A total of 7000 stampings must be produced in the press department during the next three days. Manually operated presses will be used to complete the job and the cycle time is 27 sec. Each press must...
-
How would you respond to the following statement? Part A-Introduction Greetings to all! My name is Tara L. Dymarczyk. I live in Connecticut close to Yale University. I have two grown children. My...
-
Pregnancy Length Use the normal distribution in Exercise 15. (a) What percent of the new mothers had a pregnancy length of less than 280 days? (b) What percent of the new mothers had a pregnancy...
-
Using the data in BE3-5, Journalize and post the entry on July 1 and the adjusting entry on December 31 for Kalter Insurance Co. Kalter uses the accounts Unearned Service Revenue and Service Revenue....
-
The Cabinet Shoppe is considering the addition of a new line of kitchen cabinets to its current product lines. Expected cost and revenue data for the new cabinets are provided below: Annual sales...
-
Let f : B,B,and g : Bq B, be maps with associated matrices M(f), and M(g). Give the rule which determines the entries in M(go f) in terms of the entries of M(f) and M(g). State it as a simple...
-
Question 1 (1 point) In the simple economy of OCCland, we need to figure out their nominal GDP given the following information: OCCland produces 100 bags of Tea per year at $20 per bag, 75 new...
-
1. Identify five (5) food safety practices you should follow to prevent transferring bacteria from your body and clothing to the cheese and cheese preparation equipment when preparing, storing and...
-
On January 2, 2019, Flint Corporation issued $1,950,000 of 10% bonds to yield 11% due December 31, 2028. Interest on the bonds is payable annually each December 31. The bonds are callable at 101...
-
Due Thursday, May 4 by midnight to be submitted as a homework on STIX. Prepare a short report on information requirements of a small business (Grocery Store example). Prepare your work as an...
-
This case study relates to the following Course Learning Requirements: CLR 1: Install and use the Java Development and Runtime Environment and documentation libraries. Install and use the Eclipse...
-
Write an essay with this question. Has technology become a dominant role in our lives?
-
Time Solutions, Inc. is an employment services firm that places both temporary and permanent workers with a variety of clients. Temporary placements account for 70% of Time Solutions' revenue;...
-
Use a stem-and-leaf plot to display the data, which represent the runs scored by a batsman in a World Cup series. Organize the data using the indicated type of graph. Describe any patterns. 70 75 71...
-
Use a stem-and-leaf plot to display the data shown in the table at the left, which represent the drunk driving cases registered at 30 strategic road intersections. Organize the data using the...
-
Use a stem-and-leaf plot that has two rows for each stem to display the data, which represent the incomes (in millions) of the top 30 highest-paid tech CEOs. Organize the data using the indicated...
Study smarter with the SolutionInn App