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

  Midlands design ltd-residual income

Midlands Design Ltd. of Manchester, England, is a company specializing in providing design services to residential developers. Compute the company's residual income for the year. (Omit the "£" sign in your response.)

  Manual for product costing

As the management accountant, you are responsible for setting costs for your manufacturing company's products, prior to setting the budget for the upcoming year.

  Cost-volume-profit model

Explain these objections to the accountant's convention cost-volume-profit model

  Relevant costs for progressive business solutions

Two partners who own Progressive Business Solutions, which currently operates out of an office in a small town near Boston, just discovered a vacancy in an office building in downtown Boston.

  Differences in flexible and static budget

You're in the job interview and your possible employer asks you to explain the differences between the flexible and static budget and to explain which you would recommend for the small business and why. How would you respond to this potential empl..

  Calculate break even sales in units

Given: Selling price per unit, $20; total fixed expenses, $5,000; variable expenses per unit, $15. Find break-even sales in units.

  Relevant cost of material

A company is preparing a bid that requires 757 lbs of material. They have 602 lbs in stock that originally cost 8.03/lb. Resale value of existing stock is 7.41/lb, New stock can be purchased at 8.17/lb.

  Schedule of expected collections-matierals payments

Prepare schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases. Prepare a cash budget for January and February in columnar form.

  Determining classifying cost

Use the following format to classify each cost as a product cost or a general, selling, and administrative (G,S,A) cost. Also indicate whether the cost would be recorded as an asset or an expense. The first is shown as an example.

  Relevant cost-comptronics

CompTronics, a manufacturer of computer peripherals, has excess capacity. The company's Utah plant has the following per-unit cost structure for item no. 89:

  Preparing direct-material purchases budget

Ocean Waverunners plans to manufacture 20,000 units, 24,000 units, and 30,000 units, respectively, in October, November, and December. Make a direct-material buys budget for October in parts and dollars.

  Predetermined overhead rate-mallory corporation

Mallory Corporation produces two products: A and B. The company's expected factory overhead costs for the coming year are as follows: Calculate the predetermined overhead rate based on direct labor hours and based on machine hour. Calculate the unit..

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