Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Vega Foods, Inc., has recently purchased a small mill that it intends to operate as one of its subsidiaries. The newly acquired mill has three

Vega Foods, Inc., has recently purchased a small mill that it intends to operate as one of its subsidiaries. The newly acquired mill has three products that it offers for salewheat cereal, pancake mix, and flour. Each product sells for $10 per package. Materials, labor, and other variable production costs are $3.60 per bag of wheat cereal, $4.80 per bag of pancake mix, and $2.40 per bag of flour. Sales commissions are 10% of sales for any product. All other costs are fixed.

The mills income statement for the most recent month is given below:

Product Line

Total Company Wheat Cereal Pancake Mix Flour
Sales $ 780,000 $ 260,000 $ 360,000 $ 160,000
Expenses:
Materials, labor, and other 304,800 93,600 172,800 38,400
Sales commissions 78,000 26,000 36,000 16,000
Advertising 147,320 61,500 62,000 23,820
Salaries 81,100 38,500 19,600 23,000
Equipment depreciation 39,000 13,000 18,000 8,000
Warehouse rent 15,600 5,200 7,200 3,200
General administration 90,000 30,000 30,000 30,000
Total expenses 755,820 267,800 345,600 142,420
Net operating income (loss) $ 24,180 $ (7,800) $ 14,400 $ 17,580

The following additional information is available about the company:
a.

The same equipment is used to mill and package all three products. In the above income statement, equipment depreciation has been allocated on the basis of sales dollars. An analysis of equipment usage indicates that it is used 30% of the time to make wheat cereal, 60% of the time to make pancake mix, and 10% of the time to make flour.

b.

All three products are stored in the same warehouse. In the above income statement, the warehouse rent has been allocated on the basis of sales dollars. The warehouse contains 31,200 square feet of space, of which 8,000 square feet are used for wheat cereal, 14,000 square feet are used for pancake mix, and 9,200 square feet are used for flour. The warehouse space costs the company $.50 per square foot per month to rent.

c.

The general administration costs relate to the administration of the company as a whole. In the above income statement, these costs have been divided equally among the three product lines.

d.

All other costs are traceable to the product lines.

Vega Foods management is anxious to improve the mills 3.10% margin on sales.

Required:
1.

Prepare a new contribution format segmented income statement for the month. Adjust the allocation of equipment depreciation and warehouse rent as indicated by the additional information provided. (Input all amounts as positive values except losses which should be indicated by a minus sign. Round your final answers to the nearest dollar amount. Omit the "$" sign in your response.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions