*Need assistance plotting the sales line, fixed line, and the total cost line. Please help. Thank you.
Mortgage Investor Group is opening an office in Portland, Oregon. Fixed monthly costs are office rent (58,500), depreciation on office furniture ($2,000), utilities ($2,500), special telephone lines (51,100), a connection with an online brokerage service ($2,700), and the salary of a financial planner ($11,200). Variable costs include payments to the financial planner (8% of revenue), advertising (13% of revenue), supplies and postage (3% of revenue), and usage fees for the telephone lines and computerized brokerage service (6% of revenue). Read the requirements. .... Requirement 1. Use the contribution margin ratio approach to compute Mortgage's breakeven revenue in dollars. If the average trade leads to $800 in revenue for Mortgage, how many trades must be made to break even? Begin by showing the formula and then entering the amounts to calculate the required sales dollars for Mortgage to break even. (Abbreviation used: CM = contribution margin.) Fixed costs + Target profit) CM ratio = Required sales in dollars = $ 40.000 ($ 28,000 $ 0 ) - 70 % Mortgage must make 50 trades to break even. Requirement 2. Use the equation approach to compute the dollar revenues needed to earn a monthly target profit of $11,200. Begin by selecting the formula to compute the required sales in units to earn a target profit Net sales revenue Variable costs Fixed costs Target profit Rearrange the formula you determined above and compute the required number of trades to earn a monthly target profit of $11,200. Mortgage must make 70 trades to earn a monthly operating income of $11,200. Now compute the dollar revenues needed to earn a monthly target profit of $11,200 Mortgage needs 56,000 in revenues to earn a monthly operating income of $11,200. (After you hit continue the screen may take you below the beginning of the next step. If so, scroll back up to the top of the step.) Requirement 3. Graph Mortgage's CVP relationships. Assume that an average trade leads to $800 in revenue for Mortgage. Show the breakeven point, the sales revenue line, the fixed 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 $11,200 is earned. We will begin graphing the CVP relationships by first plotting the two points: breakeven point and the point where monthly operating income of $11,200 is earned. (Enlarge the graph to medium size and use the point tool button displayed below to draw the graph. Be sure to select a label for each point plotted) 80+ 70 60 50 Dollar (Thousands) 40 Brake 30 20 10 0 80 10 20 30 40 50 60 70 Units (Trades) B Next plot the following lines: the sales revenue line, fixed cost line, and the total cost line. (Enlarge the graph to medium size and use the line tool button displayed below to draw the graph. Do NOT use plot points that require rounding. (Hint: refer to your computations from Requirements 1 and/or 2, as appropriate, to assist in identifying plot points. Be sure to select a label for each line drawn.) 80 70 60 50% Dollars (Thousands) 40 30 20 Mortgage Investor Group is opening an office in Portland, Oregon. Fixed monthly costs are office rent (58,500), depreciation on office furniture ($2,000), utilities ($2,500), special telephone lines (51,100), a connection with an online brokerage service ($2,700), and the salary of a financial planner ($11,200). Variable costs include payments to the financial planner (8% of revenue), advertising (13% of revenue), supplies and postage (3% of revenue), and usage fees for the telephone lines and computerized brokerage service (6% of revenue). Read the requirements. .... Requirement 1. Use the contribution margin ratio approach to compute Mortgage's breakeven revenue in dollars. If the average trade leads to $800 in revenue for Mortgage, how many trades must be made to break even? Begin by showing the formula and then entering the amounts to calculate the required sales dollars for Mortgage to break even. (Abbreviation used: CM = contribution margin.) Fixed costs + Target profit) CM ratio = Required sales in dollars = $ 40.000 ($ 28,000 $ 0 ) - 70 % Mortgage must make 50 trades to break even. Requirement 2. Use the equation approach to compute the dollar revenues needed to earn a monthly target profit of $11,200. Begin by selecting the formula to compute the required sales in units to earn a target profit Net sales revenue Variable costs Fixed costs Target profit Rearrange the formula you determined above and compute the required number of trades to earn a monthly target profit of $11,200. Mortgage must make 70 trades to earn a monthly operating income of $11,200. Now compute the dollar revenues needed to earn a monthly target profit of $11,200 Mortgage needs 56,000 in revenues to earn a monthly operating income of $11,200. (After you hit continue the screen may take you below the beginning of the next step. If so, scroll back up to the top of the step.) Requirement 3. Graph Mortgage's CVP relationships. Assume that an average trade leads to $800 in revenue for Mortgage. Show the breakeven point, the sales revenue line, the fixed 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 $11,200 is earned. We will begin graphing the CVP relationships by first plotting the two points: breakeven point and the point where monthly operating income of $11,200 is earned. (Enlarge the graph to medium size and use the point tool button displayed below to draw the graph. Be sure to select a label for each point plotted) 80+ 70 60 50 Dollar (Thousands) 40 Brake 30 20 10 0 80 10 20 30 40 50 60 70 Units (Trades) B Next plot the following lines: the sales revenue line, fixed cost line, and the total cost line. (Enlarge the graph to medium size and use the line tool button displayed below to draw the graph. Do NOT use plot points that require rounding. (Hint: refer to your computations from Requirements 1 and/or 2, as appropriate, to assist in identifying plot points. Be sure to select a label for each line drawn.) 80 70 60 50% Dollars (Thousands) 40 30 20
