Problem 6 27 (Part Level Submission) Barnes Entertainment Corporation prepared a master budget for the month of November that was based on sales of 153,000 board games The budgeted income statement for the period is as follows Sales Revenue $2,601,000 Variable expenses Direct materials $703,800 Direct labor 290,700 Variable overhead 397,800 Total variable expenses 1,392,300 Contribution margin 1,208,700 Fixed overhead 253,900 Fixed selling and administrative expenses 508,600 Total fixed expenses 762,500 Operating income $446,200 During November, Barnes produced and sold 187,300 board games Actual results for the month are as follows Sales Revenue $3,173,400 Variable expenses Direct materials $848,580 Direct labor 370,370 Variable overhead 498,980 Total variable expenses 1,717,930 Contribution margin 1,455,470 Fixed overhead 274,100 Fixed selling and administrative expenses 508,600 Total fixed expenses 782,700 Operating income $672,770 (a b) (a)Prepare a flexible budget for November (Round unit answers to 2 decimal places, e g 5 25 all other answers to 0 decimal places, e g 125 ) Unit 187,300games Variable expensesDirect laborOverheadDirect materialVariable overheadOperating incomeSelling and administrativeTotal variable expensesContribution marginFixed expensesTotal fixed expensesSales revenue $ $ LessAdd Total fixed expensesDirect laborTotal variable expensesContribution marginOperating incomeVariable expensesSales revenueFixed expensesSelling and administrativeDirect material Direct materialVariable expensesOverheadContribution marginDirect laborSales revenueVariable overheadOperating incomeSelling and administrativeTotal variable expensesTotal fixed expensesFixed expenses Operating incomeSelling and administrativeSales revenueTotal variable expensesOverheadTotal fixed expensesContribution marginVariable expensesFixed expensesDirect materialDirect laborVariable overhead Direct materialVariable expensesSales revenueSelling and administrativeVariable overheadDirect laborTotal fixed expensesTotal variable expensesContribution marginFixed expensesOperating incomeOverhead Fixed expensesTotal variable expensesOverheadTotal fixed expensesVariable expensesDirect materialContribution marginSelling and administrativeOperating incomeDirect laborSales revenueVariable overhead OverheadVariable expensesOperating incomeSales revenueDirect laborContribution marginSelling and administrativeDirect materialVariable overheadTotal variable expensesFixed expensesTotal fixed expenses $ AddLess Direct laborSales revenueSelling and administrativeContribution marginTotal fixed expensesTotal variable expensesFixed expensesDirect materialOperating incomeVariable expenses OverheadContribution marginDirect materialFixed expensesDirect laborSelling and administrativeTotal fixed expensesTotal variable expensesOperating incomeSales revenueVariable overheadVariable expenses Contribution marginDirect materialSales revenueOperating incomeTotal variable expensesDirect laborTotal fixed expensesFixed expensesOverheadVariable overheadSelling and administrativeVariable expenses Direct laborDirect materialContribution marginSelling and administrativeTotal variable expensesVariable overheadTotal fixed expensesFixed expensesOverheadOperating incomeSales revenueVariable expenses Selling and administrativeVariable overheadTotal variable expensesContribution marginFixed expensesVariable expensesOverheadTotal fixed expensesOperating incomeSales revenueDirect materialDirect labor $ (b)Calculate Barnes s static budget variance for November (Round answers to 0 decimal places, e g 125 Enter all variance amounts as positive values If variance is zero, select Not Applicable and enter 0 for the amounts ) Actual Results Static Budget Variance Static Budget Unit Sales FavorableUnfavorableNot Applicable Operating incomeTotal fixed expensesSales revenueTotal variable expensesVariable expensesContribution marginDirect materialDirect laborOverheadFixed expensesSelling and administrative $ $ FavorableNot ApplicableUnfavorable $ AddLess Total variable expensesVariable expensesTotal fixed expensesOperating incomeDirect materialDirect laborContribution marginFixed expensesSelling and administrative Fixed expensesOperating incomeSelling and administrativeContribution marginVariable overheadDirect materialTotal variable expensesSales revenueTotal fixed expensesVariable expensesDirect labor Not ApplicableUnfavorableFavorable Total variable expensesVariable expensesDirect laborContribution marginDirect materialVariable overheadTotal fixed expensesOperating incomeFixed expensesSales revenueSelling and administrative Not ApplicableUnfavorableFavorable Contribution marginTotal fixed expensesTotal variable expensesOperating incomeFixed expensesVariable overheadSales revenueVariable expensesDirect materialSelling and administrativeDirect labor FavorableNot ApplicableUnfavorable Selling and administrativeTotal fixed expensesContribution marginOperating incomeFixed expensesSales revenueVariable expensesDirect materialDirect laborVariable overheadTotal variable expenses Not ApplicableUnfavorableFavorable Total fixed expensesContribution marginSales revenueTotal variable expensesDirect materialOperating incomeFixed expensesVariable expensesOverheadDirect laborSelling and administrative FavorableUnfavorableNot Applicable AddLess Variable expensesDirect laborContribution marginFixed expensesTotal fixed expensesOperating incomeTotal variable expensesDirect materialSelling and administrative Contribution marginVariable expensesFixed expensesSelling and administrativeOperating incomeDirect materialTotal variable expensesDirect laborTotal fixed expensesSales revenueOverhead Not ApplicableUnfavorableFavorable Operating incomeDirect materialDirect laborSales revenueVariable expensesOverheadTotal variable expensesContribution marginFixed expensesSelling and administrativeTotal fixed expenses Not ApplicableFavorableUnfavorable Operating incomeSelling and administrativeOverheadFixed expensesTotal variable expensesDirect materialTotal fixed expensesDirect laborSales revenueVariable expensesContribution margin UnfavorableNot ApplicableFavorable Operating incomeTotal variable expensesDirect laborOverheadContribution marginSelling and administrativeFixed expensesTotal fixed expensesSales revenueVariable expensesDirect material $ $ Not ApplicableUnfavorableFavorable $ Problem 6 27 (Part Level Submission) Barnes Entertainment Corporation prepared a master budget for the month of November that was based on sales of 153,000 board games The budgeted income statement for the period is as follows Sales Revenue $2,601,000 Variable expenses Direct materials $703,800 Direct labor 290,700 Variable overhead 397,800 Total variable expenses 1,392,300 Contribution margin 1,208,700 Fixed overhead 253,900 Fixed selling and administrative expenses 508,600 Total fixed expenses 762,500 Operating income $446,200 During November, Barnes produced and sold 187,300 board games Actual results for the month are as follows Sales Revenue $3,173,400 Variable expenses Direct materials $848,580 Direct labor 370,370 Variable overhead 498,980 Total variable expenses 1,717,930 Contribution margin 1,455,470 Fixed overhead 274,100 Fixed selling and administrative expenses 508,600 Total fixed expenses 782,700 Operating income $672,770 (a b) (a) Prepare a flexible budget for November (Round unit answers to 2 decimal places, e g 5 25 all other answers to 0 decimal places, e g 125 ) Unit 187,300 games $ $ $ $ (b) Calculate Barnes's static budget variance for November (Round answers to 0 decimal places, e g 125 Enter all variance amounts as positive values If variance is zero, select Not Applicable and enter 0 for the amounts ) Static Budget Variance Actual Results Static Budget Unit Sales $ $ $ $ LINK TO TEXT $ $

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 27, 2024

Problem 6-27 (Part Level Submission) Barnes Entertainment Corporation prepared a master budget for the month of November that was based on sales of 153,000 board

Sales Revenue	$2,601,000
Variable expenses
Direct materials	$703,800
Direct labor	290,700
Variable overhead	397,800
Total variable expenses	1,392,300
Contribution margin	1,208,700
Fixed overhead	253,900
Fixed selling and administrative expenses	508,600
Total fixed expenses	762,500
Operating income	$446,200

During November, Barnes produced and sold 187,300 board games. Actual results for the month are as follows.

Sales Revenue	$3,173,400
Variable expenses
Direct materials	$848,580
Direct labor	370,370
Variable overhead	498,980
Total variable expenses	1,717,930
Contribution margin	1,455,470
Fixed overhead	274,100
Fixed selling and administrative expenses	508,600
Total fixed expenses	782,700
Operating income	$672,770

(a-b) (a)Prepare a flexible budget for November.(Round unit answers to 2 decimal places, e.g. 5.25 & all other answers to 0 decimal places, e.g. 125.)

Unit	187,300games
Variable expensesDirect laborOverheadDirect materialVariable overheadOperating incomeSelling and administrativeTotal variable expensesContribution marginFixed expensesTotal fixed expensesSales revenue	$	$
LessAdd: Total fixed expensesDirect laborTotal variable expensesContribution marginOperating incomeVariable expensesSales revenueFixed expensesSelling and administrativeDirect material
Direct materialVariable expensesOverheadContribution marginDirect laborSales revenueVariable overheadOperating incomeSelling and administrativeTotal variable expensesTotal fixed expensesFixed expenses
Operating incomeSelling and administrativeSales revenueTotal variable expensesOverheadTotal fixed expensesContribution marginVariable expensesFixed expensesDirect materialDirect laborVariable overhead
Direct materialVariable expensesSales revenueSelling and administrativeVariable overheadDirect laborTotal fixed expensesTotal variable expensesContribution marginFixed expensesOperating incomeOverhead
Fixed expensesTotal variable expensesOverheadTotal fixed expensesVariable expensesDirect materialContribution marginSelling and administrativeOperating incomeDirect laborSales revenueVariable overhead
OverheadVariable expensesOperating incomeSales revenueDirect laborContribution marginSelling and administrativeDirect materialVariable overheadTotal variable expensesFixed expensesTotal fixed expenses	$
AddLess: Direct laborSales revenueSelling and administrativeContribution marginTotal fixed expensesTotal variable expensesFixed expensesDirect materialOperating incomeVariable expenses
OverheadContribution marginDirect materialFixed expensesDirect laborSelling and administrativeTotal fixed expensesTotal variable expensesOperating incomeSales revenueVariable overheadVariable expenses
Contribution marginDirect materialSales revenueOperating incomeTotal variable expensesDirect laborTotal fixed expensesFixed expensesOverheadVariable overheadSelling and administrativeVariable expenses
Direct laborDirect materialContribution marginSelling and administrativeTotal variable expensesVariable overheadTotal fixed expensesFixed expensesOverheadOperating incomeSales revenueVariable expenses
Selling and administrativeVariable overheadTotal variable expensesContribution marginFixed expensesVariable expensesOverheadTotal fixed expensesOperating incomeSales revenueDirect materialDirect labor	$

(b)Calculate Barnes?s static budget variance for November.(Round answers to 0 decimal places, e.g. 125. Enter all variance amounts as positive values. If variance is zero, select "Not Applicable" and enter 0 for the amounts.)

Actual Results	Static Budget Variance	Static Budget
Unit Sales			FavorableUnfavorableNot Applicable
Operating incomeTotal fixed expensesSales revenueTotal variable expensesVariable expensesContribution marginDirect materialDirect laborOverheadFixed expensesSelling and administrative	$	$	FavorableNot ApplicableUnfavorable	$
AddLess: Total variable expensesVariable expensesTotal fixed expensesOperating incomeDirect materialDirect laborContribution marginFixed expensesSelling and administrative
Fixed expensesOperating incomeSelling and administrativeContribution marginVariable overheadDirect materialTotal variable expensesSales revenueTotal fixed expensesVariable expensesDirect labor			Not ApplicableUnfavorableFavorable
Total variable expensesVariable expensesDirect laborContribution marginDirect materialVariable overheadTotal fixed expensesOperating incomeFixed expensesSales revenueSelling and administrative			Not ApplicableUnfavorableFavorable
Contribution marginTotal fixed expensesTotal variable expensesOperating incomeFixed expensesVariable overheadSales revenueVariable expensesDirect materialSelling and administrativeDirect labor			FavorableNot ApplicableUnfavorable
Selling and administrativeTotal fixed expensesContribution marginOperating incomeFixed expensesSales revenueVariable expensesDirect materialDirect laborVariable overheadTotal variable expenses			Not ApplicableUnfavorableFavorable
Total fixed expensesContribution marginSales revenueTotal variable expensesDirect materialOperating incomeFixed expensesVariable expensesOverheadDirect laborSelling and administrative			FavorableUnfavorableNot Applicable
AddLess: Variable expensesDirect laborContribution marginFixed expensesTotal fixed expensesOperating incomeTotal variable expensesDirect materialSelling and administrative
Contribution marginVariable expensesFixed expensesSelling and administrativeOperating incomeDirect materialTotal variable expensesDirect laborTotal fixed expensesSales revenueOverhead			Not ApplicableUnfavorableFavorable
Operating incomeDirect materialDirect laborSales revenueVariable expensesOverheadTotal variable expensesContribution marginFixed expensesSelling and administrativeTotal fixed expenses			Not ApplicableFavorableUnfavorable
Operating incomeSelling and administrativeOverheadFixed expensesTotal variable expensesDirect materialTotal fixed expensesDirect laborSales revenueVariable expensesContribution margin			UnfavorableNot ApplicableFavorable
Operating incomeTotal variable expensesDirect laborOverheadContribution marginSelling and administrativeFixed expensesTotal fixed expensesSales revenueVariable expensesDirect material	$	$	Not ApplicableUnfavorableFavorable	$

Problem 6-27 (Part Level Submission) Barnes Entertainment Corporation prepared a master budget for the month of November that was based on sales of 153,000 board games. The budgeted income statement for the period is as follows. Sales Revenue $2,601,000 Variable expenses Direct materials $703,800 Direct labor 290,700 Variable overhead 397,800 Total variable expenses 1,392,300 Contribution margin 1,208,700 Fixed overhead 253,900 Fixed selling and administrative expenses 508,600 Total fixed expenses 762,500 Operating income $446,200 During November, Barnes produced and sold 187,300 board games. Actual results for the month are as follows. Sales Revenue $3,173,400 Variable expenses Direct materials $848,580 Direct labor 370,370 Variable overhead 498,980 Total variable expenses 1,717,930 Contribution margin 1,455,470 Fixed overhead 274,100 Fixed selling and administrative expenses 508,600 Total fixed expenses 782,700 Operating income $672,770 (a-b) (a) Prepare a flexible budget for November. (Round unit answers to 2 decimal places, e.g. 5.25 & all other answers to 0 decimal places, e.g. 125.) Unit 187,300 games $ $ : $ : $ (b) Calculate Barnes's static budget variance for November. (Round answers to 0 decimal places, e.g. 125. Enter all variance amounts as positive values. If variance is zero, select "Not Applicable" and enter 0 for the amounts.) Static Budget Variance Actual Results Static Budget Unit Sales $ $ $ : : $ LINK TO TEXT $ $