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
81) When a seller advertises an item at a low price but once in store pushes a similar item at a higher price, the seller is par
storchak [24]

Answer:

E) bait and switch

Explanation:

BAIT AND SWITCH can be defined as a way in which a seller use advert of a low price to deceive and attract customers to their shop in which the products or item advert by seller is not available in order to sell similar or separate product to the customer at a higher price instead of selling the same product with a low price advertised by the seller.

Example a seller may advert a quality Italian shoe with a low price of $50 in order to deceive a buyer or customers to their place of business by then selling a similar product of shoe that looks like the one advertise by them to the customer at a higher price of $300.

5 0
3 years ago
What term refers to the United States’ sale of steel to Germany?
aleksklad [387]
The answer would be : B. business

Business refer to an activity in which an entity provides goods or services to the consumers. In this case , The united states is the entity , Steel is the Goods, and Germany is the consumer 
3 0
3 years ago
Read 2 more answers
Cost of Goods Manufactured for a Manufacturing Company
aniked [119]

Answer:

Cost of goods manufactured $ 2567,400

Explanation:

<u>Ethtridge Manufacturing Company </u>

<u>Statement of Cost of Goods Manufactured </u>

<u>For the Month Ended July 31 </u>

Direct materials $1,150,000

Direct labor 966,000

Total factory overhead 490,500

Total manufacturing costs $  2606500

Add July 1 Work in process inventory, 316,400

Cost of Goods Available for manufacture $ 2922,900

Less July 31 Work in process inventory,  355,500

Cost of goods manufactured $ 2567,400

When we add the direct materials. direct labor and FOH we get the total manufacturing costs .

When the total manufacturing costs are added to the opening work in process inventory we get the cost of goods available for manufacture and we get the cost of goods manufactured by subtracting the ending work in process inventory from the cost of goods available for manufacture.

6 0
3 years ago
Who is affected by our government’s fiscal policies?
Norma-Jean [14]

The answer is C- The entire economy

3 0
3 years ago
What do you think Madison needs to include in the fire prevention training plan?
andrezito [222]
"Fire size", "Atmosphere in the vicinity of the fire", "Fire fighter's evacuation path" are the correct answers.
5 0
2 years ago
Other questions:
  • When should you begin preparing for an interview?
    10·1 answer
  • At the end of the current year, Accounts Receivable has a balance of $430,000; Allowance for Doubtful Accounts has a credit bala
    6·1 answer
  • 1
    13·1 answer
  • If Jane Brown closes her account at the First National Bank and uses the money instead to open a money market mutual fund​ accou
    5·1 answer
  • Which of the following should be considered last when searching for financing? Question 7 options: Family members Banks Commerci
    7·2 answers
  • Leora had some money in her wallet. She spent $18.62 buying groceries and had $43.55 left. How much money did she have in her wa
    9·2 answers
  • Suppose you bought a bond with an annual coupon rate of 7.5 percent one year ago for $898. The bond sells for $928 today. a. Ass
    13·1 answer
  • . A gracious welcome by an employee at the hotel check-in counter is an example of: a. social sustainability. b. predictive anal
    13·1 answer
  • What form of capital will be obtained by Transnet​
    6·1 answer
  • What is the key role of a destination marketing organization (DMO)<br>PLEASE HELP!
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!