Raiders Ltd CVP Problem Prepare an Excel worksheet that illustrates cost-volume-profit (CVP) analysis, also referred to as breakeven analysis. Assume that a particular product sold at Raiders Ltd a US based toy company has a sales price per unit of $4.00; variable cost per unit of $2.20; and total fixed cost of $100,000 Task 1) Calculate the contribution margin per unit, the break-even point in units of sales, and the break-even point in dollars of sales. In the input area, show sales price per unit, variable cost per unit, and total fixed cost. In the output area, show contribution margin per unit, breakeven point in units, and breakeven point in dollars computed using appropriate formulas. (12 marks) Task 2) Assume that the planning team at Raiders Ltd estimates that for the next planning period selling price for this product will increase 50%; variable expenses will decrease 25%; and that total fixed cost will decrease 25%. Compute the new values for sales price per unit, variable cost per unit, and total fixed costs and then show contribution margin per unit, breakeven point in units, and breakeven point in dollars. (15 marks) Task 3) Assume the data in requirement 1). Prepare a CVP graph to illustrate breakeven analysis. To prepare the graph, first set up a table with columns for units, total fixed cost, total variable cost, total cost, sales revenue, and profit (Remember to use appropriate formulas to determine numerical values for these variables). In the units column, show values from zero to 70,000 in increments of 10,000. Graph the data in columns for total fixed cost, total cost, and sales revenue. Label your respective axes and lines. Note that by so doing you are graphing a CVP chart! (24 marks) Graph (6 marks) Task 4) While the above calculations could just have readily been performed using a calculator: a. what advantages are there from solving CVP problems using Excel? (4 Marks) b. examine the benefits of using CVP analysis (3 marks) C. Justify at least 4 limitations of CVP analysis. (4 marks) Task 5) CVP analysis is useful only under certain conditions and only when certain assumptions hold true. Explain these assumptions and conditions. (12 marks)