Question: instructions are first two photos. thank u! 1 Saving the Emering ecansous Uiernome 2. M5 Preject Tab a. Enter information in the blue and yellow




1 Saving the Emering ecansous Uiernome 2. M5 Preject Tab a. Enter information in the blue and yellow cells only. b. DON'T add or delete amy rows or columns and DON'T round as dolng so will result in a zero c. Complete everything in yellow highlight: your score will be based on your input in these yellow cells. You MUST use cell references and formulas for all amounts when applicable; there thould be very few typed or hard-coded numbers. Do not enter or linik costs/expenses with negative signs, however, when netting them in calculating subtotals/totals you will need to subtract them. 3. Submitting Completed Prolects vla eCampus (DO NOT EMALL YOUR COMPLFIFD PROJECT) A. Calculate the missing amounts in MVP's Income Statement presented for financial reporting purposes belo Additional information: Sales Price per unit: All variable expenses in the company vary in terms of units sold There was no change in inventory levels between the beginning and end of the year Hint: Operatifflincome (Loss) mut equal D. Calculate MVP's current breakeven point in beth units and dellars: Dollars(usetheContributionMarginRatiotocalculate)n/am/a E. Redo MVP's Contribution Margin lncome statemeat wiing the Vice President of Sales (VP) suczestions and projected increase in sales volume below (all amounts should be a formula/linkk Projected sales volume incease Hint: This amount represents the new selling price Hint: Per unit variable costs are the same as the of n/a constant with dhanges in volume. However, to n/a n/a i/a inda n/a n/a F. Using the budgeted contribution murgh income statement in part E~, above, calculate the following: a. Breakeven in units: b. Operatine leverage Multiplier: AN/A Hint: This ameunt represeats the new advertiaing Given a sales volume increase of B%, operating income will increase by c. Percent: d. Dollars: m/2 n/a ha n/a N/a n/a n/s constant with danges in volume. However, Hint: This ameunt represents the new advertiaing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
