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

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…
Crane Company expects to have a cash balance of $60,350 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $85,350, February $160,350. 2. Payments to suppliers: January $54,350, February $89,350. 3. Wages: January $30,490, February $40,490. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,490, February $24,490. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $15,490, February $20,490. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $12,490 in cash. Crane Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $34,350. Prepare a cash budget for January and February.
Zisk Company purchases direct materials on credit. Budgeted purchases are April, $85,000; May, $115,000; and June, $125,000. Cash payments for purchases are: 75% in the month of purchase and 25% in the first month after purchase. Purchases for March are $75,000. Prepare a schedule of cash payments for direct materials for April, May, and June. Schedule of Cash Payments for Direct Materials April May Materials purchases Cash payments for: ZISK COMPANY Total cash payments June
Zira Company reports the following production budget for the next four months. Each finished unit requires four pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 847 pounds. Direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) Units to produce April May June 706 760 738 Units to produce Materials required per unit Materials needed for production (pounds) Add: Desired ending materials inventory (pounds) Total materials required (pounds) Less: Beginning materials inventory (pounds) Materials to purchase (pounds) Materials cost per pound Cost of direct materials purchases July 718 ZIRA COMPANY Direct Materials Budget April $ $ 706 4 2,824 2,824 ↑ 5 $ 0 $ May 760 4 3,040 Saved 3,040 June 5 $ 0 $ 738 units 4 pounds 2,952 pounds 2,952 pounds 5 per pound 0…
Wala Incorporated bases its selling and administrative expense budget on the number of units sold. The variable selling and administrative expense is $3.70 per unit. The budgeted fixed selling and administrative expense is $30,360 per month, which includes depreciation of $3,630. The remainder of the fixed selling and administrative expense represents current cash flows. The sales budget shows 3,100 units are planned to be sold in July. Required: Prepare the selling and administrative expense budget for July.
Ramos Company provides the following budgeted production for the next four months. Units to produce April 620 May June July 750 720 720 Each finished unit requires 5 pounds of direct materials. The company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 930 pounds. Direct materials cost $2 per pound. Prepare a direct materials budget for April, May, and June. Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Materials cost per pound Cost of direct materials purchases RAMOS COMPANY Direct Materials Budget April May June 620 750 720 units 0
Zira Company reports the following production budget for the next four months. Each finished unit requires five pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 20% of next month's production needs, Beginning direct materials inventory for April was 634 pounds. Direct materials cost $6 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) April May 675 June July Units to produce 634 667 647 ZIRA COMPANY Direct Materials Budget April May June Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Cost of direct materials purchases
Kirkland Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2020, the following data are available. Sales: 20,500 units quarter 1: 22.200 units quarter 2 Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 3% Fixed costs per quarter: sales salaries $10,500, office salaries $6,250, depreciation $4,340, insurance $2,000, utilities $860, and repairs expense $690. 4. Unit selling price: $24. 1. 2 3. Prepare a selling and administrative expense budget by quarters for the first 6 months of 2020. (List variable expenses before fixed expense)
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…
Harper Manufacturing determines allocation rates as part of its annual budgeting process, which takes place 1 month before the beginning of the year. The company reports the following manufacturing overhead information as part of its budgeting process: Budgeted MOH Budgeted production (units) Budgeted direct labor hours Cost Pool Cost Pool 1 Cost Pool 2 Total Total Cost $ 6,000,000 $ 9,000,000 $ 15,000,000 $ 15,000,000 25,000,000 40,000 Allocation Base Unit Direct labor hour Question a. Assuming that Harper uses a traditional job costing system with a single allocation base (units), what is the predetermined overhead rate for the upcoming year? Note: Round your answer to 2 decimals. b. Assume Job 189 comprises 36 units and 2 direct labor hours. If Harper uses a traditional job costing system with a single allocation base (units), what is the total manufacturing overhead allocated to the job? Note: Round your answer to 2 decimals. c1. Now assume that Harper uses a two-stage job costing…
Parlex Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first 6 months of 2019, the following data are available. . Sales: 20,000 units quarter 1; 22,000 units quarter 2. Variable costs per dollar of sales: sales commissions 5%, delivery expense 2%, and advertising 4%. Fixed costs per quarter: sales salaries $10,000, office salaries $8,000, depreciation $4,200, insurance $1,500, utilities $800, and repairs expense $500. Unit selling price: $20. Instructions: Prepare a selling and administrative expense budget by quarters for the first 6 months of 2019.
Zira Company reports the following production budget for the next four months. Each finished unit requires six pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 1,156 pounds. Direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) April May 642 670 Units to produce Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Cost of direct materials purchases June 676 July 656 ZIRA COMPANY Direct Materials Budget April May June