Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need to have the formula Paste BIU Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Editing Clipboard Font D18 V fx

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
i need to have the formula
Paste BIU Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Editing Clipboard Font D18 V fx E F B D 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: 2 3 Description # of Units Cost per Unit Total Cost 4 Beginning Inventory 20 $ 20.00 $ 400.00 5 Jan. 15 Purchase 27 22.00 594.00 6 Jan. 20 Purchase 33 30.00 990.00 7 Goods Available for Sale 80 $ 1,984.00 8 Less: January Sales 36 9 Ending Inventory 44 10 11 12 Required: 13 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. 14 15 FIFO Ending Inventory 16 Description # of Units Cost per Unit Total Cost 17 Jan. 20 Purchase 33 $ 30.00 $ 990.00 18 Jan. 15 Purchase 11 22.00 19 44 E per unit 37 Jan. 20 Purchase D 38 Jan. 15 Purchase 39 36 40 41 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. 42 Next, apply that same cost per unit to calculate both the Ending Inventory and Cost of Goods Sold. 43 44 45 Weighted Cost of Goods Available for Sale 46 Average Cost = Number of Units Available for Sale 47 48 Weighted Average Ending Inventory 49 # of Units Cost per Unit Total Cost 50 51 52 Weighted Average Cost of Goods Sold 53 # of Units Cost per Unit Total Cost 54 55 56 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold 57 Equation below for all three inventory methods. (All numbers should be positive.) FIFO LIFO Wtd. Avg. 58 59 Beginning Inventory BB

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

For Heintz/parrys College Accounting, Chapters 1-15, 22nd Edition, [instant Access]

Authors: James A. Heintz, Robert W. Parry

22nd Edition

1305669886, 9781305669888

More Books

Students also viewed these Accounting questions

Question

Describe the new structures for the HRM function. page 724

Answered: 1 week ago