Exercise 13-36 (Static) Estimate Purchases and Cash Disbursements (LO 13-3, 4) Ellot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 16,800 nozzles in stock, although the latest estimate for August production indicates a requirement for only 15,000 nozzles. Total uses of the nozzle are expected to be 14,700 in September and 15,540 in October. Nozzles are purchased at a wholesale price of $8. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 21,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September.

Exercise 13-36 (Static) Estimate Purchases and Cash Disbursements (LO 13-3, 4) Ellot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 16,800 nozzles in stock, although the latest estimate for August production indicates a requirement for only 15,000 nozzles. Total uses of the nozzle are expected to be 14,700 in September and 15,540 in October. Nozzles are purchased at a wholesale price of $8. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 21,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 20E

See similar textbooks

Similar questions

Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 18,700 nozzles in stock, although the latest estimate for August production indicates a requirement for only 18,800 nozzles. Total uses of the nozzle are expected to be 18,500 in September and 19,340 in October. Nozzles are purchased at a wholesale price of $27. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 40,000 parts in July. Required: Estimate purchases of the nozzle (in units) for August and September. Estimate the cash disbursements for nozzles in August and September.
Exercise 13-36 (Algo) Estimate Purchases and Cash Disbursements (LO 13-3, 4) Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 17,900 nozzles in stock, although the latest estimate for August production indicates a requirement for only 17,200 nozzles. Total uses of the nozzle are expected to be 16.900 in September and 17,740 in October. Nozzles are purchased at a wholesale price of $19. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 32,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements…
Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 17,100 nozzles in stock, although the latest estimate for August production indicates a requirement for only 15,600 nozzles. Total uses of the nozzle are expected to be 15,300 in September and 16,140 in October. Nozzles are purchased at a wholesale price of $11. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 24,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September. Complete this question by entering your…
Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 17,300 nozzles in stock, although the latest estimate for August production indicates a requirement for only 16,000 nozzles. Total uses of the nozzle are expected to be 15,700 in September and 16,540 in October. Nozzles are purchased at a wholesale price of $13. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 26,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September. Complete this question by entering your…
Preparing a financial budget—schedule of cash receipts and schedule of cash payments Agua Cool is a distributor of bottled water. For each of the items, compute the amount of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item. Management expects to sell equipment that cost $14,000 at a gain of $7,000. Accumulated depreciation on this equipment is $55,000. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for $14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one—half of commissions and other selling expenses in the month incurred, with the balance paid the following month.
Budgeting Production, Direct Materials and Income Statement Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $42,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: • The company budgeted sales at 13,000 units per month in February, April, and May and at 10,000 units in March. The selling price is $61 per unit. • The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. • The inventory of finished goods on February 1 was 2,500 units. The desired finished goods inventory at the end of…
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
Hugo Medical Supply has applied for a loan. Pacific Commerce Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Hugo Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance, $52,600; accumulated depreciation, $41,300. b. April capital expenditures of $ 42,400 budgeted for cash purchase of equipment. c. April depreciation expense, $700. d. Cost of goods sold, 60%of sales. e. Other April operating expenses, including income tax, total $14,200, 35% of which will be paid in cash and the remainder accrued at April 30. f. March 31 owners' equity, $92,600. g. March 31 cash balance, $40,300. h. April budgeted sales, $90,000, 70% of which is for cash. Of the remaining 30%, half will be collected in April and half in May. i. April cash collections on March sales, $29,100. j. April cash payments of March 31 liabilities incurred for March…
Exercise 13-39 (Algo) Prepare Budgeted Financial Statements (LO 13-6) Varmit-B-Gone is a pest control service that operates in a suburban neighborhood. The company attempts to make service calls at least once a month to all homes that subscribe to its service. It makes more frequent calls during the summer. The number of subscribers also varies with the season. The number of subscribers and the average number of calls to each subscriber for the months of interest follow: Subscribers Service calls (per subscriber) March 1,350 0.6 April 1,450 0.9 May 2,150 1.5 June 2,350 2.5 July 2,350 3.0 August 2,000 2.4 The average price charged for a service call is $80. Of the service calls, 30 percent are paid in the month the service is rendered, 60 percent in the month after the service is rendered, and 8 percent in the second month after. The remaining 2 percent is uncollectible. Varmit-B-Gone estimates that the number…
Completing a comprehensive budgeting problem—merchandising Company Alliance Printing Supply of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows: As Alliance Printing Supply’s controller, you have assembled the following additional information: April dividends of $7,000 were declared and paid. April capital expenditures of $16,300 budgeted for cash purchase of equipment. April depreciation expense, $1,000. Cost of goods sold, 40% of sales. Desired ending inventory for April is $22,400. April selling and administrative expenses include salaries of $37,000, 30% of which will be paid in cash and the remainder paid next month. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April. April budgeted sales, $89,000, 80% collected in April and 20°/0 in May. April cash payments of March 31…
Fairview Medical Supply has applied for a loan. First American Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Fairview Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance, $52,700; accumulated depreciation, $41,100. b. April capital expenditures of $42,700 budgeted for cash purchase of equipment. c. April depreciation expense, $500. d. Cost of goods sold, 60% of sales. e. Other April operating expenses, including income tax, total $13,400, 30%of which will be paid in cash and the remainder accrued at April 30. f. March 31 owners' equity, $93,600. g. March 31 cash balance, $40,100. h. April budgeted sales, $91,000, 70% of which is for cash. Of the remaining 30%, half will be collected in April and half in May. i. April cash collections on March sales, $29,200. j. April cash payments of March 31 liabilities incurred…
Operating Budget, Comprehensive Analysis (5) The unit selling price of the wiring harness assembly is $110. In February, the company plans to purchase land for future expansion. The land costs $68,000. All sales and purchases are for cash. The cash balance on January 1 equals $62,900. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum. Required: Prepare a monthly operating budget for the first quarter with the following schedules: