Expert answer:Colorado State University Comparative Cost Volume


Solved by verified expert:Option #2: Comparative Cost-Volume-Profit Analysis CalculationPhil 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 YearChewing Gum Manufacturing Division CostsVariable Costs TotalFixed Costs TotalRaw materials$ 250,000Direct manufacturing labor$ 110,000Indirect manufacturing labor$ 42,500Factory Insurance & Utilities$ 35,000Depreciation — Machinery and factory$ 48,500Repairs and maintenance —factory$ 8,000Selling, marketing, and distribution expenses$ 10,000$ 30,000General and administrative expenses$ 50,0002016 – Prior YearChewing Gum Manufacturing Division CostsVariable Costs TotalFixed Costs TotalRaw materials$ 245,000Direct manufacturing labor$ 105,000Indirect manufacturing labor$ 50,250Factory Insurance & Utilities$ 33,750Depreciation — Machinery and factory$ 38,500Repairs and maintenance —factory$ 14,000Selling, marketing, and distribution expenses$ 10,000$ 25,000General and administrative expenses$ 60,000There 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.What is the contribution margin per unit for each multipack of gum produced given the fact pattern above?What is the breakeven point in units and dollars given the fact pattern above?What is the division’s margin of safety and degree of operating leverage given the fact pattern above?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..

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:Colorado State University Comparative Cost Volume
Just from $10/Page
Order Essay
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP