Ivanhoe Company expects to have a cash balance of $51,750 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $97,750, February $172,500. Payments for direct materials: January $57,500, February $86,250. Direct labor: January $34,500, February $51,750. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,150, February $28,750. These costs include depreciation of $1,725 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,250, February $23,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,800 in cash. Ivanhoe Company has a line of credit at a local bank that enables it to borrow up to $28,750. The company wants to maintain a minimum monthly cash balance of $23,000. Prepare a cash budget for January and February.

Ivanhoe Company expects to have a cash balance of $51,750 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $97,750, February $172,500. Payments for direct materials: January $57,500, February $86,250. Direct labor: January $34,500, February $51,750. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,150, February $28,750. These costs include depreciation of $1,725 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,250, February $23,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,800 in cash. Ivanhoe Company has a line of credit at a local bank that enables it to borrow up to $28,750. The company wants to maintain a minimum monthly cash balance of $23,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

Rodriguez, Inc., is preparing its direct labor budget for 2020 from the following production budget based on a calendar year. Quarter Units Quarter 3 1 2 20,000 25,000 4 Units 35,000 30,000 Each unit requires 1.50 hours of direct labor. Prepare a direct labor budget for 2020. Wage rates are expected to be $16 for the first 2 quarters and $18 for quarters 3 and 4. (Round Direct labor time per unit answers to 2 decimal places, eg. 52.50.) $ $ RODRIQUEZ, INC. Direct Labor Budget 2 Quarter $ $ 3 $ $ 4 Year
Fortune Company's direct materials budget shows the following cost of materials to be purchased for the coming three months: January February March Material purchases $ 13,120 $ 15,230 $ 12,050 Payments for purchases are expected to be made 50% in the month of purchase and 50% in the month following purchase. The December Accounts Payable balance is $7,800. The budgeted cash payments for materials in January are:
For Gundy Company, units to be produced are 5,130 in quarter 1 and 6,100 in quarter 2. It takes 1.5 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, 2020. GUNDY COMPANYDirect Labor Budgetchoose the accounting period For the Six Months Ending June 30, 2020June 30, 2020For the Quarter Ending June 30, 2020 Quarter 1 2 Six Months select an opening labor budget item Beginning Materials InventoryCost Per PoundDesired Ending InventoryDirect Labor Cost Per HourDirect Labor Time (Hours) Per UnitDirect Materials Per UnitDirect Materials PurchasesTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredTotal Pounds Required for ProductionTotal Required Direct Labor HoursUnits to be Produced enter a…
Company L charges all operating expenses to credit. They pay 70% of their accounts payable in the month following the expense, and 30% two months following the expense. Expenses (all paid for on credit) for the last three months have been provided below: August: $80,000 September: $120,000 October: $94,000 What is the budgeted cash outflow for October?
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
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
Rishi Sunak Manufacturing Pte. Ltd. is preparing its budget for next year. The company estimates that it will be making the following raw materials purchases in the last five months of 2021: $200,000 in August, $220,000 in September, $250,000 in October, $280,000 in November and $240,000 in December. The company anticipates that it will pay 55% of what is owed one month after the month of purchase, 30% of what is owed two months after the month of purchase and the remaining 15% three months after the month of purchase. What figure will be presented in the company’s cash budget for payments for raw materials purchases in December 2021? $233,500 $253,500 $262,000 $403,500
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 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…
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…
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
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.…