Question

In: Accounting

Dazzle Jewelry Company is a new startup merchandising company with the goal of offering fine jewelry...

Dazzle Jewelry Company is a new startup merchandising company with the goal of offering fine jewelry at reasonable prices. This goal has been made possible by securing manufactures that have agreed to offer wholesale prices to Dazzle Jewelry Company. Dazzle's jewelry supplier's act in good faith is based on the hopes that this will be a long term relationship, and Dazzle's orders will increase considerably with the next 18 months. However, in order for Dazzle Jewelry Company to achieve this it must increase its sales. Dazzle Jewelry company just completed its first month of operations, the brother/sister owned startup inventory includes fresh water pearls, sterling silver, stainless steel watches and quality stone pieces. Each of the inventory category includes earrings, necklaces, rings and bracelets, except the stainless steel watches. The average cost of earrings per unit is $10 with an average selling price of $55, 20 units have been sold. The average cost of the necklace is $15 with a selling price of $65, 25 units have been sold. The bracelets have an average cost of $12 and a selling price of $45, 15 units have been sold. The rings on an average sell for $35, but cost $11 per unit, 30 units have been sold. The stainless steel watches average cost per unit is $35 with a selling price average of $85, and 50 units have been sold. Dazzle Jewelry Company plans to start their business online before setting up a physical store location to keep their overhead cost low. However, since this is Dazzle Jewelry's first year of operations the owners have decided to employed your firm to help them determine how many jewelry units they need to sell in the current operating year to reach their targeted profit of $300,000. The owners realize that this information is vital in helping them develop their sales and marketing strategy. Dazzle Jewelry Company owners noted in a follow-up e-mail that fixed cost for the year totaled $76,320, however this cost is likely to increase in the coming months by 20% based on a marketing proposal that was submitted by Bosch Advertising. The owners also noted in the e-mail that fixed cost is the same amount each month.

Based on your analysis, how many units will Dazzle Jewelry need to break-even? What recommendation do you have for the owners related to break-even?

Solutions

Expert Solution

Break-even analysis :

Earrings Necklace Bracelet Ring Watch
Selling price per Unit $ 55 $ 65 $ 45 $ 35 $ 85
Variable Cost 20 15 12 11 35
Contribution Margin per Unit $ 35 $ 50 $ 33 $ 24 $ 50
Units Sold 20 25 15 30 50

At break-even point, Total Contribution Margin = Total Fixed Cost

Let the break even number be Q.

Weighted Average Contribution Margin per unit = 35 x 20/140 + 50 x 25/140 + 33 x 15 / 140 + 24 x 30 /140 + 50 x 50 / 140 = 5 + 8.9286 + 3.5357 + 5.1429 + 17.8571 = 40.4643

40.4643 Q = $ (76,320 + 20%) / 12

or Q = 7,632 / 40.4643

or 188.61 units or 189 units.

Earrings : 189 x 20/140 : 27 units

Necklace: 25 / 140 x 189 = 33.75 units

Bracelet : 15/ 140 x 189 = 20.25 units

Ring: 30 / 140 x 189 = 40.50 units

Watch : 50 / 140 x 189 = 67.50 units

Recommendations: All the five items are lagging behind the breakeven sales in units as computed above. Therefore, an aggressive marketing strategy should be adpted to increase unit sales of each item,

Number of jewellery units that are needed to be sold in current operating year to earn a profit of $ 300,000 = $ ( 76,320 + 300,000) / 40.4643 = 9,300 units.

Earrings : 20 / 140 x 9,300 = 1,328.57 units.

Necklace : 25 / 140 x 9,300 = 1,660.71 units

Bracelet : 15 / 140 x 9,300 = 996.43 units

Rings: 30 / 140 x 9,300 = 1,992.86 units

Watches : 50/140 x 9,300 = 3,321.43 units

Total contribution margin = $ 35 x 1,328.57 + $ 50 x 1,660.71 + $ 33 x 996.43 + $ 24 x 1,992.86 + $ 50 x 3,321.43 = $ 46,500 + $ 83,035 +$ 32,882.19 +$ 47,828.64 + $166,071.50 = $ 376,317.33

Profit = $ 376,318 - $ 76,320 = $ 300,000 approx.


Related Solutions

Felix's Fine Jewelry produces fine jewelry for department stores. The following costs incurred by the company...
Felix's Fine Jewelry produces fine jewelry for department stores. The following costs incurred by the company may be classified as direct materials, direct labor, manufacturing overhead, or period costs. Classify the costs and total by classification. Prepare an operating income statement which shows the deductions of expense in terms of total classification by category: direct materials, direct labor, manufacturing overhead, or period costs. Assume Felix's Fine Jewelry's revenue for the period was $8,000,000, and there is no change in ending...
The One Ring company, a leading producer of fine cast silver jewelry, is considering the purchase...
The One Ring company, a leading producer of fine cast silver jewelry, is considering the purchase of new casting equipment that will allow it to expand its product line. The up-front cost of the equipment is $750,000. The company expects that the new equipment will produce a steady income throughout its 10-year life. a) If One Ring requires a 12% return on its investment, what minimum yearly cash inflow will be necessary for the company to go forward with this...
Breakeven cash inflows The One Ring Company, a leading producer of fine cast silver jewelry, is...
Breakeven cash inflows The One Ring Company, a leading producer of fine cast silver jewelry, is considering the purchase of new casting equipment that will allow it to expand its product line. The up-front cost of the equipment is $750,000. The company expects that the equipment will produce steady income throughout its 10-year life. a. If One Ring requires a 9% return on its investment, what minimum yearly cash inflow will be necessary for the company to go forward with...
Boyle Company makes fine jewelry that it sells to department stores throughout the United States. Boyle...
Boyle Company makes fine jewelry that it sells to department stores throughout the United States. Boyle is trying to decide which of the two bracelets to manufacture. Cost data pertaining to the two choices follow: Bracelet A Bracelet B Cost of materials per unit $ 10 $ 20 Cost of labor per unit 15 15 Advertising cost per year 5,000 3,000 Annual depreciation on existing equipment 5,000 4,000 Required Identify the fixed costs and determine the amount of fixed cost...
Rundle Company makes fine jewelry that it sells to department stores throughout the United States. Rundle...
Rundle Company makes fine jewelry that it sells to department stores throughout the United States. Rundle is trying to decide which of the two bracelets to manufacture. Cost data pertaining to the two choices follow: Bracelet A Bracelet B Cost of materials per unit $ 25 $ 49 Cost of labor per unit 38 38 Advertising cost per year 8,100 6,400 Annual depreciation on existing equipment 6,300 4,700 Required Identify the fixed costs and determine the amount of fixed cost...
Develop THE FINANCIAL PLAN and PROPOSED COMPANY OFFERING part of the business plan. Include startup plus...
Develop THE FINANCIAL PLAN and PROPOSED COMPANY OFFERING part of the business plan. Include startup plus three years projections using the financial assumptions. This section should include the following elements:             THE FINANCIAL PLAN – (12) Actual Income Statements and Balance Sheets. Pro forma Income Statements. Pro Forma Balance Sheets. Pro Forma Cash Flow Analysis. Breakeven Chart and Calculation. Cost Control. Highlights. PROPOSED COMPANY OFFERING – (13) Desired Financing. Offering. Capitalization. Use of Funds. Investor’s Return.
What began as an addiction for fine jewelry and clothing, ended in a major expense reimbursement...
What began as an addiction for fine jewelry and clothing, ended in a major expense reimbursement fraud totaling $240,000. The perpetrator became a first-time offender shortly after acquiring a management position in a worldwide consulting firm in Chicago. Her position created an opportunity to abuse expense reimbursements. She rationalized her exorbitant purchases of consumer goods as the only remedy for her severe depression. Beginning in the summer of 2001, Jennifer Childe submitted false and inflated expense reports to her new...
Suppose Lifetime Insurance Company is offering a new policy to the parents of new born babies....
Suppose Lifetime Insurance Company is offering a new policy to the parents of new born babies. The parent will pay $1,000 per year starting on the babies first birthday and will continue until her fifth birthday. After that, no more payments will be made. When the child reaches age 65, he or she receives $500,000. If the relevant interest rate is 10 percent for the first five years and 8 percent for all subsequent years, is the policy worth buying?
An insurance company is offering a new policy to its customers.Typically the policy is bought...
An insurance company is offering a new policy to its customers. Typically the policy is bought by a parent or grandparent for a child at the child’s birth. For this policy, the purchaser, say, the parent, makes the following six payments to the insurance company: First birthday $ 800 Second birthday $ 800 Third birthday $ 900 Fourth birthday $ 850 Fifth birthday $ 1,000 Sixth birthday $ 950 After the child’s sixth birthday, no more payments are made. When...
An insurance company is offering a new policy to its customers.Typically the policy is bought...
An insurance company is offering a new policy to its customers. Typically the policy is bought by a parent or a grandparent for a child at the child's birth. The details of the policy are as follows: The purchaser(say, the parent) makes the following six payments to the insurance company: First birthday: $400 Second birthday: $500 Third birthday: $600 Fourth birthday: $700 Fifth birthday: $800 Sixth birthday: $900 After the child's sixth birthday, no more payments are made. When the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT