Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget January February

Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget January 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

Bareta Sopa Products has an inventory of 25,000 units of finished products on January 1. Sales forecast (in units) for the succeeding months follows: January - 40,000 February - 55,000 March - 50,000 April - 70,000 May - 60,000 The company maintains a finished goods inventory equal to 40 percent of the forecast sales of the next month. Each unit of a product requires 3 pounds of raw materials at P5 per pound. The budgeted direct labor cost is P8 per hour, and each finished unit requires 30 minutes. Variable factory overhead is 40 percent of raw materials costs. Fixed factory overhead including depreciation is P10,000, totals P90,000 per month. Normal volume is 60,000 units per month. Selling price is P30 per unit. Required: Prepare budgeted gross profit showing cost of goods manufactured for 3 months ending March and total per quarter.
Please complete the instructional questions (a) and (b) so I can check my work. Thank you. -Mitch
Bareta Sopa Products has an inventory of 25,000 units of finished products on January 1. Sales forecast (in units) for the succeeding months follows: January - 40,000 February - 55,000 March - 50,000 April - 70,000 May - 60,000 The company maintains a finished goods inventory equal to 40 percent of the forecast sales of the next month. Each unit of a product requires 3 pounds of raw materials at P5 per pound. The budgeted direct labor cost is P8 per hour, and each finished unit requires 30 minutes. Variable factory overhead is 40 percent of raw materials costs. Fixed factory overhead including depreciation is P10,000, totals P90,000 per month. Normal volume is 60,000 units per month. Selling price is P30 per unit. Required: 1. Determine the cost of producing a finished product per unit. Show solution
China Company expects to have a cash balance of $40,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $90,000, February $200,000. Payments for direct materials: January $60,000, February $95,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,000, February $41,000. These costs include depre- ciation of $1,000 per month. All other overhead costs are paid as incured. 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 $10,000 in cash. China 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 $25,000. Instructions Prepare a cash budget for January and February.
Denger
Sunland Company has 1,920 pounds of raw materials in its December 31, 2021, ending inventory. Required production for January and February of 2022 are 4,800 and 6,000 units, respectively. Two pounds of raw materials are needed for each unit, and the estimated cost per pound is $5. Management desires an ending inventory equal to 20% of next month's materials requirements. Prepare the direct materials budget for January. SUNLAND COMPANY Direct Materials Budget +A $ +A $
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
Ramos Company provides the following (partial) production budget for the next three months. Each finished unit requires 0.6 hour of direct labor at the rate of $21 per hour. The company budgets variable overhead at the rate of $25 per direct labor hour and budgets fixed overhead of $8,500 per month. Production Budget April May June Units to produce 490 620 590 1. Prepare a direct labor budget for April, May, and June.2. Prepare a factory overhead budget for April, May, and June.
Yordi Company expects to produce 1,710 units in January and 1,836 units in February. Yordi budgets three direct labor hours per unit. Direct labor costs average $18 per hour. Prepare Yordi's direct labor budget for January and February. Begin by preparing the direct labor budget for January and February through the total direct labor hours needed for production line and then complete the budget by calculating the budgeted direct labor cost. Yordi Company Direct Labor Budget Two Months Ended January 31 and February 28 January February Direct labor hours needed for production
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units 900 1,300 1,400 Sales price $100 $100 $100 Budgeted sales $90,000 $130,000 $140,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.40 Fixed manufacturing overhead per month 3,000 Sales commissions per unit 16 Sales salaries per month 5,100 Delivery expense per unit 0.50 Factory utilities per month 4,000 Administrative salaries per month 20,000 Marketing expenses per month 7,000 Insurance expense per month 12,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.
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…