Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Is there anyone who can make an excel to finish the table and another table to show the formulas they used??? Thank you! Exercise 6-5
Is there anyone who can make an excel to finish the table and another table to show the formulas they used??? Thank you!
Exercise 6-5 Your answer is partially correct. Try again. Sheridan manufactures aluminum canoes. In planning for the coming year, CFO Alexis King is considering three different sales targets: 2,500 canoes, 3,000 canoes, and 3,500 canoes. Canoes sell for $803 each. The standa variable cost information for a canoe is as follows Direct materials 304 Direct labor Variable overhead 182 Utilities 35 Indirect materia 30 Indirect labor 60 Total $611 Annual fixed overhead cost is expected to be Maintenance 18,400 Depreciation 37,200 25,500 28,400 $109,500 Insurance Rent Total Alexis King chose to prepare a static budget based on sales of 3,000 canoes. Actual sales were 3,100 canoes at a price of $853 each. The company incurred the following costs for the year: Direct material $ 919,500 Direct labor Variable overhead 398,200 Fixed overhead 539,100 117,400 $1,974,200 Total 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 negatlve sign preceding the number e.g. -45 or parentheses e.g. (45). Round answers to 0 decimal places, e.g. 12s. If variance is zero, select "Not Applicable" and enter 0 for the amounts.) Actual Results Flexible Budget Variance Flexible Budget Sales Volume Variance Static Budget Unit sales 3100 Unfavorable 3100 3000 Sales revenue Favorable Less* | | Variable expenses Direct materia Direct labor Overhead Total variable expenses Contribution margin Total fixed expenses Operating incomeStep 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