Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribedimage text in transcribed

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 income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Assessment Manual For The Internal Audit Activity

Authors: The Internal Audit Foundation

2017 Edition

0894139975, 978-0894139970

More Books

Students also viewed these Accounting questions