### Cash Budget for Danner CompanyDanner Company projects a starting cash balance of $54,000 as of January 1, 2020. The following are the anticipated monthly budget details for January and February 2020.#### Cash Receipts- **Collections from Customers:** - January: $102,000 - February: $180,000#### Cash Disbursements- **Payments for Direct Materials:** - January: $60,000 - February: $90,000- **Direct Labor:** - January: $36,000 - February: $54,000 - **Note:** Wages are paid in the month they are incurred.- **Manufacturing Overhead:** - January: $25,200 - February: $30,000 - **Note:** These costs include depreciation of $1,800 per month. All other overhead costs are paid as incurred.- **Selling and Administrative Expenses:** - January: $18,000 - February: $24,000 - **Note:** These costs are exclusive of depreciation. They are paid as incurred.#### Additional Financial Information- **Sales of Marketable Securities (January):** $14,400- **Line of Credit:** Danner Company has access to a line of credit from a local bank enabling it to borrow up to $30,000.- **Minimum Monthly Cash Balance Requirement:** $24,000### Required Task- **Objective:** Prepare a cash budget for January and February.Please ensure all cash inflows and outflows are properly accounted for to maintain the minimum required monthly cash balance of $24,000.For further understanding, create the cash budget table to include:- Beginning cash balance- Add: Cash collections- Total cash available- Less: Cash disbursements- Ending cash balance before borrowing- Borrowing (if necessary)- Ending cash balance after borrowing ### Cash Budget Template for Danner CompanyThe following template is designed to help Danner Company create a cash budget for the upcoming months. This template comprises various input fields and dropdown lists to systematically organize anticipated cash inflows and outflows. The structure allows for data entry for both January and February, ensuring ease of tracking and comparison.#### Template Overview**Header:**- **Company Title:** DANNER COMPANY- **Section Title:** Cash Budget**Budgeting Table:**| | January | February ||---|---------|----------|| **Line Items** | $ [Input Field] | $ [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] || [Dropdown List] | [Input Field] | [Input Field] |**Description:**This table is arranged to facilitate the documentation of financial figures, with separate columns dedicated to the months of January and February. Each dropdown list corresponds to different categories of cash inflows and outflows which users can select. Adjacent to each category selection, there are input fields where respective monetary values are to be entered.Users should populate the fields accurately to maintain an effective and reliable cash budget.**Graphical Guidance:**- **Dropdown List:** This feature allows users to select predefined categories for their cash transactions.- **Input Fields:** Blank spaces are provided next to each dropdown list for users to enter relevant cash amounts for each category.This template is a crucial tool for financial planning, enabling the company to anticipate its cash needs and make informed decisions. Users must ensure accurate data entry to reflect the company's financial situation as closely as possible.

Danner Company expects to have a cash balance of $54,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $102,000, February $180,000. Payments for direct materials: January $60,000, February $90,000. Direct labor: January $36,000, February $54,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $25,200, February $30,000. These costs include depreciation of $1,800 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $18,000, February $24,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $14,400 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $30,000. The company wants to maintain a minimum monthly cash balance of $24,000. Prepare a cash budget for January and February.

Danner Company expects to have a cash balance of $54,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $102,000, February $180,000. Payments for direct materials: January $60,000, February $90,000. Direct labor: January $36,000, February $54,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $25,200, February $30,000. These costs include depreciation of $1,800 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $18,000, February $24,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $14,400 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $30,000. The company wants to maintain a minimum monthly cash balance of $24,000. Prepare a cash budget for January and February.

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

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.…
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…
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
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
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
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
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)
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.
Please help me
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
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 $