Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

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) €? %? €? %? €? %? €? %?










Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M9957096

Have any Question?


Related Questions in Accounting Basics

Question - 1 paid 20000 cash to purchase equipment costing

Question - 1. Paid $20,000 cash to purchase equipment costing $80,000. The remaining amount was recognized as a one year note payable with interest rate of 9%. 2. A major dental machine in our office is broken beyond rep ...

Question - mr x wants to build a retirement fund of 500000

Question - Mr. X wants to build a retirement fund of $500,000 by the time he is 65. He is 40 today, and he plans to make 20 equal annual deposits to the fund, the first deposit to be made today. Assuming the fund will ea ...

Question - poe inc had the following bank reconciliation at

Question - Poe, Inc. had the following bank reconciliation at March 31, year 2: Balance per bank statement, 3/31/Y2 $46,500 Add deposit in transit 10,300 56,800 Less outstanding checks 12,600 Balance per books, 3/31/Y2 $ ...

Question - horngrens financial amp managerial

Question - HORNGREN'S Financial & Managerial Accounting Preparing the statement of cash flows-indirect method Accountants for Carlson, Inc. have assembled the following data for the year ended December 31, 2016: 2016 201 ...

Question - maxwell corporation has income per books before

Question - Maxwell Corporation has income per books before tax of $400,000. Included in the income per books is $8,000 interest income from tax-exempt municipal bonds. In computing income per books, Maxwell deducted $22, ...

Question - sandhill inc leased equipment from tower company

Question - Sandhill, Inc. leased equipment from Tower Company under a 4-year lease requiring equal annual payments of $424152, with the first payment due at lease inception. The lease does not transfer ownership, nor is ...

Question - the calculated variable cost per unit of 18 high

Question - The calculated variable cost per unit of $1.8. High Level of activity is: 1,691 units and $7,147cost. If the low level of activity was 530 units, calculate the fixed cost at the low level of activity?

Question - henry company physical inventory on december 31

Question - Henry Company, physical inventory on December 31, 2017, merchandise with a cost of $439,670 was on hand at that date. Following items were all excluded from the $439,670. 1. Merchandise of $65,330 which is hel ...

Question - during 2017 crimson inc purchased 2775000 of

Question - During 2017, Crimson Inc. purchased $2,775,000 of inventory. The cost of goods sold for 2017 was $2,635,938 and the ending inventory at December 31, 2017 was $544,688. What was the inventory turnover for 2017?

Question - mcgill and smyth have capital balances on

Question - McGill and Smyth have capital balances on January 1 of $40,000 and $43,000, respectively. The partnership income-sharing agreement provides for (1) annual salaries of $20,000 for McGill and $10,000 for Smyth, ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As