Concept explainers
Green Landscaping Inc. is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected.
Clients usually pay 60% of their fee in the month that service is performed. 30% the month after, and 10% the second month after receiving service.
Actual service revenue for 2016 and expected service revenues for 2017 are November 2016, $80,000; December 2016, $90,000; January 2017, $100,000; February 2017, $120,000; and March 2017, $140,000.
Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2016 and expected purchases for 2017 are December 2016, $14,000; January 2017, $12,000; February 2017, $15,000; and March 2017, $18,000.
Instructions
(a) Prepare the following schedules for each month in the first quarter of 2017 and for the quarter in total:
(1) Expected collections from clients.
(2) Expected payments for landscaping supplies.
(b) Determine the following balances at March 31, 2017:
(1)
(2) Accounts payable.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Managerial Accounting: Tools for Business Decision Making
Additional Business Textbook Solutions
Financial Accounting
Horngren's Accounting (11th Edition)
Managerial Accounting (5th Edition)
Managerial Accounting (4th Edition)
Intermediate Accounting
Horngren's Financial & Managerial Accounting, The Financial Chapters (6th Edition)
- The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.arrow_forwardEcho Amplifiers prepared the following sales budget for the first quarter of 2018: It also has this additional information related to its expenses: Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018.arrow_forwardCASH 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.arrow_forward
- Striker Corporation is preparing its cash payments budget for next month. The following information pertains to the cash​ payments: How much cash will be paid out next month?  a. Striker Corporation pays for 55% of its direct materials purchases in the month of purchase and the remainder the following month. Last​ month's direct material purchases were $73,000​, while the company anticipates $85,000 of direct material purchases next month. b. Direct labor for the upcoming month is budgeted to be $37,000 and will be paid at the end of the upcoming month. c. Manufacturing overhead is estimated to be 150% of direct labor cost each month and is paid in the month in which it is incurred. This monthly estimate includes $18,000 of depreciation on the plant and equipment. d. Monthly operating expenses for next month are expected to be $45,000​, which includes $2,800 of depreciation on office equipment and $1,200 of bad debt expense. These monthly operating…arrow_forwardWILDHORSE COMPANY Cash Budget $ S January $ Februarrow_forwardIvanhoe Company expects to have a cash balance of $49,400 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2017. 1.Collections from customers: January $86,000, February $131,700 2.Payments to suppliers: January $45,600, February $50,300 3.Wages: January $34,300, February $40,300. Wages are paid in the month they are incurred. 4.Administrative expenses: January $24,300, February $33,000. These costs include depreciation of $1,300 per month. All other costs are paid as incurred. 5.Selling expenses: January $18,300, February $21,200. These costs are exclusive of depreciation. They are paid as incurred.      6.Sales of short-term investments in January are expected to realize $13,400 in cash. Ivanhoe has a line of credit at a local bank that enables it to borrow up to $40,300. The company wants to maintain a minimum monthly cash balance of $25,500.arrow_forward
- Whispering Winds Landscaping Company is preparing its budget for the first quarter of 2022. The next step in the budgeting process is to prepare cash receipts and cash payments schedules. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2021 and expected service revenues for 2022 are: November 2021, $130,000; December 2021, $100,000; January 2022, $144,000; February 2022, $161,000; March 2022, $170,000.Purchases of landscaping supplies are paid 30% in the month of purchase and 70% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $21,000; January 2022, $19,600; February 2022, $22,400; March 2022, $27,500. Determine the account receivable balances at March 31, 2022.arrow_forwardMerchant Industries is preparing its master budget for 2016. Relevant data pertaining to its sales budget are as follows: Sales for the year are expected to total 8,000,000 units. Quarterly sales are 25%, 30%, 15%, and 30%, respectively. The sales price is expected to be $2.00 per unit for the first quarter and then be increased to $2.20 per unit in the second quarter. Instructions Prepare a sales budget for 2016 for Merchant Industries.arrow_forwardSurity Corporation is preparing its cash payments budget for next month. The following information pertains to the cash payments: 1 Click the icon to view the data.) How much cash will be paid out next month? Surity Corporation Cash Payments Budget Cash payments for direct materials: 45% of last month's purchases 55% of next month's purchases Cash payments for direct labor Cash payments for manufacturing overhead Cash payments for operating expenses Cash payment for taxes Total cash paymentsarrow_forward
- Kronos Ltd is preparing a cash budget for May and June of 2021.  Past records reveal that 15% of all credit sales are collected during the month of sale, 45% in the month following the sale, 30% in the second month following the sale and 10% in the third month following the sale.  The company pays for 55% of purchases in the month after purchase, and the balance is paid in the month following that.  Selling expenses amount to $2 400 per month plus 10% of monthly sales.  Administrative expenses are estimated to be $9 800 per month, which includes $2 600 of depreciation expense.  Finance expenses are $1600 per month.  All selling and distribution, administrative, and finance and other expenses (except depreciation) are paid for when incurred.  It is planned to purchase equipment during May 2019 at a cost of $7 500.  A $5 800 loan payable will be repaid in full including interest charges during June 2019. The interest due at maturity date will be $750.   The company’s expected…arrow_forwardMartin Company expects to have a cash balance of $135,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows:  Collections from customers: January $246,500, February $435,000. Payments for direct materials: January $155,000, February $240,000 Direct labor: January $90,000, February $135,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $63,000, February $75,000. These costs include depreciation of $5,000 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $45,000, February $60,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $36,000 in cash. Martin Company has a line of credit at the local bank that enables it to borrow up to $75,000. The company wants to maintain a minimum monthly cash balance of $60,000.  Instructions (a)       Prepare a cash budget for…arrow_forwardChina Company expects to have a cash balance of $40,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $90,000, February $200,000. Payments for direct materials: January $60,000, February $95,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,000, February $41,000. These costs include depre- ciation of $1,000 per month. All other overhead costs are paid as incured. Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $10,000 in cash. China Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $25,000. Instructions Prepare a cash budget for January and February.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College