Melissa Bright Jewelry, Inc. is a jewelry manufacturer. It has a factory located in Hartford, CT....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Melissa Bright Jewelry, Inc. is a jewelry manufacturer. It has a factory located in Hartford, CT. It imports raw materials and hires skilled labor to assemble the finished products. The manufacturing process involves metal welding which uses lots of electricity. The average sales price per unit of finished product is $50. The Excel file below has the information of the costs of direct materials, direct labor, and other manufacturing expenses: • Melissa Bright Jewelry's raw materials are purchased in oz. The per oz. purchase price is $1.75. • Melissa Bright Jewelry, Inc. pays $15 per hour to its labor on the production line. In addition, it is required to pay the employment taxes at 7.65% of the wages and other benefits at 5% of wages. It takes 15 minutes (including break time) on average for one manufacturing labor to finish one piece of product. • Other expenses include rent, insurance, and managerial salaries. The amount of these expenses are stable every month. • The costs of supplies vary by production unit. The average cost per unit is $0.5. • Utility expenses and the production units in the past 12 months are summarized in the table in the Excel file. The manager understands that the more units produced, the higher the electricity bill. But she does not know what the per-unit electricity cost is. Requirements: 1. Calculate the number of break-even units per month. Use the regression to measure the variable and the fixed electricity cost. (30%) 2. If Melissa Bright Jewelry would like to have a monthly profit of $60,000, how many units should Melissa Bright Jewelry sell each month? (30%) 3. If Melissa Bright Jewelry can only sell 2,500 units per month and still wants to have $60,000 profit per month, how much Melissa Bright Jewelry should sell for each unit? (Assume that the unit of sales will NOT be affected by the price increase). (20%) 4. Your deliverable should be an Excel file with proper formatting, clear layout, and clear supports of your computations. (20%) 1 Melissa Bright Jewelry, Inc. 2 Raw material costs: 3 Quantity (oz.): 4 Per oz. $ 1.75 5 6 Raw material per unit: 1.00 7 8 Direct labor costs: 9 Time to manufacture one unit: 10 Direct labor hourly rate: 11 Employment tax 12 Benefits 13 14 Other monthly costs: 15 Factory rent 16 Insurance 17 Water 18 Plant manager salary (incl. taxes and benefit) 19 Administrative salary (incl. taxes and benefit) 20 Supplies 21 Janitor and custodian fees 22 Utility: 23 24 January 25 February 26 March 27 April 28 Мay 29 June 30 July 31 August 32 September 33 October 15 minutes 15.00 per hour 7.65% of wages 5% of wages 10,000 fixed per month 1,000 fixed per month 200 fixed per month 4,500 fixed per month 3,000 fixed per month 0.50 per unit $ 2$ $ 2$ 1,500 fixed per month Historial utility costs production quantity 3,550 $ Charges 58,942.78 3,360 55,361.75 2,450 40,951.62 2,640 42,078.27 2,530 40,225.81 2,740 42,846.10 2,780 46,149.11 2,450 41,818.84 2,630 43,051.85 2,400 39,175.99 34 November 35 December 2,250 37,255.24 2,100 35,857.11 36 6 7 Requirement 1: 8 Per unit 9 Sales price $ 50 O Direct material costs 1 Direct labor costs 2 Variable MOH 3 Total variable cost 4 Contribution Margin 5 6 Fixed MOH 8 9 1 2 3 4 Breakeven units 5 6 7 Requirement 2: 8 Required profit 60,000 1 2 Target production units 3 Requirement 3: Fixed unit of sales 2,500 Target unit sales price Melissa Bright Jewelry, Inc. is a jewelry manufacturer. It has a factory located in Hartford, CT. It imports raw materials and hires skilled labor to assemble the finished products. The manufacturing process involves metal welding which uses lots of electricity. The average sales price per unit of finished product is $50. The Excel file below has the information of the costs of direct materials, direct labor, and other manufacturing expenses: • Melissa Bright Jewelry's raw materials are purchased in oz. The per oz. purchase price is $1.75. • Melissa Bright Jewelry, Inc. pays $15 per hour to its labor on the production line. In addition, it is required to pay the employment taxes at 7.65% of the wages and other benefits at 5% of wages. It takes 15 minutes (including break time) on average for one manufacturing labor to finish one piece of product. • Other expenses include rent, insurance, and managerial salaries. The amount of these expenses are stable every month. • The costs of supplies vary by production unit. The average cost per unit is $0.5. • Utility expenses and the production units in the past 12 months are summarized in the table in the Excel file. The manager understands that the more units produced, the higher the electricity bill. But she does not know what the per-unit electricity cost is. Requirements: 1. Calculate the number of break-even units per month. Use the regression to measure the variable and the fixed electricity cost. (30%) 2. If Melissa Bright Jewelry would like to have a monthly profit of $60,000, how many units should Melissa Bright Jewelry sell each month? (30%) 3. If Melissa Bright Jewelry can only sell 2,500 units per month and still wants to have $60,000 profit per month, how much Melissa Bright Jewelry should sell for each unit? (Assume that the unit of sales will NOT be affected by the price increase). (20%) 4. Your deliverable should be an Excel file with proper formatting, clear layout, and clear supports of your computations. (20%) 1 Melissa Bright Jewelry, Inc. 2 Raw material costs: 3 Quantity (oz.): 4 Per oz. $ 1.75 5 6 Raw material per unit: 1.00 7 8 Direct labor costs: 9 Time to manufacture one unit: 10 Direct labor hourly rate: 11 Employment tax 12 Benefits 13 14 Other monthly costs: 15 Factory rent 16 Insurance 17 Water 18 Plant manager salary (incl. taxes and benefit) 19 Administrative salary (incl. taxes and benefit) 20 Supplies 21 Janitor and custodian fees 22 Utility: 23 24 January 25 February 26 March 27 April 28 Мay 29 June 30 July 31 August 32 September 33 October 15 minutes 15.00 per hour 7.65% of wages 5% of wages 10,000 fixed per month 1,000 fixed per month 200 fixed per month 4,500 fixed per month 3,000 fixed per month 0.50 per unit $ 2$ $ 2$ 1,500 fixed per month Historial utility costs production quantity 3,550 $ Charges 58,942.78 3,360 55,361.75 2,450 40,951.62 2,640 42,078.27 2,530 40,225.81 2,740 42,846.10 2,780 46,149.11 2,450 41,818.84 2,630 43,051.85 2,400 39,175.99 34 November 35 December 2,250 37,255.24 2,100 35,857.11 36 6 7 Requirement 1: 8 Per unit 9 Sales price $ 50 O Direct material costs 1 Direct labor costs 2 Variable MOH 3 Total variable cost 4 Contribution Margin 5 6 Fixed MOH 8 9 1 2 3 4 Breakeven units 5 6 7 Requirement 2: 8 Required profit 60,000 1 2 Target production units 3 Requirement 3: Fixed unit of sales 2,500 Target unit sales price
Expert Answer:
Related Book For
An Introduction to Statistical Methods and Data Analysis
ISBN: 978-1305269477
7th edition
Authors: R. Lyman Ott, Micheal T. Longnecker
Posted Date:
Students also viewed these general management questions
-
4 10 points eBook Print References Answer the following question based on the graph below, which is for Bli the industry. Price, costs 72 60 48 36 24 12 0 20 No D Yes e. Is the current situation...
-
Newtron Inc. is going to finance half of the new investment project with retained earnings and the other half, with a new stock issue. In the current year dividends distributed per face value is 30...
-
The factor that will decide differences in the Required rate of return for stocks that is calculated by CAPM is O a. Risk free rate Ob. Beta O c. Market risk premium O d. Market return
-
Two companies, Energen and Hastings Corporation, began operations with identical balance sheets. A year later, both required additional manufacturing capacity at a cost of $50,000. Energen obtained a...
-
An experiment was conducted to determine which of three advertisements to use in introducing a new personal computer. A total of 120 people who were thinking of buying a personal computer was split...
-
Stanislav IT Solutions uses the perpetual inventory system for the purchase and sale of jump drive inventory and had the following information available on August 31, 2023: Required 1. Calculate the...
-
Data set: Number of accidents per day in a city Use the data set and the indicated number of classes to construct (a) an expanded frequency distribution, (b) a frequency histogram, (c) a frequency...
-
The Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large...
-
The Executive Director (ED) of a North Philadelphia non-profit organization has been in place for the last 16 years. Many changes have occurred during this time. For example: more people come to work...
-
Suppose that a learning algorithm is trying to find a consistent hypothesis when the classifications of examples are actually random. There are u Boolean attributes, and examples are drawn uniformly...
-
Given m1=32363, a1=157, m2=31727, a2=146, m3=31657 and a3=142 Generate three random numbers with the combined LCG using initial seeds Xi,0=100,300,500 for the individual generators i=1,2,3...
-
What are the pros and cons for investors to stage their financial commitments?
-
What are the investment motives of family and friends? How can they help?
-
What determines the seniority of the preferred terms across different financing rounds?
-
When do inside investors prefer higher over lower valuations?
-
Why do founders often invest in their own venture?
-
Point of Parity What are the key points of parity ( PoP ) of the B honey brand? Identify the type of PoP for each identified PoP. Point of Difference What are the key points of difference ( PoD ) ?...
-
(a) How far away can a human eye distinguish two ear headlights 2.0 m apart? Consider only diffraction effects and assume an eye pupil diameter of 5.0 mm and a wavelength of 550 nm. (b) What is the...
-
Refer to Exercise 5.30. In fact, the researcher was more concerned about determining if the lead in the paint reduced the mean number of Type 2 fibers in skeletal muscles. Does the change in the...
-
For the homeownership rates given in Exercise 3.10, construct separate boxplots for the years 1985, 1996, and 2002. In exercise a. Describe the distributions of homeownership rates for each of the 3...
-
Refer to Exercise 13.34. As happens in many studies, not all the data are correctly collected. The researcher decides that errors are present in the information collected at several of the homes....
-
Pegasus Veterinary Hospital (PVH) is a partnership of five veterinarian surgeons who specialize in treating horses. PVH is located in a $25 million facility on 20 acres of land, employing over 40...
-
A tender evaluation method specifies 60% price and 40% quality. What is the weighted score of a tender that scored 80 points (out of 100) for price and 60 for quality?
-
You are a recently appointed purchasing manager who is overseeing terms and con- ditions of contract for an important international purchase with a UN country. What rules should you be particularly...
Study smarter with the SolutionInn App