Question

In: Accounting

1. Use the information below to answer the following questions. The following units of an inventory...

1. Use the information below to answer the following questions. The following units of an inventory item were available for sale during the year: Beginning inventory 10 units at $55 First purchase 25 units at $60 Second purchase 30 units at $65 Third purchase 15 units at $70 The firm uses the periodic inventory system. During the year, 60 units of the item were sold.

a. Calculate the value of ending inventory using FIFO.

b. Calculate the value of ending Inventory using LIFO.

c. Calculate the value of ending inventory using Weighted Average

Solutions

Expert Solution

Requirement a
Valuation Of Inventory using FIFO
Units Rate Value
Begining Inventory 10 55      550
First purchase 25 60 1,500
Second purchase 30 65 1,950
Third Purchase 15 70 1,050
Total Purchase 80 5,050
Sales -60
Ending Inventory 20 68.75 1,375
Note: (15*70)+(5*65) =1,375
Requirement b
Valuation Of Inventory using LIFO
Units Rate Value
Begining Inventory 10 55      550
First purchase 25 60 1,500
Second purchase 30 65 1,950
Third Purchase 15 70 1,050
Total Purchase 80 5,050
Sales -60
Ending Inventory 20 57.5 1,150
Note: (10*55)+(10*60) = 1,150
Requirement c
Valuation Of Inventory using Weighted Average
Units Rate Value
Begining Inventory 10 55      550
First purchase 25 60 1,500
Second purchase 30 65 1,950
Third Purchase 15 70 1,050
Total Purchase 80 63.125 5,050
Sales -60
Ending Inventory 20 63.125 1,263
Note: 20 X63.125 = 1,263

Related Solutions

Use the following information to answer the questions below:
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2016 2017 Sales $ 975,000 $        1,072,500 less Cost of Goods Sold: 325,000 346,125 Gross Profit 650,000 726,375 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 75,000 116,875 Interest exp 25,000 31,000 earnings before Taxes 50,000 85,875 Taxes 20,000 34,350 Net Income $ 30,000 $              51,525 Balance Sheet info: 12/31/2016 12/31/2017 Cash 60,000 $ 63,600 Accounts Receivable 80,000 $ 84,000 Inventory...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 48,000 $ 48,000 Work in process 9,900 19,700 Finished goods 67,000 33,700 Activities and information for May Raw materials purchases (paid with cash) 194,000 Factory payroll (paid with cash) 150,000 Factory overhead Indirect materials 14,000 Indirect...
Use the following information to answer questions [The following information applies to the questions displayed below.]...
Use the following information to answer questions [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 44,000 $ 54,000 Work in process 9,500 18,800 Finished goods 59,000 34,000 Activities and information for May Raw materials purchases (paid with cash) 185,000 Factory payroll (paid with cash) 250,000 Factory overhead Indirect materials 10,000 Indirect...
Use the information below to answer the following two questions: Star Jewelry sells 500 units resulting...
Use the information below to answer the following two questions: Star Jewelry sells 500 units resulting in $75,000 of sales revenue, $28,000 of variable costs, and $18,000 of fixed costs. The company's effective tax rate is 25%. 1) Breakeven point in units is ________. A) 28,723 units B) 120 units C) 187 units D) 192 units 14) 2) The number of units that must be sold to achieve $40,000 of operating income is ________. A) 590 units B) 399 units...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If Any Differences or Errors are found, Assume that Our Business made the mistake and the BANK records are accurate. 2) The Following Items were Included on the Bank Statement from the Schwab Bank for the Month as Follows; Ending Bank Balance at January 31 was $69,000. Monthly Bank Fees of $1,500 NSF Check from Customer H.Clinton for $11,000 Interest Earned During the month was...
1.) Use the given information below to answer the following questions. a.) A sample of 25...
1.) Use the given information below to answer the following questions. a.) A sample of 25 lightbulbs was taken and it was found that the mean lifetime of a certain bulb for a movie projector is 520 hours with a standard deviation of 50 hours. The standing assumption of the manufacturing company is that the lifetime of this type pf bulb is no more than 500 hours. Assume a normal distribution. Does the data support the company’s claim at a...
Use the information below to answer questions 1-5. UNIT COSTS(based on production of 100,000 units of...
Use the information below to answer questions 1-5. UNIT COSTS(based on production of 100,000 units of each product). ALPHA BETA DIRECT MATERIAL $24 $18 DIRECT LABOR 20 16 VARIABLE OVERHEAD 10 6 VARIABLE SALES 10 6 TRACEABLE FIXED 12 10 COMMON FIXED COST 14 12 ADDITIONAL INFORMATION SELLING PRICE PER UNIT $120 $80 MATERIAL COST PER POUND 6 6 The company considers its traceable fixed cost to be avoidable. whereas its common fixed expenses are unavoidable. Required: (Answer each question)...
Use the following information to answer the questions below. NUT                               &nbs
Use the following information to answer the questions below. NUT                                                                                                                               250 Exports                                                                                                                          500 Net increase in foreign ownership of U.S.based nonreserve assets                  400 Net increase in U.S. government’s foreign assets                                                  30 Net increase in U.S. private assets                                                                            250 Investment income received in the U.S.                                                                  200 Net increase in U.S. ownership of official reserve assets                                       20 Imports                                                                                                                           600 Net increase in foreign ownership of U.S. reserve assets                                     100 Investment income paid abroad by the U.S.                                                           300 What is the current account...
Use the following information to answer questions 1-5: Suppose # of units sold (Q) = 100,000...
Use the following information to answer questions 1-5: Suppose # of units sold (Q) = 100,000 Price per unit (P) = $10 Variable cost (V) = $4 Fixed operating costs =250,000 Fixed financing cost = 100,000 Tax rate is 35%. DOL = 1.71 DFL = 1.4 DTL = 2.4 How does net income change if unit sales increases by 3%? = 5.13% How does financial leverage affect net income given a 1% change in operating income? *I only need #5...
Use the following information to answer the questions below that are required to ultimately calculate a...
Use the following information to answer the questions below that are required to ultimately calculate a company’s WACC: - Long-term bonds: 3,500 bonds outstanding with 7.20% p.a. coupons paid semi-annually, $1000 face value, 25 years to maturity, current market yield is 5.72% p.a. - Preference shares: pay a dividend of 8% p.a. forever on a $15 face value, 45,000 outstanding, currently selling for $14.20 per share. - Ordinary shares: 175,000 shares outstanding selling for $37 per share with beta of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT