Chapter15Quiz_Question1

xlsx

School

Indian River State College *

*We aren’t endorsed by this school

Course

4123

Subject

Mechanical Engineering

Date

Feb 20, 2024

Type

xlsx

Pages

2

Uploaded by csy61145338

Report
Function: SUM; Formula: Multiply; Divide; Absolute Cell Referencing PROBLEM Ho Ice Cream Flavor Gallons Produced Selling Price/Gallon Vanilla 3,686 $3.20 Strawberry 7,658 4.30 Chocolate 9,897 5.30 Neapolitan 2,542 4.10 Total joint costs $60,000 BE15.3 - Using Excel to Determine Joint Cost Allocation Using the Physical Quantities Method Re for 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.
Student Work Area ow much of the joint cost will be allocated to each product if the sales value at split-off method is used? Vanilla Strawberry Chocolate Neapolitan Totals Total sales value at split-off $ 11,795 $ 32,929 $ 52,454 $ 10,422 $ 107,601 Allocated joint costs $ 6,577 $ 18,362 $ 29,249 $ 5,812 $ 60,000 equired: Provide input into cells shaded in yellow in this template. Input the required mathematical rmulas or functions with cell references to the Problem area or work area as indicated.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help