Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

With the given information above, how do I create the budgeted income statement? Total cost ENDING FINISHED GOODS INVENTORY BUDGET (ABSORPTION COSTING): Quantity $ Cost

image text in transcribedimage text in transcribed

With the given information above, how do I create the budgeted income statement?

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Frank Woods Business Accounting An Introduction To Financial Accounting

Authors: Alan Sangster, Lewis Gordon, Frank Wood

15th Edition

1292365439, 9781292365435

Students also viewed these Accounting questions