the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the periode Requirements 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold ending merchandise inventory, and gross profe 2. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory and gross prof 3. Prepare a perpetual inventory record, using the weighted average inventory costing method, and determine the company's cost of goods sold ending merchandise inventory, and gross proft (Round weighted average cost per unit to the nearest cent and all other amounts to the nearest dollar) 4. If the business wanted to pay the least amount of income taxes possible. which method would choose? Print Done the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Ente

Financial Accounting
15th Edition
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter7: Inventories
Section: Chapter Questions
Problem 7PA: Selected data on merchandise inventory, purchases, and sales for Celebrity Tan Co. and Ranchworks...
icon
Related questions
Topic Video
Question

plz help

Exercise Planet began July with merchandise inventory of 70 crates of vitamins that cost a total of $4,550. During the month, Exercise Planet purchased and sold merchandise on account as follows:
(Click the icon to view the transactions.)
Read the requirements.
Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit.
Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.)
Purchases
Cost of Goods Sold
Inventory on Hand
Unit
Cost
Total
Unit
Cost Quantity Cost
Unit
Quantity Cost
Date
Jul. 1
5
13
18
26
Totals
Date Quantity
Jul. 1
13
18
26
Quantity
Jul. 1
Unit
Date Quantity Cost
5
13
18
26
Purchases
Gross profit is
Total
Cost
Total
Cost
Unit
Quantity Cost
Total
Cost
Total
Cost
Determine the company's gross profit using the FIFO inventory costing method.
Gross profit is
using the FIFO inventory costing method.
Requirement 2. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit.
Begin by computing the cost of goods sold and cost of ending merchandise inventory using the LIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.)
Purchases
Cost of Goods Sold
Inventory on Hand
Total
Unit
Unit
Cost
Total
Unit
Cost Quantity Cost
Cost Quantity Cost
Total
Cost
Unit
Quantity Cost
Inventory on Hand
Data table
Total
Cost
Totals
Determine the company's gross profit using the weighted-average inventory costing method.
using the weighted-average inventory costing method.
Requirement 4. If the business wanted to pay the least amount of income taxes possible, which method would it choose?
If the business wanted to pay the least amount of income taxes possible, they would choose
Jul. 5 Purchase
Jul. 13 Sale
Jul. 18 Purchase
Jul. 26 Sale
130 crates @ $76 each
140 crates @ $98 each
150 crates @ $83 each
160 crates @ $102 each
Print
Done
Totals
Determine the company's gross profit using the LIFO inventory costing method.
Gross profit is
using the LIFO inventory costing method.
Requirement 3. Prepare a perpetual inventory record, using the weighted-average inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit.
Begin by computing the cost of goods sold and cost of ending merchandise inventory using the weighted-average inventory costing method. Enter the transactions chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost f merchandise inventory purchased, sold, and on hand at the end of the period. (Round weighted-average cost per unit to the neare.
Cost of Goods Sold
X
Requirements
1.
2.
3.
4.
Prepare a perpetual inventory record, using the FIFO inventory
costing method, and determine the company's cost of goods sold, ending
merchandise inventory, and gross profit.
Prepare a perpetual inventory record, using the LIFO inventory
costing method, and determine the company's cost of goods sold, ending
merchandise inventory, and gross profit.
Prepare a perpetual inventory record, using the weighted-average inventory
costing method, and determine the company's cost of goods sold, ending
merchandise inventory, and gross profit. (Round weighted-average cost per
unit to the nearest cent and all other amounts to the nearest dollar.)
If the business wanted to pay the least amount of income taxes possible,
which method would it choose?
Print
X
Done
Transcribed Image Text:Exercise Planet began July with merchandise inventory of 70 crates of vitamins that cost a total of $4,550. During the month, Exercise Planet purchased and sold merchandise on account as follows: (Click the icon to view the transactions.) Read the requirements. Requirement 1. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.) Purchases Cost of Goods Sold Inventory on Hand Unit Cost Total Unit Cost Quantity Cost Unit Quantity Cost Date Jul. 1 5 13 18 26 Totals Date Quantity Jul. 1 13 18 26 Quantity Jul. 1 Unit Date Quantity Cost 5 13 18 26 Purchases Gross profit is Total Cost Total Cost Unit Quantity Cost Total Cost Total Cost Determine the company's gross profit using the FIFO inventory costing method. Gross profit is using the FIFO inventory costing method. Requirement 2. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the LIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.) Purchases Cost of Goods Sold Inventory on Hand Total Unit Unit Cost Total Unit Cost Quantity Cost Cost Quantity Cost Total Cost Unit Quantity Cost Inventory on Hand Data table Total Cost Totals Determine the company's gross profit using the weighted-average inventory costing method. using the weighted-average inventory costing method. Requirement 4. If the business wanted to pay the least amount of income taxes possible, which method would it choose? If the business wanted to pay the least amount of income taxes possible, they would choose Jul. 5 Purchase Jul. 13 Sale Jul. 18 Purchase Jul. 26 Sale 130 crates @ $76 each 140 crates @ $98 each 150 crates @ $83 each 160 crates @ $102 each Print Done Totals Determine the company's gross profit using the LIFO inventory costing method. Gross profit is using the LIFO inventory costing method. Requirement 3. Prepare a perpetual inventory record, using the weighted-average inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the weighted-average inventory costing method. Enter the transactions chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost f merchandise inventory purchased, sold, and on hand at the end of the period. (Round weighted-average cost per unit to the neare. Cost of Goods Sold X Requirements 1. 2. 3. 4. Prepare a perpetual inventory record, using the FIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Prepare a perpetual inventory record, using the weighted-average inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar.) If the business wanted to pay the least amount of income taxes possible, which method would it choose? Print X Done
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 8 images

Blurred answer
Knowledge Booster
Accounting Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning