BOCKSA - Italy class.xlsx - ITALIAN REGION 2017 RESULTS Profit plan Volume Euros'000(000 Actual Volume Euros'000(000 Variance Sales Data Sales

BOCKSA - Italy class.xlsx - ITALIAN REGION 2017 RESULTS...

This preview shows page 1 - 3 out of 8 pages.

ITALIAN REGION, 2017 RESULTS Profit plan Actual Variance Volume Euros Volume Euros ('000) (000) ('000) (000) Sales Data Sales beer (volume in litres) 3,655 5,483 3,583 5,733 250 F Sales specialties (litres) 372 1,116 358 1,128 12 U Total Sales 4,027 6,599 3,941 6,861 262 F Cost of Goods Sold Cost of goods sold beer Malted barley (kg) 2,924 1,755 2,938 1,763 -8 U Other ingredients (100gr.) 2,193 439 2,329 466 -27 U Labor (hours) 110 1,097 115 1,204 -107 U Cost of goods sold Specialties Malted barley (kg) 298 179 269 175 4 F Other ingredients (100gr.) 149 45 161 56 -12 U Labor (hours) 30 298 29 301 -3 U Contribution margin 2,788 2,896 108 F Other costs Supervision, energy, maintenance…. 571 568 4 F Depreciation 109 109 0 F Operating margin 2,108 2,220 111 F Selling and Administrative Expenses Delivery expenses 165 158 7 F Depreciation of trucks 99 99 0 Selling expenses 160 170 -10 U Advertising 664 644 20 F Administrative salaries and expenses 279 287 -8 U Rent 61 61 0 Allocated central offices expenses 158 193 -35 U Profit Before Interest and Taxes 523 608 85 F Identifiable Assets Cash (average) 94 108 -14 U Accounts Receivable (average) 377 357 20 F Plant and equipment (net of depreciation €3200) 2,763 2,764 -1 U Total identifiable assets 3,234 3,229 5 F Condition for tourism Average summer temperature 29.7ºC 29.8ºC
Image of page 1

Subscribe to view the full document.

Selling Price and volumes Volume Mix Unit Price Total sales Variance Forecast Actual Forecast Actual Forecast Actual Forecast Actual Beer 3,655 3,583 90.76% 90.92% 1.500 1.600 5,483 5,733 249.8 Specialities 372 358 9.24% 9.08% 3.000 3.150 1,116 1,128 11.7 Total 4,027 3,941 100.0% 100.0% 6,599 6,861 261.5 Sales variance to be broken into volume, mix and price Volume Variance analysis: ((Total actual volume X mix forecast) - Volume forecasted) X Price forecasted Volume Mix F. Volume F. Price F. Variance Beer 3577.0 90.76% 3655.3 1.5 -117.5 Specialities 364.0 9.24% 372.0 3.0 -23.9 Total 3941.0 100.00% 4027.3 -141.5 unfavorable (U) Mix Variance analysis: ((Total actual volume X actual mix) - (Total actual volume X forecasted mix)) X Price forecasted Volume Mix F. Mix actual Price F. Variance Beer 3,577 90.76% 90.92% 1.500 9.0 Specialities
Image of page 2
Image of page 3
  • Fall '18

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes