Question: Refer to the data for Warner Clothing in Exercise 3-30. Data from Exercise 3-30 Sales price. . . . . . . . . .

Refer to the data for Warner Clothing in Exercise 3-30.
Data from Exercise 3-30
Sales price. . . . . . . . . . . . $ 15 per unit
Variable costs. . . . . . . . . . 3 per unit
Fixed costs. . . . . . . . . . . . 42,000 per month
Required
Using the Goal Seek function in Microsoft Excel,
a. What number must Warner Clothing sell to break even?
b. What number must Warner Clothing sell to make an operating profit of $9,000 per month?

Step by Step Solution

★★★★★

3.45 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a 3500 units The following two screenshots show the setup b 4250 uni... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1059-B-C-A-O (425).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

Refer to the data for Warner Clothing in Exercise 3-30. Assume that the company plans to sell 5,000 units per month. Consider requirements (b), (c), and (d ) independently of each other. Data from...

Refer to the data for Derby Phones in Exercise 3-28. Data from Exercise 3-28 Sales price. . . . . . . . . . . . $ 270 per unit Variable costs. . . . . . . . . . . 120 per unit Fixed costs. . . . . ....

Refer to the data for Cambridge, Inc., in Exercise 3-24. Required Using the Goal Seek function in Microsoft Excel, a. What number must Cambridge sell to break even? b. What number must Cambridge sell...

Basic Decision Analysis Using CVP Refer to the data for Warner Clothing in Exercise 3-30. Assume that the company plans to sell 5.000 units per month. Consider requirements (b), (c), and (d)...

3-31. Basic Decision Analysis Using CVP Refer to the data for Warner Clothing in Exercise 3-30. Assume that the company plans to sell 5,000 units per month. Consider requirements (b), (c), and (d)...

Can you a. (LO 3-1) 3-30. Basic Decision Analysis Using CVP Refer to the data for Derby Phones in Exercise 3-29. Assume that the projected number of units sold for the month is 5,000. Consider...

c) Thought question: How do you assess the overall risk in the rise in prices of ingredients to Alpine Cupcakes future? As in question 2, assume all sales of cupcakes remained the same, and the sales...

Hello, Need help with the following exercises: thks a million Problem 821 Straightforward Problem on Absorption versus Variable Costing (LO 2, 3, 4) 2(a). Net income: $200,000 3. Cost of goods sold...

821 Skinny Dippers, Inc. produces nonfat frozen yogurt. The product is sold in five-gallon containers, which have the following price and variable costs. Sales price...

1. What is the monthly break-even point in units sold and in sales pesos? 2. Without resorting to computations, what is the total contribution margin at your answer by preparing a contribution income...

Which of the following would be occurring if the macula densa cells are being activated? Select all that apply. the afferent arteriole would dilate sodium chloride levels would be high in the...

The front of a jet engine acts as a diffuser receiving air at 900 km/h, -5C, 50 kPa, bringing it to 80 m/s relative to the engine before entering the compressor. If the flow area is reduced to 80% of...

2.98 The file CD Rates contains the yields for one-year certificates of deposit (CDs) and for five-year CDs for 46 financial institutions selling CDs in Lake Worth, Florida, as of April 5, 2019....

Explain how each of the following will affect the net public debt, other things being equal. a. Previously, the government operated with a balanced budget, but recently there has been a sudden...

Mothers Bottlers, Inc., is a small bottling company that bottles and sells cold teas for $5 per unit. The cost of each unit follows: Materials . . . . . . . . . . . . . . . . . . . . . . . . . . . ....

Andreasen Corporation manufactures thermostats for office buildings. The following is the cost of each unit: Materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....

Mission Electronics manufactures and sells basic DVD players for sale under various generic store brand names. The cost of one of their models follows: Materials . . . . . . . . . . . . . . . . . . ....

It is assumed that the time customers spend in a record store is uniformly distributed between 3 and 12 minutes. Based on this information, what is the probability that a customer will be exactly...

What is IRP? How can it be violated? Can it be restored? Why or why not?

Because Windows Defender Antivirus and Firewall exist in the operating system itself, these tools have a level of integration that is difficult for third - party vendors to match. True or False