# Break-even analysis | Business & Finance homework help

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.

Nielsen’s Fine Clothing Store

Please do this problem in excel.

You are the owner of a general retail-clothing store. Below is the income statement for last year which is not expected to change at all during the upcoming fiscal year. You have one full time manager, two three quarter time assistant managers and 3 part time clerks. You have had the manager and assistant managers for the past five years. Five years ago sales were only 350,000 dollars. As sales have increased you have added the part time clerks. You anticipate adding more clerks as sales increase in the future. You pay you credit card vendor 1 percent of sales. Bad debt expense and shrinkage are also estimated as a percentage of sales. The Mall common area payment must be paid regardless of how many sales you make

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.

1. Please calculate the pretax breakeven point in sales dollars from the formula in the online lecture on breakeven analysis. Use the formula for breakeven sales dollars. Do not use the formula for breakeven in units.  As part of this analysis list each expense item and identify whether it is a fixed or a variable expense. (20 points)

2. What happens to your breakeven point if your primary supplier of clothing raises prices 5%? You buy 45% of your clothing from this company. (10 points)

3. Your manager has received an offer of employment from a competitor. She would make 25% more than you are paying her now. If you match this offer, what is the impact upon your breakeven point (what will the new breakeven point be)? (10 points)

Data for analysis.

First step: Determine which expense items are fixed and which are variable. I do not expect you to make the same assumptions I would make. You are graded on the application of the breakeven formula to the data as you have analyzed it.

Second Step: Calculate the breakeven sales using the formula in the online lecture.

Third Step: Do a “what if” analysis by changing the inputs (in problem 2 and 3) and recalculating the breakeven sales.

Revenues \$650,000

Expenses:

Managers’s Salaries & Benefits 25,000

Asst. Managers’ Wages 35,000

Clerical Wages 29,000

Owner’s Salary 55,000

Rent (4% of gross revenue) 13,000

Mall Common Area Payment 25,000

Phone Bill 5,000

Property Insurance 7,000

Property Taxes 5,000

Office Supplies 2,000

Postage 500

Equipment Expenses 5,000

Shrinkage 4,000

Credit Card Expense 6.500

Wholesale Clothing Purchases 380,000

—————

Total Expenses  612,000

Net Operating Income 38,000

This price of 38000 is part of the question, not a part of my actual budget.

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Commendable.
Customer 452441, April 6th, 2022
Cybersecurity
I must say that the paper is exceptionally well-written and has exceeded my expectations. I appreciate the excellent work you've done on the paper.
Customer 452455, July 3rd, 2023
Turned in the new assignment,. Everything was great
Customer 463053, December 4th, 2022
Psychology
Absolutely wonderful speech! Thank you so much!
Customer 462815, April 20th, 2022
History
Excellent response.
Customer 462281, April 20th, 2022
Nursing
Thanks a lot Peter
Customer 453199, March 28th, 2020
Education
GOOD WORK
Customer 463813, April 19th, 2023
SEO
This was a job well done
Customer 463679, April 20th, 2023
Military
Good job
Customer 456821, November 28th, 2022
Family and consumer science
Great effort.
Customer 462739, April 14th, 2022
Health Care
Thank you!
Customer 454001, February 7th, 2020
Accounting
Thank you!
Customer 454299, April 21st, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend