Question: please help find the right figures in excel if you can thank you Sheridan manufactures aluminum canoes. In planning for the coming year, CFO Alexis



Sheridan manufactures aluminum canoes. In planning for the coming year, CFO Alexis King is considering three different sales targets: 1.600 canoes, 2,100 canoes, and 2,600 canoes, Canoes sell for $ 800 each. The standard variable cost information for a canoe is as follows Direct materials $ 325 100 Direct labor Variable overhead Utilities 15 45 Indirect material Indirect labor 25 Total $ 510 Annual fixed overhead cost is expected to be $ 50,000 Maintenance Depreciation 38,000 Insurance 29,000 Rent 58.000 Total $ 175.000 Alexis King chose to prepare a static budget based on sales of 2,400 canoes. Actual sales were 2.450 canoes at a price of $ 790 each. The company incurred the following costs for the year Direct material Direct labor Variable overhead Fibed overhead Total $ 788.000 405,000 212,000 150,000 $ 1.555,000 Prepare a performance report for the year that shows the flexible budget and sales volume variances. (If operating income is negative, enter amounts using a negative sign preceding the number eg -45 or parentheses es. (45). Round answers to decimal places, eg. 125. If variance is zero, select "Not Applicable and enter for the amounts.) Actual Results Flexible Budget Variance Unit sales Sales revenue S Less Variable expenses Direct material Direct labor DOO Overhead Total variable expenses Todo!!! Contribution margin Total fixed expenses Operating income Flexible Budget Sales Volume Variance Static Budget TA HATA TORTO !!! DODOMA
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
