E21-15 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 overhead $35,000, selling and administrative expenses $45,000, and purchase of securities $14,000. Deitz wants to maintain a balance of at least $25,000 cash at the end of each quarter. Instructions Prepare a cash budget for the first quarter.

E21-15 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 overhead $35,000, selling and administrative expenses $45,000, and purchase of securities $14,000. Deitz wants to maintain a balance of at least $25,000 cash at the end of each quarter. Instructions Prepare a cash budget for the first quarter.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. How much cash would be collected in June from sales?
Bramble Corp. reported the following information for 2022: Budgeted purchases October November December $260000 $296000 $318000 • Operating expenses are: Salaries, $110000; Depreciation, $30000; Rent, $20000; Utilities, $28000 • Operating expenses are paid during the month incurred. • Accounts payable is used only for inventory acquisitions. What are budgeted cash disbursements for operating expenses in November? $158000 $454000 $149000 O $188000
The income statement for the first quarter of 2019 was as follows: Income Statement For the Quarter Ended March 31, 2019 Sales Cost of goods sold Gross profit Operating expenses ales salaries Rent expense Depreciation Utilities Miscellaneous Total operating expenses Net income $52,000 24,000 12,000 3,600 12,800 $720,000 396,000 324,000 104,400 $219,600 Prepare a budgeted quarterly income statement in tabular form for the first quarter of 2020.
Suppose 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?
The following information pertains to Omega Projects Ltd for the three months ended 31 December 2020. Actual Budgeted October November December R R R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional information: It is expected that debtors will settle their accounts as follows: 20% in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of The remaining 5% is usually written off as bad Trade creditors are paid in the month after the purchases at a discount of 5%. 50% of the salaries and wages are weekly wages. Because wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were…
None
Janniel Inc. is preparing its budget for 2016. Income statement for 2015 is presented below: Sales (100,000 units) P1,000,00 Cost of sales 600,000 Gross Profit P400,000 Operating expenses 240,000 Operating Income P160,000 Operating expenses includes depreciation of P40,000. For the year 2016, the company plans to increase selling price by 10% which is expected to decrease sales volume in units by 5%. The cost of sales as a percent of sales will increase to 62%. Other than depreciation, all operating costs are variable. Required: What is the budgeted income for 2016?
Give me correct answer and explanation.
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)
Please help me with show all calculation thanku
LB Enterprises (LB) is preparing its budget for the first quarter of 2019. LB's balance sheet as of December 31, 2018 is as follows: Assets Liabilities Cash $5,000 Accounts Payable $9500 Accounts Recievable 28,000 Inventories Direct Materials 8,100 Finished Goods (500 Units) 16,870 Stockholders Equity Equipment - gross 45,000 Accumulated depreciation 15.000 Common Stock $15,000 Net Equipment 30,000 Retained Earnings 63,470 Total Assets $87,970 Total Liabilities and $87,960 Equity LB sells one product for $45/unit. The Company forecasts that it will sell 2,000; 1,500; 1,600; and 1,700 units in January, February, March and April, respectively. • Sales to customers are all on credit. 40% of the cash for these sales is collected in the month of the sale and the remaining 60% is collected in the following month. LB wants finished goods inventory equal to 25% of the next month's sales on hand at the end of each month. LB wants direct materials equal to 75% of the current month's production…
Romeo Lindo, the management accountant at “Woods Household Supplies” is in the process of planning the company’s cash needs for the last quarter of 2016. Extracts from the sales and purchases budgets are as follows:Month2016CashSalesSalesOnAccountPurchasesOnAccountAugust$71,000$520,000$420,000September$55,500$640,000$400,000October$38,400$760,000$520,000November$36,500$680,000$440,000December$56,750$850,000$540,000(i) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale40% in the first month following the sale10% in the second month following the sale(ii) Accounts payable are settled as follows, in accordance with the credit terms 5/30, n60:75% in the month in which the inventory is purchased25% in the following month(iii) In the month of November, an old motor vehicle, with net book value of $95,000, will be sold for cash to an employee…