Chapter 2: Applying Excel
Estimated manufacturing overhead cost
Estimated total amount of the allocation base
Actual manufacturing overhead cost
Actual total amount of the allocation base
Exercise 2-4 High-Low Method [L024]
The Edelweiss Hotel in 1|lilail, Iillolorado, has accumulated records of the total electn'cal costs of the hotel
and the num her of occupancydays otter the last year. An occupancyday represents a room rented out for
MC u. 36 Conversion cost consists of which of the fol.
Conversion cost consists of which of the following?
0 Manufacturing overhead cost.
0 Direct materials and direct labor cost.
0 Direct labor cost.
a . Direct labor and manufacturing overhead cost.
chapter 2: Applying encel: exercise cfw_Pan 2 or 2;
1. Now change all of the dollar amounts in the data area of 1,rour worksheet so that it looks like this:
a_hoptier 2: Applying Excel =
If 1,rour formulas are correct, 1,rou sho
MC Qu. 167 This question is to be considered independen.
Data concerning Homme Corporation's single product appear below:
Per Unit Percent of Sales
Selling price . $190 100%
Variable expenses . M w
Contribution margin . E M
The company is currently sell
Chapter 3: Applying Excel: Exercise [Part 2 of 2
2. Change all of the numbers in the data area of 1,rour worksheet so that it looks like this:
hapter 3: Applying Excel _
Selling price per unit
1I.lariaole expenses oerunit
Exercise 3-1 Preparing a Contribution Format Income Statement [LOIS-1]
Wheeler Corporation's most recent income statement follows:
Told Per Lh't
Sales cfw_5,000 units $205,000 $25.00
1lllariable expenses 144,000 15.00
Contribution margin 54,000 $ 5.00
Exercise 3-3 Compute the Margin of Safety [LOB-7]
l'ir'lohan Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning next month's
budget appear below:
Selling price $25 per unit
1lrlan'able expenses $15 per unit
Fix ed expens
Exercise 5-3 Reconciliation of Absorption and Variable Costing Net
Operating Incomes [LO5-3]
[The following information applies to the questions displayed below.]
High Tension Transformers, Inc., manufactures heavy-duty transformers for electrical switchi