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
CASE STUDYBUSINESS LAWAnderson Darragh, a real estate agent for RE/MAX, informed Bryan Thomas, a real estate developer, that he
Doss [256]
Based on legalities, Thomas has the right to refuse payment of the 8% commission to RE/MAX because he already stated his refusal during the meeting with Darragh nor did he sign the document that Darragh gave him during the meeting. Thus, there was no meeting of minds. 

Darragh is entitled to be given a reimbursement for his expenses incurred in securing documents that he willingly gave to Thomas. He can also ask Thomas for a recompensation for his labors but it will be according to Thomas's discretion. 

Darragh can't claim that he worked on implied consent from Thomas because Thomas specifically stated his refusal in paying for the 8% commission during their meeting but Darragh did not stop to renegotiate the commission nor convince Thomas to accept the contract. 
6 0
3 years ago
Jubilee, Inc., owns 30 percent of JPW Company and applies the equity method. During the current year, Jubilee buys inventory cos
kumpel [21]

Answer:

the gross profit reported is $1,518

Explanation:

The computation of the amount of gross profit that reported is shown below:

But before that the gross profit percentage is

= (Sales - cost of goods sold) ÷ (sales)

= ($138,000 - $110,400) ÷ ($138,000)

= 20%

Now the gross profit is

= $25,300 × 20% × 30%

= $1,518

Hence, the gross profit reported is $1,518

8 0
3 years ago
Isaac is looking for a business angel. his best chance of finding one is through:
Jet001 [13]

If Isaac is looking for a business angel, the best chance that he may be able to find one and to know where to look is by having to contact people that are involved with business associates, lawyers and even accountants.

8 0
3 years ago
The par value or stated value of stock represents the amount of legal capital that a corporation must maintain for the protectio
ohaa [14]

Answer:

True

Explanation:

This is the value of stock or share that was set by the owners of a corporation at the point of registration of the company. It is the price that is stated in the corporation's article of association and also in the share certificate. The par value of a share has no relationship with the market value as they can be far apart.

The par value is a value specified by law for the protection of the people who might want to extend credit to the corporation.

6 0
3 years ago
Paris operates a talent agency as a sole proprietorship,and this year she incurred the following expenses in operating her talen
Juliette [100K]

Answer:

A) $450.

Explanation:

The computation of the total deductible amount of the expenses is as follows:

In the case of the deduction with respect to the meal cost and entertainment. Only the half of the expense would be deducted i.e. for the business meeting

As in the question the opera tickets is $900 so the half of $900 i.e. $450 would be allowed as a deduction

Therefore the correct option is A.

6 0
2 years ago
Other questions:
  • Which set of personal qualities is essential for a good manager?
    12·1 answer
  • Which of the following is NOT a type of funded retention?a: reservesB: self-insurancec: captivesd. credite: all of the above
    7·1 answer
  • Gerben is a small-scale apparel manufacturing company. its marketing team is planning to bring about a new line of clothing, and
    5·1 answer
  • You have just purchased a share of preferred stock for $50.00. The preferred stock pays an annual dividend of $5.00 per share fo
    8·1 answer
  • As the case explains, at one time customers were likely to buy their donuts at Dunkin’ Donuts and their coffee at Starbucks. How
    9·1 answer
  • Consider two economic regions, region A and region B. If region A has strict union protection laws present, while region B lacks
    8·1 answer
  • What is a description of the prime rate?
    11·1 answer
  • Byron Corp is considering the purchase of a new piece of equipment. The cost savings from the equipment would result in an annua
    14·1 answer
  • What other considerations do manufacturers have when deciding on the dimensions of the cans, besides minimizing the amount of ma
    13·1 answer
  • Type the correct answer in the box. Spell all words correctly.
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!