Cyclops Cycles manufactures two models of dirt-bikes for the Alberta market, the Pegasus and the Phoenix...

 

Transcribed Image Text:

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 margin of $4,200 each At the end of 2021 Cyclops determined that 10,000 dirt-bikes 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 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) 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 margin of $4,200 each At the end of 2021 Cyclops determined that 10,000 dirt-bikes 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 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)

Answer rating: 100% (QA)

SOLUTION Let s solve ... View the full answer