This preview shows pages 1–2. Sign up to view the full content.
FileName: 3737e5e20f6b53f15ec924248cb321d9c628351c.xls, Tab: Chapter 5 Demo Problem , Page 1 of 2, 12/28/2011, 19:01:14
Name:
Date:
Instructor:
Course:
$20
each. For the coming year, management
management expects fixed costs to total
$220,000
and variable costs to be
$9
per unit.
Instructions:
Label
=
Label
+
Label
+
Label
Units
Identifier
=
Value
+
Amount
+
Amount
Identifier
=
Amount
+
Amount
Identifier
=
Formula
Label
=
Label

Label
Formula
=
Amount

Amount
Label
=
Label
÷
Label
Formula
=
Amount
÷
Amount
Label
=
Label
÷
Label
Formula
=
Amount
÷
Percentage
$500,000
Label
=
Label

Label
Label
Formula
=
Amount

Amount
Amount
$165,000
using the mathematical equation.
Label
=
Label
+
Label
+
Label
Identifier
=
Amount
+
Amount
+
Amount
Fixed cost and Net income
Identifier
=
Amount
Identifier
=
Formula
Units
Managerial Accounting, 3
rd
Edition,
by Weygandt, Kieso, and Kimmel
Solving Managerial Accounting Problems Using Microsoft Excel for Windows
by Rex A Schildhouse
Chapter 5 Demo Problem,
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
 Winter '07
 LeonardA.Bacon
 Managerial Accounting

Click to edit the document details