Scott Products Inc. is a merchandising company that sells binders, paper, and other school sup- plies....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Scott Products Inc. is a merchandising company that sells binders, paper, and other school sup- plies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July through October are as follows: July August September October Sales........ $40,000 $70,000 $50,000 $45,000 Cost of goods sold... 24,000 42,000 30,000 27,000 Gross margin...... 16,000 28,000 20,000 18,000 Selling and administrative expenses: Selling expense........ 7,200 11,700 8,500 7,300 Administrative expense*. 5,600 7,200 6,100 5,900 Total expenses...... 12,800 18,900 14,600 13,200 Operating income.... $ 3,200 $ 9,100 $ 5,400 $ 4,800 *Includes $2,000 depreciation each month. b. Sales are 20% for cash and 80% on credit. c. Credit sales are collected over a three-month period, with 10% collected in the month of sale, 70% in the month following sale, and 20% in the second month following sale. May sales totalled $30,000, and June sales totalled $36,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month's inventory purchases is paid for in the month of purchase. The remaining 50% is paid in the follow- ing month. Accounts payable for inventory purchases at June 30 total $11,700. e. The company maintains its ending inventory levels at 75% of the cost of the merchandise to be sold in the following month. The merchandise inventory at June 30 is $18,000. f. Land costing $4,500 will be purchased in July. g. Dividends of $1,000 will be declared and paid in September. h. The cash balance on June 30 is $8,000; the company must maintain a cash balance of at least this amount at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow up to a total loan balance of $40,000. The interest rate on these loans is 1% per month. All bor- rowing is done at the beginning of a month. The company would, as far as it is able, repay the loan at the end of each month. Interest must be paid at the end of each month based on the outstanding loans for that month. There are no loans outstanding as at June 30. Required: 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for July, August, and September. b. A schedule of expected cash disbursements for merchandise purchases for July, August, and September and for the quarter in total. 3. Prepare a cash budget for July, August, and September and for the quarter in total. Scott Products Inc. is a merchandising company that sells binders, paper, and other school sup- plies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for July through October are as follows: July August September October Sales........ $40,000 $70,000 $50,000 $45,000 Cost of goods sold... 24,000 42,000 30,000 27,000 Gross margin...... 16,000 28,000 20,000 18,000 Selling and administrative expenses: Selling expense........ 7,200 11,700 8,500 7,300 Administrative expense*. 5,600 7,200 6,100 5,900 Total expenses...... 12,800 18,900 14,600 13,200 Operating income.... $ 3,200 $ 9,100 $ 5,400 $ 4,800 *Includes $2,000 depreciation each month. b. Sales are 20% for cash and 80% on credit. c. Credit sales are collected over a three-month period, with 10% collected in the month of sale, 70% in the month following sale, and 20% in the second month following sale. May sales totalled $30,000, and June sales totalled $36,000. d. Inventory purchases are paid for within 15 days. Therefore, 50% of a month's inventory purchases is paid for in the month of purchase. The remaining 50% is paid in the follow- ing month. Accounts payable for inventory purchases at June 30 total $11,700. e. The company maintains its ending inventory levels at 75% of the cost of the merchandise to be sold in the following month. The merchandise inventory at June 30 is $18,000. f. Land costing $4,500 will be purchased in July. g. Dividends of $1,000 will be declared and paid in September. h. The cash balance on June 30 is $8,000; the company must maintain a cash balance of at least this amount at the end of each month. i. The company has an agreement with a local bank that allows the company to borrow up to a total loan balance of $40,000. The interest rate on these loans is 1% per month. All bor- rowing is done at the beginning of a month. The company would, as far as it is able, repay the loan at the end of each month. Interest must be paid at the end of each month based on the outstanding loans for that month. There are no loans outstanding as at June 30. Required: 1. Prepare a schedule of expected cash collections for July, August, and September and for the quarter in total. 2. Prepare the following for merchandise inventory: a. A merchandise purchases budget for July, August, and September. b. A schedule of expected cash disbursements for merchandise purchases for July, August, and September and for the quarter in total. 3. Prepare a cash budget for July, August, and September and for the quarter in total.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-1259024900
9th canadian edition
Authors: Ray Garrison, Theresa Libby, Alan Webb
Posted Date:
Students also viewed these accounting questions
-
Scott Products Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Scott Products has had...
-
Refer to the data for Scott Products Inc. in Problem 9-21. The company's president is interested in knowing how reducing inventory levels and collecting accounts receivable sooner will impact the...
-
Linking every transport stakeholder together and ensuring seamless travel across Europe is a dream. With this objective, Amadeus, a leading global travel technology player, initiated a novel idea of...
-
Calculate the missing values List price (S) Discount rate (%) Discount amount (S) Net price (S) mount ($) Net price ($) 249.00 331
-
The following information is taken from the 2005 financial statements of La-Z-Boy, Inc., maker of recliners and other home furnishings, and the 2005 financial statements of McDonald's, maker of the...
-
In which of the health care settings above will the function medical admission need to be supported?
-
In the past, Peter Kelles tire dealership in Baton Rouge sold an average of 1,000 radials each year. In the past 2 years, 200 and 250, respectively, were sold in fall, 350 and 300 in winter, 150 and...
-
What is the purpose of an audit performed by a CPA? Do audits signify to financial statement users that no fraud and embezzlement occurred at the organization? How does sampling financial...
-
LG Enterprises has been offered an opportunity that will receive the following mixed stream of cash flows over the next 5 years respectively: 5,000, 8,000, 12,000, 8,000, 2,000. If they must earn 9%...
-
Paolo, Inc. (the lessor) entered into a sales-type lease with another company on January 1, 2016. The lease was for five years with $40,000 due at the end of each year. The cost of the equipment on...
-
A. B. A business, electricity charges amount to RM12,000 per annum. In the year to 31 December 2021, RM9,000 has been paid. The electricity for the final quarter is paid in January 2022. Show the...
-
Can you elucidate the concept of performance-driven culture and its impact on organizational effectiveness and employee engagement, exploring how values alignment, recognition programs, and...
-
A $1000 increase in real per capita GNP will cause the human development index (HDI) to what? Explain.
-
Can you elaborate on the role of goal setting theory and expectancy theory in shaping performance management processes, examining how clear, challenging goals and performance incentives can motivate...
-
How cloud computing can assist companies in reducing their costs associated with e-commerce?
-
Could a set of three vectors in span all of? Explain. What about n vectors in when n is less than m? R4
-
What is the basic idea behind the finite element method?
-
For a bar element of length \(l\) with two nodes, the shape function corresponding to node 1 is given by a. \(\left(1-\frac{x}{l} ight)\) b. \(\frac{x}{l}\) c. \(\left(1+\frac{x}{l} ight)\)
-
Derive the stiffness matrix of the tapered bar element (which deforms in the axial direction) shown in Fig. 12.13. The diameter of the bar decreases from \(D\) to \(d\) over its length. P. E D X d...
Study smarter with the SolutionInn App