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...
-
1. Discuss the problems, if any, of explaining the Box-Jenkins method to John's banker and others on his management team. 2. Given the autocorrelations in Figure 9-39 and the partial autocorrelations...
-
Ecologists classify the cause of forest fragmentation as either anthropogenic (i.e., due to human development activities such as road construction or logging) or natural in origin (e.g., due to...
-
The FUTA tax is levied only on the employees. True/False
-
The following information pertains to Worthy Video Company. 1. Cash balance per bank, July 31, $7,293. 2. July bank service charge not recorded by the depositor $28. 3. Cash balance per books, July...
-
Please prepare a bond amortization table. On February 1, 2021, Wolf Inc. issued 10% bonds dated February 1, 2021, with a face amount of $270,000. The bonds sold for $323,440 and mature in 20 years....
-
After the success of the companys first two months, Santana Rey continues to operate Business Solutions. (Transactions for the first two months are described in the Chapter 2 serial problem.) The...
-
Write report describing how you can develop and implement policies and procedures relevant to bookkeeping activities. The report should identify the strategies you can use in your role as a...
-
Execution Steps of Building the Inverted Index is shown as below: September 11, 2019 Execution Steps to Build Inverted Index Count by Term, Doc Year out to TermLook Up Table Sort on Term, Doc_Year...
-
An older-model car accelerates from 0 to speed v in a time interval of At. A newer, more powerful sports car accelerates from 0 to 5v in the same time period. Assuming the energy coming from the...
-
Your investment is as follows: Investment Value Return Stock (RM) (%) Top Glove 35,870 12.3% Medi Health 18,250 11.8% Pavillion 25,600 7.35% Assess the weighted return on the portfolio. % (2...
-
Consider the cointegrated model Yt Xt = 0Xt + vit, Xt-1+U2t, where it and v2t are mean zero serially uncorrelated random variables with E [vtv2j] = 0 for all t and j. Derive the vector error...
-
Hemming Company reported the following current-year purchases and sales for its only product Date January 1 January 16 March 14 March 15 July 30 October 5 Sales Purchase Sales Purchase Activities...
-
Abhinav Corp. offers a set of building blocks to customers who send in 3 codes from Abhinav cereal, along with $1.00. Abhinav purchased 99,100 building block sets in 2002 for $2.50 each, and ...
-
Describe the Operations (+,,*,/) that can cause negligible addition (NA), error magnification (EM), or subtractive cancellation (SC) in calculating ?((x^2)+1) - x . Give the range of where they might...
-
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....
-
In Equation (3.153), we saw a linear version of an epidemic model. The commonly used nonlinear SIR model is given by \[\begin{align*} \frac{d S}{d t} & =-\beta S I \\ \frac{d I}{d t} & =\beta S...
-
The Michaelis-Menten kinetics reaction is given by \[E+S \underset{k_{1}}{\stackrel{k_{3}}{\longrightarrow}} E S \underset{k_{2}}{\longrightarrow} E+P\] The resulting system of equations for the...
-
Each business day, on average, a company writes checks totaling \($25,000\) to pay its suppliers. The usual clearing time for the checks is four days. Meanwhile, the company is receiving payments...
Study smarter with the SolutionInn App