Managerial Accounting Production Costs Worksheet

[Enter Name]ACCT 2120
January 29, 2020
Problem 1-20
Item
Description
a.
The cost of leasing the Meals-OnWheels van
b.
The cost of incidental supplies such
as salt, pepper, napkins, and so on
c.
The cost of gasoline consumed by
the Meals-On-Wheels van
d.
The rent on the facility that houses
Madison Seniors Care Center,
including the Meals-On-Wheels
program
e.
The salary of the part-time manager
of the Meals-On-Wheels program
f.
Depreciation on the kitchen
equipment used in the Meals-OnWheels program
g.
The hourly wages of the caregiver
who drives the van and delivers the
meals
h.
The costs of complying with health
safety regulations in the kitchen
i.
The costs of mailing letters
soliciting donations to the Meals-OnWheels program
Direct or Indirect
Cost of the MealsOn-Wheels
Program
Direct or Indirect
Cost of Particular
Seniors Served by
the Meals-OnWheels Program
Direct
Direct
Indirect
Indirect
Variable or Fixed
with Respect to the
Number of Seniors
Served by the
Meals-On-Wheels
Program
Variable Fixed
[Enter Name]
ACCT 2120
January 29, 2020
Problem 1-24
Instructions: Insert the appropriate amounts in the boxes below for each column. The total for each column will be added automatically in Row 20. The Print Area of the worksheet has been sized to appear on one sheet in Landscape orientation.
Dozier Co. produced and sold 1,000 units with the costs below:
Direct materials
$
$
3c
Prime
$ 43,000
$ 12,000
18,000
Total selling expense
$ 30,000
$
4,000
25,000
Total administrative expense
$ 29,000
TOTAL
–
$
–
–
$
–
$
–
$
–
$
–
$
–
–
$
–
Manually calculate and enter
Variable Cost per Unit Produced and Sold
5) If 1,001 units were made instead, what is the incremental
manufacturing cost to make the additional unit?
Incremental cost per unit produced
$
Manually enter
Number of Units Produced and Sold
Number of Units Produced and Sold
Predicting Cost Behavior
4a
4b
Variable Mfg Total Fixed
28,000
Fixed selling expense
Fixed administrative expense
Manufacturing Cost Classification
3b
3c
Total Non-Mfg Conversion
$ 35,000
Total manufacturing overhead
Variable administrative expense
3a
Total Mfg
$ 15,000
Fixed manufacturing overhead
Variable selling expense
Cost Object Assignment
2a
2b
Direct
Indirect
$ 69,000
Direct labor
Variable manufacturing overhead
Preparing Financial Stmts
1a
1b
Product
Period
Manually enter
Manually calculate and enter
e sheet in Landscape orientation.
alculate and enter
Var Cost per Unit
Made and Sold
4c
$
–