Danner Company expects to have a cash balance of $55,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $105,400, February $186,000. Payments for direct materials: January $62,000, February $93,000. Direct labor: January $37,200, February $55,800. Wages are paid in the month they are incurred, Manufacturing overhead: January $26,040, February $31,000. These costs include depreciation of $1,860 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $18,600, February $24,800. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $14,880 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $31,000. The company wants to maintain a minimum monthly cash balance of $24,800. Prepare a cash budget for January and February Beginning Cash Balance Add O DANNER COMPANY Cash Budget $ O January February SL

Danner Company expects to have a cash balance of $55,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $105,400, February $186,000. Payments for direct materials: January $62,000, February $93,000. Direct labor: January $37,200, February $55,800. Wages are paid in the month they are incurred, Manufacturing overhead: January $26,040, February $31,000. These costs include depreciation of $1,860 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $18,600, February $24,800. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $14,880 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $31,000. The company wants to maintain a minimum monthly cash balance of $24,800. Prepare a cash budget for January and February Beginning Cash Balance Add O DANNER COMPANY Cash Budget $ O January February SL

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

Anderson Manufacturing Inc., aims to prepare a cash budget for September 2020. The cash balance at the beginning of September is $9,000. The actual sales for July and August and expected sales for September are: Information Cah Sales Sales on Accoun 0000 60,00 Tetal Sales July (5 Augut (5) Septemberis 14,300 Sales on account are collected over a three-month period in the following ratio: 10% in the month of sale, 70% in the month following sale 18% in the second month following sale 2% remaining are uncollectible. Additional information includes: (a) Purchases of inventory will total S 50,000 for September; 20% will be paid for in September. Accounts payable from August's inventory purchases is $ 32,000, all of which will be paid in September. (b) Selling and administrative expenses are budgeted at $ 26,000 for September; of which $ 8,000 is for depreciation. (c) Equipment costing $ 36,000 will be purchased for cash during September, and other miscellancous cash expenses of $ 6,000…
Zisk Company purchases direct materials on credit. Budgeted purchases are April, $80,000; May, $110,000; and June, $120,000. Cash payments for purchases are: 70% in the month of purchase and 30% in the first month after purchase. Purchases for March are $70,000. Prepare a schedule of cash payments for direct materials for April, May, and June.
S ABC Company's raw materials purchases for June, July, and August are budgeted at $39,000, $29,000, and $54,000, respectively. Based on past experience, ABC expects that 70% of a month's raw material purchases will be paid in the month of purchase and 30% in the month following the purchase. Required: Prepare an analysis of cash disbursements from raw materials purchases for ABC Company for August. Budgeted raw material purchases August cash payments: Current month's purchases Prior month's purchases Total cash payments June July August $ 0
Hayma Company's sales budget for 2022 in units for the next five months is as follows: January 20,000, February 26,000, March 32,000, April 40,000 and May 42,000. The Company's ending finished goods inventory policy is set for 25% of the following month's sales. January 1 beginning inventory is 2,800 units. How many units will be produced in March? O a. 34,000 O b. 24,700 O c. 40,500 O d. 30,000 O e. None of the given answers. O f. 27,500
Shalom Company prepared the following sales budget for the first two quarters of 2023: January February March April 10,000 14,000 11,000 15,000 May 18,000 June 20,000 Unit sales Shalom Company sells the product at P15 per unit. 20% of sales is cash, and the balance is on credit. The company estimates that collection of sales on account will be 60% in the month of sales with the remainder in the following month. On December 31, 2022, accounts receivable was P60,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) How much is the expected total cash receipts for January?
6
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 2024
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May: Sales 116,000 Manufacturing Costs 49,000 Selling and administrative expenses 34,000 Capital expenditures - June: Sales 143,000 Manufacturing costs 61,000 Selling and administrative expenses 39,000 Capital expenditures - July: Sales 186,000 Manufacturing Costs 67,000 Selling and administrative expenses 41,000 Capital expenditures 45,000 The company expects to sell about 15% of his merchandise for cash of sales account 65% are expected to be collected in the month following the sale and the remainder of the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80%…
Crane Company has 2,120 pounds of raw materials in its December 31, 2026, ending inventory. Required production for January and February of 2027 are 4,240 and 5,300 units, respectively. Two pounds of raw materials are needed for each unit, and the estimated cost per pound is $8. Management desires an ending inventory equal to 25% of next month's materials requirements. Prepare the direct materials budget for January. CRANE COMPANY Direct Materials Budget SA $