Brabant nv of the netherlands is a wholesale distributor of

Assignment Help Accounting Basics
Reference no: EM13579519

Brabant NV of the Netherlands is a wholesale distributor of Dutch cheeses that it sells throughout the European Community. Unfortunately, the company's profits have been declining, which has caused considerable concern. To help understand the condition of the company, the managing director of the company has requested that the monthly income statement be segmented by sales territory. Accordingly, the company's accounting department has prepared the following statement for March, the most recent month. (The Dutch currency is the euro which is designated by €.)


Sales Territory


Southern
Europe
Middle
Europe
Northern
Europe
  Sales 312,000     804,000      703,000    







  Territorial expenses (traceable):





       Cost of goods sold
93,000    
237,000     
315,000    
       Salaries
58,000    
57,000     
108,000    
       Insurance
9,200    
16,300     
14,500    
       Advertising
109,000    
240,000     
245,000    
       Depreciation
21,000    
33,000     
25,000    
       Shipping
16,000    
34,000     
40,000    







  Total territorial expenses
306,200    
617,300     
747,500    







  Territorial income (loss)
    before corporate expenses

5,800    
186,700     
(44,500)   







  Corporate expenses:





       Advertising (general)
13,000    
39,000     
34,000    
       General administrative
19,000    
19,000     
19,000    







  Total corporate expenses
32,000    
58,000     
53,000    







  Net operating income (loss) (26,200)    128,700      (97,500)   








 Cost of goods sold and shipping expenses are both variable; other costs are all fixed. Brabant NV purchases cheeses at auction and from farmers' cooperatives, and it distributes them in the three territories listed above. Each of the three sales territories has its own manager and sales staff. The cheeses vary widely in profitability; some have a high margin and some have a low margin. (Certain cheeses, after having been aged for long periods, are the most expensive and carry the highest margins.)

Required:
3.

Prepare a new segmented contribution format income statement for May. Show a Total column as well as data for each territory. In addition, for the company as a whole and for each sales territory, show each item on the segmented income statement as a percent of sales. (Note: % columns may not total due to rounding.) (Input all amounts as positive values except losses and their percentages which should be indicated by a minus sign. Round your percentage answers to 1 decimal place. Omit the "€" and "%" signs in your response.)


Total

Southern Europe

Middle Europe

Northern Europe


        Amount
       in €s
          %         Amount
       in €s
          %         Amount
       in €s
          %         Amount
       in €s
          %
  Sales € ?   %? €? %? €? %? €? %?









  Variable expenses:







   Cost of goods sold €? %? €? %? €? %? €? %?
  Shipping expense €? %? €? %? €? %? €? %?









  Total variable expenses
















Contribution margin €? %? €? %? €? %? €? %?









  Traceable fixed expenses:







  Salaries €? %? €? %? €? %? €? %?
  Insurance €? %? €? %? €? %? €? %?
Advertising €? %? €? %? €? %? €? %?
Depreciation €? %? €? %? €? %? €? %?









  Total traceable fixed expenses
















Territorial segment margin €? %? €? %? €? %? €? %?









  Common fixed expenses:







   Advertising (general) €? %? €? %? €? %? €? %?
  General administration €? %? €? %? €? %? €? %?









  Total common fixed expense
















Net operating income (loss) €? %? €? %? €? %? €? %?










Reference no: EM13579519

Questions Cloud

Clay company has excess factory capacity clay is submitting : clay company has excess factory capacity. clay is submitting a bid on a job with the following estimated costs fixed
Calculate purchases gross margin inventory turn days : analytical procedures in audit planning the audit of circuits technology inc. cti. cti resells installs and provides
For a representative sample of cars would the correlation : a for a representative sample of cars would the correlation between the age of the car and its gasoline economy miles
A rent check received on december 30 by the manager of an : constructive receipt. which of the following constitutes constructive receipt in the current year ended december 31a
Brabant nv of the netherlands is a wholesale distributor of : brabant nv of the netherlands is a wholesale distributor of dutch cheeses that it sells throughout the european
Your company currently produces steel and aluminum rims the : your company currently produces steel and aluminum rims. the board of directors wants you to consider the introduction
On january 1 year xxx1 holmes co borrowed cash from legacy : on january 1 year xxx1 holmes co. borrowed cash from legacy bank by issuing an 80000 face value three-year term note
If act math scores are normally distributed with a standard : in 2000 as reported by act research service the mean act math score was 20.7. if act math scores are normally
The polishing department of burgoa manufacturing company : the polishing department of burgoa manufacturing company has the following production and manufacturing cost data for

Reviews

Write a Review

Accounting Basics Questions & Answers

  Estimating amount of unrealized gain

At year-end, only $24,000 of merchandise was still being held by Yarby. What amount of unrealized gain must be deferred by Bowler?

  At the beginning of the year lambert motors issued the

at the beginning of the year lambert motors issued the three notes described below. interest is paid at year end. 1 the

  Recognizing the amount of revenue

Payment terms were: 50% due on October 1, 1996, 25% due on first delivery and 25% due on the second delivery. What amount of revenue should Acme recognize from this sale during 1996?

  The sales manager believes the company could increase sales

fox companyprojected income statementfor the year ending decemeber 31 2004revenues400000variable costsvariable

  Bond retirement-gain or loss

On February 1, 2008, Pat Weaver Inc. (PWI) issued 10%, $1,000,000 bonds for $1,116,000. PWI retired all of these bonds on January 1, 2009, at 102. Unamortized bond premium on that date was $92,800. How much gain or loss should be recognized on thi..

  Provide missing journal entry for prepaid rent

Prepaid rent at 1/1/10 was $20,000. During 2010 rent payments of $123,000 were made and charged to "rent expense." The 2010 income statement shows as a general expense the item "rent expense" in the amount of $122,000.

  Peluso company a manufacturer of snowmobiles is operating

peluso company a manufacturer of snowmobiles is operating at 70 of plant capacity. pelusos plant manager is considering

  A company started the year with retained earnings of

a company started the year with retained earnings of 200000. during the year it reported net income of 80000 and it

  P company purchased the net assets of s company for 225000

p company purchased the net assets of s company for 225000. on the date of ps purchase s company had no investments in

  Prepare anamortization table of the loan

Prepare anamortization table of the loan. What will bethe amount of interest expense reported by Brookstone Farm for theloan in 2007 and in 2008?

  How might this approach encourage poor business decisions

Explain why it might make sense for this company to award bonuses based on sales growth. How might this approach encourage poor business decisions when compared to a bonus plan tied to earnings?

  Result of the transaction

Amata paid $100 per share for her Kingbird Corporation's stock five (5) years ago. As a result of this transaction, which of the following is correct?

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