Prepare a new contribution format segmented income statement

Assignment Help Managerial Accounting
Reference no: EM13166726

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 sale-wheat cereal, pancake mix, and flour. Each product sells for $10 per package. Materials, labor, and other variable production costs are $4.30 per bag of wheat cereal, $5.50 per bag of pancake mix, and $3.10 per bag of flour. Sales commissions are 10% of sales for any product. All other costs are fixed.

The mill's income statement for the most recent month is given below:

 

 

 

 

Product Line

 

Total
Company

Wheat
Cereal

Pancake
Mix

Flour

 

  Sales

$

990,000

 

$

330,000

 

$

430,000

 

$

230,000

 

 

 













 

  Expenses:

 

 

 

 

 

 

 

 

 

 

 

 

 

       Materials, labor, and other

 

449,700

 

 

141,900

 

 

236,500

 

 

71,300

 

 

       Sales commissions

 

99,000

 

 

33,000

 

 

43,000

 

 

23,000

 

 

       Advertising

 

139,380

 

 

60,900

 

 

52,200

 

 

26,280

 

 

       Salaries

 

105,000

 

 

51,000

 

 

21,000

 

 

33,000

 

 

       Equipment depreciation

 

49,500

 

 

16,500

 

 

21,500

 

 

11,500

 

 

       Warehouse rent

 

19,800

 

 

6,600

 

 

8,600

 

 

4,600

 

 

       General administration

 

90,000

 

 

30,000

 

 

30,000

 

 

30,000

 

 

 













 

  Total expenses

 

952,380

 

 

339,900

 

 

412,800

 

 

199,680

 

 

 













 

  Net operating income (loss)

$

37,620

 

$

(9,900)

 

$

17,200

 

$

30,320

 

 

 

























 


 

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 40% of the time to make wheat cereal, 50% 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 39,600 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 17,600 square feet are used for flour. The warehouse space costs the company $0.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 mill's 3.80% 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.

Reference no: EM13166726

Questions Cloud

Prepare a quarterly income statement : Prepare a quarterly income statement, a statement of retained earnings, and a balance sheet and journalize and post the adjusting entries. In the ledger accounts ( T-accounts), indicate the adjusting entries with an A.
Declare a pointer to an array of 500 school : In a main() demonstration function, declare a pointer to an array of 500 School objects and include code to handle any memory allocation errors that occur. in a loop, declare 500 array objects at a time, continuing to rewrite the main() functions ..
Uses a loop to populate a one-dimensional array : Write the following program that creates and uses a loop to populate a one-dimensional array that holds the even numbers between 1 and 12; creates and uses a loop to populate a second one-dimensional array that holds the odd numbers between 1 and 12;..
Table called transactionlog : Create a table called TransactionLog. Create a trigger, which inserts a new record (user CardNo, ISBN, date) into the TransactionLog table whenever the a borrower checks out a book or returns a book.
Prepare a new contribution format segmented income statement : 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.
Jane''s farm stand sells a variety of vegetables : Jane's farm stand sells a variety of vegetables. Write a program that produces an output file of vegetables sold, sorted by the biggest selling vegetable in terms of money made to the poorest selling.
Consider a server with poisson job-arrival stream : Consider a server with Poisson job-arrival stream at an average rate of 60 per hour. Determine the probability that the time interval between successive job arrivals is
State qualitative analysis scenario : Consider the following qualitative analysis scenario and then classify what type(s) of qualitative analysis principle is/are being used. More than one choice may be correct.
Explain competitive equilibrium solubilization : Selective precipitation, fractional precipitation, amphoteric precipitate solubilization, competitive equilibrium solubilization: anion protonation, competitive equilibrium solubilization

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd