BE15.3 - Using Excel to Determine Joint Cost Allocation Using the Physical Quantities Method PROBLEM Maggpie produces and sells four kinds of ice cream from a single process. The following information relates to production, costs, and sales of the ice cream. Ice Cream Flavor Gallons Produced Selling Price/Gallon Vanilla 3,000 $3.00 Strawberry 3,000 3.50 Chocolate 2,000 3.50 Neapolitan 1,000 3.50 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. How much of the joint cost will be allocated to each product if the sales value at split-off method is used? Total sales value at split-off Allocated

BE15.3 - Using Excel to Determine Joint Cost Allocation Using the Physical Quantities Method PROBLEM Maggpie produces and sells four kinds of ice cream from a single process. The following information relates to production, costs, and sales of the ice cream. \begin{tabular}{lrr} Ice Cream Flavor & Gallons Produced & Selling Price/Gallon \\ \hline Vanilla & 3,000 & $3.00 \\ Strawberry & 3,000 & 3.50 \\ Chocolate & 2,000 & 3.50 \\ Neapolitan & 1,000 & 3.50 \end{tabular} Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. How much of the joint cost will be allocated to each product if the sales value at split-off method is used? \begin{tabular}{|c|c|c|c|c|c|} \hline & Vanilla & Strawberry & Chocolate & Neapolitan & Totals \\ \hline \multicolumn{6}{|c|}{ Total sales value at split-off } \\ \hline Allocated joint costs & & & & & \\ \hline \end{tabular}