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.

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter4: Internal Control And Cash

Section: Chapter Questions

Problem 66.2C

See similar textbooks

Similar questions

Question 4 Part I Advent used their historic collection percentages to budget for sales revenue for the first quarter of 2020as follows: January $100,000 February $175,000 March $250,000The company anticipates that approximately 80% of sales each month will be on credit. The historic percentages on collection are: 50% in the month of sale 40% in the month following the sale 10% two months following the sale Required: Prepare a monthly cash collections/receipts budget for the first quarter of 2020.
4B. Draw up a cashbudget for Amal showing the balance at the end of each month, from the following information for the six months from July to December 2020: (a) Opening cash (including bank) balance on 1 July 2020 OMR 8000 (b) Production in units: Jan Feb March April May June July Aug Sep Oct Nov Dec 600 720 810 900 960 1,050 1,110 1,140 1,020 930 780 750 (c) Raw materials used in production cost OMR 30 per unit. Of this, 60 per cent is paid in the month of production and remaining balance in the month after production (d) Direct labour costs of OMR 15 per unit are payable in the month of production. (e) Variable expenses are OMR 5 per unit, payable 40 per cent in the same month as production and remaining balance in the month after production (f) Sales at OMR 70 per unit: Jan Feb March April May June July Aug Sep Oct Nov Dec 500 600 700 960 870 1,000 900 1,050 1,200 950 850 800 Debtors to pay…
4C. Draw up a cashbudget for Amal showing the balance at the end of each month, from the following information for the six months from July to December 2019: (a) Opening cash (including bank) balance on 1 July 2019 OMR 3600 (b) Production in units: Jan 500 Feb800 March 700 April 900 May1000 June850 July890 Aug1050 Sep650 Oct750 Nov 900 Dec800 (c) Raw materials used in production cost OMR 25 per unit. Of this, 75 per cent is paid in the month of production and remaining balance in the month after production. (d) Direct labour costs of OMR 20 per unit are payable in the month of production. (e) Variable expenses are OMR 10 per unit, payable 50 per cent in the same month as production and remaining balance in the month after production. (f) Sales at OMR 70 per unit: Jan 450 Feb 600 March 900 April 800 May 850 June 700 July 1,000 Aug 800 Sep 900 Oct 500 Nov 600 Dec 750 Debtors to pay their accounts one month after that in which sales is made (g) Fixed expenses of OMR 1,200 per month…
QUESTION 3- Cash Budgets Jamieson Ltd is preparing to set up business on 1/7/2022 and has made the following forecast for the first six months of trading: July August Sept Oct Nov Dec Total Sales $525,000 588,000 616,000 630,000 658,000 672,000 3,689,000 Purchases $300,000 336,000 352,000 360,000 376,000 384,000 2,108,000 The expected selling price is $70 per unit. The cash collection pattern from debtors is expected to be: Cash customers - 30% of sales revenue will be for immediate cash and cash discount of 5% will be allowed. Credit customers - 70% of sales revenue will be from credit customers. These creditors will pay their bills 50% in month after sale and the remainder in the second month after sale. The purchases will be paid for 50% in month after purchase when 2% cash discount will be received. The remaining purchases will be paid for in the second month after purchase. Expected costs: Wages $45,000 per…
Question 1 Green Enterprises Ltd is preparing to set up a new business on the first of January 2021 to manufacture a single product. Below is the sales budget for the company for the first 6 months of 2021. Sales Budget January February March April May June Sales Unit 8 000 8 500 10 000 11 000 11 500 10 500 Sales Revenue 240 000 255 000 300 000 330 000 345 000 315 000 Additional Information; The Cash collections patterns from sales is expected to be as follows: Cash Customers 30% of sales revenue will be for immediate cash Credit Customers 70% of sales revenue will be from credit customers. These debtors will pay their bills, 50% in the month after sales and the reminder in the second month after sales. Stocks of finished goods are maintained 60% of the following months sales requirement, and the budgeted…
Question 1 Green Enterprises Ltd is preparing to set up a new business on the first of January 2021 to manufacture a single product. Below is the sales budget for the company for the first 6 months of 2021. Sales Budget January February March April May June Sales Unit 8 000 8 500 10 000 11 000 11 500 10 500 Sales Revenue 240 000 255 000 300 000 330 000 345 000 315 000 Additional Information; The Cash collections patterns from sales is expected to be as follows: Cash Customers 30% of sales revenue will be for immediate cash Credit Customers 70% of sales revenue will be from credit customers. These debtors will pay their bills, 50% in the month after sales and the reminder in the second month after sales. Stocks of finished goods are maintained 60% of the following months sales requirement, and the budgeted…
Question 1Ming Chung Limited is applying for additional bank overdraft finance to enable thecompany to make the plant and machinery purchase described below. The directorshave has asked you to draw up a cash budget for the 6 months to 30 June 2020 toprove to the bank that that overdraft finance will be repaid by 30 June 2020. Thecompany provides you with the following financial information:Month Sales Purchases Wages Overheads£ £ £ £November 2019 (actual) 45,800 18,400 9,600 6,000December 2019 (actual) 34,600 13,900 9,800 14,000January 2020 (budgeted) 42,200 16,800 10,500 7,000February 2020 (budgeted) 44,000 17,600 11,200 7,500March 2020 (budgeted) 54,000 21,600 13,500 18,800April 2020 (budgeted) 57,600 23,000 14,400 8,000May 2020 (budgeted) 61,800 24,700 15,300 9,200June 2020 (budgeted) 63,700 25,500 15,900 9,800Notes♦ The bank balance at 1 January 2020 is expected to be £25,000.♦ 60% of sales are for cash with the other 40% being on credit. 70% of creditsales pay in the month…
QUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…
QUESTION 3 REQUIRED Use the information provided below to prepare the following for Mustang Enterprises for January and February 2024. 3.1 Debtors Collection Schedule 3.2 Cash Budget. INFORMATION The following information was supplied by Mustang Enterprises: 1. Mustang Enterprises expects to have an unfavourable bank balance of R40 000 on 31 December 2023. 2. The monthly sales were projected as follows: 2023 Units November 44 000 December 53 000 2024 Units January 47 000 February 31 000 3. The selling price is R20 per unit (excluding any discounts). All the goods produced each month are expected to be sold in the same month. Sixty percent (60%) of the sales is expected to be on credit and the balance is for cash. Thirty percent (30%) of the cash sales is subject to a discount of 10%. 4. Credit sales are usually collected as follows: 20% in the month of sale, and these debtors receive a 5% discount. 75% in the month after the sale, and the rest is usually written off as bad debts. 5.…
10. Right Answer Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Check Answer Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Check Answer Company's…
Ch. 8 Expected Cash Disbursements Question Please solve and explain the following problem with formula typed out. Pastoria Enterprises has scheduled raw materials purchases of $100,000 in Janurary $130,000 in February and $150,000 in March. The company pays for 75% of its purchases in the month of purchases and 25% in the month after purchase. What is the expected cash disbursement for the month of February?
Question 3 The Plantd’ Company’s budgeted sales for the first quarter of 2020 are as follows: N$ January 400 000 February 320 000 March 480 000 Total 1 200 000 Credit sales are normally collected as follows: Percent (%) In the month of sale 50 The month following the sale 30 The second month following the month of the sale 20 Total…