Calculate the companys total weekly gross profit

Assignment Help Corporate Finance
Reference no: EM13839234

Assignment: Decision-Making

In approximately 950 words respond to Part 1 and Part 2 accordingly:

Part 1

Seymore Industrial Products Inc. (SIPI) is a diversified industrial-cleaner processing company. The company's Brisbane plant produces two products: a table cleaner and a floor cleaner from a common set of chemical inputs (CDG). Each week 900,000 grams of chemical input are processed at a cost of $210,000 into 600,000 grams of floor cleaner and 300,000 grams of table cleaner. The floor cleaner has no market value until it is converted into a polish with the trade name StepShine. The additional processing costs for this conversion amount to $240,000.

StepShine sells at $20 per 30-gram bottle. The table cleaner can be sold for $18 per 25-gram bottle. However, the table cleaner can be converted into two other products by adding 300,000 grams of another compound (TCP) to the 300,000 grams of table cleaner. This joint process will yield 300,000 grams each of table stain remover (TSR) and table polish (TP). The additional processing costs for this process amount to $100,000. Both table products can be sold for $14 per 25-gram bottle.

The company decided not to process the table cleaner into TSR and TP based on the following analysis:

Process Further

Table Cleaner Table Stain

Remover

(TSR) Table Polish (TP) Total

Production in grams 300,000 300,000 300,000

Revenue $216,000 $168,000 $168,000 $336,000

Costs:

CDG costs 70,000* 52,500 52,500 105,000**

TCP costs 0 50,000 50,000 100,000

Total costs 70,000 102,500 102,500 205,000

Weekly gross profit $146,000 $65,500 $65,500 $131,000

*If table cleaner is not processed further, it is allocated 1/3 of the $210,000 of CDG cost, which is equal to 1/3 of the total physical output.

**If table cleaner is processed further, total physical output is 1,200,000 grams. TSR and TP combined account for 50% of the total physical output and are each allocated 25% of the CDG cost.

To complete Part 1:

• Determine if management made the correct decision to not process the table cleaner further by doing the following:

o Calculate the company's total weekly gross profit assuming the table cleaner is not processed further.

o Calculate the company's total weekly gross profit assuming the table cleaner is processed further.

o Compare the resulting net incomes and comment on management's decision.

• Using incremental analysis, determine if the table cleaner should be processed further. Justify your response.

Part 2

The management of Gill Corporation is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called SIDI, is a component of the company's finished product.

The following information was collected from the accounting records and production data for the year ending 31 December 2014:

• 5,000 units of SIDI were produced in the Machining Department.

• Variable manufacturing costs applicable to the production of each SIDI unit were:

o direct materials $4.75 o direct labour $4.60 o indirect labour $0.45 o utilities $0.35

• Fixed manufacturing costs applicable to the production of SIDI were:

Cost item Direct Allocated

Depreciation $1,100 $900

Property taxes 500 200

Insurance 900 600

Total $2,500 $1,700

• All variable manufacturing and direct fixed costs will be eliminated if SIDI is purchased. Allocated costs will have to be absorbed by other production departments.

• The lowest quotation for 5,000 SIDI units from a supplier is $56,000.

• If SIDI units are purchased, freight and inspection costs would be $0.30 per unit, and receiving costs totalling $500 per year would be incurred by the Machining Department.

To complete Part 2:

• Prepare an incremental analysis for SIDI. Your analysis should have columns for (1) Make SIDI, (2) Buy SIDI and (3) Net Income Increase/Decrease.

• Based on your analysis, what decision should management make? Justify your response.

• Would the decision be different if Gill Corporation has the opportunity to produce $6,000 of net income with the facilities currently being used to manufacture SIDI? (Show computations.) Justify your response.

• What nonfinancial factors should management consider in making its decision and why?

Note: This assignment must adhere to the following:

• Include a cover sheet that contains your course name, your first and last name and student number.

• Clearly indicate question number and part thereof for each of your answers.

• Begin a new part on a new page.

• Submit as a Word document only; we will use track changes to provide feedback and grade your submission. Do not submit a pdf.

• To keep the size of your file small, minimise the number of pictures (if any) to a minimum.

• Do not take a screen shot of your Excel file (if used) and insert as a picture; please create a table within your Word document by copying and pasting over your Excel table.

• References use APA style as per text guide. If you use hyperlinks for referencing information, please include the hyperlink and name of site in your reference list.

• In text referencing, reference list, appendices and calculations not included in word count.

Reference no: EM13839234

Questions Cloud

Paper on health insurance portability and accoutability act : Write a paper on given topic- The topic is Health Insurance Portability and Accoutability Act (HIPAA).
Rf behavior calculations : In this Lab, students use an online calculator to compute power, cable loss, antenna gain, free space path loss, link budget, and Fresnel zone clearance.
Describe the role of a systems analyst : First, in general terms describe the role of a systems analyst, then demonstrate your understanding, by providing examples of that role in the context of the workplace situation in your source.
What are the variance and expected return : What are the variance and expected return of an equally weighted portfolio of all five securities?
Calculate the companys total weekly gross profit : Calculate the company's total weekly gross profit assuming the table cleaner is not processed further. Calculate the company's total weekly gross profit assuming the table cleaner is processed further.
Programming assignment-the pathfinder : The following grid of ones and zeroes is a double scripted array representation of a terrain of size 12 x 12.
Why do those two examples represent luxury to you : What represents luxury to you and focus on two (2) examples of luxury when explaining what represents luxury to you, Why do those two examples represent luxury to you, and how does price impact that perception
Vocabulary development within the pre-production : Describing the benefits of strategies that encourage vocabulary development within the pre-production and early production stages of language acquisition. These strategies should transcend all content areas.
Calculate the divisional margin for the year : Calculate the divisional margin for the year. Calculate the DuPont ROI, and evaluate the performance of Global Resources in relation to the expected performance. Calculate the residual income.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Average price-earnings ratio

What is the industry average price-earnings ratio?

  Olga is the proprietor of a small business in 2012 the

olga is the proprietor of a small business. in 2012 the business income before consideration of any cost recovery or

  Find the initial cost and total value

The management of Mitchell labs announced to go private in 2002 by purchasing in all 3 million of its outstanding shares at 19.50/share. By 2006 management had restructured the firm by selling off petroleum research division for 13 million.

  Imagine you are considering acquiring a company you have

imagine you are considering acquiring a company. you have received their financial statements and have learned that

  Formulate a bip model in algebraic form

Formulate a BIP model in algebraic form for this problem and Formulate and solve this model on a spreadsheet.

  Companys required rate of return on investment projects

The company's required rate of return on investment projects is 20 and what is the Net Present Value (NPV) of this project? Should this project be accepted?

  Interaction of the balance sheet and income statement

Internal financial data is not available to public, so we have to rely on external data for our analysis. Review the financial statements for 2 years for your firm which is Walgreens and another firm which is CVS in the same industry.

  Standard normal curve

Which is larger, the area under the standard normal curve between -1 and 1 or between 0 and 2, and explain your reasoning?

  Find risk premium on the market

Risk Free rate 4 percent and the expected return on the market portfolio is 12%. Using the capital asset model:

  Find safest overall portfolio return

There are few, if any, real corporations with negative betas. But suppose you found one with B=-,25.

  Different growth rates distort a comparative ratio analysis

Different growth rates distort a comparative ratio analysis? Give some examples and how might these problems be alleviated?

  What is equivalent constant annual average return

What is the total return over the three years to an investor who buys the stock at 150p and holds the stock for three years, reinvesting intermediate dividends back into the stock? What is the equivalent constant annual average return over the thr..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd