Differential Analysis

profilehalramadhan

There are two problems for this Module’s CT Assignment.

  1.  Boxx Corporation is considering the acquisition of new equipment.  The equipment can be purchased from an overseas supplier for $6,500.  The freight and installation costs for the equipment are $615.  If purchased, annual repairs and maintenance are estimated to be $445 per year over the five-year useful life of the equipment.  Alternatively, Boxx can lease the equipment from a domestic supplier for $1,850 per year for five years, with no additional costs.  

Required:

    1. Prepare a differential analysis to determine whether Boxx should lease (Alternative 1) or purchase (Alternative 2) the equipment. 
    2. Indicate specifically the company should lease or buy the equipment after completing the analysis. Explain. Hint:  This is a “lease or buy” decision, which must be analyzed from the perspective of the equipment user as opposed to the equipment owner.
  1. A condensed income statement by product line for Astronomy Baking Inc. indicated the following for Moon Cookies for the past year:

Sales

$450,000

Cost of goods sold

205,000

Gross profit

245,000

Operating expenses

287,000

Loss from operations

($42,000)

  1. It is estimated that 15% of the cost of goods sold represents fixed factory overhead costs, and that 30% of the operating expenses are fixed.  Because Moon Cookies is only one of the many products, the fixed costs will not be materially affected if the product is discontinued.
  2. Required:
    1. Prepare a differential analysis to determine whether Moon Cookies should be continued (Alternative 1) or discontinued (Alternative 2).
    2. Should Moon Cookies be retained?  Explain.

Use an Excel spreadsheet for each of the two problems.

 

No plagiarism is allowed. It must be your own work.

You need to do deep and clear analysis. 

Show your work by writing the formulas.

Each problem needs to be in separate sheet.

Follow the instructions carefully.

    • 7 years ago
    • 15
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      differential_analysis.xlsx