Question

The management of Shatner Manufacturing Company is trying to decide whether to continue manufacturing a part or to buy it from an outside supplier. The part, called CISCO, 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 December 31, 2020.

1. 8,100 units of CISCO were produced in the Machining Department.
2. Variable manufacturing costs applicable to the production of each CISCO unit were:
    direct materials $5.10, direct labor $4.89, indirect labor $0.42, utilities $0.35.
3. Fixed manufacturing costs applicable to the production of CISCO were:

Cost Item		Direct		Allocated
Depreciation		$1,900		$930
Property taxes		470		400
Insurance		900		640
		$3,270		$1,970

All variable manufacturing and direct fixed costs will be eliminated if CISCO is purchased. Allocated costs will not be eliminated if CISCO is purchased. So if CISCO is purchased, the fixed manufacturing costs allocated to CISCO will have to be absorbed by other production departments.

4. The lowest quotation for 8,100 CISCO units from a supplier is $87,328.
5. If CISCO units are purchased, freight and inspection costs would be $0.38 per unit, and receiving costs totaling $1,290 per year would be incurred by the Machining Department.

(a) Prepare an incremental analysis for CISCO. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

		Make CISCO		Buy CISCO		Net Income Increase (Decrease)
Direct material		$enter direct material in dollars		$enter direct material in dollars		$enter direct material in dollars
Direct labor		enter direct labor in dollars		enter direct labor in dollars		enter direct labor in dollars
Indirect labor		enter indirect labor in dollars		enter indirect labor in dollars		enter indirect labor in dollars
Utilities		enter utilities in dollars		enter utilities in dollars		enter utilities in dollars
Depreciation		enter depreciation in dollars		enter depreciation in dollars		enter depreciation in dollars
Property taxes		enter property taxes in dollars		enter property taxes in dollars		enter property taxes in dollars
Insurance		enter insurance in dollars		enter insurance in dollars		enter insurance in dollars
Purchase price		enter the purchase price in dollars		enter the purchase price in dollars		enter the purchase price in dollars
Freight and inspection		enter freight and inspection in dollars		enter freight and inspection in dollars		enter freight and inspection in dollars
Receiving costs		enter receiving costs in dollars		enter receiving costs in dollars		enter receiving costs in dollars
Total annual cost		$enter total annual cost in dollars		$enter total annual cost in dollars		$enter total annual cost in dollars

Answer 1

Solution:

Incremental Analysis - Shatner Manufacturing Company
Particulars	Make CISCO	Buy CISCO	Net Income Increase (Decrease)
Direct material	$41,310.00		$41,310.00
Direct labor	$39,609.00		$39,609.00
Indirect labor	$3,402.00		$3,402.00
Utilities	$2,835.00		$2,835.00
Depreciation	$2,830.00	$930.00	$1,900.00
Property taxes	$870.00	$400.00	$470.00
Insurance	$1,540.00	$640.00	$900.00
Purchase price		$87,328.00	-$87,328.00
Frieght and inspection		$3,078.00	-$3,078.00
Receiving costs		$1,290.00	-$1,290.00
Total annual costs	$92,396.00	$93,666.00	-$1,270.00

Company should make the CISCO.