Valley View Trailmasters makes two types of tents for mountain camping, the Explorer and the Climber. Data concerning the two product lines is presented in the table below:
|
EXPLORER |
CLIMBER |
|
|---|---|---|
|
Sales price per unit |
$390 |
$615 |
|
Direct materials per unit |
$92 |
$115 |
|
Direct labor per unit |
$51 |
$75 |
|
Estimated annual production |
4,000 units |
9,000 units |
The company has always employed a tradition costing system in which manufacturing overhead is applied to units based on machine hours. Estimated data concerning manufacturing overhead and direct labor hours for the upcoming year appear below:
Estimated total manufacturing overhead $484,746
Estimated total machine hours 1,000
The company is considering replacing its traditional costing system with an activity based costing system that would assign its indirect product costs to four activity cost pools. Information about the amount assigned to these cost pools, the identified cost driver for each and usage of the cost drivers by the two product lines is presented in the following table:
|
ACTIVITY |
TOTAL COST |
COST DRIVER |
TOTAL |
EXPLORER |
CLIMBER |
|---|---|---|---|---|---|
|
Machine maintenance |
$78,840 |
Machine hours |
1,000 |
350 |
650 |
|
Batch setups |
$136,364 |
Setups |
146 |
60 |
86 |
|
Quality control |
$163,020 |
Inspections |
1,650 |
975 |
675 |
|
Technical support |
$106,522 |
Technical support calls |
964 |
352 |
612 |
|
Total manufacturing overhead cost |
$484,746 |
INSTRUCTIONS: Use EXCEL FROMULAS (Show them to next the value) to calculate the following amounts in the spaces provided on your template.
1. Calculate the predetermined overhead rate using the traditional volume-based costing system.
2. Calculate the total amount of overhead cost that would be assigned to each product line under the company’s traditional costing system.
3. Calculate the gross margin per unit for each product line using traditional volume-based costing.
4. Calculate the activity rate for each cost pool using activity-based costing.
5. Calculate the total amount of overhead cost that would be assigned to each product line using activity-based costing.
6. Calculate the gross margin per unit for each product line under the proposed activity based costing system.
Here is the attached template:
Show formulas as well as the values.
| EXPLORER | CLIMBER | ACTIVITY | TOTAL COST | COST DRIVER | TOTAL | EXPLORER | CLIMBER | ||
| Sales price per unit | $390 | $615 | Machine maintenance | $78,840 | Machine hours | 1,000 | 350 | 650 | |
| Direct materials per unit | $92 | $115 | Batch setups | $136,364 | Setups | 146 | 60 | 86 | |
| Direct labor per unit | $51 | $75 | Quality control | $163,020 | Number of inspections | 1650 | 975 | 675 | |
| Technical support | $106,522 | Number of support calls | 964 | 352 | 612 | ||||
| Estimated annual production | 4000 units | 9000 units | Total manufacturing overhead cost | $484,746 | |||||
| Estimated total manufacturing overhead: | $ 484,746 | ||||||||
| Estimated total machine hours: | 1,000 | ||||||||
| Calculate the predetermined overhead rate using traditional | |||||||||
| volume-based costing | |||||||||
| Calculate the total amount of overhead that would be assigned to each product line | |||||||||
| using traditional volume-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
| Calculate the gross margin per unit for each product line using traditional volume-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
| Calculate the activity rate for each cost pool using activity-based costing | |||||||||
| ACTIVITY | RATE | ||||||||
| Machine maintenance | |||||||||
| Batch setups | |||||||||
| Quality control | |||||||||
| Labor support | |||||||||
| Calculate the total amount of overhead that would be assigned to each product line | |||||||||
| using activity-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
| Calculate the gross margin per unit for each product line using activity-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
In: Accounting
Valley View Trailmasters makes two types of tents for mountain camping, the Explorer and the Climber. Data concerning the two product lines is presented in the table below:
|
EXPLORER |
CLIMBER |
|
|---|---|---|
|
Sales price per unit |
$390 |
$615 |
|
Direct materials per unit |
$92 |
$115 |
|
Direct labor per unit |
$51 |
$75 |
|
Estimated annual production |
4,000 units |
9,000 units |
The company has always employed a tradition costing system in which manufacturing overhead is applied to units based on machine hours. Estimated data concerning manufacturing overhead and direct labor hours for the upcoming year appear below:
Estimated total manufacturing overhead $484,746
Estimated total machine hours 1,000
The company is considering replacing its traditional costing system with an activity based costing system that would assign its indirect product costs to four activity cost pools. Information about the amount assigned to these cost pools, the identified cost driver for each and usage of the cost drivers by the two product lines is presented in the following table:
|
ACTIVITY |
TOTAL COST |
COST DRIVER |
TOTAL |
EXPLORER |
CLIMBER |
|---|---|---|---|---|---|
|
Machine maintenance |
$78,840 |
Machine hours |
1,000 |
350 |
650 |
|
Batch setups |
$136,364 |
Setups |
146 |
60 |
86 |
|
Quality control |
$163,020 |
Inspections |
1,650 |
975 |
675 |
|
Technical support |
$106,522 |
Technical support calls |
964 |
352 |
612 |
|
Total manufacturing overhead cost |
$484,746 |
INSTRUCTIONS: Use EXCEL FROMULAS (Show them next to the value) to calculate the following amounts in the spaces provided on your template.
1. Calculate the predetermined overhead rate using the traditional volume-based costing system.
2. Calculate the total amount of overhead cost that would be assigned to each product line under the company’s traditional costing system.
3. Calculate the gross margin per unit for each product line using traditional volume-based costing.
4. Calculate the activity rate for each cost pool using activity-based costing.
5. Calculate the total amount of overhead cost that would be assigned to each product line using activity-based costing.
6. Calculate the gross margin per unit for each product line under the proposed activity based costing system.
Here is the attached template:
Show formulas next to the values.
| EXPLORER | CLIMBER | ACTIVITY | TOTAL COST | COST DRIVER | TOTAL | EXPLORER | CLIMBER | ||
| Sales price per unit | $390 | $615 | Machine maintenance | $78,840 | Machine hours | 1,000 | 350 | 650 | |
| Direct materials per unit | $92 | $115 | Batch setups | $136,364 | Setups | 146 | 60 | 86 | |
| Direct labor per unit | $51 | $75 | Quality control | $163,020 | Number of inspections | 1650 | 975 | 675 | |
| Technical support | $106,522 | Number of support calls | 964 | 352 | 612 | ||||
| Estimated annual production | 4000 units | 9000 units | Total manufacturing overhead cost | $484,746 | |||||
| Estimated total manufacturing overhead: | $ 484,746 | ||||||||
| Estimated total machine hours: | 1,000 | ||||||||
| Calculate the predetermined overhead rate using traditional | |||||||||
| volume-based costing | |||||||||
| Calculate the total amount of overhead that would be assigned to each product line | |||||||||
| using traditional volume-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
| Calculate the gross margin per unit for each product line using traditional volume-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
| Calculate the activity rate for each cost pool using activity-based costing | |||||||||
| ACTIVITY | RATE | ||||||||
| Machine maintenance | |||||||||
| Batch setups | |||||||||
| Quality control | |||||||||
| Labor support | |||||||||
| Calculate the total amount of overhead that would be assigned to each product line | |||||||||
| using activity-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
| Calculate the gross margin per unit for each product line using activity-based costing | |||||||||
| EXPLORER | |||||||||
| CLIMBER | |||||||||
In: Accounting
|
Martinez Company’s relevant range of production is 10,500 units to 15,500 units. When it produces and sells 13,000 units, its unit costs are as follows: |
|
Amount |
|||
|
Direct materials |
$ |
5.30 |
|
|
Direct labor |
$ |
2.80 |
|
|
Variable manufacturing overhead |
$ |
1.40 |
|
|
Fixed manufacturing overhead |
$ |
3.30 |
|
|
Fixed selling expense |
$ |
2.30 |
|
|
Fixed administrative expense |
$ |
2.20 |
|
|
Sales commissions |
$ |
1.20 |
|
|
Variable administrative expense |
$ |
0.45 |
|
11a) If 11,000 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production?
11b) If 11,000 units are produced, what is the total amount of manufacturing overhead cost expressed on a per unit basis? (Round your answer to 2 decimal places.)
12a) If 15,500 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production?
12b) If 15,500 units are produced, what is the total amount of manufacturing overhead cost expressed on a per unit basis? (Round your answer to 2 decimal places.)
13) If the selling price is $21.30 per unit, what is the contribution margin per unit sold? (Round your answer to 2 decimal places.)
14a) If 11,000 units are produced, what are the total amount of direct manufacturing costs incurred to support this level of production?
14b) If 11,000 units are produced, what are the total amount of indirect manufacturing costs incurred to support this level of production?
15) What total incremental cost will Martinez incur if it increases production from 13,000 to 13,001 units? (Round your answer to 2 decimal places.)
In: Accounting
Almaden Hardware Store sells two product categories, tools and
paint products. Information pertaining to its 2018 year-end
inventory is as follows:
| Inventory, by Product Category |
Quantity |
Per Unit Cost |
Net Realizable Value | ||||||||
| Tools: | |||||||||||
| Hammers | 110 | $ | 5.70 | $ | 6.20 | ||||||
| Saws | 270 | 10.70 | 9.70 | ||||||||
| Screwdrivers | 370 | 2.70 | 3.30 | ||||||||
| Paint products: | |||||||||||
| 1-gallon cans | 570 | 6.70 | 5.70 | ||||||||
| Paint brushes | 110 | 4.70 | 5.20 | ||||||||
Required:
1. Determine the carrying value of inventory at
year-end, assuming the lower of cost or net realizable value
(LCNRV) rule is applied to (a) individual products, (b) product
categories, and (c) total inventory.
2. Assuming that the company reports an inventory
write-down as a line item in the income statement, for each of the
LCNRV applications determine the amount of the loss.
Determine the carrying value of inventory at year-end, assuming the lower of cost or net realizable value (LCNRV) rule is applied to (a) individual products, (b) product categories, and (c) total inventory.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Assuming that the company reports an inventory write-down as a line item in the income statement, for each of the LCNRV applications determine the amount of the loss.
|
In: Accounting
Question 1 Consider the production function:F(L,K) = L^1/3 K^1/3 .
Suppose the wage rate (price per unit of labour), w, is 2 and the capital rental rate (price per unit of capital), r, is 1.
(a) Does this production function exhibit increasing, decreasing or constant returns to scale? Explain.
(b) (If you would like to, you can do part (c) first and use your answer to (c) to answer this question.) Find the total cost of producing 32 units of output.
(c) Find the total cost, average cost and marginal cost of producing y units of output. Is the average cost increasing or decreasing in y? Is the marginal cost higher or lower than the average cost?
Now consider the production function
F(L,K) = L^2/3 K^1/3 .
(d) Does this production function exhibit increasing, decreasing or constant returns to scale? Explain.
(e) Find the total cost, average cost and marginal cost of producing y units of output. Is the average cost increasing or decreasing in y? Is the marginal cost higher or lower than the average cost? (You can leave your answers in indices. The expression is more important than the value.)
In: Economics
Chapter 7 Homework Assignment (part 1)
Hide or show questions
Progress:7/8 items
eBook
Show Me How
Calculator
Print Item
Weighted Average Cost Flow Method Under Perpetual Inventory System
The following units of a particular item were available for sale during the calendar year:
| Jan. 1 | Inventory | 30,000 | units at $30.00 |
| Mar. 18 | Sale | 24,000 | units |
| May 2 | Purchase | 54,000 | units at $31.00 |
| Aug. 9 | Sale | 45,000 | units |
| Oct. 20 | Purchase | 21,000 | units at $32.10 |
The firm uses the weighted average cost method with a perpetual inventory system. Determine the cost of merchandise sold for each sale and the inventory balance after each sale. Present the data in the form illustrated in Exhibit 5. Round unit cost to two decimal places, if necessary.
| Schedule of Cost of
Merchandise Sold Weighted Average Cost Flow Method |
|||||||||
|---|---|---|---|---|---|---|---|---|---|
| Purchases | Cost of Merchandise Sold | Inventory | |||||||
| Date | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
| Jan. 1 | $ | $ | |||||||
| Mar. 18 | $ | $ | |||||||
| May 2 | $ | $ | |||||||
| Aug. 9 | |||||||||
| Oct. 20 | |||||||||
| Dec. 31 | Balances | $ | $ | $ | |||||
Check My Work
Previous
Next
In: Accounting
Job Order Cost Sheet
Remnant Carpet Company sells and installs commercial carpeting for office buildings. Remnant Carpet Company uses a job order cost system. When a prospective customer asks for a price quote on a job, the estimated cost data are inserted on an unnumbered job cost sheet. If the offer is accepted, a number is assigned to the job, and the costs incurred are recorded in the usual manner on the job cost sheet. After the job is completed, reasons for the variances between the estimated and actual costs are noted on the sheet. The data are then available to management in evaluating the efficiency of operations and in preparing quotes on future jobs. On October 1, Remnant Carpet Company gave Jackson Consulting an estimate of $2,652 to carpet the consulting firm’s newly leased office. The estimate was based on the following data:
| Estimated direct materials: | |
| 30 meters at $33 per meter | $ 990 |
| Estimated direct labor: | |
| 20 hours at $30 per hour | 600 |
| Estimated factory overhead (75% of direct labor cost) | 450 |
| Total estimated costs | $2,040 |
| Markup (30% of production costs) | 612 |
| Total estimate | $2,652 |
On October 3, Jackson Consulting signed a purchase contract, and the delivery and installation were completed on October 10.
The related materials requisitions and time tickets are summarized as follows:
| Materials Requisition No. | Description | Amount | |
| 112 | 15 meters at $33 | $495 | |
| 114 | 19 meters at $33 | 627 | |
| Time Ticket No. | Description | Amount | |
| H10 | 10 hours at $30 | $300 | |
| H11 | 14 hours at $30 | 420 | |
Required:
Enter amounts as positive numbers.
1. Complete that portion of the job order cost sheet that would be prepared when the estimate is given to the customer.
2. Record the costs incurred, and complete the job order cost sheet.
| JOB ORDER COST SHEET | |||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||||||||||||||||||
| Amount | Amount | Amount | |||||||||||||||||||||||||||||||||||||||||||||
| 30 Meters at $33 | $ | 20 Hours at $30 | $ | Direct Materials | $ | ||||||||||||||||||||||||||||||||||||||||||
| Direct Labor | |||||||||||||||||||||||||||||||||||||||||||||||
| Factory Overhead | |||||||||||||||||||||||||||||||||||||||||||||||
| Total | $ | Total | $ | Total cost | $ | ||||||||||||||||||||||||||||||||||||||||||
| ACTUAL | |||||||||||||||||||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||||||||||||||||||
| Mat. Req. No. | Description | Amount | Time Ticket No. | Description | Amount | Item | Amount | ||||||||||||||||||||||||||||||||||||||||
| 112 | 15 Meters at $33 | $ | H10 | 10 Hours at $30 | $ | Direct Materials | $ | ||||||||||||||||||||||||||||||||||||||||
| Direct Labor | |||||||||||||||||||||||||||||||||||||||||||||||
| 114 | 19 Meters at $33 | H11 | 14 Hours at $30 | Factory Overhead | |||||||||||||||||||||||||||||||||||||||||||
| Total | $ | Total | $ | Total Cost | $ | ||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Delph Company uses a job-order costing system and has two manufacturing departments—Molding and Fabrication. The company provided the following estimates at the beginning of the year:
| Molding | Fabrication | Total | |||||
| Machine-hours | 25,000 | 35,000 | 60,000 | ||||
| Fixed manufacturing overhead costs | $ | 800,000 | $ | 200,000 | $ | 1,000,000 | |
| Variable manufacturing overhead cost per machine-hour | $ | 5.80 | $ | 5.80 | |||
During the year, the company had no beginning or ending inventories and it started, completed, and sold only two jobs—Job D-70 and Job C-200. It provided the following information related to those two jobs:
| Job D-70: | Molding | Fabrication | Total | |||
| Direct materials cost | $ | 377,000 | $ | 324,000 | $ | 701,000 |
| Direct labor cost | $ | 240,000 | $ | 130,000 | $ | 370,000 |
| Machine-hours | 18,000 | 7,000 | 25,000 | |||
| Job C-200: | Molding | Fabrication | Total | |||
| Direct materials cost | $ | 300,000 | $ | 280,000 | $ | 580,000 |
| Direct labor cost | $ | 110,000 | $ | 230,000 | $ | 340,000 |
| Machine-hours | 7,000 | 28,000 | 35,000 | |||
Delph had no underapplied or overapplied manufacturing overhead during the year.
Exercise 2-15 Part 2
2. Assume Delph uses departmental predetermined overhead rates based on machine-hours.
a. Compute the departmental predetermined overhead rates.
b. Compute the total manufacturing cost assigned to Job D-70 and Job C-200.
c. If Delph establishes bid prices that are 150% of total manufacturing costs, what bid prices would it have established for Job D-70 and Job C-200?
d. What is Delph’s cost of goods sold for the year?
Compute the departmental predetermined overhead rates. (Round the final answers to 2 decimal places.)
|
||||||||||
Compute the total manufacturing cost assigned to Job D-70 and Job C-200. (Round your intermediate calculations to 2 decimal places.)
|
If Delph establishes bid prices that are 150% of total manufacturing costs, what bid prices would it have established for Job D-70 and Job C-200? (Round your intermediate calculations to 2 decimal places.)
|
hat is Delph’s cost of goods sold for the year? (Round your intermediate calculations to 2 decimal places.)
|
In: Accounting
Delph Company uses a job-order costing system and has two manufacturing departments—Molding and Fabrication. The company provided the following estimates at the beginning of the year:
| Molding | Fabrication | Total | |||||
| Machine-hours | 30,000 | 40,000 | 70,000 | ||||
| Fixed manufacturing overhead costs | $ | 770,000 | $ | 290,000 | $ | 1,060,000 | |
| Variable manufacturing overhead cost per machine-hour | $ | 5.80 | $ | 5.80 | |||
During the year, the company had no beginning or ending inventories and it started, completed, and sold only two jobs—Job D-70 and Job C-200. It provided the following information related to those two jobs:
| Job D-70: | Molding | Fabrication | Total | |||
| Direct materials cost | $ | 377,000 | $ | 327,000 | $ | 704,000 |
| Direct labor cost | $ | 230,000 | $ | 140,000 | $ | 370,000 |
| Machine-hours | 23,000 | 7,000 | 30,000 | |||
| Job C-200: | Molding | Fabrication | Total | |||
| Direct materials cost | $ | 260,000 | $ | 260,000 | $ | 520,000 |
| Direct labor cost | $ | 110,000 | $ | 260,000 | $ | 370,000 |
| Machine-hours | 7,000 | 33,000 | 40,000 | |||
Delph had no underapplied or overapplied manufacturing overhead during the year.
2. Assume Delph uses departmental predetermined overhead rates based on machine-hours.
a. Compute the departmental predetermined overhead rates.
Compute the departmental predetermined overhead rates. (Round the final answers to 2 decimal places.)
|
||||||||||
b. Compute the total manufacturing cost assigned to Job D-70 and Job C-200.
Compute the total manufacturing cost assigned to Job D-70 and Job C-200. (Round your intermediate calculations to 2 decimal places.)
|
c. If Delph establishes bid prices that are 140% of total manufacturing costs, what bid prices would it have established for Job D-70 and Job C-200?
If Delph establishes bid prices that are 140% of total manufacturing costs, what bid prices would it have established for Job D-70 and Job C-200? (Round your intermediate calculations to 2 decimal places.)
|
d. What is Delph’s cost of goods sold for the year?
What is Delph’s cost of goods sold for the year? (Round your intermediate calculations to 2 decimal places.)
|
In: Accounting
Job Order Cost Sheet
Remnant Carpet Company sells and installs commercial carpeting for office buildings. Remnant Carpet Company uses a job order cost system. When a prospective customer asks for a price quote on a job, the estimated cost data are inserted on an unnumbered job cost sheet. If the offer is accepted, a number is assigned to the job, and the costs incurred are recorded in the usual manner on the job cost sheet. After the job is completed, reasons for the variances between the estimated and actual costs are noted on the sheet. The data are then available to management in evaluating the efficiency of operations and in preparing quotes on future jobs. On October 1, Remnant Carpet Company gave Jackson Consulting an estimate of $9,450 to carpet the consulting firm’s newly leased office. The estimate was based on the following data:
| Estimated direct materials: | |
| 200 meters at $35 per meter | $7,000 |
| Estimated direct labor: | |
| 16 hours at $20 per hour | 320 |
| Estimated factory overhead (75% of direct labor cost) | 240 |
| Total estimated costs | $7,560 |
| Markup (25% of production costs) | 1,890 |
| Total estimate | $9,450 |
On October 3, Jackson Consulting signed a purchase contract, and the delivery and installation was completed on October 10.
The related materials requisitions and time tickets are summarized as follows:
| Materials Requisition No. | Description | Amount | |
| 112 | 140 meters at $35 | $4,900 | |
| 114 | 68 meters at $35 | 2,380 | |
| Time Ticket No. | Description | Amount | |
| H10 | 10 hours at $20 | $200 | |
| H11 | 10 hours at $20 | 200 | |
Required:
Enter amounts as positive numbers.
1. Complete that portion of the job order cost sheet that would be prepared when the estimate is given to the customer.
2. Record the costs incurred and complete the job order cost sheet.
| JOB ORDER COST SHEET | |||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||||||||||||||||||
| Amount | Amount | Amount | |||||||||||||||||||||||||||||||||||||||||||||
| 200 Meters at $35 | $ | 16 Hours at $20 | $ | Direct Materials | $ | ||||||||||||||||||||||||||||||||||||||||||
| Direct Labor | |||||||||||||||||||||||||||||||||||||||||||||||
| Factory Overhead | |||||||||||||||||||||||||||||||||||||||||||||||
| Total | $ | Total | $ | Total cost | $ | ||||||||||||||||||||||||||||||||||||||||||
| ACTUAL | |||||||||||||||||||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||||||||||||||||||
| Mat. Req. No. | Description | Amount | Time Ticket No. | Description | Amount | Item | Amount | ||||||||||||||||||||||||||||||||||||||||
| 112 | 140 Meters at $35 | $ | H10 | 10 Hours at $20 | $ | Direct Materials | $ | ||||||||||||||||||||||||||||||||||||||||
| Direct Labor | |||||||||||||||||||||||||||||||||||||||||||||||
| 114 | 68 Meters at $35 | H11 | 10 Hours at $20 | Factory Overhead | |||||||||||||||||||||||||||||||||||||||||||
| Total | $ | Total | $ | Total Cost | $ | ||||||||||||||||||||||||||||||||||||||||||
In: Accounting