70.2K
Verified Solution
Link Copied!
With the given information above, how do I create the budgeted income statement?
Total cost ENDING FINISHED GOODS INVENTORY BUDGET (ABSORPTION COSTING): Quantity $ Cost Production cost per unit: Direct Materials 2 lbs. 4.00 Direct Labor 1 hours 13.00 MOH* 1 hours 6.39 Unit product cost 8.00 13.00 6.39 27.39 $ Budgeted finished goods inventory: Ending finished goods inventory (units)** Multiply by unit product cost Ending finished goods inventory ($) $ $ 650 27.39 17,803.50 * Overhead applied based on direct labor hours. ** From production budget (desired ending inventory). SALES BUDGET: Quarter 1 2 4,000 6,000 45 $ 45 $ 180,000 $ 270,000 $ Budgeted Unit Sales Sales Price per unit Total sales 3 7,500 45 $ 337,500 $ 4 5,000 45 $ 225,000 $ Year 22,500 45 1,012,500 $ $ $ Beginnign accounts receiveable first Q sales second Q sales third Q sales fourth Q sales Total cash collected EXPECTED CASH COLLECTIONS: 40,000 126,000 54,000 189,000 81,000 236,250 40,000 180,000 270,000 337,500 157,500 985,000 101,250 157,500 258,750 $ $ 166,000 $ 243,000 $ 317,250 $ PRODUCTION BUDGET: Quarter 1 2 4,000 6,000 unit sales (sales budget) 3 7,500 4 5,000 Year 22,500 plus desired ending inventory total unit needs less beginning inventory Production needs in units) 600 4,600 400 4,200 750 6,750 600 500 8,000 750 7,250 700 5,700 500 5,200 700 23,200 400 22,800 6,150 BUDGETED INCOME STATEMENT Budget: Sales Sales, FGI $ 1,012,500 1,014,750 Sales COGS Gross Margin S&A Expenses Net Operating Income Interest expense Net Income S&A Exp. 282,200 Cash 1,750 Total cost ENDING FINISHED GOODS INVENTORY BUDGET (ABSORPTION COSTING): Quantity $ Cost Production cost per unit: Direct Materials 2 lbs. 4.00 Direct Labor 1 hours 13.00 MOH* 1 hours 6.39 Unit product cost 8.00 13.00 6.39 27.39 $ Budgeted finished goods inventory: Ending finished goods inventory (units)** Multiply by unit product cost Ending finished goods inventory ($) $ $ 650 27.39 17,803.50 * Overhead applied based on direct labor hours. ** From production budget (desired ending inventory). SALES BUDGET: Quarter 1 2 4,000 6,000 45 $ 45 $ 180,000 $ 270,000 $ Budgeted Unit Sales Sales Price per unit Total sales 3 7,500 45 $ 337,500 $ 4 5,000 45 $ 225,000 $ Year 22,500 45 1,012,500 $ $ $ Beginnign accounts receiveable first Q sales second Q sales third Q sales fourth Q sales Total cash collected EXPECTED CASH COLLECTIONS: 40,000 126,000 54,000 189,000 81,000 236,250 40,000 180,000 270,000 337,500 157,500 985,000 101,250 157,500 258,750 $ $ 166,000 $ 243,000 $ 317,250 $ PRODUCTION BUDGET: Quarter 1 2 4,000 6,000 unit sales (sales budget) 3 7,500 4 5,000 Year 22,500 plus desired ending inventory total unit needs less beginning inventory Production needs in units) 600 4,600 400 4,200 750 6,750 600 500 8,000 750 7,250 700 5,700 500 5,200 700 23,200 400 22,800 6,150 BUDGETED INCOME STATEMENT Budget: Sales Sales, FGI $ 1,012,500 1,014,750 Sales COGS Gross Margin S&A Expenses Net Operating Income Interest expense Net Income S&A Exp. 282,200 Cash 1,750
Answer & Explanation
Solved by verified expert
