Chapter 2 15e Note: Use your text and provided resourc
See Problem details beginning page 52 Chapter 2: Applying Excel p. 52 Instructions: Complete worksheet, do not respond to questions unless instructed to do so. Everythin
relates directly to Problems and Exercises at the end of the chapter in the assigned text.
Provided Data
Sales
Variable costs:
Cost of goods sold
Variable selling
Variable administrative
Fixed costs:
Fixed selling
Fixed administrative $12,000
$6,000
$600
$400
$2,500
$1,500 Enter a formula into each of the shaded cells below
1. Traditional Format Income Statement
Sales
Cost of goods sold
Gross margin
Selling and administrative expenses:
Selling
$
Administrative
Net operating income
Contribution Format Income Statement
Sales
Variable expenses:
Cost of goods sold
$
Variable selling
Variable administration
Contribution margin
Fixed expenses:
Fixed selling
Fixed administrative
Net operating income
2. Provided Data
Sales
Variable costs:
Cost of goods sold
Variable selling
Variable administrative
Fixed costs:
Fixed selling
Fixed administrative
Sales
Cost of goods sold $ 3,100
1,900
$ $
6,000
600
400 12,000
6,000
6,000 5,000
1,000 Correct 12,000 7,000
5,000 Correct 2,500
1,500
$ 4,000
1,000 Correct $13,200
$6,000
$990
$440
$2,500
$1,500
$ 13,200
6,000 Gross margin
Selling and administrative expenses:
Selling
Administrative
Net operating income Incorrect Contribution Format Income Statement
Sales
Variable expenses:
Cost of goods sold
$
Variable selling
Variable administration
Contribution margin
Fixed expenses:
Fixed selling
Fixed administrative
Net operating income $ 13,200 6,000
990
440
Incorrect
2,500
1,500
Incorrect The Foundational 15, p. 53
Enter a formula into each of the shaded cells below
Provided Data
Direct materials
Direct labor
Variable manufacturing costs
Fixed manufacturing overhead
Fixed selling expense
Fixed administrative expense
Sales commissions
Variable administrative expense
1. Direct materials
Direct labor
Variable manufacturing overhead
Variable manufacturing cost per unit Amount per unit
$
6.00
$
3.50
$
1.50
$
4.00
$
3.00
$
2.00
$
1.00
$
0.50
$
$
$ Variable manufacturing cost per unit (a)
Number of units produced (b)
Total variable manufacturing cost (a) × (b)
Average fixed manufacturing overhead per unit (c)
Number of units produced (d)
Total fixed manufacturing cost (c) × (d)
Total product (manufacturing) cost 6.00
3.50
1.50
Incorrect
$ 10,000.00
Incorrect Incorrect Note: The average fixed manufacturing overhead cost per unit of $4.00 is valid for only one level
of activity—10,000 units produced. 2. Sales commissions
Variable administrative expense
Variable selling and administrative per unit
Variable selling and admin. per unit (a)
Number of units sold (b) $
$ 1.00
0.50 $ 1.50
10,000 Incorrect Total variable selling and admin. Expense (a) × (b)
Average fixed selling and administrative expense per
unit (c)
Number of units sold (d)
Total fixed selling and administrative expense (c) × (d)
Total period (nonmanufacturing) cost Incorrect Incorrect Note: The average fixed manufacturing overhead cost per unit of $4.00 is valid for only
one level of activity—10,000 units produced.
3. Direct materials
Direct labor
Variable manufacturing overhead
Sales commissions
Variable administrative expense
Variable cost per unit sold Incorrect 4. Direct materials
Direct labor
Variable manufacturing overhead
Sales commissions
Variable administrative expense
Variable cost per unit sold Incorrect 5.
Number of units sold
Total variable costs 8,000 Number of units sold
Total variable costs 12,500 Incorrect 6. 7. Total fixed manufacturing cost (see
requirement 1)
Number of units produced Incorrect Incorrect
8,000 Average fixed manufacturing cost
per unit produced
8. Total fixed manufacturing cost (see
requirement 1)
Number of units produced (b) Incorrect 12,500 Average fixed manufacturing cost
per unit produced Incorrect 9. Incorrect 10. Incorrect 11. Variable overhead per unit
Number of units produced
Total variable overhead cost
Total fixed overhead Incorrect
8,000 Total manufacturing overhead cost
Total manufacturing overhead cost
Number of units produced
Manufacturing overhead per unit
12. Variable overhead per unit
Number of units produced
Total variable overhead cost
Total fixed overhead
Total manufacturing overhead cost
Total manufacturing overhead cost
Number of units produced
Manufacturing overhead per unit Incorrect
$
$ 12,500 Incorrect
$ Incorrect 13. Selling price per unit
Variable cost per unit sold
Contribution margin per unit
14. Direct materials per unit
Direct labor per unit
Direct manufacturing cost per unit (a)
Number of units produced (b)
Total direct manufacturing cost
Variable overhead per unit
Number of units produced
Total variable overhead cost
Total fixed overhead
Total indirect manufacturing cost 8,000
- Incorrect Incorrect
Incorrect 11,000
Incorrect
11,000 Incorrect 15. Direct materials per unit
Direct labor per unit
Variable manufacturing overhead per unit
Incremental cost per unit produced $
$
$ 6.00
3.50
1.50
Incorrect Note: Variable selling and administrative expenses are variable with respect to the
number of units sold, not the number of units produced. Exercises, beginning p. 53
Enter a formula into each of the shaded cells below
Exercise 2-4, #1 only
1. Cups of Coffee Served in a Week
2,000
2,100
2,200
Fixed cost
Variable cost
Total cost
Average cost per cup served * 1. Incorrect
Incorrect
Incorrect Incorrect
* Total cost ÷ cups of coffee served in a week Incorrect Exercise 2-5, #1 only Electrical
Costs OccupancyDays Incorrect January
February
March
April
May
June
July
August
September
October
November
December 1,736
1,904
2,356
960
360
744
2,108
2,406
840
124
720
1,364 $
$
$
$
$
$
$
$
$
$
$
$ 4,127
4,207
5,083
2,857
1,871
2,696
4,670
5,148
2,691
1,588
2,454
3,529 High activity level
Low activity level
Change Incorrect
Incorrect
Incorrect Variable cost
Total Cost (highest cost level)
Variable cost element
Fixed cost element Incorrect
Incorrect
Incorrect
Incorrect
Incorrect Exercise 2-5, #1, #2, and #3
Use the data provided mid-page 58 to complete Traditional and Contribution Format
Income Statements (input formats below)
1. Traditional income statement
The Alpine House, Inc.
Sales
Cost of goods sold
Beginning Inventory
Merchandise Purchases
Ending Inventory
Cost of goods sold
Gross margin
Selling and administrative expenses:
Selling expenses
Administrative expenses
Total Selling and administrative expenses:
Net operating income 2. Incorrect
Incorrect Incorrect
Incorrect Contribution format income statement
The Alpine House, Inc.
Sales
Variable expenses:
Cost of goods sold:
Beginning Inventory
Merchandise Purchases
Ending Inventory
Cost of goods sold Incorrect Selling expenses
Administrative expenses
Total Variable Expenses
Contribution margin
Fixed expenses:
Selling expenses
Administrative expenses
Total Fixed expenses
Net operating income Incorrect
Incorrect Incorrect
Incorrect 3. Number of skis sold
Total Contribution Margin
The contribution of each pair of skis toward fixed
expenses and profits Incorrect Appendix 2B Exercises and Problems, beginning p. 80
Exercise 2B-1
Match the eight terms shown immediately below with the 12 definitions on page 80.
Input the number assigned to each term to match the numbered definition. There is a
match for every term and a term for every definition. Two definitions have two
matching terms, show both.
1. Appraisal costs
2. Quality cost report
3. Quality of conformance
4. Internal failure costs
Definition number (see p. 80):
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12. 5. Quality circles
6. Prevention costs
7. External failure costs
8. Quality costs
Matching Term
Incorrect
Incorrect
Incorrect
Two terms
Incorrect
Incorrect
Incorrect
Incorrect
Incorrect
Incorrect
Two terms
Incorrect Problem 2B-3, #1 and #2
An analysis of the company’s quality cost report is presented below:
Last Year
1.
Amount
Percent*
Prod. Cost
Qual. Cost
Prevention costs:
Machine maintenance
$
70.00
Training suppliers
$
Quality circles
$
- Total prevention costs
Appraisal costs:
Incoming inspection
Final testing
Total appraisal costs
Internal failure costs:
Rework
Scrap
Total internal failure costs
External failure costs:
Warranty repairs
Customer returns
Total external failure costs $ $
$
$ $
$
$ $
$
$ 70.00
Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect 20
80
100 50
40
90 90
320
410 Total quality cost $ 670 Total production cost $ 4,200 * Percentage figures may not add down due to rounding. From the above analysis how would you assess the year over year change for each category:
Total quality costs (25-30 words±):
Not required for traditional classroom delivery. No additional credit is given for completing this portion of the assignment.
2016 External failure costs (25-30 words±): Not required for traditional classroom delivery. No additional credit is given for completing this portion of the as
Timmons July, 2016 Appraisal costs (10-15 words±): Not required for traditional classroom delivery. No additional credit is given for completing this portion of the as
Timmons July, 2016 Internal failure costs (25-30 words±):
Not required for traditional classroom delivery. No additional credit is given for completing this portion of the as
Timmons July, 2016 Prevention costs (25-30 words±):
Not required for traditional classroom delivery. No additional credit is given for completing this portion of the as
Timmons July, 2016 2. In the box provided below respond to question #2 on p. 82. Do not exceed the space provided (60 words±).
Not required for traditional classroom delivery. No additional credit is given for completing this portion of the assignment.
2016 Not required for traditional classroom delivery. No additional credit is given for completing this portion of the assignment.
2016 Attention: Tests (and/or quizzes) in Managerial Accounting WILL NOT include the CORRECT / INCORRECT indicators.
goal should not be to merely arrive a solution that moves the indictor from INCORRRECT to CORRECT but to know how
correct solution. The End text and provided resources!
etails beginning page 52 ructed to do so. Everything in this worksheet
ssigned text. Duplicated from above
Provided Data
Direct materials
Direct labor Amount
per unit
$
6.00
$
3.50 Variable manufacturing costs
Fixed manufacturing overhead
Fixed selling expense
Fixed administrative expense
Sales commissions
Variable administrative expense $
$
$
$
$
$ 1.50
4.00
3.00
2.00
1.00
0.50 Amount $
$
$ 120.00
10.00
20.00 This Year
Percent*
Prod. Cost Qual. Cost
Incorrect
Incorrect
Incorrect $ $
$
$ $
$
$ $
$
$ 150.00
Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect Incorrect 40
90.00
130.00 130
70
200 30
80
110 $ 590 $ 4,800 this portion of the assignment. - Timmons July, mpleting this portion of the assignment. - mpleting this portion of the assignment. - mpleting this portion of the assignment. - mpleting this portion of the assignment. - ded (60 words±).
this portion of the assignment. - Timmons July, ECT / INCORRECT indicators. Therefore, your
to CORRECT but to know how you arrived at the

 

• 1499750286-Ch002_Worksheet 15e Problems TC.xlsx

SuperTutor

(15)

Status NEW Posted 11 Jul 2017 05:07 AM My Price 20.00

-----------

Attachments

file 1499750291-Solutions file.docx preview (51 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer