M5 P

.xlsx

School

West Virginia University *

*We aren’t endorsed by this school

Course

201

Subject

Accounting

Date

Apr 25, 2024

Type

xlsx

Pages

4

Uploaded by BarristerGoldfinchMaster1053 on coursehero.com

Project Instructions Projects are your own work. It is academic dishonesty to work with or submit a file prepared by another individual. 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 reporting 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 management predictions and calculate its breakeven and operating leverage. MPV's maximum capacity is 60,000 units per year. Instructions: 1. Saving and Entering eCampus Username a. Open the Project file using Excel for Microsoft 365 previously downloaded onto your device. You will receive a 0 if you use any other spreadsheet program, such as Numbers, Google Sheets, etc. b. Be careful not to include a space before or after your username. Failure to enter your eCampus Username properly makes your submission ungradable and result in a 0. c. Save your Project file on your computer. Do not save your project on the Cloud, if you try to submit your project from the Cloud, your file will be ungradable and will result in a 0. When naming your file, do not include any punctuation, symbols, or dashes in your file name; doing so may cause your file to be ungradable and will result in a 0. Recommendation: You may want to create a folder for this class on your Desktop and save all your course projects there for easy access. 2. M5 Project Tab a. Enter information in the blue and yellow cells only. b. DON'T add or delete any rows or columns and DON'T round as doing 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 should be very few typed or hard-coded numbers. Summing contiguous amounts: Use the SUM function and reference the cells being added using a colon between the first and last cell in the range (i.e. =SUM(B6:B7) or =SUM(B8:B11)). 3. Submitting Completed Projects via eCampus (DO NOT EMAIL YOUR COMPLETED PROJECT) a. Save your file on your PC (not in the Cloud). b. Verify that you used correct cell linking and SUM function requirements. Review each and verify that you have followed ALL the above instructions before submitting your project. Remember, if you changed any of your links or formulas, you must save your file again. You are now ready to submit your project. c. In eCampus, go to Assignments/Projects… and click on the related project link. d. Locate the Assignment Submission section on the new screen. e. Click Browse My Computer in the Attach Files box (surrounded by a dashed border). f. Locate your saved Excel file, select your file by clicking on it. g. Click Open and select Submit. h. Review your submission to ensure your file uploaded correctly and you can see the answers you entered. Submissions uploaded incorrectly before the due date and corrected after the due date are considered late and will not be accepted. i. No late projects will be accepted. See Makeup Policy provided in the course syllabus. j. DO NOT correspond using the Write Submission or Add Comments dialog box as any such correspondence will NOT be viewed. Go to the M5 Project tab and, in the blue cell, type your eCampus Username, such as npl0001. Do not capitalize any letters, do not include “@mix.wvu.edu”, and do not use your student number. Do not enter or link costs/expenses with negative signs; however, when netting them in calculating subtotals/totals you will need to subtract them.
M5 Project Enter eCampus Username: ecd00002 A. Calculate the missing amounts in MVP's Income Statement presented for financial reporting purposes below: MVP, Inc. Income Statement For the Year Ended December 31, 2021 Sales $ 375,000 Cost of Goods Sold: Direct Materials (variable) 100,000 Direct Labor (variable) 19,800 Manufacturing Overhead ($40,000 is fixed) 89,750 Cost of Goods Sold 209,550 Gross Profit 165,450 =D8-D13 Operating Expenses: Sales Commissions (variable) 12,500 Shipping (variable) 2,500 Advertising (fixed) 9,900 Billing (of which $10,000 is fixed) 10,250 Sales and Administrative Salaries (fixed) 90,000 Total Operating Expenses 125,150 Operating Income (Loss) $ 40,300 =D14-D21 Additional information: Sales Price per unit: $15.00 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 B. Using the information above, calculate the missing amounts below: a. Units of product MVP sold in 2021: 25,000 =D8/C25 Variable cost per unit for the following mixed costs: b. Variable Manufacturing Overhead per unit: $ 1.99 =(C12-40000)/C31 c. Variable Billing per unit: $ 0.01 =250/C31
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help