Proj 2 FALL 2019 Student.xlsx - Accounting 202 PROJECT 2 CVP ANALYSIS(40 pts Name Rachel Gibson Class time!2:30 Enter the last 4 digits of your student

# Proj 2 FALL 2019 Student.xlsx - Accounting 202 PROJECT 2...

• 3

This preview shows page 1 - 2 out of 3 pages.

Page 1 Accounting 202 PROJECT 2 - CVP ANALYSIS (40 pts) Name: Rachel Gibson Class time !2:30 Enter the last 4 digits of your student ID number: 3 4 6 0 (These digits will be used to for some variables in the project) Highest = 6 Round all dollar amounts to whole dollars, except for per unit amounts. Per unit amounts should be Lowest other than 0= 3 rounded to the nearest cent. Percentages should be rounded as follows: 20.75% or .2075 Do not change rows or colums on this spreadsheet. Input areas are in yellow. You MUST show your work in the areas indicated to get credit for the problem. Presented below is Baron Company's Income Statement prepared on the traditional (functional) basis: complete Requirement 2. Then, complete the totals on the income statement. Baron Company Income Statement For the Year Ended December 31, 2018 Sales \$375,000 Cost of Goods Sold Direct Materials (variable) \$72,500 Direct Labor (variable) 45,000 Manufacturing Overhead (mixed) 67,200 184,700 Gross Margin 190,300 Operating Expenses Commissions (variable) 30,000 Shipping (variable) 6,000 A. Multiply the HIGHEST digit entered above 6000 Advertising (fixed) 92,000 above by 1,000 and enter here enter the result Billing (mixed) 5,969 B. Complete Requirement 2 below and insert result here Sales and Administrative Salaries (fixed) 66,000 should have a loss Total Operating Expenses 199,969 Net Operating Income (Loss) \$ (9,669) Selling price per unit is \$15 and variable manufacturing overhead is \$1 per unit. All variable expenses in the company vary in terms of units sold.

#### You've reached the end of your free preview.

Want to read all 3 pages?

• Spring '17

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern