Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I just need help for the answers on the right side for the questions under C and help with the weighted avg ending inv and
I just need help for the answers on the right side for the questions under C and help with the weighted avg ending inv and cost of good sold. but if you want to do it all and post, that would be good just to check over my answers
1001 - Cat 11 - BIGA 3. FI... OBY. 2. UNE Mosoly to record and mate moned in business and decision making You must make a copy before using this sheet. This is the master. File (right under the title) then make a copy to save to your own Google Drive or Download as Microsoft Excel. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel/Sheets capabilities by using as many formulas and functions as possible Better Bottles, Inc. uses a periodic inventory system and has the following information available: MASTER INVENTORY RECORD Reference given data section MASTER RECORD.This should be calculated FIRST Fof Untou Total cost Chapter & Course Outcomes: (to be demonstrated in this project) Calculate Cost of Good Sold and Ending inventory using 3 costing methods in the periodic Al system of inventory Analyze the impact on the financial statements of each inventory costing method and system of inventory Beginning inventory Jan 15 purchase 20 S 20.00 275 2200 100 390 Use Microsoft Excel proficiently to record and summarire information used in business analysis and decision makin 30.00 Jan 20 purchase Total Inventory Ianuary Sales Ending Inventory 33 S 80 36 44 950 1954 www Uw forms for these deli REQUIRED FOR POINTS: A Complete the master inventory record wing formulas. Reference/link to this information for each costing schedule. 1. Complete the inventory costing schedules documenting details (every possible shelf) in the calculation of ending inventory and cost of goods sold for each of the costing methods. Use formules for calculations and reference link to the master record C.Answer the following questions: Which method provides the highest net income? Which method provides the largest asset value on the Balance Sheet? Are your answers always true? Explain Which method would you choose? Explain INVENTORY COSTING SCHEDULES Link or reference back to the description units and cost on the master record FIFO Ending Inventory Count Desc an 30 mich 5990.00 - 5 123 - F1 - 00 Use Exception contundentioned in business and decision making A INVENTORY COSTING SCHEDULES Link or reference back to the description units and cost on the master record Caldab the digital Good Song Answer the following questions: Which method provides the highest net income? Which method provides the largest asset value on the Balance Sheet? Are your answers always true? Explain Which method would you choose? Explain Desco lan 20 purchase Jan 15 purchase FFO Ending Inventory tanti Coolpar 33 S 30.00 11 S 22.00 Totalcom 5990.00 $242.00 Awe $1,232.00 Beginning inventory Jan 15 purchase O Cost of Goods Sold of Chen 20 S 20.00 16 5 22.00 Sco $400.00 $352.00 36 $752.00 Galculate the demon Cost of Good Son Periodic Demon Beginning inventory lan 15 purchase LIFO Ending Inventory of Chit permit 20 $ 20.00 24 S 22.00 Tulos $400.00 $528.00 $928.00 Det lan 20 purchase lan 15 purchase 44 LIFO Cost of Goods Sold Go 335 30.00 35 22.00 Foto S990.00 566.00 Sheett- Copy of Project #2 directions - File Edit View insert Format data Tools Add-ons Help Latit was 28.000 BT 3001 - C 13 * | 1 6 A 4.3. - - - . 00 @Y. 2. Use Microsoft Excel proficiently is record and are intentioned in business analysis and decision making Desco Ian 20 purchase Jan 15 purchase UFO Cost of Good Seld onts cost per 33 S 30.00 3 $ 22.00 Total $990.00 $66,00 36 $1.056,00 the Editory and cost of Good Solid using Powegited Average WLIGHTED AVERAGE Ending Inventory of Units Cod per unit 44 248 Total 0312 1012 WEIGHTED AVERAGE Cost of Goods Sold of Uw Cost per unit 36 248 Total cost 9 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started