Betty DeRose, Inc. operates two departments, the handling department and
the packaging department. During April, the handling department reported
the following information:
% complete % complete
units DM conversion
work in process, April 1 18,000 38% 71%
units started during April 80,000
work in process, April 30 44,000 82% 47%
The cost of beginning work in process and the costs added during April
were as follows:
DM Conversion Total cost
work in process, April 1 $ 51,764 $152,477 $204,241
costs added during April 191,452 232,125 423,577
total costs 243,216 384,602 627,818
Calculate the conversion unit cost using the weighted average process
costing method.In: Accounting
Combat Fire, Inc. manufactures steel cylinders and nozzles for
two models of fire extinguishers: (1) a home fire extinguisher and
(2) a commercial fire extinguisher. The home model is a
high-volume (54,000 units), half-gallon cylinder that holds 2 1/2
pounds of multi-purpose dry chemical at 480 PSI. The commercial
model is a low-volume (10,200 units), two-gallon cylinder that
holds 10 pounds of multi-purpose dry chemical at 390 PSI. Both
products require 1.5 hours of direct labor for completion.
Therefore, total annual direct labor hours are 96,300 or [1.5 hours
× (54,000 + 10,200)]. Estimated annual manufacturing overhead is
$1,573,108. Thus, the predetermined overhead rate is $16.34 or
($1,573,108 ÷ 96,300) per direct labor hour. The direct materials
cost per unit is $18.50 for the home model and $26.50 for the
commercial model. The direct labor cost is $19 per unit for both
the home and the commercial models.
The company’s managers identified six activity cost pools and
related cost drivers and accumulated overhead by cost pool as
follows.
|
Estimated Use of |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Activity Cost Pools |
Cost Drivers |
Estimated Overhead |
Estimated Use of |
Home |
Commercial |
|||||
| Receiving | Pounds |
$87,100 |
335,000 |
215,000 |
120,000 |
|||||
| Forming | Machine hours |
150,150 |
35,000 |
27,000 |
8,000 |
|||||
| Assembling | Number of parts |
399,280 |
217,000 |
165,000 |
52,000 |
|||||
| Testing | Number of tests |
47,940 |
25,500 |
15,500 |
10,000 |
|||||
| Painting | Gallons |
57,838 |
5,258 |
3,680 |
1,578 |
|||||
| Packing and shipping | Pounds |
830,800 |
335,000 |
215,000 |
120,000 |
|||||
|
$1,573,108 |
||||||||||
Under traditional product costing, compute the total unit cost
of each product. (Round answers to 2 decimal places,
e.g. 12.50.)
|
Home Model |
Commercial Model |
|||
|---|---|---|---|---|
| Total unit cost |
Under ABC, prepare a schedule showing the computations of the
activity-based overhead rates (per cost driver). (Round
overhead rate to 2 decimal places, e.g.
12.25.)
|
Activity Cost Pool |
Estimated |
Estimated |
Activity-Based |
||||||
|---|---|---|---|---|---|---|---|---|---|
| Receiving | $enter a dollar amount | enter an amount of pounds | Pounds | $enter a dollar amount per pound rounded to 2 decimal places | per pound | ||||
| Forming | enter a dollar amount | enter a number of machine hours | Machine hours | $enter a dollar amount per machine hour rounded to 2 decimal places | per machine hour | ||||
| Assembling | enter a dollar amount | enter a number of parts | Parts | $enter a dollar amount per part rounded to 2 decimal places | per part | ||||
| Testing | enter a dollar amount | enter a number of tests | Tests | $enter a dollar amount per test rounded to 2 decimal places | per test | ||||
| Painting | enter a dollar amount | enter an amount of gallons | Gallons | $enter a dollar amount per gallon rounded to 2 decimal places | per gallon | ||||
| Packing and shipping | enter a dollar amount | enter an amount of pounds | Pounds | $enter a dollar amount per pound rounded to 2 decimal places | per pound | ||||
| $enter a total amount | |||||||||
Prepare a schedule assigning each activity’s overhead cost pool to each product based on the use of cost drivers. (Round overhead cost per unit to 2 decimal places, e.g. 12.25 and cost assigned to 0 decimal places, e.g. 2,500.)
Compute the total cost per unit for each product under ABC.
In: Accounting
Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas, Nevada, market. The company uses the same engine for all its ATVs. The purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the size of the warehouse and other administrative restrictions, she must order the engines in lot sizes of 1,000 each. The unique characteristics of the standardized engine require special tooling to be used during the manufacturing process. Kuantan ATV agrees to reimburse the supplier for the tooling. This is a critical purchase, since late delivery of engines would disrupt production and cause 50 percent lost sales and 50 percent back orders of the ATVs. Jane has obtained quotes from two reliable suppliers but needs to know which supplier is more cost-effective. The terms of sale are 5/10 net 30 for Supplier 1 and 3/10 net 30 for Supplier 2. The data related to the costs of ownership associated with two reliable suppliers has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Questions
1. What is the total cost of ownership for each of the suppliers? Assume the buyer will take advantage of the largest discount. Do not round intermediate calculations. Round your answers to the nearest cent.
| Supplier 1 | Supplier 2 | |
| Total | $ | $ |
2. Which supplier is more cost-effective?
| Total Cost of Ownership Analysis | ||||||||
| Unit Price | Supplier 1 | Supplier 2 | ||||||
| Requirements (annual forecast units) | 14,000 | 1 to 999 units per order | $530.00 | $520.00 | ||||
| Lot size (Q) | 1,000 | 1000 to 2999 units per order | $520.00 | $515.00 | ||||
| Weight per engine (lbs) | 29 | 3000+ units per order | $510.00 | $506.00 | ||||
| Order processing cost (per order) | $125.00 | Tooling cost | $25,000 | $22,000 | ||||
| Inventory carrying rate (per year) | 24% | Terms (net 30) | 5% | 3% | ||||
| Cost of working capital (per year) | 5% | Distance (miles) | 140 | 100 | ||||
| Profit margin | 20% | Supplier Quality Rating (defects) | 3% | 2% | ||||
| Price of finished ATV | $5,000 | Supplier Delivery Rating (lateness) | 2% | 3% | ||||
| Back-order cost (per unit) | $19.00 | |||||||
| Back-order lost sales | 50% | Supplier 1 | Supplier 2 | Formulas | ||||
| Late delivery lost sales | 50% | Total engine cost | #N/A | #N/A | ||||
| Cash discount (net 30) | #N/A | #N/A | ||||||
| Other Information | Cash discount (early payment) | #N/A | #N/A | |||||
| Truckload (TL>=40,000 lbs) | $0.60 | per ton-mile | Tooling cost | #N/A | #N/A | |||
| Less-than-truckload (LTL) | $1.20 | per ton-mile | Transportation cost | #N/A | #N/A | |||
| Per ton-mile | 2,000 | lbs per mile | Ordering cost | #N/A | #N/A | |||
| Days per year | 365 | Carrying cost | #N/A | #N/A | ||||
| Invoice payment period (days) | 30 | Quality cost | #N/A | #N/A | ||||
| Discount period (days) | 10 | Backorder cost | #N/A | #N/A | ||||
| Lost sales cost | #N/A | #N/A | ||||||
| Total cost | #N/A | #N/A | ||||||
| Lowest cost | #N/A |
In: Math
1.(B)Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 8%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $108 to purchase these supplies.
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:
Activity Cost Pool (Activity Measure)Total CostTotal ActivityCustomer deliveries (Number of deliveries)$567,0007,000deliveriesManual order processing (Number of manual orders) 312,0004,000ordersElectronic order processing (Number of electronic orders) 208,00013,000ordersLine item picking (Number of line items picked) 574,000410,000line itemsOther organization-sustaining costs (None) 690,000 Total selling and administrative expenses$2,351,000
Worley gathered the data below for two of the many hospitals that it serves—University and Memorial (each hospital purchased medical supplies that had cost Worley $32,000 to buy from manufacturers):
Activity
Activity MeasureUniversityMemorialNumber of deliveries1228Number of manual orders043Number of electronic orders170Number of line items picked110250
Required:
1. Compute the total revenue that Worley would receive from University and Memorial.
2. Compute the activity rate for each activity cost pool.
3. Compute the total activity costs that would be assigned to University and Memorial.
4. Compute Worley's customer margin for University and Memorial. (Hint: Do not overlook the $32,000 cost of goods sold that Worley incurred serving each hospital.)
In: Accounting
Stillicum Corporation makes ultra light-weight backpacking
tents. Data concerning the company’s two product lines appear
below:
| Deluxe | Standard | |||||
| Direct materials per unit | $ | 64.00 | $ | 52.00 | ||
| Direct labor per unit | $ | 22.00 | $ | 18.00 | ||
| Direct labor-hours per unit | 0.70 | DLHs | 1.40 | DLHs | ||
| Estimated annual production | 10,000 | units | 50,000 | units | ||
The company has a traditional costing system in which
manufacturing overhead is applied to units based on direct
labor-hours. Data concerning manufacturing overhead and direct
labor-hours for the upcoming year appear below:
| Estimated total manufacturing overhead | $ | 570,000 | |
| Estimated total direct labor-hours | 77,000 | DLHs | |
Required:
1. Determine the unit product costs of the Deluxe and Standard products under the company’s traditional costing system.
2. The company is considering replacing its traditional costing
system with an activity-based absorption costing system that would
have the following three activity cost pools:
| Expected Activity | |||||
| Activity Cost Pools and Activity Measures | Estimated Overhead Cost |
Deluxe | Standard | Total | |
| Supporting direct labor (direct labor-hours) | $ | 385,000 | 7,000 | 70,000 | 77,000 |
| Batch setups (setups) | 120,000 | 200 | 100 | 300 | |
| Safety testing (tests) | 65,000 | 30 | 70 | 100 | |
| Total manufacturing overhead cost | $ | 570,000 | |||
Determine the unit product costs of the Deluxe and Standard products under the company’s traditional costing system. (Round your intermediate calculations and final answers to 2 decimal places.)
|
Determine the unit product costs of the Deluxe and Standard products under the activity-based absorption costing system. (Round your intermediate calculations and final answers to 2 decimal places.)
|
In: Accounting
Prior to the first month of operations ending October 31 Marshall Inc. estimated the following operating results:
| Sales (20,000 x $71) | $1,420,000 | ||
| Manufacturing costs (20,000 units): | |||
| Direct materials | 852,000 | ||
| Direct labor | 202,000 | ||
| Variable factory overhead | 94,000 | ||
| Fixed factory overhead | 112,000 | ||
| Fixed selling and administrative expenses | 30,500 | ||
| Variable selling and administrative expenses | 36,800 | ||
The company is evaluating a proposal to manufacture 22,400 units instead of 20,000 units, thus creating an Inventory, October 31 of 2,400 units. Manufacturing the additional units will not change sales, unit variable factory overhead costs, total fixed factory overhead cost, or total selling and administrative expenses.
a. 1. Prepare an estimated income statement, comparing operating results if 20,000 and 22,400 units are manufactured in the absorption costing format. If an amount box does not require an entry leave it blank or enter “0”.
| Marshall Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ending October 31 | ||
| 20,000 Units Manufactured | 22,400 Units Manufactured | |
| Sales | $ | $ |
| Cost of goods sold: | ||
| Cost of goods manufactured | $ | $ |
| Inventory, October 31 | ||
| Total cost of goods sold | $ | $ |
| Gross profit | $ | $ |
| Selling and administrative expenses | ||
| Income from operations | $ | $ |
Feedback
a. 2. Prepare an estimated income statement, comparing operating results if 20,000 and 22,400 units are manufactured in the variable costing format. If an amount box does not require an entry leave it blank or enter “0”.
| Marshall Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ending October 31 | ||
| 20,000 Units Manufactured | 22,400 Units Manufactured | |
| Sales | $ | $ |
| Variable cost of goods sold: | ||
| Variable cost of goods manufactured | $ | $ |
| Inventory, October 31 | ||
| $ | $ | |
| $ | $ | |
| $ | $ | |
| Fixed costs: | ||
| $ | $ | |
| Total fixed costs | $ | $ |
| $ | $ | |
In: Accounting
Model Z $93
Model EF $88
Model DS $127
Sonata Corporation has 5 activities—assembly, materials management, testing, inspecting and milling. The cost driver for assembly is machine hours. Total costs and production volumes for the year 2019 were estimated as follows
|
Total Indirect cost |
Allocation Base |
Cost Driver |
|
|
Assembly |
$992,500 |
240,600 |
Machine hours |
|
Materials management |
$405,600 |
42,500 |
Parts |
|
Testing |
$190,000 |
7,000 |
Units |
|
Inspection |
$120,400 |
4,775 |
Inspections |
|
Milling |
$215,750 |
220,050 |
Milling Minutes |
The following is the amount each product uses of each driver:
|
Model Z |
Model EF |
Model DS |
|
|
No. Of Units |
1,005 |
730 |
885 |
|
Assembly |
61,305 Machine Hours |
45,260 Machine hours |
56,640 Machine Hours |
|
Materials management |
5,025 parts |
2,190 parts |
6,195 parts |
|
Testing |
402 units |
365 units |
354 units |
|
Inspection |
201 inspections |
292 inspections |
177 inspections |
|
Milling |
31,155 Milling Minutes |
25,550 Milling Minutes |
25,665 Milling Minutes |
In: Accounting
Income Statements under Absorption Costing and Variable Costing
Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (46,200 units) during the first month, creating an ending inventory of 4,200 units. During February, the company produced 42,000 units during the month but sold 46,200 units at $100 per unit. The February manufacturing costs and selling and administrative expenses were as follows:
| Number of Units | Unit Cost | Total Cost |
||||
| Manufacturing costs in February 1 beginning inventory: | ||||||
| Variable | 4,200 | $40.00 | $168,000 | |||
| Fixed | 4,200 | 15.00 | 63,000 | |||
| Total | $55.00 | $231,000 | ||||
| Manufacturing costs in February: | ||||||
| Variable | 42,000 | $40.00 | $1,680,000 | |||
| Fixed | 42,000 | 16.50 | 693,000 | |||
| Total | $56.50 | $2,373,000 | ||||
| Selling and administrative expenses in February: | ||||||
| Variable | 46,200 | $19.50 | $900,900 | |||
| Fixed | 46,200 | 7.00 | 323,400 | |||
| Total | $26.50 | $1,224,300 | ||||
a. Prepare an income statement according to the absorption costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| Cost of goods sold: | ||
| $ | ||
| $ | ||
| $ | ||
b. Prepare an income statement according to the variable costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| $ | ||
| $ | ||
| Fixed costs: | ||
| $ | ||
| $ | ||
c. What is the reason for the difference in the amount of operating income reported in (a) and (b)?
Under the method, the fixed manufacturing cost included in the cost of goods sold is matched with the revenues. Under , all of the fixed manufacturing cost is deducted in the period in which it is incurred, regardless of the amount of inventory change. Thus, when inventory decreases, the income statement will have a lower operating income.
In: Accounting
40. TaskMaster Enterprises employs a standard cost system in which direct materials inventory is carried at standard cost. TaskMaster has established the following standards for the prime costs of one unit of product.
| Standard | Standard | Standard | ||||||||||
| Quantity | Price | Cost | ||||||||||
| Direct Materials | 8 | pounds | $ | 1.80 | per pound | $ | 14.40 | |||||
| Direct Labor | .20 | hour | $ | 9.00 | per hour | 1.80 | ||||||
| $ | 16.20 | |||||||||||
During November, TaskMaster purchased 200,000 pounds of direct materials at a total cost of $400,000. The total factory wages for November were $44,000, 90% of which were for direct labor. TaskMaster manufactured 23,000 units of product during November using 182,000 pounds of direct materials and 5,000 direct labor hours.
What is the direct materials efficiency (quantity) variance for November?
$28,800.
$3,600.
$36,400.
$40,000.
41. In 2016, Evans Corporation had an operating profit of $764,000 and a residual income of $307,000. If Evans' cost of capital is 10%, what is the amount of the invested capital?
$3,070,000.
$2,613,000.
$7,640,000.
$4,570,000.
42.
| Denominator hours for May | 22,500 | ||
| Actual hours worked during May | 21,500 | ||
| Standard hours allowed for May | 19,500 | ||
| Flexible budget fixed overhead cost | $ | 67,500 | |
| Actual fixed overhead costs for May | $ | 72,000 | |
Danske Company had total underapplied overhead of $22,500. Additional information is as follows:
| Variable Overhead: | |||
| Applied based on standard direct labor hours allowed | $ | 57,000 | |
| Budgeted based on standard direct labor hours | 45,500 | ||
| Fixed Overhead: | |||
| Applied based on standard direct labor hours allowed | $ | 45,000 | |
| Budgeted based on standard direct labor hours | 34,500 | ||
What is the actual total overhead for the period?
$57,500.
$102,500.
$124,500.
$67,500.
In: Accounting
Income Statements under Absorption Costing and Variable Costing
Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (77,000 units) during the first month, creating an ending inventory of 7,000 units. During February, the company produced 70,000 units during the month but sold 77,000 units at $90 per unit. The February manufacturing costs and selling and administrative expenses were as follows:
| Number of Units | Unit Cost | Total Cost |
||||
| Manufacturing costs in February 1 beginning inventory: | ||||||
| Variable | 7,000 | $36.00 | $252,000 | |||
| Fixed | 7,000 | 14.00 | 98,000 | |||
| Total | $50.00 | $350,000 | ||||
| Manufacturing costs in February: | ||||||
| Variable | 70,000 | $36.00 | $2,520,000 | |||
| Fixed | 70,000 | 15.40 | 1,078,000 | |||
| Total | $51.40 | $3,598,000 | ||||
| Selling and administrative expenses in February: | ||||||
| Variable | 77,000 | $18.20 | $1,401,400 | |||
| Fixed | 77,000 | 7.00 | 539,000 | |||
| Total | $25.20 | $1,940,400 | ||||
a. Prepare an income statement according to the absorption costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| Cost of goods sold: | ||
| $ | ||
| $ | ||
| $ | ||
b. Prepare an income statement according to the variable costing concept for the month ending February 28.
| Fresno Industries Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ended February 28 | ||
| $ | ||
| $ | ||
| $ | ||
| Fixed costs: | ||
| $ | ||
| $ | ||
c. What is the reason for the difference in the amount of operating income reported in (a) and (b)?
Under the method, the fixed manufacturing cost included in the cost of goods sold is matched with the revenues. Under , all of the fixed manufacturing cost is deducted in the period in which it is incurred, regardless of the amount of inventory change. Thus, when inventory decreases, the income statement will have a lower operating income.
In: Accounting