Lily Industries' balance sheet at December 31, 2021, is presented below. LILY INDUSTRIES Balance Sheet December...

        

Transcribed Image Text:

Lily Industries' balance sheet at December 31, 2021, is presented below. LILY INDUSTRIES Balance Sheet December 31, 2021 Assets Current Assets Cash $8,250 Accounts receivable 80,850 Finished goods inventory (1,650 26,400 units) Total current assets 115,500 Property, Plant, and Equipment Equipment Less: Accumulated depreciation 33,000 Total assets $148,500 $44,000 11,000 Liabilities Liabilities and Stockholders' Equity Notes payable Accounts payable Total liabilities Stockholders' Equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Budgeted data for the year 2022 include the following. $44,000 27,500 $27,500 49,500 77,000 71,500 $148,500 2022 Quarter 4 Total Sales budget (9,400 units at $32) $90,240 $300,800 Direct materials used 18,700 68,750 Direct labor 13,750 55,990 Manufacturing overhead applied 11,000 53,460 Selling and administrative expenses 19,800 82,500 To meet sales requirements and to have 2,750 units of finished goods on hand at December 31, 2022, the production budget shows 9,900 required units of output. The total unit cost of production is expected to be $18. Lily uses the first-in, first-out (FIFO) inventory costing method. Interest expense is expected to be $3,850 for the year. Income taxes are expected to be 20% of income before income taxes. In 2022, the company expects to declare and pay an $8,800 cash dividend. The company's cash budget shows an expected cash balance of $27,704 at December 31, 2022. All sales and purchases are on account. It is expected that 60% of quarterly sales are collected in cash within the quarter and the remainder is collected in the following quarter. Direct materials purchased from suppliers are paid 50% in the quarter incurred and the remainder in the following quarter. Purchases in the fourth quarter were the same as the materials used. In 2022, the company expects to purchase additional equipment costing $9.900. $4.550 of depreciation expense on equipment is included in the budget data and split equally between manufacturing overhead and selling and administrative expenses. Lily expects to pay $8,800 on the outstanding notes payable balance plus all interest due and payable to December 31 (included in interest expense $3,850, above). Accounts payable at December 31. 2022, includes amounts due suppliers (see above) plus other accounts payable relating to manufacturing overhead of $7.920. Unpaid income taxes at December 31 will be $5,500. Prepare a budgeted statement of cost of goods sold. LILY INDUSTRIES Budgeted Cost of Goods Sold MA OCE Prepare a budgeted multiple-step income statement for 2022. LILY INDUSTRIES Budgeted Income Statement Prepare a retained earnings statement for 2022. (List Items that increase retained earnings first.) LILY INDUSTRIES Budgeted Retained Earnings Statement 3000 Prepare a budgeted classified balance sheet at December 31, 2022. (List Current Assets in order of liquidity) LILY INDUSTRIES Budgeted Balance Sheet Assets Liabilities and Stockholders' Equity Lily Industries' balance sheet at December 31, 2021, is presented below. LILY INDUSTRIES Balance Sheet December 31, 2021 Assets Current Assets Cash $8,250 Accounts receivable 80,850 Finished goods inventory (1,650 26,400 units) Total current assets 115,500 Property, Plant, and Equipment Equipment Less: Accumulated depreciation 33,000 Total assets $148,500 $44,000 11,000 Liabilities Liabilities and Stockholders' Equity Notes payable Accounts payable Total liabilities Stockholders' Equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Budgeted data for the year 2022 include the following. $44,000 27,500 $27,500 49,500 77,000 71,500 $148,500 2022 Quarter 4 Total Sales budget (9,400 units at $32) $90,240 $300,800 Direct materials used 18,700 68,750 Direct labor 13,750 55,990 Manufacturing overhead applied 11,000 53,460 Selling and administrative expenses 19,800 82,500 To meet sales requirements and to have 2,750 units of finished goods on hand at December 31, 2022, the production budget shows 9,900 required units of output. The total unit cost of production is expected to be $18. Lily uses the first-in, first-out (FIFO) inventory costing method. Interest expense is expected to be $3,850 for the year. Income taxes are expected to be 20% of income before income taxes. In 2022, the company expects to declare and pay an $8,800 cash dividend. The company's cash budget shows an expected cash balance of $27,704 at December 31, 2022. All sales and purchases are on account. It is expected that 60% of quarterly sales are collected in cash within the quarter and the remainder is collected in the following quarter. Direct materials purchased from suppliers are paid 50% in the quarter incurred and the remainder in the following quarter. Purchases in the fourth quarter were the same as the materials used. In 2022, the company expects to purchase additional equipment costing $9.900. $4.550 of depreciation expense on equipment is included in the budget data and split equally between manufacturing overhead and selling and administrative expenses. Lily expects to pay $8,800 on the outstanding notes payable balance plus all interest due and payable to December 31 (included in interest expense $3,850, above). Accounts payable at December 31. 2022, includes amounts due suppliers (see above) plus other accounts payable relating to manufacturing overhead of $7.920. Unpaid income taxes at December 31 will be $5,500. Prepare a budgeted statement of cost of goods sold. LILY INDUSTRIES Budgeted Cost of Goods Sold MA OCE Prepare a budgeted multiple-step income statement for 2022. LILY INDUSTRIES Budgeted Income Statement Prepare a retained earnings statement for 2022. (List Items that increase retained earnings first.) LILY INDUSTRIES Budgeted Retained Earnings Statement 3000 Prepare a budgeted classified balance sheet at December 31, 2022. (List Current Assets in order of liquidity) LILY INDUSTRIES Budgeted Balance Sheet Assets Liabilities and Stockholders' Equity

Answer rating: 100% (QA)

Lily Industries Budgeted Cost of Goods Sold For the Year Ending December 31 2022 Req 1 Beginning fin... View the full answer