Question

1 Approved Answer

Posted on Jul 27, 2024

Create a detailed review in table format of the provided budget. The table will have 4 columns titled Report, Error, Correction Required, and Effect, respectively.

Create a detailed review in table format of the provided budget. The table will have 4 columns titled "Report," "Error", "Correction Required," and "Effect," respectively.

Below are descriptions of what should be in each column of your review table with an example based on overstated sales on the income statement (this error probably doesn't actually occur in this assignment).

Report: Identify the report(s) affected by the error (e.g., "Income Statement"). Note that you are only reviewing 3 reports. They are (I) the budgeted income statement (II) the flexible budget for production costs, and (III) the performance report. You believe--based on prior reviews--that all other budgets and schedules are accurate.
Error: Provide the detailed position of the error within the report (e.g., "Sales"), and a brief description of the error (e.g., budgeted sales of $5,500,000 is inaccurate).
Correction Required: Provide the correction required and some direction for making the correction, recognizing any expected relations among the reports (e.g., Budgeted sales should be equal to the total on the sales budget ($5,450,000). Demonstrate your knowledge by explaining the problem to the cost accountant like you would want it explained to you if you made such an error.
Effect: Calculate and state the effect that the error will have on the reports (e.g., On the Income Statement, Budgeted Sales, Gross Margin, Operating income, and Income before taxes is overstated by $50,000; Budgeted Income Taxes are overstated by $15,000; and Budgeted Net Income is overstated by $35,000. Other reports are not directly affected)

The cost accountant used 4,650 units as predicted produced units.

image text in transcribed

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

image text in transcribed

Barnes Boards Sales Budget For the year ending 12/31/2021 Units Unit selling price $ Sales $ Quarter 1 600 1,000 $ 600,000 $ Quarter 2 400 950 $ 380,000 $ Quarter 3 1,200 1,225 $ 1,470,000 $ Quarter 4 2,500 1,200 $ 3,000,000 $ Total 4,700 1,160 5,450,000 Unit sales Desired ending inventory Total needed Less Beg. inventory Units produced Barnes Boards Production Budget For the year ending 12/31/2021 Quarter 1 Quarter 2 Quarter 3 600 400 1,200 80 240 500 680 1,700 100 80 240 580 560 1,460 Quarter 4 2,500 120 2,620 500 2,120 Total 4,700 120 4,820 100 4,720 640 Barnes Boards Direct Materials Purchases Budget For the year ending 12/31/2021 Quarter 1 580 Quarter 2 560 Quarter 3 1,460 Quarter 4 2,120 Total 4,720 Units produced DM per unit Wood (board feet) Grip tape tape feet) Hardware sets Wheel sets 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 Production needs Wood (board feet) Grip tape (tape feet) Hardware sets Wheel sets 1,885 2,030 609 609 1,820 1,960 588 588 4,745 5,110 1,533 1,533 6,890 7,420 2,226 2,226 15,340 16,520 4,956 4,956 283 Desired ending inventory Wood (board feet) Grip tape tape feet) Hardware sets Wheel sets 182 196 475 511 153 153 689 742 223 223 283 305 91 91 59 59 305 91 91 Less: Beg. inventory Wood (board feet) Grip tape (tape feet) Hardware sets Wheel sets 689 742 255 275 82 82 182 196 59 59 475 511 153 153 255 275 82 82 223 223 DM to purchase Wood (board feet) Grip tape (tape feet) Hardware sets Wheel sets 1,812 1,951 586 586 2,113 2.275 682 682 4,959 5,341 1,603 1,603 6,484 6,983 2,094 2,094 15,368 16,550 4,965 4,965 $ S DM avg. cost per foot/set Wood (board feet) Grip tape tape feet) Hardware sets Wheel sets S $ $ 3.10 $ 0.65 $ 8.00 $ 16.00 $ 3.10 $ 0.65 $ 8.00 $ 16.00 S 3.10 0.65 8.00 16.00 $ $ $ 3.10 S 0.65 S 8.00 S 16.00 $ 3.10 0.65 8.00 16.00 Total purchase cost $ 20,949 $ 24,397 $ 57,317 $ 74,895 $ 177,566* *Total does not foot due to rounding. Barnes Boards Direct Labor Budget For the year ending 12/31/2021 Units produced DL per unit Direct labor hrs needed Avg. cost per DLH Total direct labor cost Quarter 1 580 1.50 870 25.00 $ 21,750 $ Quarter 2 560 1.50 840 25.00 $ 21,000 $ Quarter 3 1,460 1.50 2,190 25.00 $ 54,750 $ Quarter 4 2,120 1.50 3,180 25.00 $ 79,500 $ Total 4,720 1.50 7,080 25.00 177,000 $ $ Barnes Boards Overhead Budget For the year ending 12/31/2021 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budgeted direct labor hours 870 840 2,190 3,180 7,080 Variable overhead rate $ 13.00 $ 13.00 13.00 $ 13.00 $ 13.00 Budgeted variable overhead $ 11,310 $ 10,920 $ 28,470 $ 41,340 $ 92,040 Budgeted fixed overhead $ 215,000 $ 215,000 $ 215,000 $ 215,000 $ 860,000 Total overhead cost $ 226,310 $ 225,920 $ 243,470 $ 256,340 $ 952,040 Barnes Boards Ending Finished Goods Inventory Budget For the year ending 12/31/2021 $ $ 37.62 37.50 Unit Costs: Direct materials Direct labor Overhead Budgeted variable overhead Budgeted fixed overhead Total cost per unit $ $ 19.50 182.20 $ $ 201.70 276.82 Budgeted units in ending inventory Total ending inventory cost 120 33,219 $ Barnes Boards COGS Budget For the year ending 12/31/2021 Direct Materials $ Direct Labor $ Overhead $ Total manufacturing cost $ Add: Beginning inventory, finished goods $ Less: Ending inventory, finished goods $ Cost of goods sold $ 177,566 177,000 952,040 1,306,606 27,682 33,219 1,301,069 Barnes Boards Marketing/Sales and Administrative Expense Budget For the year ending 12/31/2021 Salaries Insurance Depreciation Other Total sales and administrative expense Quarter 1 Quarter 2 $ 60,000 $ 60,000 $ $ 1,350 $ 1,350 $ $ 3,600 $ 3,600 $ $ 1,200 $ 1,200 $ $ 66,150 $ 66,150 $ Quarter 3 60,000 $ 1,350 $ 3,600 $ 1,200 $ 66,150 $ Quarter 41 60,000 $ 1,350 $ 3,600 $ 1,200 $ 66,150 $ Total 240,000 5,400 14,400 4,800 264,600 Ala Barnes Boards Budgeted Income Statement For the year ending 12/31/2021 Sales $ 5,450,000 Less: Cost of goods sold $ 1,306,606 Gross margin $ 4,143,394 Less: Marketing and administrative expenses $ 66,150 Operating Income $ 4,077,244 Less: Interest expense $ 719,053 Net Income $ 3,358,191 Less: Income taxes (at 30%) $ 1,007,460 Income before taxes $ 2,350,711 Barnes Boards Flexible Budget for Production Costs For the year ending 12/31/2021 Variable Cost per unit Production in units 4,620 4,720 4,520 4,820 4,920 $ Production Costs: Variable: Direct Materials Direct Labor Variable Overhead Total Variable Costs Total fixed overhead Total production costs $ $ 37.62 $ 170,042 $ 173,250 $ 177,000 $ 181,328 $ 185,090 37.50 $ 169,500 $ 173,804 $ 177,566 $ 180,750 $ 184,500 19.50 $ 88,140 $ 90,090 $ 92,040 $ 93,990 $ 95,940 94.62 $ 427,682 $ 437,144 $ 446,606 $ 456,068 $ 465,530 $ 840,000 $ 850,000 $ 860,000 $ 870,000 $ 880,000 $1,267,682 $1,287,144 $1,306,606 $1,326,068 $1,345,530 $ Barnes Boards Performance Report: Production Costs For the year ending 12/31/2021 Actual Flex Budget 4,650 4,650 Variance F/U F Units Production Costs: Variable: Direct Materials Direct Labor Variable Overhead Total Variable Costs Total fixed overhead Total production costs $ $ $ U F 171,946 $ 182,765 $ 100,923 $ 455,634 $ 845,637 $ 1,301,271 $ 174,933 $ 174,375 $ 90,675 $ 439,983 $ 847,246 $ 1,287,229 $ 2,979 8,390 10,248 15,659 1,609 14,050 $ U $ $ F U Barnes Boards Sales Budget For the year ending 12/31/2021 Units Unit selling price $ Sales $ Quarter 1 600 1,000 $ 600,000 $ Quarter 2 400 950 $ 380,000 $ Quarter 3 1,200 1,225 $ 1,470,000 $ Quarter 4 2,500 1,200 $ 3,000,000 $ Total 4,700 1,160 5,450,000 Unit sales Desired ending inventory Total needed Less Beg. inventory Units produced Barnes Boards Production Budget For the year ending 12/31/2021 Quarter 1 Quarter 2 Quarter 3 600 400 1,200 80 240 500 680 1,700 100 80 240 580 560 1,460 Quarter 4 2,500 120 2,620 500 2,120 Total 4,700 120 4,820 100 4,720 640 Barnes Boards Direct Materials Purchases Budget For the year ending 12/31/2021 Quarter 1 580 Quarter 2 560 Quarter 3 1,460 Quarter 4 2,120 Total 4,720 Units produced DM per unit Wood (board feet) Grip tape tape feet) Hardware sets Wheel sets 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 3.25 3.50 1.05 1.05 Production needs Wood (board feet) Grip tape (tape feet) Hardware sets Wheel sets 1,885 2,030 609 609 1,820 1,960 588 588 4,745 5,110 1,533 1,533 6,890 7,420 2,226 2,226 15,340 16,520 4,956 4,956 283 Desired ending inventory Wood (board feet) Grip tape tape feet) Hardware sets Wheel sets 182 196 475 511 153 153 689 742 223 223 283 305 91 91 59 59 305 91 91 Less: Beg. inventory Wood (board feet) Grip tape (tape feet) Hardware sets Wheel sets 689 742 255 275 82 82 182 196 59 59 475 511 153 153 255 275 82 82 223 223 DM to purchase Wood (board feet) Grip tape (tape feet) Hardware sets Wheel sets 1,812 1,951 586 586 2,113 2.275 682 682 4,959 5,341 1,603 1,603 6,484 6,983 2,094 2,094 15,368 16,550 4,965 4,965 $ S DM avg. cost per foot/set Wood (board feet) Grip tape tape feet) Hardware sets Wheel sets S $ $ 3.10 $ 0.65 $ 8.00 $ 16.00 $ 3.10 $ 0.65 $ 8.00 $ 16.00 S 3.10 0.65 8.00 16.00 $ $ $ 3.10 S 0.65 S 8.00 S 16.00 $ 3.10 0.65 8.00 16.00 Total purchase cost $ 20,949 $ 24,397 $ 57,317 $ 74,895 $ 177,566* *Total does not foot due to rounding. Barnes Boards Direct Labor Budget For the year ending 12/31/2021 Units produced DL per unit Direct labor hrs needed Avg. cost per DLH Total direct labor cost Quarter 1 580 1.50 870 25.00 $ 21,750 $ Quarter 2 560 1.50 840 25.00 $ 21,000 $ Quarter 3 1,460 1.50 2,190 25.00 $ 54,750 $ Quarter 4 2,120 1.50 3,180 25.00 $ 79,500 $ Total 4,720 1.50 7,080 25.00 177,000 $ $ Barnes Boards Overhead Budget For the year ending 12/31/2021 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budgeted direct labor hours 870 840 2,190 3,180 7,080 Variable overhead rate $ 13.00 $ 13.00 13.00 $ 13.00 $ 13.00 Budgeted variable overhead $ 11,310 $ 10,920 $ 28,470 $ 41,340 $ 92,040 Budgeted fixed overhead $ 215,000 $ 215,000 $ 215,000 $ 215,000 $ 860,000 Total overhead cost $ 226,310 $ 225,920 $ 243,470 $ 256,340 $ 952,040 Barnes Boards Ending Finished Goods Inventory Budget For the year ending 12/31/2021 $ $ 37.62 37.50 Unit Costs: Direct materials Direct labor Overhead Budgeted variable overhead Budgeted fixed overhead Total cost per unit $ $ 19.50 182.20 $ $ 201.70 276.82 Budgeted units in ending inventory Total ending inventory cost 120 33,219 $ Barnes Boards COGS Budget For the year ending 12/31/2021 Direct Materials $ Direct Labor $ Overhead $ Total manufacturing cost $ Add: Beginning inventory, finished goods $ Less: Ending inventory, finished goods $ Cost of goods sold $ 177,566 177,000 952,040 1,306,606 27,682 33,219 1,301,069 Barnes Boards Marketing/Sales and Administrative Expense Budget For the year ending 12/31/2021 Salaries Insurance Depreciation Other Total sales and administrative expense Quarter 1 Quarter 2 $ 60,000 $ 60,000 $ $ 1,350 $ 1,350 $ $ 3,600 $ 3,600 $ $ 1,200 $ 1,200 $ $ 66,150 $ 66,150 $ Quarter 3 60,000 $ 1,350 $ 3,600 $ 1,200 $ 66,150 $ Quarter 41 60,000 $ 1,350 $ 3,600 $ 1,200 $ 66,150 $ Total 240,000 5,400 14,400 4,800 264,600 Ala Barnes Boards Budgeted Income Statement For the year ending 12/31/2021 Sales $ 5,450,000 Less: Cost of goods sold $ 1,306,606 Gross margin $ 4,143,394 Less: Marketing and administrative expenses $ 66,150 Operating Income $ 4,077,244 Less: Interest expense $ 719,053 Net Income $ 3,358,191 Less: Income taxes (at 30%) $ 1,007,460 Income before taxes $ 2,350,711 Barnes Boards Flexible Budget for Production Costs For the year ending 12/31/2021 Variable Cost per unit Production in units 4,620 4,720 4,520 4,820 4,920 $ Production Costs: Variable: Direct Materials Direct Labor Variable Overhead Total Variable Costs Total fixed overhead Total production costs $ $ 37.62 $ 170,042 $ 173,250 $ 177,000 $ 181,328 $ 185,090 37.50 $ 169,500 $ 173,804 $ 177,566 $ 180,750 $ 184,500 19.50 $ 88,140 $ 90,090 $ 92,040 $ 93,990 $ 95,940 94.62 $ 427,682 $ 437,144 $ 446,606 $ 456,068 $ 465,530 $ 840,000 $ 850,000 $ 860,000 $ 870,000 $ 880,000 $1,267,682 $1,287,144 $1,306,606 $1,326,068 $1,345,530 $ Barnes Boards Performance Report: Production Costs For the year ending 12/31/2021 Actual Flex Budget 4,650 4,650 Variance F/U F Units Production Costs: Variable: Direct Materials Direct Labor Variable Overhead Total Variable Costs Total fixed overhead Total production costs $ $ $ U F 171,946 $ 182,765 $ 100,923 $ 455,634 $ 845,637 $ 1,301,271 $ 174,933 $ 174,375 $ 90,675 $ 439,983 $ 847,246 $ 1,287,229 $ 2,979 8,390 10,248 15,659 1,609 14,050 $ U $ $ F U