Question

Segmented Income Statement Gorman Nurseries Inc. grows poinsettias and fruit trees in a green house/nursery operation. The following information was provided for the coming year.
Poinsettias Fruit Trees
Sales $970,000 $3,100,000
Variable cost of goods sold 460,000 1,630,000
Direct fixed overhead 160,000 200,000

A sales commission of 4% of sales is paid for each of the two product lines. Direct fixed selling and administrative expense was estimated to be $146,000 for the poinsettia line and $87,000 for the fruit tree line. Common fixed overhead for the nursery operation was estimated to be $800,000; common selling and administrative expense was estimated to be $450,000.

Required:
Prepare a segmented income statement for Gorman Nurseries for the coming year, using variable costing.

Answer 1

Answer:

Poinsettias records a loss of $118,125            

Fruit Trees records a profit of $92,325        

The company therefore records an overall $25,800 loss

NB: See the workings below see the assumption mad to allocate common expenses since none is given in the question.

Explanation:

Variable costing income statement is a type of income statement that records variable cost separately first to determine the contribution margin and thereafter record the fixed cost which is further split into direct fixed expenses and common expenses.

The segmented income statement for Gorman Nurseries for the coming year can therefore be presented as follows:

Gorman Nurseries Inc.

Segmented Income Statement

For the coming year

Particulars                        Poinsettias ($)     Fruit Trees ($)    Total ($)

Sales                                         970,000           3,100,000        4,070,000

Variable COGS                       (460,000)         (1,630,000)     (2,090,000)

Variable selling exp. (w1.)         (38,800)           (124,000)        (162,800)  

Contribution margin                 471,200            1,346,000      1,817,200

Direct fixed overhead             (160,000)          (200,000)       (360,000)

Direct fixed S $ Admn exp.     (146,000)           (87,000)        (233,000)

Segment margin                       165,200           1,059,000      1,224,200

Common fixed overh. (w2a)     (176,077)           (623,923)     (800,000)

Common S $ Admn ex (w2b)   (107,248)           (342,752)      (450,000)

Segment Net Income (loss)   (118,125)               92,325        (25,800)

Workings:

w1. Variable selling expenses = Sales * Commission percentage

Poinsettias = $970,000 * 4% = $38,8000

Fruit Trees = $3,100,000 * 4% = $124,000

w2. Allocation of common expenses using the following assuptions:

a) Use cost of goods sold (COGS) to allocate Common fixed overhead:

Poinsettias = (460,000 / 2,090,000) * $800,000 = $176,077

Fruit Trees = (1,630,000 / 2,090,000) * $800,000 = $623,923

b) Use common selling and administrative expense using Sales:

Poinsettias = (970,000 / 4,070,000) * $450,000 = $176,077

Fruit Trees = (3,100,000 / 4,070,000) * $450,000 = $623,923