Question

Question 1 (15 Marks) The Tasmanian Division of McGregor Ltd makes and sells tables and beds. The following estimated revenue and cost information from the Division's activity-based costing system is available for 2018: 2,000 Tables 2,500 Beds Revenues $250,000 $500,000 Direct materials and direct labour costs 150,000 262,500 Depreciation on equipment used exclusively by each 21,000 29,000 product line Marketing and distribution costs: $20,000 (fixed) + ($375 per shipment x 40 shipments) 35,000 $30,000 (fixed) + ($375 per shipment x 100 shipments) 67,500 Fixed administration costs of the Division allocated to 55,000 110,000 product lines on the basis of revenues Corporate costs allocated to product lines on the basis of 25,000 50,000 revenues Total costs 286,000 519,000 Operating profit (loss) $(36,000) $(19,000) Additional information: a) On 1 January 2018, the equipment for each product line has a carrying amount of $50,000 and zero disposal value. Any equipment not used will remain idle. b) Fixed marketing and distribution costs are avoidable if the line is discontinued. C) Fixed administration costs of the Division and corporate costs are unavoidable. d) Each shipment includes 50 tables or 25 beds. Required: 1. On the basis of financial considerations alone, should Tasmanian discontinue the table's product line for the year, assuming the released facilities remain idle? What would be the financial effect of dropping this product line? Show your workings. (8 Marks) 2. Tasmanian received a one-time order from overseas for 1,000 beds at $120 per bed. Tasmanian has to pay transport costs for $12,500 but no additional marketing and distribution costs for this order. a. If Tasmanian has enough excess capacity for this order, should the Tasmanian Division accept this one-time order? What would be the financial effect of accepting the one-time order? Show your workings. (4 Marks) b. If Tasmanian is working at full capacity. What would be the minimum price to accept the one-time order and decrease sales by 1,000 beds to regular customers? Show your workings. (3 Marks)

Answer 1

1. Refer table below for analysis.

Table would require 2,462 units to break even. At current level of operations (Activity), positive EBITDA for tables is not sustainable. Currently table contributes -ve EBITDA of $15,000. Beds on the other hand are providing with +ve EBITDA of $10,000. If tables are shut down at current level of operations, overall negative EBITDA of $5,000 would become positive.

Particulars	2,000 tables	5,000 beds	Metrics per table	Metrics per bed
Sales / Revenue	$                  250,000	$                500,000	$                       125	$                    100
Variable cost
- Direct material and variable cost	$                  150,000	$                262,500	$                         75	$                      53
- Marketing and distribution cost
----  Fixed (Semi variable)	$                    20,000	$                  30,000	$                         10	$                        6
----  Variable	$                    15,000	$                  37,500	$                      7.50	$                   7.50
Contribution (Sales - Variable cost)	$                    65,000	$                170,000	$                         33	$                      34
Fixed cost (Unavoidable)	$                    55,000	$                110,000
Corporate cost	$                    25,000	$                  50,000
EBITDA (Total contribution / metrics per product)	$                  (15,000)	$                  10,000
Break even units	2,462	4,706

2. a. Refer table below for analysis. Additional shipment would provide additional $81,000 of contribution levels and a total EBITDA of $79,000 over the initial EBITDA of @10,000.

Particulars	Metrics per bed for 5000 beds	5,000 beds	Metrics per bed for additional 1200 beds	1,200 beds	Total
Sales / Revenue	$    100	$      500,000	$     120	$     144,000	$      644,000
Variable cost
- Direct material and variable cost	$      53	$      262,500	$       53	$       63,000	$      325,500
- Marketing and distribution cost
----  Fixed (Semi variable)	$        6	$        30,000	$        -	$               -	$        30,000
----  Variable	$   7.50	$        37,500	$        -	$               -	$        37,500
Contribtion	$      34	$      170,000	$       68	$       81,000	$      251,000
Fixed cost (Unavoidable)					$      110,000
Corporate cost					$        50,000
Transport cost					$        12,000
EBITDA (Total contribution / metrics per product)					$        79,000

b. Refer table below. The minimum price should be $ 90.833 per bed to maintain the same level of EBITDA of $10,000. Anything below this would result in a loss from the earlier setup of 5000 beds.  

Particulars	Metrics per bed for 5000 beds	4,000 beds	Metrics per bed for additional 1200 beds	1,200 beds	Total
Sales / Revenue	$          100	$ 400,000	$       91	$     109,000	$      509,000
Variable cost
- Direct material and variable cost	$            53	$ 210,000	$       53	$       63,000	$      273,000
- Marketing and distribution cost
----  Fixed (Semi variable)	$              6	$   24,000	$        -	$               -	$        24,000
----  Variable	$         7.50	$   30,000	$        -	$               -	$        30,000
Contribtion	$            34	$ 136,000	$       38	$       46,000	$      182,000
Fixed cost (Unavoidable)					$      110,000
Corporate cost					$        50,000
Transport cost					$        12,000
EBITDA (Total contribution / metrics per product)					$        10,000