Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are asfollows.Collections from customers: January $85,000, February $150,000.Payments for direct materials: January $50,000, February $75,000.Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred.Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other overhead costs arepaid as incurred.Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred.Sales of marketable securities in January are expected to realize $12,000 in cash. Danner Company has a line of credit at a local bank that enables it toborrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $20,000.Prepare a cash budget for January and February. V:DANNER COMPANYCash Budget$14January$February

Ending cash balance = Beginning balance + Cash receipt - Cash disbursements + Borrowings -…

Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the follows. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other overhead costs paid as incurred. Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $12,000 in cash. Danner Company has a line of credit at a local bank that enabl borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $20,000.

Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the follows. Collections from customers: January $85,000, February $150,000. Payments for direct materials: January $50,000, February $75,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of $1,500 per month. All other overhead costs paid as incurred. Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $12,000 in cash. Danner Company has a line of credit at a local bank that enabl borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $20,000.

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

Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,400 units. Sales Costa PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,234,000 1,001,000 246,400 46,200 295,000 198,000 231,000 251,000 610,700 193,000 $ 161,700
Yeaman has $13,000 in cash on hand on January 1 and has collected the following budget data: (Click on the icon to view the budget data) Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Yeaman has cash payments for selling and administrative expenses including salaries of $65,000 per month plus commissions that are 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of $1,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Yeaman need to borrow cash by the end of February? Begin by preparing the cash budget for January, then prepare the cash budget for February (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar.) Data table Sales Cash receipts from customers Cash payments for direct materials purchases Direct labor costs Manufacturing overhead costs (includes…
Lily’s Manufacturing Company has budgeted the following unit sales: 2021 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2020, was 1,000 units. Each unit requires 2 pounds of raw materials that are estimated to cost an average of $3 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 10% of next month's anticipated sales. They also have a policy of maintaining a raw materials inventory at the end of each month equal to 20% of the pounds needed for the following month's production.…
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
For Crane Company, units to be produced are 5,300 in quarter 1 and 7,420 in quarter 2. It takes 1.6 hours to make a finished unit, and the expected hourly wage rate is $15 per hour. Prepare a direct labor budget by quarters for the 6 months ending June 30, 2022. $ $ CRANE COMPANY Direct Labor Budget 1 Quarter $ $ 2 $ Six Months
During June, Tarras Corporation plans to serve 46,000 customers. The company uses the following revenueand cost formulas in its budgeting, where Q is the number of customers served. Revenue:$4.40Q Wages and salaries:$34,600 + $1.67Q Supplies:$0.87Q Insurance:$15,000 Miscellaneous expenses:$5,600 + $0.57Q Required:Prepare the company's planning budget for June. Show all your calculations and you may round youranswers to the nearest dollar.
The Simmons Company finished their sales projections for the coming year. The company produces one product. Part of next year's sales projections are as follows. Projected Sales in Units July 125,000 August 145,000 September 139,000 October 155,000 November 180,000 The budget committee has also completed the following information on inventories. Raw Materials Ending Balance, June, 50,000 lbs Desired ending levels (monthly 10% of next month's production needs) Work-In-Progress None Finished Goods Inventory Ending Balance, June, 22,000 units Desired ending levels: 20% of next month's sales The Engineering Department has developed the following standards upon which the production budgets will be developed. Item Standard Material usage 3 pounds per unit Material price per pound $2.00 per pound Labor usage 0.5 hours per unit Labor rate $40 per hour Machine hours 2 machine hours per unit The Simmons Company uses a modified allocation method for…
6