Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for portable DVD players are as follows:
| June 1 | Inventory | 62 units @ $87 | |
| 6 | Sale | 44 units | |
| 14 | Purchase | 75 units @ $92 | |
| 19 | Sale | 42 units | |
| 25 | Sale | 11 units | |
| 30 | Purchase | 35 units @ $97 |
The business maintains a perpetual inventory system, costing by the last-in, first-out method.
Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 5.
Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Schedule of Cost of Merchandise Sold | |||||||||
| LIFO Method | |||||||||
| Portable DVD Players | |||||||||
| Date | Quantity Purchased | Purchases Unit Cost | Purchases Total Cost | Quantity Sold | Cost of Merchandise Sold Unit Cost | Cost of Merchandise Sold Total Cost | Inventory Quantity | Inventory Unit Cost | Inventory Total Cost |
| June 1 | 62 | $87 | $5394 | ||||||
| June 6 | $ | $ | |||||||
| June 14 | $ | $ | |||||||
| June 19 | |||||||||
| June 25 | |||||||||
| June 30 | |||||||||
| June 30 | Balance | $ | $ | ||||||
In: Accounting
Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows:
| Inventory | Purchases | Sales | |||
| Dec. 1 | 2,900 units at $34 | Dec. 10 | 1,450 units at $36 | Dec. 12 | 2,030 units |
| Dec. 20 | 1,305 units at $38 | Dec. 14 | 1,740 units | ||
| Dec. 31 | 870 units |
a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Schedule of Cost of Goods Sold | |||||||||
| LIFO Method | |||||||||
| Prepaid Cell Phones | |||||||||
Date |
Quantity Purchased |
Purchases Unit Cost |
Purchases Total Cost |
Quantity Sold |
Cost of Goods Sold Unit Cost |
Cost of Goods Sold Total Cost |
Inventory Quantity |
Inventory Unit Cost |
Inventory Total Cost |
| Dec. 1 | |||||||||
| Dec. 10 | |||||||||
| Dec. 12 | |||||||||
| Dec. 14 | |||||||||
| Dec. 20 | |||||||||
| Dec. 31 | |||||||||
| Dec. 31 | Balances | ||||||||
In: Accounting
Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:
| Inventory | Purchases | Sales | |||
| May 1 | 2,400 units at $22 | May 10 | 1,200 units at $24 | May 12 | 1,680 units |
| May 20 | 1,080 units at $26 | May 14 | 1,440 units | ||
| May 31 | 720 units |
a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Schedule of Cost of Merchandise Sold | |||||||||
| LIFO Method | |||||||||
| Prepaid Cell Phones | |||||||||
| Date | Quantity Purchased | Purchases Unit Cost | Purchases Total Cost | Quantity Sold | Cost of Merchandise Sold Unit Cost | Cost of Merchandise Sold Total Cost | Inventory Quantity | Inventory Unit Cost | Inventory Total Cost |
| May 1 | $ | $ | |||||||
| May 10 | $ | $ | |||||||
| May 12 | $ | $ | |||||||
| May 14 | |||||||||
| May 20 | |||||||||
| May 31 | |||||||||
| May 31 | Balances | $ | $ | ||||||
In: Accounting
Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows:
| Inventory | Purchases | Sales | |||
| May 1 | 3,800 units at $29 | May 10 | 1,900 units at $31 | May 12 | 2,660 units |
| May 20 | 1,710 units at $33 | May 14 | 2,280 units | ||
| May 31 | 1,140 units |
a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Schedule of Cost of Merchandise Sold | |||||||||
| LIFO Method | |||||||||
| Prepaid Cell Phones | |||||||||
| Date | Quantity Purchased | Purchases Unit Cost | Purchases Total Cost | Quantity Sold | Cost of Merchandise Sold Unit Cost | Cost of Merchandise Sold Total Cost | Inventory Quantity | Inventory Unit Cost | Inventory Total Cost |
| May 1 | $ | $ | |||||||
| May 10 | $ | $ | |||||||
| May 12 | $ | $ | |||||||
| May 14 | |||||||||
| May 20 | |||||||||
| May 31 | |||||||||
| May 31 | Balances | $ | $ | ||||||
In: Accounting
Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for portable game players are as follows:
| Apr. 1 | Inventory | 35 units @ $78 | |
| 10 | Sale | 29 units | |
| 15 | Purchase | 43 units @ $81 | |
| 20 | Sale | 25 units | |
| 24 | Sale | 6 units | |
| 30 | Purchase | 24 units @ $85 |
The business maintains a perpetual inventory system, costing by the last-in, first-out method.
Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4.
Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Schedule of Cost of Merchandise Sold | |||||||||
| LIFO Method | |||||||||
| Portable Game Players | |||||||||
| Date | Quantity Purchased | Purchases Unit Cost | Purchases Total Cost | Quantity Sold | Cost of Merchandise Sold Unit Cost | Cost of Merchandise Sold Total Cost | Inventory Quantity | Inventory Unit Cost | Inventory Total Cost |
| Apr. 1 | $ | $ | |||||||
| Apr. 10 | $ | $ | |||||||
| Apr. 15 | $ | $ | |||||||
| Apr. 20 | |||||||||
| Apr. 24 | |||||||||
| Apr. 30 | |||||||||
| Apr. 30 | Balance | $ | |||||||
In: Accounting
Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales data for portable DVD players are as follows:
| Apr. 1 | Inventory | 120 units at $26 | |
| 10 | Sale | 90 units | |
| 15 | Purchase | 140 units at $28 | |
| 20 | Sale | 110 units | |
| 24 | Sale | 40 units | |
| 30 | Purchase | 160 units at $30 |
The business maintains a perpetual inventory system, costing by the last-in, first-out method.
Determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.
| Schedule of Cost of Merchandise Sold | |||||||||
| LIFO Method | |||||||||
| Portable Game Players | |||||||||
| Date | Quantity Purchased | Purchases Unit Cost | Purchases Total Cost | Quantity Sold | Cost of Merchandise Sold Unit Cost | Cost of Merchandise Sold Total Cost | Inventory Quantity | Inventory Unit Cost | Inventory Total Cost |
| Apr. 1 | $ | $ | |||||||
| Apr. 10 | $ | $ | |||||||
| Apr. 15 | $ | $ | |||||||
| Apr. 20 | |||||||||
| Apr. 24 | |||||||||
| Apr. 30 | |||||||||
| Apr. 30 | Balances | $ | $ | ||||||
In: Accounting
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,768,200 | |
| Cost of goods sold | 1,221,420 | ||
| Gross margin | 546,780 | ||
| Selling and administrative expenses | 610,000 | ||
| Net operating loss | $ | (63,220 | ) |
Hi-Tek produced and sold 60,200 units of B300 at a price of $21 per unit and 12,600 units of T500 at a price of $40 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,300 | $ | 162,700 | $ | 563,000 |
| Direct labor | $ | 120,800 | $ | 42,100 | 162,900 | |
| Manufacturing overhead | 495,520 | |||||
| Cost of goods sold | $ | 1,221,420 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $53,000 and $106,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 214,620 | 90,900 | 62,400 | 153,300 | |
| Setups (setup hours) | 118,400 | 76 | 220 | 296 | ||
| Product-sustaining (number of products) | 102,000 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,500 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 495,520 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Complete this question by entering your answers in the tabs below.
Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,642,900 | |
| Cost of goods sold | 1,223,872 | ||
| Gross margin | 419,028 | ||
| Selling and administrative expenses | 560,000 | ||
| Net operating loss | $ | (140,972 | ) |
Hi-Tek produced and sold 60,400 units of B300 at a price of $19 per unit and 12,700 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,300 | $ | 162,000 | $ | 562,300 |
| Direct labor | $ | 121,000 | $ | 42,600 | 163,600 | |
| Manufacturing overhead | 497,972 | |||||
| Cost of goods sold | $ | 1,223,872 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $56,000 and $103,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 202,752 | 90,700 | 62,900 | 153,600 | |
| Setups (setup hours) | 133,320 | 73 | 230 | 303 | ||
| Product-sustaining (number of products) | 101,000 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,900 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 497,972 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.) Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,755,600 | |
| Cost of goods sold | 1,217,906 | ||
| Gross margin | 537,694 | ||
| Selling and administrative expenses | 590,000 | ||
| Net operating loss | $ | (52,306 | ) |
Hi-Tek produced and sold 60,200 units of B300 at a price of $21 per unit and 12,600 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,600 | $ | 162,800 | $ | 563,400 |
| Direct labor | $ | 120,500 | $ | 42,600 | 163,100 | |
| Manufacturing overhead | 491,406 | |||||
| Cost of goods sold | $ | 1,217,906 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $56,000 and $101,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 205,556 | 90,800 | 62,600 | 153,400 | |
| Setups (setup hours) | 125,050 | 75 | 230 | 305 | ||
| Product-sustaining (number of products) | 100,600 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,200 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 491,406 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Complete this question by entering your answers in the tabs below.
Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
ompute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,753,800 | |
| Cost of goods sold | 1,234,694 | ||
| Gross margin | 519,106 | ||
| Selling and administrative expenses | 570,000 | ||
| Net operating loss | $ | (50,894 | ) |
Hi-Tek produced and sold 60,300 units of B300 at a price of $21 per unit and 12,500 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,900 | $ | 162,900 | $ | 563,800 |
| Direct labor | $ | 120,500 | $ | 42,400 | 162,900 | |
| Manufacturing overhead | 507,994 | |||||
| Cost of goods sold | $ | 1,234,694 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $54,000 and $105,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 209,884 | 91,000 | 62,200 | 153,200 | |
| Setups (setup hours) | 136,310 | 77 | 240 | 317 | ||
| Product-sustaining (number of products) | 100,800 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 61,000 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 507,994 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting