BE4.4 - Using Excel to Determine Volume, Variable Cost, and Contribution Margin PROBLEM Molly's Marbles incurred...

Transcribed Image Text:

BE4.4 - Using Excel to Determine Volume, Variable Cost, and Contribution Margin PROBLEM Molly's Marbles incurred variable and fixed costs in generating sales for the month of September. Marbles are sold in small bags with each bag consider to be one unit. Information concerning operations for the month of September follows. Total sales Total contribution margin Selling price per unit $ 50,000 30,000 5.00 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 many units did Molly sell that month? Number of units sold What was her variable cost per unit? Variable cost per unit What is the contribution margin per unit? Contribution margin per unit BE4.4 - Using Excel to Determine Volume, Variable Cost, and Contribution Margin PROBLEM Molly's Marbles incurred variable and fixed costs in generating sales for the month of September. Marbles are sold in small bags with each bag consider to be one unit. Information concerning operations for the month of September follows. Total sales Total contribution margin Selling price per unit $ 50,000 30,000 5.00 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 many units did Molly sell that month? Number of units sold What was her variable cost per unit? Variable cost per unit What is the contribution margin per unit? Contribution margin per unit

Answer rating: 100% (QA)

The detailed answer for the above question is provided bel... View the full answer