Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!


Colorado State University Comparative Cost Volume Profit Analysis

Colorado State University Comparative Cost Volume Profit Analysis

Question Description

Option #2: Comparative Cost-Volume-Profit Analysis Calculation

Phil Lesley, Controller, would like to complete a comparative cost-volume-profit analysis for the current year over the prior year for the chewing gum manufacturing plant to determine if the breakeven point was achieved, and how it may have differed between the two years.

Specific costs for production of 400,000 units each year, include the following:

2017 – Current Year
Chewing Gum Manufacturing Division Costs Variable Costs Total Fixed Costs Total
Raw materials $ 250,000
Direct manufacturing labor $ 110,000
Indirect manufacturing labor $ 42,500
Factory Insurance & Utilities $ 35,000
Depreciation — Machinery and factory $ 48,500
Repairs and maintenance —factory $ 8,000
Selling, marketing, and distribution expenses $ 10,000 $ 30,000
General and administrative expenses $ 50,000
2016 – Prior Year
Chewing Gum Manufacturing Division Costs Variable Costs Total Fixed Costs Total
Raw materials $ 245,000
Direct manufacturing labor $ 105,000
Indirect manufacturing labor $ 50,250
Factory Insurance & Utilities $ 33,750
Depreciation — Machinery and factory $ 38,500
Repairs and maintenance —factory $ 14,000
Selling, marketing, and distribution expenses $ 10,000 $ 25,000
General and administrative expenses $ 60,000

There is no beginning or ending inventories. The total sales for 400,000 units produced are $1,050,000 for 2016 and $1,200,000 for 2017.

Using Microsoft Excel, answer the following questions for each year given the fact pattern above, showing all supporting calculations and labelling answers clearly. Please refer to CSU-Global Library (Links to an external site.)Links to an external site. for tutorials on using Microsoft Excel or use the Excel Tutorials link found in the classroom if you need assistance.

  1. What is the contribution margin per unit for each multipack of gum produced given the fact pattern above?
  2. What is the breakeven point in units and dollars given the fact pattern above?
  3. What is the division’s margin of safety and degree of operating leverage given the fact pattern above?
  4. Create a very simple Excel table summarizing answers of each computation for each year. *Below the table in Excel, please write at least 3 observations you have regarding the data comparisons/contrasts.

Responses should be in complete sentences utilizing proper grammar. Your paper must be formatted according to CSU-Global Guide to Writing and APA Requirements (Links to an external site.)Links to an external site..

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.