Question

In: Accounting

Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the...

Required information

The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5]

[The following information applies to the questions displayed below.]

Diego Company manufactures one product that is sold for $77 per unit in two geographic regions—the East and West regions. The following information pertains to the company’s first year of operations in which it produced 48,000 units and sold 43,000 units.

Variable costs per unit:
Manufacturing:
Direct materials $ 27
Direct labor $ 12
Variable manufacturing overhead $ 3
Variable selling and administrative $ 5
Fixed costs per year:
Fixed manufacturing overhead $ 864,000
Fixed selling and administrative expense $ 456,000

The company sold 33,000 units in the East region and 10,000 units in the West region. It determined that $220,000 of its fixed selling and administrative expense is traceable to the West region, $170,000 is traceable to the East region, and the remaining $66,000 is a common fixed expense. The company will continue to incur the total amount of its fixed manufacturing overhead costs as long as it continues to produce any amount of its only product.

Foundational 6-9

9. If the sales volumes in the East and West regions had been reversed, what would be the company’s overall break-even point in unit sales?

10. What would have been the company’s variable costing net operating income (loss) if it had produced and sold 43,000 units? You do not need to perform any calculations to answer this question.

11. What would have been the company’s absorption costing net operating income (loss) if it had produced and sold 43,000 units? You do not need to perform any calculations to answer this question.

13. Prepare a contribution format segmented income statement that includes a Total column and columns for the East and West regions.

14. Diego is considering eliminating the West region because an internally generated report suggests the region’s total gross margin in the first year of operations was $50,000 less than its traceable fixed selling and administrative expenses. Diego believes that if it drops the West region, the East region's sales will grow by 5% in Year 2. Using the contribution approach for analyzing segment profitability and assuming all else remains constant in Year 2, what would be the profit impact of dropping the West region in Year 2?

15. Assume the West region invests $38,000 in a new advertising campaign in Year 2 that increases its unit sales by 20%. If all else remains constant, what would be the profit impact of pursuing the advertising campaign?

Solutions

Expert Solution

9.

Break-Even Point in Sales (Unit) = Fixed Costs/ Contribution Margin per unit

Fixed Cost = 864,000+456,000 = 1320,000

Contribution Margin = Sales price - Variable cost

= 77 - (27+12+3+5) = 30

Break-even point = 1320,000/ 30 = 44,000

10.

Net Operating Loss = $30,000

11.

Net Operating Profit = $60,000

13.

Total Geographic Regions
East West
Sales $          3,311,000 $        2,541,000 $        770,000
Variable Cost $          2,021,000 $        1,551,000 $        470,000
Contribution Margin $          1,290,000 $            990,000 $        300,000
Fixed Selling and Admin OH $              390,000 $            170,000 $        220,000
Segment Margin $              900,000 $            820,000 $          80,000
Common Fixed Selling & Admin OH $                66,000
Common Fixed Manufacturing OH $              864,000
Net Operating Income/Loss $              (30,000)

14.

Total
Sales $          2,668,050
Variable Cost $          1,628,550
Contribution Margin $          1,039,500
Fixed Selling and Admin OH $              236,000
Fixed Manufacturing OH $              864,000
Net Operating Income/Loss $              (60,500)

15.

Total Geographic Regions
East West
Sales $          3,465,000 $        2,541,000 $        924,000
Variable Cost $          2,115,000 $        1,551,000 $        564,000
Contribution Margin $          1,350,000 $            990,000 $        360,000
Fixed Selling and Distribution OH $              390,000 $            170,000 $        220,000
Advertising campaign $                38,000 $          38,000
Segment Margin $              922,000 $            820,000 $        102,000
Common Fixed Selling & Distribution OH $                66,000
Common Fixed Manufacturing OH $              864,000
Net Operating Income/Loss $                (8,000)

$22,000 Increase in profit of the West region. Still, the overall Net loss will be there with a reduction of $22,000.


Related Solutions

Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the questions displayed below.] Diego Company manufactures one product that is sold for $70 per unit in two geographic regions—the East and West regions. The following information pertains to the company’s first year of operations in which it produced 53,000 units and sold 48,000 units. Variable costs per unit: Manufacturing: Direct materials $ 21 Direct labor $ 10 Variable manufacturing overhead $ 2 Variable selling...
Required information The Foundational 15 [LO12-2, LO12-3, LO12-4, LO12-5, LO12-6] [The following information applies to the...
Required information The Foundational 15 [LO12-2, LO12-3, LO12-4, LO12-5, LO12-6] [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $120 and $80, respectively. Each product uses only one type of raw material that costs $6 per pound. The company has the capacity to annually produce 100,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta...
Required information The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions...
Required information The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.] Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to...
Required information The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions...
Required information The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.] Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to...
The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] Diego Company manufactures one product that is sold...
The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] Diego Company manufactures one product that is sold for $80 per unit in two geographic regions—the East and West regions. Variable costs per unit: Manufacturing: Direct materials $ 24 Direct labor $ 14 Variable manufacturing overhead $ 2 Fixed costs per year: Fixed manufacturing overhead $ 800,000 Fixed selling and administrative expense $ 496,000 The company sold 25,000 units in the East region and 10,000 units in the West region. It determined...
The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.]...
The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.] Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month...
The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.]...
The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.] Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month...
The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.]...
The Foundational 15 [LO2-1, LO2-2, LO2-3, LO2-4] [The following information applies to the questions displayed below.] Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments—Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month...
2nd question part 4 he Foundational 15 [LO7-1, LO7-3, LO7-4] [The following information applies to the...
2nd question part 4 he Foundational 15 [LO7-1, LO7-3, LO7-4] [The following information applies to the questions displayed below.] Hickory Company manufactures two products—13,000 units of Product Y and 5,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all $684,000 of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for...
The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the...
The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT