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: $ 9,00e $ 26,000 $ 48,600 $ 199, 200 $ 29,175 Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock $ 150, 000 Retained earnings $ 13,625 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) $ 65,000 $ 81,000 $ 86,000 $ 111,000 $ 62,000 April Мay June July c. Sales are 60% for cash and 40% on credit. Credit sales are collected In the month following sale. The accounts recelvable 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 pald for In the month of purchase; the other half is pald 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,800 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $819 per month (Includes depreciation on new assets). g. Equlpment costing $3,000 will be purchased for cash in April. h. Management would like to malntaln 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. Required 1 Required 2 Required 3 Required 4 Required 5 Complete the schedule of expected cash collections. Schedule of Expected Cash Collections April May June Quarter Cash sales 48,600 Credit sales 26,000 Total collections 74,600 Complete the merchandise purchases budget and the schedule of expected cash disbursements for merchandise purchases. Merchandise Purchases Budget April May June Quarter Budgeted cost of goods sold 60,750 64,500 Add desired ending merchandise inventory 51,600 Total needs 112,350 64,500 Less beginning merchandise inventory Required purchases 48,600 63,750 84,500 Budgeted cost of goods sold for April = $81,000 sales x 75% = $80,750. Add desired ending inventory for April = $64,500 x 80% = $51,600. Schedule of Expected Cash Disbursements-Merchandise Purchases April May June Quarter March purchases 29,175 29,175 April purchases 31,875 31,875 63,750 May purchases June purchases Total disbursements 61,050 31,875 92,925 Shilow Company Cash Budget April May June Quarter Beginning cash balance 9.000 Add collections from customers 74,600 Total cash available 83,600 Less cash disbursements: For inventory 61.050 For expenses 18,380 For equipment 3,000 Total cash disbursements 82,430 Excess (deficiency) of cash available over disbursements 1,170 Financing: Borrowings Repayments Interest Total financing Ending cash balance 1.170 Shilow Company Income Statement For the Quarter Ended June 30 Cost of goods sold: Selling and administrative expenses: Shilow Company Balance Sheet June 30 Assets Current assets: Total current assets Total assets Liabilities and Stockholders' Equity Stockholders' equity: Total liabilities and stockholders' equity The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: $ 9,00e $ 26,000 $ 48,600 $ 199, 200 $ 29,175 Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock $ 150, 000 Retained earnings $ 13,625 a. The gross margin is 25% of sales. b. Actual and budgeted sales data: March (actual) $ 65,000 $ 81,000 $ 86,000 $ 111,000 $ 62,000 April Мay June July c. Sales are 60% for cash and 40% on credit. Credit sales are collected In the month following sale. The accounts recelvable 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 pald for In the month of purchase; the other half is pald 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,800 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $819 per month (Includes depreciation on new assets). g. Equlpment costing $3,000 will be purchased for cash in April. h. Management would like to malntaln 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. Required 1 Required 2 Required 3 Required 4 Required 5 Complete the schedule of expected cash collections. Schedule of Expected Cash Collections April May June Quarter Cash sales 48,600 Credit sales 26,000 Total collections 74,600 Complete the merchandise purchases budget and the schedule of expected cash disbursements for merchandise purchases. Merchandise Purchases Budget April May June Quarter Budgeted cost of goods sold 60,750 64,500 Add desired ending merchandise inventory 51,600 Total needs 112,350 64,500 Less beginning merchandise inventory Required purchases 48,600 63,750 84,500 Budgeted cost of goods sold for April = $81,000 sales x 75% = $80,750. Add desired ending inventory for April = $64,500 x 80% = $51,600. Schedule of Expected Cash Disbursements-Merchandise Purchases April May June Quarter March purchases 29,175 29,175 April purchases 31,875 31,875 63,750 May purchases June purchases Total disbursements 61,050 31,875 92,925 Shilow Company Cash Budget April May June Quarter Beginning cash balance 9.000 Add collections from customers 74,600 Total cash available 83,600 Less cash disbursements: For inventory 61.050 For expenses 18,380 For equipment 3,000 Total cash disbursements 82,430 Excess (deficiency) of cash available over disbursements 1,170 Financing: Borrowings Repayments Interest Total financing Ending cash balance 1.170 Shilow Company Income Statement For the Quarter Ended June 30 Cost of goods sold: Selling and administrative expenses: Shilow Company Balance Sheet June 30 Assets Current assets: Total current assets Total assets Liabilities and Stockholders' Equity Stockholders' equity: Total liabilities and stockholders' equity
Expert Answer:
Answer rating: 100% (QA)
Solution Solution 1 Schedule of expected cash collections Particulars April May June Quarter Budgeted Sales 8100000 8600000 11100000 27800000 Cash Sal... 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
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: (a) The gross margin in 25% of sales (b) Actual and budgeted sales data: (c) Sales are 60%...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $8,000 Accounts receivable $20,000 Inventory $36,000...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
Why should the digital divide matter to people who can afford to be fully connected?
-
Does the nonemployee spouse have any rights to a pension plan participants defined benefits?
-
Provide the explanation for each of the following general journal entries: Date 2021 June 11 Cash Office Equipment B. Blue, Capital (A) 15 Cash Account Titles and Descriptions Accounts Receivable...
-
The laminate described in Problem 7.15 has laminae that are \(0.25 \mathrm{~mm}\) thick and the stiffness matrix associated with the \(0^{\circ}\) lamina is given by If a single bending moment per...
-
Airport Coach Service Company operates scheduled coach service from Boston's Logan Airport to downtown Boston and to Cambridge. A common scheduling service center at the airport is responsible for...
-
What is behavioral targeting? How can it be used to exploit business opportunities? What ethical problems can arise from behavioral targeting on the internet? How can combining ethics and psychology...
-
You work for Euroc, a limited liability company, which seeks growth through acquisitions. You are a member of a team that is investigating the possible purchase of Choggerell, a limited liability...
-
Lysa has an autism spectrum disorder, and people often think she is rude because she doesn't wave back to them when they wave at her. What is the more likely explanation for Lysa not waving? a) Lysa...
-
Which of the following statements about no-argument constructors and inheritance are correct? (Choose two.) A. The compiler cannot insert a no-argument constructor into an abstract class. B. If a...
-
Which of the following variables are always in scope for the entire program once defined? A. Package variables B. Class variables C. Instance variables D. Local variables
-
How many cells in the following table are incorrect? A. Zero B. One C. Two D. Three E. Four Allows abstract methods? Type Abstract class Yes Concrete class Yes Interface Yes Allows constants? Yes Yes...
-
Which of the following are valid class declarations? (Choose three.) A. class {} B. class river {} C. class Str3@m {} D. class Pond2$ {} E. class _var_ {} F. class 50cean {}
-
Which variables have a scope limited to a method? A. Interface variables B. Class variables C. Instance variables D. Local variables
-
Suppose there are two firms competing in the market for dentures. Each firm has to decide whether or not to advertise their product. The first firm, Chewy Chew, has been in the market for some time...
-
Using a graphing utility, graph y = cot -1 x.
-
Smoky Mountain Corporation makes two types of hiking bootsXtreme and the Pathfinder. Data concerning these two product lines appear below: The company has a traditional costing system in which...
-
Architectural Consultants began operations on January 2. The following activity was recorded in the companys Work in Process account for the first month of operations: Leeds Architectural Consultants...
-
For many years Futura Company has purchased the starters that it installs in its standard line of farm tractors. Due to a reduction in output, the company has idle capacity that could be used to...
-
What ideas do you have for a new business? How can you multiply the stimuli around these ideas to enhance them and identify attractive opportunities?
-
What do you really enjoy doing? What is your passion? Can your passion be a platform for a viable opportunity?
-
What do your friends and family envision you doing? What strengths and weaknesses do they observe? How do their insights help lead you to an opportunity that is right for you?
Study smarter with the SolutionInn App