Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with the parts I have not completed. thank you. these are all different parts of question 22 eBook Calculator Budgeted Income statement
Please help me with the parts I have not completed. thank you. these are all different parts of question 22
eBook Calculator Budgeted Income statement and supporting budgets for three months Bellaire Inc gathered the following data for use in developing the budgets for the first quarter Canuary February March) of its fiscal year: a. Estimated sales at $125 per unit: January February March 25,000 units 30,000 units 45,000 units 50,000 units April b. Estimated finished goods inventories: January 1 2 ,000 units January 31 10% of next month's sales of next month's sales February 28 March 31 10% 10% of next month's sales c. Work in process inventories are estimated to be insignificant (zero), d. Estimated direct materials inventories: January 1 1,000 lbs January 31 1,500 lbs February 28 2,000 lbs. March 31 2.500 lbs. e Manufacturing costs: Previ crack My Work PROBS 22 Calculator e Manufacturing costs: Direct materials (0.8 lb, per unit x $15 per lb.) Direct labor (2.5 hrs. per unit * $24 per hr.) Variable factory overhead ($1.20 per direct labor hour) Fixed factory overhead ($200,000 per month, allocated using 40,000 units) Total per-unit manufacturing costs 1. Selling expenses: $4 per unit Variable selling expenses Fixed selling expenses Administrative expenses (all fixed costs) $150,000 $400,000 1. Prepare a sales budget for March. Bellaire Inc Sales Budget For the First Quarter Ending March Estimated units sold Selling price per units Total budgeted sales Previous Check My Work PROBS 22 Cook Calculator Print item 2. Prepare a production budget for March. Bellaire Inc Production Budget For the First Quarter Encling March 3 February Estimated units sold Desired ending Inventory Total units available for sale Less estimated beginning inventory Total units to be produced The direct materials cost budget, the direct labor cost budget, and the factory owerhead budget each use the level of production from the production budget to estimate costs 3. Prepare a direct materials purchases budget for March Bellaire Inc Direct Materials Purchases Budget For the First Quarter Ending March 31 January February 26.000 3100 First Quarter March 45.500 100.000 Previous ched My Wok lessonLocatore di progresse PROBS 22 eBook Calculator Print item 3. Prepare a direct materials purchases budget for March. Bellaire Inc. Direct Materials Purchases Budget For the First Quarter Ending March 31 Units to be produced 26.000 31.500 Materials required per un 36.400 lbs. 82.400 lbs. Materials required for production Desired ending inventory 2.500 lbs. Total materials available for use 22.300 lbs. 27,200 400 lbs. X 38.900 lbs. 2,000 lbs. Less estimated beginning inventory 1.000 lbs. 1.500 lbs. 2.500 lbs. X Total materials to be purchased 300 lbs. 25.700 lbs. 36.000 lbs. X5 Cost per pound 319,500 385.500 S 553.500 Cost of direct materials to be purchased $1.2550 The direct materials cost budget, the direct labor cost budget and the factory overhead budget each use the level of production from the production budget to estimate car PROES 22 Printem 4. Prepare a direct labor cost budget for March Inc Debor Costa For the starter Ending March 31 Units to be produced Direct labor que permit Direct labor hours required for production Direct labor hourly rate Direct labor cost 5 2.230,000 The direct materials cost budget, the direct labor cost budget and the factory overhead budget each use the level of production from the production budget to estimate costs 5. Prepare a factory overhead cost budget for March Belle Inc Factory Overhead Cost Budget For the st a nding arch 31 rary Ched D u hare to search O PROBS 22 eBook Calculator Printem 5. Prepare a factory overhead cost budget for March Bellaire Inc Factory Overhead Cont Budget For the First Quarter Ending March 31 February March F irst Quarter Variable factory overhead: Budgeted direct labor hours 78.750 hrs. 111.750 hrs. 257.500 hrs. Variable factory overhead rate $ 136,500 $ 309,000 Budgeted variable factory overhead Fixed factory overhead: Budgeted fixed factory overhead 200.000 600.000 $278.000 5 Total factory overhead cost 294.500 check the The direct materials cost budget, the direct labor cost budget, and the factory overhead budget each use the level of production from the production budget to estimato costs 6. Prepare a cost of goods sold budget for March Bellaire Inc Cost of Goods Sold Budget a ntin Ench Premio PROBS 22 eBook Calculator Printer 6. Prepare a cost of goods sold budget for March. Bellaire Inc Cost of Goods Sold Budget For the First Quarter Ending March 31 February Beginning finished goods inventory Mary $160.000 Cost of goods manufactured: Direct materials Direct labor Factory overhead Total cost of goods manufactured Cost of finished goods available for sale Ending finished goods inventory Cost of goods sold The cost of goods sold budget combines the budgeted costs from the direct labor direct materials, and factory overhead budgets with estimated beginning and ending inventory to total cost of goods sold. Previous Check My Wodk PROBS 22 eBook CNculator Printer 7. Prepare a selling and administrative expenses budget for March. Enter all amounts as positive number. Bellaire Inc Selling and Administrative Expenses Budget For the First Quarter Ending March 31 First Quarter Selling expenses Budgeted sales units Variable selling expenses pe Total variable selling expenses Fixed selling expenses Total selling expenses Administrative expenses: Budgeted fixed administrative expenses Total selling and administrative expenses Chece Estimated sales from the sales budget estimated cost of goods sold from the cost of goods sold budget, and estimated selling and administrative expenses from the selling and administrative expense budget are used to prepare a budgeted income statement 8. Prepare a budgeted income statement with budgeted operating income Previous Check My Work ROBS 22 Calculator Printem B. Prepare a budgeted income statement with budgeted operating income for March Bellaire Inc. Budgeted Income Statement For the First Quarter Ending March 31 January Februar Sales 3.125,000 $12.500,000 Cost of goods sold Gross profit Selling and administrative expenses: Selling expenses Administrative expenses Total selling and administrative expenses Operating income pentes from the selling Estimated sales from the sales budget, estimated cost of goods sold from the cost of goods sold budget, and estimated selling and administrative administrative expense budget are used to prepare a budgeted income statement eBook Calculator Budgeted Income statement and supporting budgets for three months Bellaire Inc gathered the following data for use in developing the budgets for the first quarter Canuary February March) of its fiscal year: a. Estimated sales at $125 per unit: January February March 25,000 units 30,000 units 45,000 units 50,000 units April b. Estimated finished goods inventories: January 1 2 ,000 units January 31 10% of next month's sales of next month's sales February 28 March 31 10% 10% of next month's sales c. Work in process inventories are estimated to be insignificant (zero), d. Estimated direct materials inventories: January 1 1,000 lbs January 31 1,500 lbs February 28 2,000 lbs. March 31 2.500 lbs. e Manufacturing costs: Previ crack My Work PROBS 22 Calculator e Manufacturing costs: Direct materials (0.8 lb, per unit x $15 per lb.) Direct labor (2.5 hrs. per unit * $24 per hr.) Variable factory overhead ($1.20 per direct labor hour) Fixed factory overhead ($200,000 per month, allocated using 40,000 units) Total per-unit manufacturing costs 1. Selling expenses: $4 per unit Variable selling expenses Fixed selling expenses Administrative expenses (all fixed costs) $150,000 $400,000 1. Prepare a sales budget for March. Bellaire Inc Sales Budget For the First Quarter Ending March Estimated units sold Selling price per units Total budgeted sales Previous Check My Work PROBS 22 Cook Calculator Print item 2. Prepare a production budget for March. Bellaire Inc Production Budget For the First Quarter Encling March 3 February Estimated units sold Desired ending Inventory Total units available for sale Less estimated beginning inventory Total units to be produced The direct materials cost budget, the direct labor cost budget, and the factory owerhead budget each use the level of production from the production budget to estimate costs 3. Prepare a direct materials purchases budget for March Bellaire Inc Direct Materials Purchases Budget For the First Quarter Ending March 31 January February 26.000 3100 First Quarter March 45.500 100.000 Previous ched My Wok lessonLocatore di progresse PROBS 22 eBook Calculator Print item 3. Prepare a direct materials purchases budget for March. Bellaire Inc. Direct Materials Purchases Budget For the First Quarter Ending March 31 Units to be produced 26.000 31.500 Materials required per un 36.400 lbs. 82.400 lbs. Materials required for production Desired ending inventory 2.500 lbs. Total materials available for use 22.300 lbs. 27,200 400 lbs. X 38.900 lbs. 2,000 lbs. Less estimated beginning inventory 1.000 lbs. 1.500 lbs. 2.500 lbs. X Total materials to be purchased 300 lbs. 25.700 lbs. 36.000 lbs. X5 Cost per pound 319,500 385.500 S 553.500 Cost of direct materials to be purchased $1.2550 The direct materials cost budget, the direct labor cost budget and the factory overhead budget each use the level of production from the production budget to estimate car PROES 22 Printem 4. Prepare a direct labor cost budget for March Inc Debor Costa For the starter Ending March 31 Units to be produced Direct labor que permit Direct labor hours required for production Direct labor hourly rate Direct labor cost 5 2.230,000 The direct materials cost budget, the direct labor cost budget and the factory overhead budget each use the level of production from the production budget to estimate costs 5. Prepare a factory overhead cost budget for March Belle Inc Factory Overhead Cost Budget For the st a nding arch 31 rary Ched D u hare to search O PROBS 22 eBook Calculator Printem 5. Prepare a factory overhead cost budget for March Bellaire Inc Factory Overhead Cont Budget For the First Quarter Ending March 31 February March F irst Quarter Variable factory overhead: Budgeted direct labor hours 78.750 hrs. 111.750 hrs. 257.500 hrs. Variable factory overhead rate $ 136,500 $ 309,000 Budgeted variable factory overhead Fixed factory overhead: Budgeted fixed factory overhead 200.000 600.000 $278.000 5 Total factory overhead cost 294.500 check the The direct materials cost budget, the direct labor cost budget, and the factory overhead budget each use the level of production from the production budget to estimato costs 6. Prepare a cost of goods sold budget for March Bellaire Inc Cost of Goods Sold Budget a ntin Ench Premio PROBS 22 eBook Calculator Printer 6. Prepare a cost of goods sold budget for March. Bellaire Inc Cost of Goods Sold Budget For the First Quarter Ending March 31 February Beginning finished goods inventory Mary $160.000 Cost of goods manufactured: Direct materials Direct labor Factory overhead Total cost of goods manufactured Cost of finished goods available for sale Ending finished goods inventory Cost of goods sold The cost of goods sold budget combines the budgeted costs from the direct labor direct materials, and factory overhead budgets with estimated beginning and ending inventory to total cost of goods sold. Previous Check My Wodk PROBS 22 eBook CNculator Printer 7. Prepare a selling and administrative expenses budget for March. Enter all amounts as positive number. Bellaire Inc Selling and Administrative Expenses Budget For the First Quarter Ending March 31 First Quarter Selling expenses Budgeted sales units Variable selling expenses pe Total variable selling expenses Fixed selling expenses Total selling expenses Administrative expenses: Budgeted fixed administrative expenses Total selling and administrative expenses Chece Estimated sales from the sales budget estimated cost of goods sold from the cost of goods sold budget, and estimated selling and administrative expenses from the selling and administrative expense budget are used to prepare a budgeted income statement 8. Prepare a budgeted income statement with budgeted operating income Previous Check My Work ROBS 22 Calculator Printem B. Prepare a budgeted income statement with budgeted operating income for March Bellaire Inc. Budgeted Income Statement For the First Quarter Ending March 31 January Februar Sales 3.125,000 $12.500,000 Cost of goods sold Gross profit Selling and administrative expenses: Selling expenses Administrative expenses Total selling and administrative expenses Operating income pentes from the selling Estimated sales from the sales budget, estimated cost of goods sold from the cost of goods sold budget, and estimated selling and administrative administrative expense budget are used to prepare a budgeted income statementStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started