Problem 8-29 (Algo) Completing a Master Budget (LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d47634a77_4776647d475c701b.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d476d6234_4786647d47676203.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d4777bbd1_4796647d4771f0ef.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d47837f40_4796647d477b430c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d478cff42_4806647d4786e2a8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d4798260b_4816647d4791355a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647d47a52259_4816647d479d756a.jpg)
Transcribed Image Text:
Problem 8-29 (Algo) Completing a Master Budget (LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] 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 $ 60,000 $ 76,000 $ 81,000 $106,000 $ 57,000 $ 8,500 $ 24,000 $ 45,600 $121,200 $ 27,300 $ 150,000 $ 22,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 & 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,300 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). 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,300 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 $2,500 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Complete the schedule of expected cash collections. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Complete the schedule of expected cash collections. Cash sales Credit sales Total collections Schedule of Expected Cash Collections April $ 45,600 24,000 $ 69,600 May June Quarter Required 1 Required 2 Required 3 Required 4 Required 5 Complete the merchandise purchases budget and the schedule of expected cash disbursements for merch Merchandise Purchases Budget April Budgeted cost of goods sold $ 57,000 $ May 60,750 June Quarter Add desired ending merchandise inventory 48,600 Total needs 105,600 Less beginning merchandise inventory 45,600 Required purchases $ 60,000 Budgeted cost of goods sold for April = $76,000 sales x 75% = $57,000. Add desired ending inventory for April = $60,750 x 80% $48,600. Schedule of Expected Cash Disbursements-Merchandise Purchases March purchases April purchases May purchases April $ 27,300 May 30,000 30,000 June Quarter $ 27,300 60,000 June purchases Total disbursements < Required 1 Required 3 > Beginning cash balance Add collections from customers Total cash available Less cash disbursements: For inventory For expenses For equipment Total cash disbursements Shilow Company Cash Budget Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance April May June Quarter $ 8,500 69,600 78,100 57,300 16,980 2,500 76,780 1,320 < Required 2 Required 4 > Required 1 Required 2 Required 3 Required 4 Required 5 Prepare an absorption costing income statement for the quarter ended I Shilow Company Income Statement For the Quarter Ended June 30 Cost of goods sold: Selling and administrative expenses: Prepare a balance sheet as of June 30. Shilow Company Balance Sheet June 30 Current assets: Total current assets Total assets Stockholders' equity: Assets Liabilities and Stockholders' Equity Total liabilities and stockholders' equity Problem 8-29 (Algo) Completing a Master Budget (LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] 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 $ 60,000 $ 76,000 $ 81,000 $106,000 $ 57,000 $ 8,500 $ 24,000 $ 45,600 $121,200 $ 27,300 $ 150,000 $ 22,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 & 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,300 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). 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,300 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 $2,500 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Complete the schedule of expected cash collections. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Complete the schedule of expected cash collections. Cash sales Credit sales Total collections Schedule of Expected Cash Collections April $ 45,600 24,000 $ 69,600 May June Quarter Required 1 Required 2 Required 3 Required 4 Required 5 Complete the merchandise purchases budget and the schedule of expected cash disbursements for merch Merchandise Purchases Budget April Budgeted cost of goods sold $ 57,000 $ May 60,750 June Quarter Add desired ending merchandise inventory 48,600 Total needs 105,600 Less beginning merchandise inventory 45,600 Required purchases $ 60,000 Budgeted cost of goods sold for April = $76,000 sales x 75% = $57,000. Add desired ending inventory for April = $60,750 x 80% $48,600. Schedule of Expected Cash Disbursements-Merchandise Purchases March purchases April purchases May purchases April $ 27,300 May 30,000 30,000 June Quarter $ 27,300 60,000 June purchases Total disbursements < Required 1 Required 3 > Beginning cash balance Add collections from customers Total cash available Less cash disbursements: For inventory For expenses For equipment Total cash disbursements Shilow Company Cash Budget Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance April May June Quarter $ 8,500 69,600 78,100 57,300 16,980 2,500 76,780 1,320 < Required 2 Required 4 > Required 1 Required 2 Required 3 Required 4 Required 5 Prepare an absorption costing income statement for the quarter ended I Shilow Company Income Statement For the Quarter Ended June 30 Cost of goods sold: Selling and administrative expenses: Prepare a balance sheet as of June 30. Shilow Company Balance Sheet June 30 Current assets: Total current assets Total assets Stockholders' equity: Assets Liabilities and Stockholders' Equity Total liabilities and stockholders' equity
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Alligood Equipment Corporation sold a precision tool machine with computer controls to Kaui Corporation for $400,000 on January 2 and agreed to take payment nine months later on October 2. Assuming...
-
Explain how the paired-samples t test helps us evaluate individual differences and the independent-samples t test helps us evaluate group differences.
-
Mercer Inc. is preparing its annual budgets for the year ending December 31, 2010. Accounting assistants furnish the following data. An accounting assistant has prepared the detailed manufacturing...
-
On May 31, 2014, the following data were accumulated to assist the accountant in preparing the adjusting entries for Oceanside Realty: a. Fees accrued but unbilled at May 31 are $19,750. b. The...
-
1. (20 Points) Write A Script A3_HW2_1.M Which Converts 250 Miles To Km 2. (20 Points) Write An External Function KmToMiles.M" For Km-To-Miles Conversion, Which Takes An Input Argument In Km And...
-
You are thinking of starting a business that specializes in aquatic fish and aquatic fish supplies. The fish and supplies you will be selling are not available at the stores such as Pet Supplies Plus...
-
Calculate the production rate of a well in an oil reservoir at time of 40 days. The following data are given: Flowing bottomhole pressure, p wf =2000 psi Porosity,f= 0.25 Oil saturation S oi = 100%...
-
Today Peter bought an apartment which he will rent. The market price which he paid for this apartment is 5 0 0 , 0 0 0 . Every year he will receive 3 5 , 0 0 0 from renting the apartment. Moreover,...
-
DONG Manufacturing currently produces 3,000 tires per month. The following per unit data for 3,000 tires apply for sales to regular customers: Direct materials $38 Direct manufacturing labor 14...
-
A grocery is considering building a new warehouse. If taken, the construction would cost $100,000 today, but the new warehouse would bring the benefits of $103,000 in one year. Besides, a bank offers...
-
A conducting wire of length 2.61 m has a current of 14.4 A passing through it. The wire is placed in a magnetic field of strength 1.58 T. If the angle between the wire and the magnetic field is 45.3,...
-
1: Company J is considering a project with a 4-year lifespan. The initial cash flow estimate is $125million in the first year increasing by $125million in each of the years 2 through 4. To begin the...
-
Which of the following gives the range of y = 4 - 2 -x ? (A) (- , ) (B) (- , 4) (C) [- 4, ) (D) (- , 4] (E) All reals
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App