FIFO METHDO | ||||||||||
COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | ENDING INVENTORY | ||||||||
Date | Particulars | No. of Units | Cost Per unit | Total | No. of Units | Cost Per unit | Cost of Goods Sold | No. of Units | Cost Per unit | Ending invetory |
Jan, 01 | Beginning inventory | 3000 | $ 38.00 | $1,14,000 | ||||||
February, 14 | 900 | $ 39.00 | $35,100 | 3000 | $ 38.00 | $1,14,000 | ||||
900 | $ 39.00 | $35,100 | ||||||||
March , 18 | 2400 | $ 40.00 | $96,000 | 3000 | $ 38.00 | $1,14,000 | ||||
900 | $ 39.00 | $35,100 | ||||||||
2400 | $ 40.00 | $96,000 | ||||||||
April, 15 | Sales | 2800 | $ 38.00 | $1,06,400 | 200 | $ 38.00 | $7,600 | |||
900 | $ 39.00 | $35,100 | ||||||||
2400 | $ 40.00 | $96,000 | ||||||||
July, 21 | Purchases | 1800 | $ 40.30 | $72,540 | 200 | $ 38.00 | $7,600 | |||
900 | $ 39.00 | $35,100 | ||||||||
2400 | $ 40.00 | $96,000 | ||||||||
1800 | $ 40.30 | $72,540 | ||||||||
August , 20 | Sales | 200 | $ 38.00 | $7,600 | ||||||
900 | $ 39.00 | $35,100 | ||||||||
900 | $ 40.00 | $36,000 | 1500 | $ 40.00 | $60,000 | |||||
1800 | $ 40.30 | $72,540 | ||||||||
September, 27 | Purchases | 1800 | $ 40.60 | $73,080 | 1500 | $ 40.00 | $60,000 | |||
1800 | $ 40.30 | $72,540 | ||||||||
1800 | $ 40.60 | $73,080 | ||||||||
October, 03 | Sales | 1500 | $ 40.00 | $60,000 | 1800 | $ 40.30 | $72,540 | |||
1800 | $ 40.60 | $73,080 | ||||||||
November, 05 | Purchases | 600 | $ 41.00 | $24,600 | 1800 | $ 40.30 | $72,540 | |||
1800 | $ 40.60 | $73,080 | ||||||||
600 | $ 41.00 | $24,600 | ||||||||
Total | 7,500 | $3,01,320 | 6,300 | $2,45,100 | 4,200 | $1,70,220 | ||||
Develop Review View Formulas Data Home Draw Page Layout Insert Wrap Calibri (Body) A A 11...
Home Insert Draw Page Layout Formulas Data Review View Develop = = 27 LG Calibri (Body) BI UB & fx 11 VA A a A E a Wrap Merge Paste s 29 x Exercise C Miami Discount Company inventory records show: Unit Cost Units Total Cost $114,000 3,000 $38.00 Beginning inventory Purchases: February 14 March 18 July 21 September 27 2 November 5 3 Sales: April 15 5 August 20 6 October 3 900 2,400 1,800 1,800 600 39.00 40.00...
Page Layout Formulas Draw Data Review View Developer ome Insert insart Calibri (Body) AA Wrap Text General 11 Delete A BIU Conditional Format Formatting as Table Styles Cel Sort & Fiter Paste S % CMerge&Center Format X 17 A C P E M H Exercise ikettle Company made the following purchas of Product Ain its first year of cpereions Unit Unit Cost January 2 March 31 July 5 November 1 1,400h 7.40 1,200h 7.00 2,400 1800 760 8.00 The ending...
AutoSave HW 6-1 Home Insert Draw Page Layout Formulas Data Review View Developer Calibri (Body) A A 11 99 Wrap Text General Paste BIU A. Merge & Center $% f K17 x A C F G H Exercise 4 1 Apartial trial balance is presented below The ending physical count ofinventory is $96. Prepare the 2 adjusting entries required under the periodic 2 inventory method 4 Trial Balance Debit Credit Merchandise Inventory 6 120 7 Sales 40 Sales Discounts 18...
DATA REVIEW VIEW FORMULAS AA Wrap Text FILE HOME INSERT PAGE LAYOUT Cut Calibri 11 Paste Format Painter BIU.B. S Clipboard Font Copy E E Merge & Center 88 Conditional Format as Cell Formatting Table Styles Inse Alignment 041 X fx Production Cost Report: Weighted Average Method. Quality Confections Company manufactures chocolate bars in two processing departments, Mixing and Packaging, and uses the weighted average method for its process costing system. The table that follows shows information for the Mixing...
Draw Page Layout Formulas Data Review View Calibri (Body) 11 A = = = 2 2 Wrap Text General Insert -X Cut b Copy ~ Format x A S E E Merge & Center $ % % -98 Conditional Form Formatting as Ta! BIV x ACCT 301 Week 6 HW Exercise 4 Process contestem Step 1 Physical flow begin WIP 4000 End WIP Started 2000 Transferred out 4000 The Finishing Department of Cosette Company has the following production and cost...
AutoSave OFF 5 = Home View Insert Draw Page Layout Formulas Data Review Calibri (Body) 11 A A = = = BIU CA E Paste 2 Wrap Text Merge & Cent 23 x ✓ fx $6,300 A B Question 3 (answer requirements a, b and c) C D н (5 points for part a, 6 points for part b, and 5 points for c) Hudson Incoporated currently uses a job-order costing system and applies manufacturing overhead with a predetermined overhead...
AutoSave Home Draw Insert Page Layout Formulas Data Review View Developer X Calibri (Body) A A 11 12 wrap Tet G Paste BIU A Marge & Center X f 014 A 8 G H K 20 yerLamp Company TelBne 21 22 As of December 31, 2018 23 Debt Credt 24 Cash 25 Accouns Recevable 26 Menhandse Inventory 228800 191.200 222000 27 Prepaid Inurance 11600 28 Land 240,000 440000 29 uding 30 Acnumulated Depreciation-Bding 31 Store Fates 32 Accumudated Deprecetion-Store Ftues...
Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = = ). General Calibri B I 11 . Font - A A . .A. Wrap Text Merge & Center. U $ . % * 3 Alignment Number Clipboard R14 4. A . B C D G H nter the last 4 digits of your student ID number 4 Name/s: 7 Save this file in EXCEL FORMAT as: P2 Lastname 8 Round all...
Insert Page Layout FormulasData Review View Cut Home Calibri (Body) 11 A-A Paste Blu Format Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bough 1 BA-Question: Incomplete manufacturing costs, expenses, and selling data for two different cases are as follows. Indicote the missing amount of different cost items, and prepare a condensed cost of goods manufactured 5 schedule, an income statement, and a partial balance sheet. Case 9,600 10 Direct materials...
Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Wrap Text Auto Fil- General Paste BIU - A Merge & Center E Conditional Format as Cell Formatting Insert Delete Formar Clear- Table Styles Clipboard Font Alignment Number Styles Cells K11 A D F G H J 1 Comprehensive Budgeting Problem 20 points Silverman Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain...