Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Acct3360 Excel Assignment -Variance Analysis Excel Version (7.55%) due April 16, 2023 @ 11:59pm Due Date: Wednesday, April 16 @ 11:59pm Cyclops Cycles manufactures two

image text in transcribed
Acct3360 Excel Assignment -Variance Analysis Excel Version (7.55%) due April 16, 2023 @ 11:59pm Due Date: Wednesday, April 16 @ 11:59pm Cyclops Cycles manufactures two models of dirtbikes for the Alberta market, the Eggasgs and the Phoenix models. Based on a projected Alberta market size of 9,600 m 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 margin of $4,200 each At the end of 2021 Cyclops determined that 10,000 dirtbikes had been sold Alberta- wide. 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 Reguired: Create a dynamic solution in Excel similarutg the ones done in class: a) Complete a Management Variance Report like the ones we did in class and are on Moodle. {3.5 marks) b) Comment on the four variances management would nd most actionable and explain their specific causes in Cyclops's case. Be specific in your comments and explanations. {4 marks) Be sure your Excel sheet is dynamic and automatically adjusts if data is changed. 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 with AI-Powered 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

Cornerstones of Managerial Accounting

Authors: Mowen, Hansen, Heitger

3rd Edition

978-0324660135

Students also viewed these Accounting questions