Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Acct3360 Excel Assignment -Variance Analysis Excel Version (5%) - due November 14, 2022@ 11:59pm Due Date: Wednesday, Nov 14@ 11:59pm Cyclops Cycles manufactures two models

image text in transcribed
Acct3360 Excel Assignment -Variance Analysis Excel Version (5\%) - due November 14, 2022@ 11:59pm Due Date: Wednesday, Nov 14@ 11:59pm Cyclops Cycles manufactures two models of dirt-bikes for the Alberta market, the Pegasus and the Phoenix models. Based on a projected Alberta market size of 9,600 dirt bikes sold Cyclops budgeted the following 2021 results: 2,000 Pegasus models sold @ a contribution margin of $3,500 each 1,200 Phoenix models sold @ a contribution marqin of $4,200 each At the end of 2021 Cyclops determined that 10,000 dirt-bikes had been sold Albertawide. The actual results for Cyclops were: 2,394 Pegasus models sold @ $3,200 contribution margin per unit 1,409 Phoenix models sold @ \$4,100 contribution margin per unit Required: Create a solution in Excel similar to the ones done in class: a) Complete a Management Variance Report like the ones we did in class and are on Moodle. ( 3 marks) b) Comment on the four variances management would find most actionable and explain their specific causes in Cyclops's case. Be specific in your comments and explanations. ( 2 marks) Be sure to drop your completed Excel spreadsheet into the Dropbox provided on Moodle

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

Portfolio Of Marketing Audits Company Self Assessment Audits

Authors: David Crosby

1st Edition

1902433157, 978-1902433158

More Books

Students also viewed these Accounting questions

Question

5. Identify three characteristics of the dialectical approach.

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

4. Explain the strengths and weaknesses of each approach.

Answered: 1 week ago