Questions
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for portable DVD players are as...

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...

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...

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...

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...

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...

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...

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.

  • Required 1
  • Required 2
  • Required 3

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
% of % of
Amount Amount Amount
Traditional Cost System
% %
% %
% %
Total cost assigned to products $0 $0 $0
Total cost $0
B300 T500 Total
% of % of
Amount Total Amount Amount Total Amount Amount
Activity-Based Costing System
Direct costs:
% %
% %
% %
Indirect costs:
% %
% %
% %
Total cost assigned to products $0 $0 0
Costs not assigned to products:
Total cost $0

In: Accounting

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
% of % of
Amount Amount Amount
Traditional Cost System
% %
% %
% %
Total cost assigned to products $0 $0 $0
Total cost $0
B300 T500 Total
% of % of
Amount Total Amount Amount Total Amount Amount
Activity-Based Costing System
Direct costs:
% %
% %
% %
Indirect costs:
% %
% %
% %
Total cost assigned to products $0 $0 0
Costs not assigned to products:
Total cost $0

In: Accounting

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...

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.

  • Required 1
  • Required 2
  • Required 3

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
% of % of
Amount Amount Amount
Traditional Cost System
% %
% %
% %
Total cost assigned to products $0 $0 $0
Total cost $0
B300 T500 Total
% of % of
Amount Total Amount Amount Total Amount Amount
Activity-Based Costing System
Direct costs:
% %
% %
% %
Indirect costs:
% %
% %
% %
Total cost assigned to products $0 $0 0
Costs not assigned to products:
Total cost $0

In: Accounting

Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
Product margin $0

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.)

B300 T500 Total
% of % of
Amount Amount Amount
Traditional Cost System
Direct materials % %
Direct labor % %
Manufacturing overhead % %
Total cost assigned to products $0 $0 $0
Selling and administrative
Total cost $0
B300 T500 Total
% of % of
Amount Total Amount Amount Total Amount Amount
Activity-Based Costing System
Direct costs:
Direct materials % %
Direct labor % %
% %
Indirect costs:
Machining % %
Setups % %
Product sustaining % %
Total cost assigned to products $0 $0 0
Costs not assigned to products:
Other
Selling and administrative
Total cost $0

In: Accounting