BE15.3 - Using Excel to Determine Joint Cost Allocation Using the Physical Student Work Area Quantities Method Required: Provide input into cells shaded in yellow in this template. Input the required mathematical PROBLEM formulas or functions with cell references to the Problem area or work area as indicated. 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. How much of the joint cost will be allocated to each product if the sales value at split-off method is Ice Cream Flavor Gallons Produced Selling Price/Gallon used? Vanilla 3,000 $3.00 Strawberry 3,000 3.50 Vanilla Strawberry Chocolate Neapolitan Totals Chocolate 2,000 3.50 Total sales value at split-off Neapolitan 1,000 3.50 Allocated joint costs Total joint costs $80,000