View the step-by-step solution to:


1.    The other category of variances, operational efficiency variances, are calculated by comparing the

inputs of the raw materials and labor hours compared to the standards for each. Again, the calculations can be challenging, so I am providing the variance amounts for you. For the French region, the operational efficiency variances reduced the profit by 187,000 Euro. For the Italian region, the operational efficiency variance increased profit by 31,000 Euro.

2.    There are some miscellaneous variances as well, including the corporate allocation for both regions. For just the French region, there was the effect of the shipments to Spain and the new delivery business. Input these amounts from the case exhibits to the worksheet.

3.    The next task for you is to complete the chart found in the posted Excel file. It is the worksheet titled 2009 Performance. Each of the highlighted cells need to be filled in, either with the previous calculations, data from the other exhibits, or new calculations for this page. Note that the chart is asking for the changes to profit as a result of comparing the budget to the actual results. Each input should reconcile the total difference from planned profit to actual profit. When you include this chart in your final report, do not include the entire workbook. Just put this page in your report, likely as an appendix item.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes