Expects to have a cash balance of $41,400 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $78,200, February $138,000. Payments for direct materials: January $46,000, February $69,000. Direct labor: January $27,600, February $41,400, Wages are paid in the month they are incurred. Manufacturing overhead: January $19,320, February $23,000. These costs include depreciation of $1,380 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $13,800, February $18,400, These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11.040 in cash. Coronado Company has a line of credit at a local bank that enables it to borrow up to $23,000. The company wants to maintain a minimum monthly cash balance of $18,400. Prepare a cash budget for January and February.

Expects to have a cash balance of $41,400 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $78,200, February $138,000. Payments for direct materials: January $46,000, February $69,000. Direct labor: January $27,600, February $41,400, Wages are paid in the month they are incurred. Manufacturing overhead: January $19,320, February $23,000. These costs include depreciation of $1,380 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $13,800, February $18,400, These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11.040 in cash. Coronado Company has a line of credit at a local bank that enables it to borrow up to $23,000. The company wants to maintain a minimum monthly cash balance of $18,400. 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

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…
Please show calculation
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.…
Show Me How eBook Entries for stock dividends Instructions Chart of Accounts Journal Instructions Pro-Builders Corporation has 242,000 shares of $45 par common stock outstanding. On September 2, Pro-Builders Corporation declared a 2% stock dividend to be issued November 30 to stockholders of record on October 3. The market price of the stock was $48 per share on September 2. Journalize the entries required on September 2, October 3, and November 30. If no entry is required, simply skip to the next transaction. Refer to the Chart of Accounts for exact wording of account titles. Journal JOURNAL DESCRIPTION POST. REF. DEBIT CREDIT S Check My Work 3 more Check My Work uses remaining 2 3 4 DATE Print Item PAGE 10 ACCOUNTING EQUATION LIABILITIES ASSETS EQUITY X
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
Sunland Company has accumulated the following budget data for the year 2022: 1. 2. 3. 4. 5. 6. Sales: 29,200 units; unit selling price $82 Cost of one unit of finished goods: direct materials, 2 kg at $5 per kilogram; direct labour, 3 hours at $13 per hour; and manufacturing overhead, $5 per direct labour hour Inventories (raw materials only): beginning, 9,900 kg; ending, 15,700 kg Raw materials cost: $5 per kilogram Selling and administrative expenses: $219,000 Income taxes: 30% of income before income taxes Prepare a schedule showing the calculation of the cost of goods sold for 2022. SUNLAND COMPANY Computation of Cost of Goods Sold For the Year Ending December 31, 2022 Cost of goods sold Manufacturing overhead Beginning inventory Direct materials Ending inventory Number of units sold Selling and administrative expenses Direct labour Cost of one unit of finished goods eTextbook and Media $ $ $
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.
Coronado Company prepares monthly cash budgets. Relevant data from operating budgets for 2022 are as follows. January February Sales $331,200 $368,000 Direct materials purchases 110,400 115,000 Direct labor 82,800 92,000 Manufacturing overhead 64,400 69,000 Selling and administrative expenses 72,680 78,200 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses that include $920 of depreciation per month.Other data: 1. Credit sales: November 2021, $230,000; December 2021, $294,400. 2. Purchases of direct materials: December 2021, $92,000. 3. Other…
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…
6