Question: 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
Get step-by-step solutions from verified subject matter experts
