# Pretax Breakeven Point Assignment

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

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  .. Get Finance homework help today

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 Australia Assessments
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.
Excellent work!
Customer 463337, March 7th, 2023
Management
support is great. I am grateful to you and your company. thank you very much.
Customer 454227, April 6th, 2020
History
Good work.
Customer 462717, May 15th, 2022
Literature
Beautifully written essay!
Customer 462241, November 25th, 2021
Excellent.
Customer 452615, May 23rd, 2022
Thank you!
Customer 453187, March 2nd, 2022
Human Resources Management (HRM)
Thank you for this excellent power point
Customer 453633, February 24th, 2020
Medicine
Good work.
Customer 462931, May 4th, 2022
Great effort.
Customer 458115, May 2nd, 2022
Ethics
Excellent job
Customer 456821, May 3rd, 2022
English 101
Excellent deliverables. I love the immersive thought.
Customer 462537, April 21st, 2022
English 101
Satisfactory. However, always go through instructions before submitting to identify omissions.
Customer 462843, April 11th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend