Question: please see word doc for assignment and use excel template for solutions. Leary Month of April Inventory Ending Inventory and COGS Option #1- Mod 4-

please see word doc for assignment and use excel template for solutions.

Leary Month of April Inventory Ending Inventory and COGS Option #1- Mod 4- Protfolio Project Student Template Date Inentory Activity 1-Apr Briginning Inventory (BI) 5-Apr Purchases (Transferred in or TI) 10-Apr Purchases (Transferred in or TI) 15-Apr Purchases (Transferred in or TI) 20-Apr Purchases (Transferred in or TI) 25-Apr Purchases (Transferred in or TI) Q1: TOTAL Goods Avail for Sale(units and $) Given: Units sold (transferred out or TO) += # Units $ Cost Total Cost MustKnow: Inventory Formula= Units = EI= Q2: Average cost= EI= Good available for sale$ / Goods available for sale units= EI= units in inventory * average cost= COGS= BI + TI - EI BI + TI = $4,200; COGS = $3,500 Q3: LIFO= First-In, Still-Here for EI = EI= COGS= BI + TI - EI BI + TI = EI = Q4: FIFO= Last-In, Still- Here for EI= EI COGS= BI + TI - EI BI + TI = EI = Question 5- Show work speadsheet on how you calculated the numbers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Ling Corporation decided to acquire all of Huang Corporation's voting common stock on January 1, 2017. The purchase price consisted of $10,000 for the registering and issuing of 10,000 shares of Ling...

Hi, I need a help from those people who have a great knowledge regarding accounting. Please help me to resolve the questions in attached file. BSB51215 Diploma of Marketing BSBFIM501 Manage budgets...

Business Accounting & Finance - A1 Assignment - Individual Assignment Assignment Instructions: Assignment Reference BAF/StudentNumber/Jan18/A1 Due Date 08 February 2018 Weighting 20% of the course...

I need help with the december part of this...... Overview In previous modules, you examined the initial stages of the accounting cycle and practiced journalizing financial transactions. In Milestone...

During April, Leary Company sold 1,000 units of Product Q. Product Qs beginning inventory and purchases during the month are shown below. (Assume the periodic inventory system is used.) Assignment...

During April, Leary Company sold 1,000 units of Product Q. Product Q's beginning inventory and purchases during the month are shown below. (Assume the periodic inventory system is used.) Assignment...

PRACTICE NUMBER 5 I NEED HELP below. Chart of Accounts Current Assets 10000 Cash ma 11000 Accounts Receivable 12000 Inventory-Orange Roller Blades 12100 Inventory - Black Roller Blades 13100 Office...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

NEED HELP WITH PART 2, 3, 4 AND 5 PLEASE!!!! CCOUNTING SETY The Business This practice set is designed in five parts. In the first part, the student will complete the journal entries for the month of...

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

Jones Flowers's bonds have 23 years remaining to maturity. Interest is paid annually, they have a $1,000 par value, the coupon interest rate is 9%, and the yield to maturity is 11%. What is the...

Resident of X country goes to Y country and utilize the services of Y country, this transaction will be shown as on the balance of payment account. A B D receipt side of Y country and payment side...

Monitoring and control mechanisms are another way to track change implementation and performance. Group of answer choices True False

you have been asked by the president of Farr construction company to evaluate the proposed acquisition of a new earth mover. the mover's basic price is $50,00 and it will cost another $10,000 to...

A metal fabricator is considering the purchase of two new milling machines. Model A costs $65,000 to purchase, has annual operating costs of $2,000, requires a $5,000 overhaul every 3 years, and has...

A Bar of initial diameter = 80 mm is drawn with a draft = 16 mm. The draw die has an entrance angle 17, and the coefficient of friction at the work-die interface = 0.1. The metal behaves as a...

Show how Phase I of the simplex method can be used to solve n simultaneous linear equations in n unknowns. Show how the following cases can be detected: a. Inconsistency of the system. b. Redundancy...

describe change management and why it is important to a project.

1. To provide an insight into why a communication situation can be perceived differently depending on which psychological framework we choose to use.

4. What is the meaning of this statement, we should always demarcate a problem in accordance with our objectives, or with what we are trying to understand? a) Give at least three examples that shed...

3. Discuss the following statements: a) The way in which a problem is structured provides many of the premises for the actual solution. b) Our assumptions about the demarcation of a problem will...