1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Nookie1986 [14]
3 years ago
10

Using the Goal Seek function in Microsoft Excel, prepare an Excel spreadsheet to answer the following questions: Warner Clothing

is considering the introduction of a new baseball cap for sales by local vendors. The company has collected the following price and cost characteristics:
Sales Price............$15 per unit
Variable cost......... 3 per unit
Fixed cost.............. 42,000 per month

Required
a. What number must Warner sell per month to break even?
b. What number must Warner sell per month to make an operating profit of $30,000?
Business
1 answer:
Masja [62]3 years ago
3 0

Answer:

3,500 units

6,000 units

Explanation:

Given:

Sales Price = $15 per unit

Variable cost = $3 per unit

Fixed cost = $42,000 per month

A. Break even point

Break even point(in units) =  Total fixed cost / (Sales Price - Variable cost)

                             =  $42,000 / ($15 - $3)

                             = $42,000/ $12

                             = 3,500 units

B. Number of sales unit

Sales unit for desired profit = (Total fixed cost + Desired profit)/ (Sales Price - Variable cost)

                                             = ($42,000 + $30,000) / ($15 -$3)

                                             = $72,000 / $12

                                             = 6,000 units

You might be interested in
the nominal interest rate is 7 percent and the expected inflation rate is 4 percent. the real interest rate is
Hoochie [10]

Answer:

2.88%

Explanation:

According to the fisher equation :

(1 + Nominal interest ) = (1 + real interest) (1 + inflation rate)

(1.07) = (1.04) x (1 + real interest)

(1.07) / (1.04) = (1 + real interest)

1.028846

real interest rate = 2.88%

6 0
3 years ago
​a _____ controls database operations, including storing, retrieving, updating, and deleting data.
Radda [10]

Answer: A data language controls database operations including storing, retrieving, updating and deleting data

Explanation: This is the definition for manipulation

3 0
3 years ago
Read 2 more answers
Durban Metal Products, Ltd., of the Republic of South Africa makes specialty metal parts used in applications ranging from the c
gladu [14]

Answer:

<u>Overhead Report for heavy-duty trailer axles.</u>

Order size ($ 16.85 × 200)              $3,370.00

Customer orders ($ 320.00 × 1)        $320.00

Product testing ($ 89.00 × 4)            $356.00

Selling ( $ 1,090.00 × 2)                  $2,180.00

Total                                                 $6,226.00

Conclusion :

The total overhead cost assigned to the order is $6,226.00

Explanation:

ABC system allocates overheads to jobs using cost drivers.

First an Activity Center where costs accumulate is identified these can be several in our scenario we have four Activity Centers.

Then the Cost driver rate is calculated for each Activity Center. Our question has provided these.

The final step is to allocate the overheads to a particular job using the cost driver rate.

7 0
3 years ago
Sammie is planning a persuasive request. What advice should she follow for the opening of her request? a. Capture the reader's a
Andrei [34K]

Answer:

a. Capture the reader's attention and interest.

Explanation:

To be able to make a request to someone persuasively, , it is very pertinent to lead the person to a point where such person can listen to you. This can only work in a context where you are very efficient in using story telling and other means of interaction that are capable of winning the persona interest and loyalty. Otherwise, you cannot have the person respond to your request.

4 0
3 years ago
Which of the following companies has the lowest degree of leverage?
LiRa [457]

The firm with a 20% Debt and 80% Equity has the lowest degree of leverage.

<h3>What is a degree of leverage?</h3>

This means  how much a firm operating income changes in response to a change in sales.

Because the Firm C has a low debt, this means its has the lowest degree of leverage when compared to others.

Therefore, the Option C is correct.

Missing options "90% Debt, 10% Equity

30% Debt, 70% Equity

20% Debt, 80% Equity

50% Debt, 50% Equity"

Read more about degree of leverage

<em>brainly.in/question/8720374</em>

#SPJ1

4 0
2 years ago
Other questions:
  • Jake just got a big promotion at work and wants to buy a new Jaguar.​ However, he lives in northeast​ Indiana, and the nearest J
    10·1 answer
  • The three types of mathematical simulation models are
    8·1 answer
  • Indy Sport and Hobby's Allowance for Doubtful Accounts had an unadjusted credit balance of $400. The manager estimates that $900
    5·2 answers
  • A partial adjusted trial balance of Piper Company at January 31, 2017, shows the following:
    10·1 answer
  • When Tesla receives a $1,000 reservation payment from a customer, what Tesla general ledger accounts does this $1,000 impact? Ex
    11·1 answer
  • In January 2021, Summit Department Store sells a gift card for $50 and receives cash. In February, 2021, the customer comes back
    9·1 answer
  • Boney Corporation processes sugar beets that it purchases from farmers. Sugar beets are processed in batches. A batch of sugar b
    7·1 answer
  • Why is it important to research a school’s curriculum before deciding whether to go there?
    7·1 answer
  • How do u make friends
    7·2 answers
  • The​ ________ is the optimum budget to managers that plan revenues and expenses at different sales volumes.
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!