Required: (A) Prepare a perpetual inventory record for All Things Auto, using the first in, first out (FIFO) method to determine the value of ending inventory at December 31, 2020, and the total amount to be assigned to cost of goods sold for the period. (B) Given that selling, distribution and administrative costs for the quarter were $23,445, $10,250 and$75,435 respectively, prepare an income statement for All Things Auto (DieĦard) for the quarter ended December 31, 2020, to determine the net profit for the quarter. (C) Journalize the transactions on November 12 and November 27, assuming the business uses a: Perpetual inventory system Periodic inventory system

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter12: Current Liabilities
Section: Chapter Questions
Problem 3PB: Review the following transactions, and prepare any necessary journal entries for Sewing Masters Inc....
icon
Related questions
Question

Please help

All Things Auto are retailers who purchase and sell vehicle parts & accessories, including batteries. The business
uses a perpetual inventory system and began the last quarter of 2020 with merchandise inventory of 10 batteries
of the "DieHard" brand at a total cost of $168,200.
The following transactions, relating to the "DieHard" brand were completed during the quarter:
October 5
October 14
October 22
Purchased 15 batteries at a cost of $17,020 each.
Sold 18 batteries at $22,250 per battery
Purchased 24 batteries at a cost of $18,175 each but the supplier gave a 4% quantity discount.
November 10 Sold 15 batteries to Orion Auto Ltd and 10 batteries to Brown's Auto Detailing at a price of
$23,990 each.
Owing to an increased demand for this brand of batteries, 30 batteries were purchased on
account at a cost of $17,612 each. In addition, All Things Auto paid $288 in cash on each
battery to have the inventory shipped from the vendor's warehouse to their location.
November 12
November 27 Sold 23 batteries which yielded total sales revenue of $576,840. (8 of these batteries were
sold on account to Middletown Fuel & Auto Accessories a longstanding customer)
November 30A customer, to whom 5 batteries were sold at the end of the business day on November 27,
returned 2 units, as they were of the "Duralast" brand.
In preparation for the festive season, All Things purchased 25 batteries at a total cost of
$474.500.
5 of the batteries purchased on December 2 were returned to the supplier, as the poles were
either corroded or otherwise badly damaged.
December 2
December 15
December 30 Sold 22 batteries to two customers (Omega Traders & Middleton Auto Accessories) at a
selling price of S26,950 each.
December 31
An actual count of inventory was carried out which revealed that there were 9 units of the
"DieHard" brand in the warehouse.
All purchases were on account and received on the dates stated.
Required:
(A)
to determine the value of ending inventory at December 31, 2020, and the total amount to be assigned to
cost of goods sold for the period.
Prepare a perpetual inventory record for All Things Auto, using the first in, first out (FIFO) method
(B)
Given that selling, distrībution and administrative costs for the quarter were $23,445, S10,250 and$75,435
respectively, prepare an income statement for All Things Auto (DieHard) for the quarter ended
December 31, 2020, to determine the net profit for the quarter.
(C)
Journalize the transactions on November 12 and November 27, assuming the business uses a:
Perpetual inventory system
Periodic inventory system
Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units.
(D)
The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the
business $30 to place a single order.
The maximum number of units sold for any one week is 150 and minimum sales 8o units. The
vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The
EOQ model is appropriate.
i) What is the cost minimizing solution for this product each year?
ii) Determine the re-order level, minimum inventory level and maximum inventory level for the
product.
Transcribed Image Text:All Things Auto are retailers who purchase and sell vehicle parts & accessories, including batteries. The business uses a perpetual inventory system and began the last quarter of 2020 with merchandise inventory of 10 batteries of the "DieHard" brand at a total cost of $168,200. The following transactions, relating to the "DieHard" brand were completed during the quarter: October 5 October 14 October 22 Purchased 15 batteries at a cost of $17,020 each. Sold 18 batteries at $22,250 per battery Purchased 24 batteries at a cost of $18,175 each but the supplier gave a 4% quantity discount. November 10 Sold 15 batteries to Orion Auto Ltd and 10 batteries to Brown's Auto Detailing at a price of $23,990 each. Owing to an increased demand for this brand of batteries, 30 batteries were purchased on account at a cost of $17,612 each. In addition, All Things Auto paid $288 in cash on each battery to have the inventory shipped from the vendor's warehouse to their location. November 12 November 27 Sold 23 batteries which yielded total sales revenue of $576,840. (8 of these batteries were sold on account to Middletown Fuel & Auto Accessories a longstanding customer) November 30A customer, to whom 5 batteries were sold at the end of the business day on November 27, returned 2 units, as they were of the "Duralast" brand. In preparation for the festive season, All Things purchased 25 batteries at a total cost of $474.500. 5 of the batteries purchased on December 2 were returned to the supplier, as the poles were either corroded or otherwise badly damaged. December 2 December 15 December 30 Sold 22 batteries to two customers (Omega Traders & Middleton Auto Accessories) at a selling price of S26,950 each. December 31 An actual count of inventory was carried out which revealed that there were 9 units of the "DieHard" brand in the warehouse. All purchases were on account and received on the dates stated. Required: (A) to determine the value of ending inventory at December 31, 2020, and the total amount to be assigned to cost of goods sold for the period. Prepare a perpetual inventory record for All Things Auto, using the first in, first out (FIFO) method (B) Given that selling, distrībution and administrative costs for the quarter were $23,445, S10,250 and$75,435 respectively, prepare an income statement for All Things Auto (DieHard) for the quarter ended December 31, 2020, to determine the net profit for the quarter. (C) Journalize the transactions on November 12 and November 27, assuming the business uses a: Perpetual inventory system Periodic inventory system Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. (D) The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold for any one week is 150 and minimum sales 8o units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate. i) What is the cost minimizing solution for this product each year? ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Market Efficiency
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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
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
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning