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

instructions are first two photos. thank u!
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 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!