1. Molega Lake Outfitters Manufactures stand up paddle boards. These are sold through smaller retailers across Canada. They are considering making a smaller children's paddle board. It will sell to retailers for $325 each Equipment to manufacture the product is estimated to cost $63,000 and labour and materials to make the board is estimated to be $235 per board. a. 14 pts) Construct revenue, cest and profit functions in terms of the number of boards made b. [3 pts) How many boards must be made and sold to breakeven? c. 13 pts] What is the monetary value at the breakeven point. d. [3 pts] Canadian Tire would like to be exclusive retailer for the boards and is prepared to purchase 1.000 boards. What is the lowest price at which Molega can sell the boards to Canadian Tire and still becakeven? c [6 pts] Construct a graph of the revenue, cost and profit functions from part. Label all functions and the axes, as well as the breakeven point. 1.13 pts) Suppose that they estimate that demand will be 175 units per year. How long will it take for them to breakeven? B. 3 pts) How many units must they sell to achieve a profit of 20% of total costs? h. [3 pts) How many units must they sell to achieve a profit of at least 20% of revenues! 1. [3 pts] A national chain of surf supply stores wants to be the exclusive distributor of the Molega Lake Outfitters and has guaranteed to purchase 400 units over the next two years. What is the price that Molega Lake Outfitters can sell the boards for and still breakeven in 2 years? 1- 13 pts] Using Excel, build the basic breakeven model for part a) above. You should lay it out like the image below. Then Fill out the table for the know parameters and formulations in column Once the spreadsheet is built, press Ctrl and keys at the same time and your spreadsheet should flip to formula view. Take a screen shot of your spreadsheet and print it. This screenshot should show the formules that you used, k [3 pts) Now open Goal Seek, fill in the cells and then take another screenshot. The screenshot will show both the values in column B as well as the Goal seek box. 1.13 pts) Press OK on the Goal Seek window, take the last screenshot to show the breakeven values in column B