Deitz Corporation is projecting a cash balance of $33,300 in its December 31, 2019, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2020 shows total collections of $205,350. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $47,730. Other information gathered for the first quarter of 2020 is sale of equipment $3,330; direct labor $77,700, manufacturing overhead $38,850, selling and administrative expenses $49,950; and purchase of securities $15,540. Deitz wants to maintain a balance of at least $27,750 cash at the end of each quarter. Prepare a cash budget for the first quarter.

Deitz Corporation is projecting a cash balance of $33,300 in its December 31, 2019, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2020 shows total collections of $205,350. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $47,730. Other information gathered for the first quarter of 2020 is sale of equipment $3,330; direct labor $77,700, manufacturing overhead $38,850, selling and administrative expenses $49,950; and purchase of securities $15,540. Deitz wants to maintain a balance of at least $27,750 cash at the end of each quarter. 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

Thomas Company had the following information related to September 2020: 1) Depreciation on the store equipment was $60,000 for the month. 2) Sales of merchandise inventory for the month of September were $1,800,000, of which $1,200,000 was paid in cash and the remaining amount sold on credit. The cost of the merchandise sold was $1,080,000. 3) The next payroll will be $144,000 and will be paid on October 12. This payroll will cover wages earned during the last week of September and the first week of October. 4) The utility bill of $72,000 for the month of September was both received and paid in early October. 5) Thomas sold a company car for a gain of $12,000 on September 22. 6) On September 3, Thomas paid $6,000 for August’s telephone bill. 7) On October 1, Thomas received the September telephone bill, which totaled $12,000. The bill will be paid in mid-October. 8) Wages paid in cash to employees during the month totaled $288,000. This amount included $60,000 paid for work done in…
A company uses the percentage-of-completion method of accounting. In 2020, the company began work a project, which had a contract price of $22,300. Other details follow: 2020 2021 Costs incurred to date $6,000 $18,000 Estimated costs to complete, as of December 31 14,000 -0- Billings to date 11,460 16,830 Collections to date 9,470 14,650 In the journal entry to record progress billings for 2021, how much should Billings on Construction in Process be debited/credited? (Just enter the amount. DO NOT put a plus or minus sign in front of the amount.)
Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 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?
Fine Co. has the following sales forecasts for the third quarter of 2021: ₱85,000 (July), ₱88,000 (Aug), ₱82,000 (Sep). All sales are on credit. Seventy-five percent are collected in the month of sales and remainder is collected the following month. Minimum cash balance is ₱10,000. How much cash would be collected in August from sales?
Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley’s financial performance: Beginning-of-period balances:Accounts Receivable: $135,000Accounts Payable: $67,500Accumulated Factory Depreciation: $720,000Cash: $33,750 Estimates for end-of-period balances:Accounts Receivable: $168,750Accounts Payable: $45,000Accumulated Factory Depreciation: $740,000 Budgeted activity levels for the period:Sales: $625,000Purchases of Direct Materials: $112,000Direct Labor Wages: $187,500Manufacturing Overhead: $62,500Selling and Administrative Expenses: $105,000 Except for purchases of direct materials, all expenses are paid as incurred. What is the budgeted ending cash balance for the period? Select one: a. None of these options are correct. b. $223,000 c. $191,750 d. $175,500 e. $155,500
The beginning cash balance is $18,000. Sales are forecasted at $860,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $11,300 will be collected in the current year. The company is required to make a $14,000 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $95,000, and the annual interest rate is 8%. Compute the excess of available cash over cash disbursements. Excess of available cash over cash disbursements $
Give me correct answer and explanation.
6
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…