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
-
Assume that adults have IQ scores that are normally distributed with a mean of 102.6 and a standard deviation of 17.8. Find the probability that a randomly selected adult has an IQ greater than...
-
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
-
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...
-
Explain why a none quilibrium test rather than an equilibrium test is needed to detetmine the storage coefficient of an aquifer.
-
1. In a perfectly competitive market all firms and potential entrants are identical. Each has a total cost curve given by TC = 40q-q+.01q where q denotes the quantity of each firm. The market demand...
-
The equilibrium for extraction of acetic acid from water into 3heptanol at \(25^{\circ} \mathrm{C}\) is \(\mathrm{y}=0.828 \mathrm{x}\), where \(\mathrm{y}\) is weight fraction acetic acid in...
-
Production workers for Chadwick Manufacturing Company provided 3,200 hours of labor in January and 2,800 hours in February. The company, whose operation is labor intensive, expects to use 48,000...
-
define a sequelize like below: var Program=sequelize.define('Program',{ programCode:{ type:Sequelize.STRING, primaryKey:true }, programName:Sequelize.STRING, },...
-
Write an assembly program in which you will store two signed 8-bit integers to (al) and (bl) registers and preform the following operations. Add both values and store the answer in (ch) register....
-
ErgoPillow is an online shop selling two different models of ergonomic pillow which helps to relief sore necks. It sells the delux and premium version for $50 and $80 each. The deluxe pillow is...
-
Define and explain each terms with examples Customization and Personalization Collaboration Workbook Information Workbook Distribution
-
Read the following article Buy American. I Am. by Warren Buffett, The New York Times, October 16, 2008 Warren wrote this article during the subprime mortgage crisis. The Dow Jones Industrial Average...
-
You are planning to borrow $2501. You can repay the loan in 40 monthly payments of $79.06 each or 36 monthly payments of 85.93 each. You decide to take the 40 month loan. During each of the first 36...
-
To what degreee was the war of 1812 truly a second war of independence? Why did Henry clay find it so vitally important to fight ? How familiar were you with the market revolution? How did it compare...
-
Talo Inc. has, for the last 15 years, been manufacturing shirts. The company has the following information available for the past year: $145,000 $14,000 5.00 Total sales Total operating income Degree...
-
(a) How far away can a human eye distinguish two ear headlights 2.0 m apart? Consider only diffraction effects and assume an eye pupil diameter of 5.0 mm and a wavelength of 550 nm. (b) What is the...
-
An increase in which component of quality costs is most likely to result in a decrease in the other three components? a. prevention costs b. inspection costs c. internal failure costs d. external...
-
Activity-based costing can be used to refine which of the following? a. job-order costing b. process costing c. both job-order and process costing d. neither job-order nor process costing
-
How might the proportion of total quality control costs in each of the four components of quality control (prevention, inspection, internal failure, and external failure) vary for different types of...
Study smarter with the SolutionInn App