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

Zisk Co. purchases raw materials on account. Budgeted purchase amounts are April, $81,000; May, $111,000; and June, $121,000. Payments are made as follows: 75% in the month of purchase and 25% in the month after purchase. The March 31 balance of accounts payable is $23,000. Prepare a schedule of budgeted cash payments for April, May, and June. April May June Current month purchases 75% Ending accounts payable 25% Total purchases Zisk Co. Schedule of Cash Payments For April, May, and June April May June Cash payments for: Current month purchases Prior month purchases Budgeted cash payments for materials
Waterway Company prepares monthly cash budgets. Relevant data from operating budgets for 2027 are as follows. January February Sales $460,800 $512,000 Direct materials purchases 153,600 160,000 Direct labor 115,200 128,000 Manufacturing overhead 89,600 96,000 Selling and administrative expenses 101,120 108,800 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, which include $1,280 of depreciation per month. Other data: 1. Credit sales: November 2026, $320,000; December 2026, $409,600. 2. Purchases of direct materials: December 2026, $128,000. 3. Other receipts: January-Collection of December 31, 2026, notes…
In Ayayai Company, direct labor is $20 per hour. The company expects to operate at 12,400 direct labor hours each month. In January 2027, direct labor totaling $255,440 is incurred in working 12,896 hours. (a) Your answer is correct. Prepare a static budget report. Product Line Direct Labor CA $ Budget 248,000 +A $ AYAYAI COMPANY Static Direct Labor Budget Report For the Month Ended January 31, 2027 Actual 255,440 +A Difference 7,440 i Unfavorable
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 40% of next month's production needs. Beginning direct materials inventory for April was 1,541 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 June 642 670 676 Units to produce Check my work July 656
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units 800 1,300 1,500 Sales price $100 $100 $100 Budgeted sales $80,000 $130,000 $150,000 It also has this additional information related to its expenses: Direct material per unit $1.50 Direct labor per unit 2 Variable manufacturing overhead per hour 0.50 Fixed manufacturing overhead per month 2,900 Sales commissions per unit 15 Sales salaries per month 5,100 Delivery expense per unit 0.40 Factory utilities per month 5,000 Administrative salaries per month 21,000 Marketing expenses per month 8,000 Insurance expense per month 11,000 Depreciation expense per month 10,000 Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all amounts as positive numbers. Echo AmplifiersSales and Administrative BudgetFor the Quarter Ending March 31, 2018 January February March Budgeted Sales in Units…
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
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units BOD Sales price $100 $100 Budgeted sales $80,000 $130,000 $100,000 It also has this additional information related to its expenses: Direct material per unit Direct labor per unit Variable manufacturing overhead per hour Fixed manufacturing overhead per month Sales commissions per unit Sales salaries per month Delivery expense per unit Factory utilities per month Administrative salaries per month Marketing expenses per month Insurance expense per month Depreciation expense per month Budgeted Sales in Units Variable Expenses Sales Commissions 1,300 Delivery Total Variable Expenses Fixed Expenses Sales Salaris $100 Administrative Salaries Marketing Expenses Insurance Expense Depreciation Expense 1,500 Total Fixed Expenses Total Selling and Administrative Expenses $1.50 2 Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all…
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 11, 200 2nd Quarter 8,500 3rd Quarter 8,600 4th Quarter 10,980 Units to be produced Each unit requires 0.55 direct labor-hours, and direct laborers are paid $16.00 per hour. Required: 1. Prepare the company's direct labor budget for the upcoming fiscal year. (Round "Direct labor time per unit (hours)" answers to 2 decimal places.) Direct labor time per unit (hours) Total direct labor-hours needed Direct labor cost per hour Total direct labor cost Rordan Corporation Direct Labor Budget 2nd Quarter 1st Quarter 3rd Quarter 4th Quarter Year
Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and maintenance $0.50. Fixed overhead costs per quarter: supervisory salaries $35,000; depreciation $15,000; and maintenance $12,000. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.) ATLANTA COMPANYManufacturing Overhead Budget Quarter 1 2 3 4 Year $ $ $ $ $…
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.…
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