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]
4 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]4 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
Simko Company issued $750,000, 8-year, 6 percent bonds on January 1, 2018. The bonds were issued for $710,000. Interest is payab
11Alexandr11 [23.1K]

Answer:

Bond issuance:

Dr cash                                          $710,000

Dr discount on bonds payable    $40,000

Cr bonds payable                                           $750,000

The payment of interest on December 31, 2018:

Dr interest expense     $50,000

Cr discount on bonds payable    $5000

Cr cash                                           $45,000

Explanation:

The bonds were issued at a discount to their face value, as a result, the discount on bonds payable is computed thus:

discount on bonds payable=$750,000-$710,000=$40,000

Bonds payable would be credited with $750,000 while cash and discount on bonds payable would be debited with $710,000 and $40,000 respectively

annual discount amortization=$40,000/8=$5000

annual coupon=$750,000*6%=$45000

6 0
3 years ago
Becton Labs, Inc., produces various chemical compounds for industrial use. One compound, called Fludex, is prepared using an ela
brilliants [131]

Answer:

Becton Labs, Inc.

1. Direct materials:

a. Price variance

= $20,600 Favorable

Quantity variance

= $1,890 Unfavorable

b. The company can sign the contract provided it is made clear to the new supplier that price variations would not be welcome shortly after signing the contract, but will depend on the market realities.

2. Direct labor:

a. Direct labor rate and efficiency variances:

Direct labor rate variance

= $3,200 Favorable

Efficiency variance

= $8,160 Unfavorable

b. I would not recommend that the new labor mix be continued.  The old mix may be working better because the labor efficiency cost increased with the new mix labor mix.

3. The variable overhead rate and efficiency variances:

Variable overhead rate variance

= $5,200 Favorable

Variable overhead efficiency variance

= $2,380 Unfavorable

Explanation:

a) Data and Calculations:

Standard  Costs for 1 Unit of Fludex:

                                              Standard              Standard      Standard Cost

                                        Quantity or Hours   Price or Rate  

Direct materials                     2.40 ounces    $27.00 per ounce   $64.80

Direct labor                           0.60 hours        $12.00 per hour          7.20

Variable manufacturing

overhead                             0.60 hours          $3.50 per hour          2.10

Total standard cost per unit                                                           $74.10

Activities recorded during November:

a. Materials purchased = 13,000 ounces at $330,300

Each ounce = $25.41 (330,300/13,000)

b. Materials used for production = 10,150 ounces (13,000 - 2,850)

Standard materials = 4,200 * 2.40 = 10,080 ounces

c. Direct labor hours = 20 * 160 = 3,200 hours

Standard labor hours = 0.60 * 4,200 = 2,520

Average labor rate = $11.00 per hour

Direct labor costs = $35,200 ($11.00 * 3,200)

d. Standard variable overhead = $11,200 (3,200 *$3.50)

Actual overhead incurred = $6,000

Actual overhead rate = $1.43 ($6,000/4,200)

e. Units produced = 4,200

1. Direct materials:

a. Price variance = (Actual price - standard price)* Actual units

= ($25.41 - $27.00)13,000 = $20,600 F

Quantity variance = (Actual quantity - Standard quantity) Standard Cost

= (10,150 - 10,080) * $27.00

= $1,890 U

b. The company can sign the contract provided it is made clear to the new supplier that price variations would not be welcome shortly after signing the contract, but will depend on the market realities.

2. Direct labor:

a. Direct labor rate and efficiency variances:

Direct labor rate variance = (Actual rate - Standard rate) * Actual hours

= ($11 - $12) * 3,200 = $3,200 Favorable

Efficiency variance = (Actual hours - Standard hours) * Standard rate

= (3,200 - 2,520) * $12

= $8,160 Unfavorable

b. I would not recommend that the new labor mix be continued.  The old may be working better because the labor efficiency cost increased.

3. The variable overhead rate and efficiency variances:

Variable overhead rate variance = Actual costs − (AH × SR)

= $6,000 - (3,200 * $3.50)

= $6,000 - $11,200

= $5,200 Favorable

Variable overhead efficiency variance =  (AH − SH) × SR

= (3,200 - 2,520) * $3.50

= $2,380 Unfavorable

3 0
3 years ago
Which of the following fiscal policy action would cause the economy to contract?
maksim [4K]
<span>This is a tricky question, because most of the answers provided are correct. For instance, by raising taxes, the government drops down the demand rates, as well as by decreasing the money supply (in that case, it also prevents economy from falling into an inflating situation). As for balancing the budget, this economical move entails decreasing the public expenditure and, therefore, contracting the demanding economical figures too. </span>
4 0
3 years ago
It is the end of the year but not the end of the pay period. How will this affect the balance sheet?
Nataliya [291]

Answer:

This has no effect on the period-end balance sheet.

Explanation:

A statement of the assets, liabilities, and capital of a business or other organization at a particular point in time, detailing the balance of income and expenditure over the preceding period.

According to the question asked the balanced sheet was prepared before the pay period came so this effect will not affect the balance sheet.

8 0
4 years ago
Read 2 more answers
Grayson owns a local smoothie store. His business started small, but over the years, word of mouth has spread, bringing more peo
irina1246 [14]

Growth requires developing a formal structure to function efficiently.

<u>Explanation</u>:

Growing a business from lower level to higher level requires lot of efforts and talents. If the business is developed and moving to the next level, it is necessary for the entrepreneur to follow certain formal structure.

The formal structure helps the owner of the company to maintain his standard in specific hierarchy. This formality may keep the employees or workers organized. The work will be allotted clearly to each and every one and each of them will have their own responsibilities.

3 0
3 years ago
Other questions:
  • New investors may want to consider _______ funds, which are mutual funds that invest in one particular kind of stock or a partic
    13·1 answer
  • Martinez Company sponsors a defined benefit pension plan for its employees. The following data relate to the operation of the pl
    9·1 answer
  • Members of the board of directors of have received the following operating income data for the year just​ ended:
    5·1 answer
  • 5. Use the information below to answer question 5:
    8·2 answers
  • Amir buys a Baskin Robbins franchise. He has made a financial commitment and agrees to conduct business in accordance with Baski
    15·1 answer
  • The mode of transportation that results in the lowest transportation cost will also lower total costs for a supply chain.
    15·1 answer
  • On July 1, 2019, Stacy Company signed a $140,000, one-year, 6 percent note payable. The principal and interest will be paid on J
    13·1 answer
  • A registered representative is assigned an account. The account information lists the customer's age, income, and investment obj
    5·1 answer
  • A company is a devout follower of Confucian ethics. Hence, it hires people who live by similar principles. What is most likely t
    13·1 answer
  • What enables a oligopoly to form within a market
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!