Answered step by step
Verified Expert Solution
Question
1 Approved Answer
answer the cells in yellow! thank you! In this project, you will complete MPV's Income Statement for financial reporting. You will convert its income Statement
answer the cells in yellow! thank you!
In this project, you will complete MPV's Income Statement for financial reporting. You will convert its income Statement into a Contribution Margin income Statement for management re, purposes. You will differentiate between variable costs and fixed costs and calculate its breakeven. You will then redo the contribution Margin income Statement based on different mara prediction and calculate its breakeven and operating leverage. MPV's maximum capacity is co,000 units per year. Calculate the missing amounts in MVP's Income Statement presented for financial reporting purposes below: 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: Operating income (Loss) must ate MVP's current breakeven point in both units and dollars: Dollars(usetheContributionMarginRatiotocalculate):n/an/a C. Redo MVP's Contribution Margin income Statement using the Vice President of Sales (VP) suggestions and projected Increase in sales volume below (all amounts should be a formula/link): seduce welling price by: Increase atwerthing conts by: Prejected sales velume increase: N/a n/a n/a Na N/a A/a n/a nida n/a Hint: This amount represents the new selling prici Hint: Per unit varlable costs are the carme as the o constant with changes in volume. However, 1 F. Using the budgeted centribution margin incoene statement in part E. above, calculate the following: 1int: This amount represeats the new advertisine 2. 8reakeven in units: b. Operating Leverage Multiplier: N/A IN/A Given a sales volume increase of 8x, operating income will increase by: c. Percent: d. Dollars: aN/A aN/A 2. MS Project Tab a. Enter information in the blue and yellow cells only. b. bcert add or delete afry rows or columns and DONT round as doing so will reult in a zero. c. Complete everything in yellow highlight; your score will be based on your irpect in thele yellow cell. You MUST ue cell teftrencet and formulas for all amounts when applicable; there should be very few typed or hard-coded nurmbers. In this project, you will complete MPV's Income Statement for financial reporting. You will convert its income Statement into a Contribution Margin income Statement for management re, purposes. You will differentiate between variable costs and fixed costs and calculate its breakeven. You will then redo the contribution Margin income Statement based on different mara prediction and calculate its breakeven and operating leverage. MPV's maximum capacity is co,000 units per year. Calculate the missing amounts in MVP's Income Statement presented for financial reporting purposes below: 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: Operating income (Loss) must ate MVP's current breakeven point in both units and dollars: Dollars(usetheContributionMarginRatiotocalculate):n/an/a C. Redo MVP's Contribution Margin income Statement using the Vice President of Sales (VP) suggestions and projected Increase in sales volume below (all amounts should be a formula/link): seduce welling price by: Increase atwerthing conts by: Prejected sales velume increase: N/a n/a n/a Na N/a A/a n/a nida n/a Hint: This amount represents the new selling prici Hint: Per unit varlable costs are the carme as the o constant with changes in volume. However, 1 F. Using the budgeted centribution margin incoene statement in part E. above, calculate the following: 1int: This amount represeats the new advertisine 2. 8reakeven in units: b. Operating Leverage Multiplier: N/A IN/A Given a sales volume increase of 8x, operating income will increase by: c. Percent: d. Dollars: aN/A aN/A 2. MS Project Tab a. Enter information in the blue and yellow cells only. b. bcert add or delete afry rows or columns and DONT round as doing so will reult in a zero. c. Complete everything in yellow highlight; your score will be based on your irpect in thele yellow cell. You MUST ue cell teftrencet and formulas for all amounts when applicable; there should be very few typed or hard-coded nurmbers Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started