Question

In: Accounting

Problem #1 Walters, LLC produces knock-off watches. Each watch sells for $40.00. Walters produced and sold...

Problem #1

Walters, LLC produces knock-off watches. Each watch sells for $40.00. Walters produced and sold 100 watches last year. Use the following cost data to compute the variable cost per unit and the fixed cost for the period.

Volume

Cost

10

$800.00

20

$1,100.00

15

$900.00

18

$1,050.00

25

$1,250.00

a. Using the high-low method, determine the amount of variable cost per unit.

Answer: ________________________

b. Using the high-low method, determine the total amount of fixed costs.

Answer: ________________________

c. What is the variable cost ratio?

Answer: ________________________

d. What is the contribution margin per unit?

Answer: ________________________

e. What is the contribution margin ratio?

Answer: ________________________

f. How many watches must Walters sell to break even?

Answer: ________________________

g. What is the break-even sales revenue?

Answer: ________________________

h. What was Walters’ operating income last year?

Answer: ________________________

i. What was Walters’ margin of safety?

Answer: ________________________

j. Assume the company has a desired net income of $1,500.

(1) How many sales dollars must the company earn?

Answer: ________________________

(2) How many watches must the company sell?

Answer: ________________________

Solutions

Expert Solution

  • All working forms part of the answer
  • Answer are provided with workings, in a sequence as asked.
  • Answer a) Variable cost per unit

Volume

Cost

Highest Level

25

$1250

Lowest Level

10

$800

Difference

15 (B)

$450 (A)

Variable cost per unit [A/B]

[450/15] $30

Answer b) Total fixed cost = $500

Working

High Level

Low Level

A

Total cost

$1250

$800

B

Volume

25

10

C

Variable cost per unit

$30

$30

D=BxC

Total Variable cost

$750

$300

E=A-D

Total fixed cost

$500

$500

Answer (c) to (j) in sequence

(C)

Variable cost per unit

30

Sale Price per unit

40

Variable cost ratio

75%

(d)

Sale Price per unit

40

Variable cost per unit

30

Contribution margin per unit

$10

(e)

Contribution margin per unit

10

Sale Price per unit

40

Contribution margin ratio

25%

(f)

Fixed Cost

500

Contribution margin per unit

10

Watches to be sold for break Even

50 watches

(g)

Break Even in no of watches

50

Sale Price per unit

40

Break Even Sales revenue

$2000

(h)

Contribution per unit

10

Units Sold last year

100

Total contribution margin

1000

(-)Fixed Cost

500

Operating Income

$500

(i)

Total Revenues

4000

Break Even Revenues

2000

Margin of Safety

$2000

(j)

Desired Net Income

1500

Fixed Cost

500

Total contribution margin required

2000

Contribution per unit

10

(j2) No. of Units to sell

200

(j1) Sales Dollars to earn $1500 profit

[200 x 40] $8000


Related Solutions

william's watches ltd produces and sells two types of wrist watch: the standard and the deluxe....
william's watches ltd produces and sells two types of wrist watch: the standard and the deluxe. in the coming year williams watches ltd expects to sell 4000 units of the standard and 2000 units of the deluxe. Information on the two products is as follows: standard Deluxe sales price 500 400 variable cost 275 220 Total fixed costs are expected to be 180,000. required: 1, calculate the breakeven point in sales value 2. calculate the margin of safety in sales...
Halla Corporation produces and sells bottled water. The bottled water produced by the company is sold...
Halla Corporation produces and sells bottled water. The bottled water produced by the company is sold for 500 won per bottle, and the variable cost of producing and selling a bottle of bottled water is 300 won. Meanwhile, the fixed cost incurred in facility investment for the production and sale of the bottled water is 10 million won. Halla Corp. uses 40 million won in debt with an interest rate of 10 percent. Answer the following question. 1. Halla Corporation's...
1. Kathy produces handbags and in a month she produced and sold 50 of them. On...
1. Kathy produces handbags and in a month she produced and sold 50 of them. On an average her cost of producing each handbag is $50. The market price of the handbag is $65. This will lead Kathy to earn a total revenue of a. $2,000. b. $6,500. c. $5,750. d. $3,250. 2. A firm Average Variable Cost of producing a box of pencil is $1 and it's Average Total Cost is $3 if 500 pencil boxes are produced. Based...
MicroDecor produces stylish microwave ovens. Each unit sells for $620. During 20X7, the company produced 23,000...
MicroDecor produces stylish microwave ovens. Each unit sells for $620. During 20X7, the company produced 23,000 units, and sold 21,000 units. Beginning inventory contained a total of 3,200 units. Production and SG&A costs have been stable for many years. Assume the per unit costs in beginning and ending inventory are identical. Per unit cost information follows: Direct materials cost $160 Direct labor cost 110 Variable factory overhead 85 Variable SG&A 60 Annual fixed manufacturing overhead is $245,000. Annual fixed SG&A...
EXERCISE 1. A shop sells home computers. The numbers of computers sold in each of five...
EXERCISE 1. A shop sells home computers. The numbers of computers sold in each of five successive years were as follows: Year (x) 1 2 3 4 5 Sales (y) 10 30 70 140 170 Draw a scatter diagram for the data Find the least squares regression line of y on x and fit it on you scatter plot The shop manager uses this regression line to predict the sales in the following (i.e. the 6th) year. Find the predicted...
1. A company produces and sells two different products. The demand for each product is unlimited,...
1. A company produces and sells two different products. The demand for each product is unlimited, but the company is constrained by cash availability and machine capacity. Each unit of the first and second product requires 3 and 4 machine hours, respectively. There are 20,000 machine hours available in the current production period. The production costs are $3 and $2 per unit of the first and second product, respectively. The selling prices of the first and second product are $6...
Problem 1: West Coast Board Manufacturing Inc. produces and sells surf boards in Southern California. The...
Problem 1: West Coast Board Manufacturing Inc. produces and sells surf boards in Southern California. The company expected the following revenues and costs in 2018 for its Premium surf boards: Revenue (750 boards @ $300 per board) $225,000 Variable costs 105,000 Fixed costs 60,000 a) How many sets of clubs must be sold for Tee Times, Inc. to reach their breakeven point? (show your calculation) b) How many boards must be sold to earn a target operating income of $100,000?...
Waterways Continuing Problem 07 (Part 1) Waterways mass-produces a special connector unit that it normally sells...
Waterways Continuing Problem 07 (Part 1) Waterways mass-produces a special connector unit that it normally sells for $3.90. It sells approximately 32,700 of these units each year. The variable costs for each unit are $2.50. A company in Canada that has been unable to produce enough of a similar connector to meet customer demand would like to buy 14,500 of these units at $2.80 per unit. The production of these units is near full capacity at Waterways, so to accept...
Waterways Continuing Problem 07 (Part 1) Waterways mass-produces a special connector unit that it normally sells...
Waterways Continuing Problem 07 (Part 1) Waterways mass-produces a special connector unit that it normally sells for $4.00. It sells approximately 38,100 of these units each year. The variable costs for each unit are $2.20. A company in Canada that has been unable to produce enough of a similar connector to meet customer demand would like to buy 14,700 of these units at $2.50 per unit. The production of these units is near full capacity at Waterways, so to accept...
QUESTION #1 (2 PARTS): X Company produces and sells 69,400 units of its regular product each...
QUESTION #1 (2 PARTS): X Company produces and sells 69,400 units of its regular product each year for $14.00 each. The following cost information relates to this production: Total   Per-Unit   Direct materials $138,106 $1.99       Direct labor [all variable] 113,816 1.64       Variable overhead 188,768 2.72       Fixed overhead 156,844 2.26       Variable selling 72,176 1.04       Fixed selling 90,914 1.31     A company has offered to buy 4,340 units for $11.93 each. Because the special order product is slightly different than the regular product, direct...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT