Concord manufactures aluminum canoes. In planning for the coming year, CFO Alexis King is considering three different sales targets: 2,830 canoes, 3,320 canoes, and 3,710 canoes. Canoes sell for $880 each. The standard variable cost information for a canoe is as follows

Direct materials $ 299 Direct labor 138 Variable overhead Utilities 35 Indirect material 30 Indirect labor 60 Total $ 562

Annual fixed overhead cost is expected to be:

Maintenance $ 20,500 Depreciation 43,600 Insurance 27,600 Rent 31,310 Total $ 123,010

Prepare a flexible budget for the three sales levels under consideration.

Unit 2,830 3,320 3,710 select an opening item Sales revenue $enter a dollar amount 880 $enter a dollar amount 2,490,400 $enter a dollar amount 2921600 $enter a dollar amount 3264800 select between addition and deduction Less : select an opening item Variable expenses select an opening item Direct material enter a dollar amount 299 enter a dollar amount 846170 enter a dollar amount 992680 enter a dollar amount 1109290 select an opening item Direct labor enter a dollar amount 138 enter a dollar amount 390540 enter a dollar amount 458160 enter a dollar amount 511980 select an opening item Utilities enter a dollar amount 35 enter a dollar amount 99050 enter a dollar amount 116200 enter a dollar amount 129850 select an opening item Indirect material enter a dollar amount 30 enter a dollar amount 84900 enter a dollar amount 99600 enter a dollar amount 111300 select an opening item Indirect labor enter a dollar amount 60 enter a dollar amount 169800 enter a dollar amount 199200 enter a dollar amount 222600 select an opening item Total variable expenses enter a total amount for section one enter a total amount for section one enter a total amount for section one enter a total amount for section one select an opening item Contribution margin $enter a total amount for the first part enter a total amount for the first part enter a total amount for the first part enter a total amount for the first part select between addition and deduction Less : select an opening item Fixed expenses select an opening item Maintenance enter a dollar amount 20500 enter a dollar amount 20500 enter a dollar amount 20500 select an opening item Depreciation enter a dollar amount 43600 enter a dollar amount 43600 enter a dollar amount 43600 select an opening item Insurance enter a dollar amount 27600 enter a dollar amount 27600 enter a dollar amount 27600 select an opening item Rent enter a dollar amount 31310 enter a dollar amount 31310 enter a dollar amount 31310 select an opening item Total fixed expenses enter a total amount for section two enter a total amount for section two enter a total amount for section two select an opening item Operating income $enter a total amount for this budget $enter a total amount for this budget $enter a total amount for this budget