The following data relate to the operations of Shllow 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 Shllow 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 $ 68,000 $ 84,000 $ 89,000 $ 114,000 $ 65,000 $ 9,300 $ 27,200 $ 50,400 $ 102,000 $ 30,300 $ 150,000 $ 8,600 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, $4,100 per month; other expenses (excluding depreciation), 6% of sales. Assume these expenses are paid monthly. Depreciation is $765 per month (Includes depreciation on new assets). g. Equipment costing $3,300 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 Shllow 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 $ 68,000 $ 84,000 $ 89,000 $ 114,000 $ 65,000 $ 9,300 $ 27,200 $ 50,400 $ 102,000 $ 30,300 $ 150,000 $ 8,600 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, $4,100 per month; other expenses (excluding depreciation), 6% of sales. Assume these expenses are paid monthly. Depreciation is $765 per month (Includes depreciation on new assets). g. Equipment costing $3,300 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
-
An order book displays the following information for stock ABC: Bid Shares 200 100 300 200 Price 25.76 25.66 25.62 25.54 Ask Price 25.82 25.94 25.98 26.06 Shares 100 200 200 400 What is the total...
-
The following drawdown information was collected from an observation well 120 ft away from a 16-in.-diameter well that is pumped at a uniform rate of 1.25 cfs. Determine the permeability and the...
-
A student named a coordination complex tripotassium dichloridodibromidodihy-droxidoiron. The students instructor pointed out that although the correct formula for the compound could be deduced, this...
-
Choose an appropriate closed system and draw a bar diagram representing the energy conversions and transfers that occur during each process of Checkpoint 7.9: (a) a ball launching as the compressed...
-
The items below are components of Patel Corporations income statement for the year ended December 31, 2011. Recast the income statement in proper multistep form, including allocation income taxes to...
-
Sketch a hand written a Enhanced ER diagram for this table and fix the error if there is Message cation D Notification UserNotif Password UserName UserID RoleID User D Phone User # Role securityID...
-
On Jan 01, 2020, ACME Incorporated issued $10 million of 6% convertible bonds at 100, which are due on December 31, 2029. The bonds pay interest annually on December 31. Each $1,000 bond can be...
-
Imagine the following. Youre in the audience of a business plan competition. The next team up to present is d.light, a for-profit social enterprise that plans to bring light to people without access...
-
How does the correlation between different assets in a portfolio affect the risk of the portfolio?
-
According to Markowitz, what is wrong with maximizing returns of a portfolio as an investment goal? How can investors use ex post data to evaluate an investment?
-
What is the two-step investment process proposed by Markowitz?
-
What is the difference between ex ante and ex post returns?
-
ABC Corporation manufactures two styles of lamps?a Bedford Lamp and a Lowell Lamp. The following per unit data are available: Total fixed costs are $30,000, and Company can sell a maximum of 10,000...
-
During registration at Tech every quarter, students in the Department of Management must have their courses approved by the departmental advisor. It takes the advisor an average of 4 minutes...
-
The section of the investment policy statement (IPS) that provides information about how the policy may be executed, including investment constraints, is best described as the: A. Investment...
-
Which of the following is least likely to be placed in the appendices to an investment policy statement (IPS)? A. Rebalancing Policy. B. Strategic Asset Allocation. C. Statement of Duties and...
-
Which of the following typical topics in an investment policy statement (IPS) is most closely linked to the clients distinctive needs? A. Procedures. B. Investment Guidelines. C. Statement of Duties...
Study smarter with the SolutionInn App