Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Irregularities Frauds And The Necessity Of Technical Auditing In Construction Industry

Authors: A. L. M. Ameer

1st Edition

1481799754, 978-1481799751

More Books

Students also viewed these Accounting questions

Question

1. Write the distribution of scores on the board after tests.

Answered: 1 week ago