Answer:
Data validation
Explanation:
Here the combo box determines the validating the data and also provides the data list that is to be chosen from the given set of the data. Now if can be chosen from the drop-down list with respect to combo box also the motive would remain the same as it comes under data validation option
Hence, the correct option is data validation
Answer:
(a)
Mathematical Equation for break-even
F = QP - QV
Where
F = fixed cost
Q = Break-even quantity
P = Selling price
V = Variable cost
F = Q ( P - V )
Q = F / ( P - V )
Q = $327,030 / ( $630 - $300 )
Q = $327,030 / $330
Q = 991 units
(b)
Contribution Margin = Price per unit - Variable cost per unit
Contribution Margin = $630 - $300 = $330
Break-even Point in Units = Fixed Cost / Contribution margin per unit
Break-even Point in Units = $327,030 / $330 = 991 units
Explanation:
Mathematical equation use the the break-even equation which represent the behavior of each element towards the break-even point.
Contribution per unit method use the contribution of each unit to calculate the break-even point.
Answer:
$154,900
Explanation:
The computation of the total cost of operating the assembly department as follows:
= Direct expenses of assembly department + allocated amount
= $123,400 + $52,500 × 69,000 ÷ (69,000 + 46,000)
= $123,400 + $52,500 × 69,000 ÷ 115,000
= $123,400 + $31,500
= $154,900
Answer:
c. $64 million
Explanation:
For computing the revenue recognized, first we have to determine the percentage which is shown below:
= Cost incurred in 2014 ÷ expenses incurred
= $48 million ÷ $120 million
= 40%
And, the contract price is $160 million
So, the revenue recognized would be
= Contract price × percentage
= $160 million × 40%
= $64 million