National Investor Group is opening an office in Portland, Oregon, Faxed monthly costs are office rent (58.500 depreciation on office furniture 152.000), utilities (52.100), special telephone lines $2.100) a connection with an online brokerage service (52,800), and the salary of a financial planner 154.500) Variable costs include payments to the financial planner is of revenuel, advertising (13% of revenue supplies and postage 3 of revenue and usage fees for the telephone lines and computerized brokerage service 16% of revenue). YOU MUST SHOW ALL CALCULATIONS TO EARN MARKS REQUIREMENTS A Use the contribution margin ratio approach to compute National's breakeven revenue in dollars. If the average trade leads to $1,000 in revenue for National, how many trades must be made to break even? Use the equation approach to compute the dollar revenues needed to earn a monthly target profit of $12,600 Using MS Excel, or any spreadsheet program, graph National's CVP relationships. Assume that an average trade leads to $1.000 in revenue for National Show the breakeven point, the sales revenue line, the foed cost line, the total cost line, the operating loss area, the operating income area, and the sales in units (trades) and dollars when monthly operating income of $12.600 earned. UPLOAD THE FILE TO ASSIGNMENT SUBMISSION ON BLACKBOARD TOGETHER WITH THE REST OF THE ANSWERS OR PROVIDE THE LINK BE YOU ARE USING GOOGLE SHEET D. Suppose that the average revenue National earns increases to $1.200 per trade Compute the new breakeven point in trades. How does this affect the breakeven point