Question: Refer to the data for Derby Phones in Exercise 3-28. Data from Exercise 3-28 Sales price. . . . . . . . . .

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. . . . . . . . . . . . . 300,000 per month
Required
Using the Goal Seek function in Microsoft Excel,
a. What number must Derby Phones sell to break even?
b. What number must Derby Phones sell to make an operating profit of $6,000 per month?

Step by Step Solution

★★★★★

3.42 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a 2000 units The following two screenshots show the setup b 2040 units ... 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 (424).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

Refer to the data for Derby Phones in Exercise 3-28. Assume that the projected number of units sold for the month is 5,000. Consider requirements (b), (c), and (d ) independently of each other. Data...

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. . . . . . ....

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...

Refer to the data for Derby Phones in Exercise 3-28. Assume that the projected number of units sold for the month is 5.000. Consider requirements (b), (c), and (d) independently of each other. a....

Chapter 3 Fundamentals of Cost-Volume-Profit Analysis 3-29. Basic Decision Analysis Using CVP Refer to the data for Derby Phones in Exercise 3-28. Assume that the projected number of units sold for...

Basic Analysis Using CvP Refer to the data for Derby Phones in Exercise 328. Assume that the projected number of units sold for the month is 5,000. Consider requirements and of each other. Required...

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...

1) 2) Using Excel to perform CVP Analysis Refer to the data for Derby Phones above. Using Goal Seek function in Excel. a) What number must Derby Phones sell to break-even? b) What number must Derby...

Please see the template and answer the question using those templates please question 3-30: price and cost characteristics. Sales price $ 270 per unit Variable costs 120 per unit Fixed costs 300,000...

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)...

AMC has 10 million shares outstanding 400000 shares of 5 preferred stock and 200000 semi annual bonds with a 75 coupon selling at 95 of par with 14 years to maturity Common stock sells at 42share...

Company A sells 188 units at a price of $ 2.5 unit. The variable cost per unit is $ 1.75 and has a total fixed cost of $ 63. Find the breakeven point in units and in value for firm A. Suppose the...

17. What is a pension plan curtailment? Explain the accounting for pension plan curtailments.

Explain in your own words why there is likely to be a relationship between federal budget deficits and U.S. international trade deficits.

Marias Food Service provides meals that nonprofit organizations distribute to handicapped and elderly people. Here is her forecasted income statement for April, when she expects to produce and sell...

Carlsbad Enterprises has a capacity to produce 400,000 computer cases per year. The company is currently producing and selling 320,000 cases per year at a selling price of $40 per case. The cost of...

Assume that Cold Rock sells ice cream for $4.80 per gallon. The cost of each gallon follows: Materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $1.80...

James Fromholtz is considering whether to invest in a newly formed investment fund. The fund's investment objective is to acquire home mortgage securities at what it hopes will be bargain prices. The...

A cashless society describes an economic state whereby financial transactions are not conducted with money in the form of physical banknotes or coins, but rather through the transfer of digital...

25. Richmond Rail Company has 3 rail cars available to move freight this period. Each car can hold 70 tons of material and 5238 cu/ft of volume. There are 4 types of freight available to be used A,...