1. Pls. carefully reference and populate the excel sheet per instructor’s direction.
2. The case requirement document need to be answer not the article question…
3. Populate Data, Reference Data thru Excel and Answer the Case Requirement from Word Document attached.
0
0
0
0
0
0
0
0
0
0
0
0
Revenues
Variable costs
Contribution margin
Fixed costs
Operating income
Income tax expense
Net income
$
$/Unit
%
Number of units =
Revenue
Materials
Flash memory
Application process
Chips-phone
Gyroscope
8 other chips
Variable supplies and tools
Subtotal
Labor
Assembly and packaging
Shipping
Total variable costs
Factory rent
Machine depreciation
utility fee and taxes
Supervision
Total fixed costs
Total costs
Actual
Flexible
Budget
Units
/
=
x
Sales-Volume
Variance
Flexible Budget
Static Budget
Price Variance
Efficiency Variance
–
AQ
AP
SP
SQ
(
)
Total Flexible Budget Variance =
Assembly and
Packaging
Use red text to depict unfavorable variances
Use yellow text to depict favorable variances
Cost per unit of product:
Revenue per unit of product:
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
