Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry. The essay portion will not be graded.
MEMO
The cost of production report was used to identify the cost per case for each of the four flavors as shown below.
Orange Cola Lemon-Lime Root Beer
Total cases
Cost per case
Orange Cola Lemon-Lime Root Beer
Concentrate
Water
Sugar
Bottles
Flavor changeover
Conversion cost
Total cost per case
Cost per Case by Cost Element
[Key conclusion of memo here]
As can be seen, the cost per case of Root Beer is significantly above the cost per case of the other three flavors. A
more detailed analysis is necessary to understand the causes of this difference. The individual cost elements that
determine the total cost can be divided by the number of cases. This analysis is provided below.
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry. The essay portion will not be graded.
MEMO
The cost of production report was used to identify the cost per case for each of the four flavors as shown below.
Orange Cola Lemon-Lime Root Beer
Total cases 19,125$ 391,800$ 324,000$ 36,000$
Orange Cola Lemon-Lime Root Beer
Concentrate 1.85$ 2.15$ 2.10$ 1.90$
Cost per Case by Cost Element
Answers are entered in the cells with gray backgrounds.
As can be seen, the cost per case of Root Beer is significantly above the cost per case of the other three flavors. A more
detailed analysis is necessary to understand the causes of this difference. The individual cost elements that determine
the total cost can be divided by the number of cases. This analysis is provided below.
Cells with non-gray backgrounds are protected and cannot be edited.