Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

no numbers, only forumlas for each individual cell. starting numbers in top right near directions (ex 100 is cell H2 , $72 is cell I4)

no numbers, only forumlas for each individual cell. starting numbers in top right near directions (ex 100 is cell H2 , $72 is cell I4)
image text in transcribed
image text in transcribed
image text in transcribed
For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: = B3 + c3 A B D G H 1 1 100 WN 150 200 $60 $68 $72 270 2 Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 100 units at $60 3 per unit. During the year, Cortez made two batch purchases of this chair. The first was a 150-unit purchase at $68 per 4 unit; the second was a 200-unit purchase at $72 per unit. During the period, it sold 270 chairs. 5 6 Required a1. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses FIFO. 8 9. (Use the cells from the given information to complete this question.) 10 7 FIFO Units Unit Cost Cost of Goods Sold 12 13 From first purchase 14 From second purchase 15 Total 16 17 12. Determine the amount of product costs that would be allocated to ending inventory, assuming that Cortez uses FIFO. 18 19 (Use the cells from the given information to complete this question.) 20 Ending Inventory FIFO Units Unit Cost 21 22 23 24 25 26 bl. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses LIFO. 28 (Use the cells from the given information to complete this question.) 27 29 Cost of Goods Sold UFO Units Unit Cost 30 31 33 34 Total B F H 1 K A D E 25 G 26 bi. Determine the amount of product costs that would be allocated to cost of goods sold, assuming that Cortez uses LIFO. 27 28 (Use the cells from the given information to complete this question.) 29 LIFO Units Unit Cost Cost of Goods Sold 30 31 32 33 34 Total 35 36 b2. Determine the amount of product costs that would be allocated to ending Inventory, assuming that Cortez uses LIFO. 38 (Use the cells from the given information to complete this question.) 37 39 40 LIFO Ending Inventory Units Unit Cost 8 43 Total ending Inventory 45 c. Determine the amount of product costs that would be allocated to cost of goods sold and ending inventory, assuming that Cortez uses Weighted average. 47 (Use the cells from the given information to complete this question.) nam 49 50 Cost of goods sold 51 Ending inventory units units

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

Financial Accounting An Integrated Statements Approach

Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren

2nd Edition

324312113, 978-0324312119

More Books

Students also viewed these Accounting questions

Question

2 What are the advantages and disadvantages of job evaluation?

Answered: 1 week ago

Question

1 Name three approaches to job evaluation.

Answered: 1 week ago