Concept explainers
Deitz Corporation is projecting a cash balance of $30,000 in its December 31,2016. balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2017 shows total collections of $185,000. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $43,000. Other information gathered for the first quarter of 2017 is sale of equipment $3,000, direct labor $70,000, manufacturing
Instructions
Prepare a
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
MANAGERIAL ACCT.-WILEYPLUS BLKBRD PKG
Additional Business Textbook Solutions
Financial Accounting (12th Edition) (What's New in Accounting)
Managerial Accounting (4th Edition)
Horngren's Accounting (12th Edition)
Intermediate Accounting (2nd Edition)
Financial Accounting, Student Value Edition (4th Edition)
Principles of Accounting Volume 1
- Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?arrow_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_forwardSuppose that the Sales in December 2019 were 41,498. The sales are expected to grow by 5% in January 2020, by 10% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 9%. The company's cash collection is as follows: 24% is collected in the same month, 47% is collected in the next month, and the remainder in the following month. What is the cash collection for July, 2020?arrow_forward
- Suppose that the Sales in December 2019 were 78,893. The sales are expected to grow by 15% in January 2020, by 4% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 4%. The company's cash collection is as follows: 22% is collected in the same month, 22% is collected in the next month, and the remainder in the following month. What is the cash collection for June, 2020?arrow_forwardSuppose that the Sales in December 2019 were 26,630. The sales are expected to grow by 7% in January 2020, by 5% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 11%. The company's cash collection is as follows: 71% is collected in the same month and the remainder in the next month. What is the cash collection for July, 2020?arrow_forwardOn its December 31, 2017, balance sheet, Calgary Industries reports equipment of $465,000 and accumulated depreciation of $93,000. During 2018, the company plans to purchase additional equipment costing $99,000 and expects depreciation expense of $39,500. Additionally, it plans to dispose of equipment that originally cost $51,500 and had accumulated depreciation of $7,500. The balances for equipment and accumulated depreciation, respectively, on the December 31, 2018 budgeted balance sheet are:arrow_forward
- Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period?…arrow_forwardCrane Company expects to have a cash balance of $60,350 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $85,350, February $160,350. 2. Payments to suppliers: January $54,350, February $89,350. 3. Wages: January $30,490, February $40,490. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,490, February $24,490. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $15,490, February $20,490. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $12,490 in cash. Crane 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 $34,350. Prepare a cash budget for January and February.arrow_forwardUsing the information provided, what is the length of the production cycle for the firm? Allied Industries, Inc. Selected Income Statement Items, 2017 Cash Sales $1,500,000 Credit Sales $7,500,000 Total Sales $9,000,000 COGS $6,000,000 Allied Industries, Inc. Selected Balance Sheet Accounts 12/31/201712/31/2016Change Accounts Receivable $270,000 $240,000 $30,000 Inventory $125,000 $100,000 $25,000 Accounts Payable $110,000 $90,000 $20,000arrow_forward
- D’s Company Ltd expects to have a cash balance of $45000 on March 1, 2024.Relevant monthly budget data for the months of March and April are as follows:• Collections from customers: March $85000; April $150000• Payments for direct materials: March $50000; April $75000• Direct labour: March $30000; April $45000. Wages are paid in the month they are incurred.• Manufacturing overhead: March $21000; April $25000. These costs include depreciation of$1500 per month. All other overhead costs are paid as incurred.• Selling and administrative expenses: March $15000; April $20000. These costs are exclusive ofdepreciation. They are paid as incurred.• Sales of marketable securities in March are expected to be realised $12000 in cash.D’s Company Ltd. has a line of credit at a local bank that enables it to borrow up to$25000. Thecompany wants to maintain a minimum monthly cash balance of $20000. prepare cash budgets for march n april 2024arrow_forwardDuring 2014, Sigma Company earned service revenues amounting to $720,000, of which $605,000 was collected in cash; the balance will be collected in January 2015. Also in 2014 there were collections of cash prior to the delivery of goods/services totaling $11,800. What amount should the 2014 income statement report for service revenues?arrow_forwardBonita Company expects to have a cash balance of $52,200 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $98,600, February $174,000. Payments for direct materials: January $58,000, February $87,000. Direct labor: January $34,800, February $52,200. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,360, February $29,000. These costs include depreciation of $1,740 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,400, February $23,200. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,920 in cash. Bonita Company has a line of credit at a local bank that enables it to borrow up to $29,000. The company wants to maintain a minimum monthly cash balance of $23,200.Prepare a cash budget for January and February.…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College