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 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? Vanilla Strawberry 3,000 $3.00 3,000 3.50 Chocolate 2,000 3.50 Neapolitan 1,000 3.50 Total joint costs $80,000 Total sales value at split-off Allocated joint costs Vanilla Strawberry Chocolate Neapolitan Totals