Answered step by step
Verified Expert Solution
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
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
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