Calculate cost of goods sold and ending inventory

Assignment Help Accounting Basics
Reference no: EM131113117

Problem 1 - Periodic Inventory - FIFO, LIFO, Weighted Average (WA)

Salandra Inc. buys engines, and then installs them in dirt bikes for weekend race enthusiasts. Inventory records of the engines for 2015 are shown below                                                                                                          

DATE


UNITS

PER UNIT COST

TOTAL COST

1/1

Beginning Inventory

150

$120

$18,000

1/2

Bought

80

$124

$9,920

2/4

Sold

(96)



4/8

Bought

100

$132

$13,200

5/15

Bought

160

$136

$21,760

7/20

Sold

(200)



9/16

Bought

240

$140

$33,600

11/23

Sold

(400)



12/10

Bought

180

$144

$25,920

12/22

Sold

(60)



 

Cost of Goods Available for Sale

$122,400

Units Available for Sale (BI + units bought)

910 units

Units Sold

756 units

Ending Inventory

154 units

Part a. Assuming the Periodic System and FIFO, calculate Cost of Goods Sold and Ending Inventory.

Part b. Assuming the Periodic System and LIFO, calculate Cost of Goods Sold and Ending Inventory.

Problem 2 - Salandra Inc. buys engines, and then installs them in dirt bikes for weekend race enthusiasts. Inventory records of the engines for 2015 are shown below                                                                                                            

DATE


UNITS

PER UNIT COST

TOTAL COST

1/1

Beginning Inventory

150

$120

$18,000

1/2

Bought

80

$124

$9,920

2/4

Sold

(96)



4/8

Bought

100

$132

$13,200

5/15

Bought

160

$136

$21,760

7/20

Sold

(200)



9/16

Bought

240

$140

$33,600

11/23

Sold

(400)



12/10

Bought

180

$144

$25,920

12/22

Sold

(60)



 

Cost of Goods Available for Sale

$122,400

Units Available for Sale (BI + units bought)

910 units

Units Sold

756 units

Ending Inventory

154 units

Part a. Assuming the Perpetual System and LIFO, calculate Cost of Goods Sold and Ending Inventory      

Part b. Assuming the Perpetual System and WA, calculate Cost of Goods Sold and Ending Inventory       

Problem 3 - Review the unadjusted trial balance below and prepare adjusting journal entries to record the various described items below. Record in the space provided at the bottom of this spreadsheet.  After completing journal entries, complete the adjusted trial balance below.  Lastly complete the income statement, balance sheet and statement of retained earnings. The balance sheet must balance.  The accounting equation is Assets = Liabilities + Equity.                                                                                                       

Baltimore Corporation Unadjusted Trial Balance January 31, 2016

 

 

 

 

Debits

Credits

 Cash 

 $ 37,500

 $ -

 Accounts receivable

             12,410

                       -

 Prepaid insurance

               2,400

                       -

 Supplies inventory

               7,113

                       -

 Equipment

             35,000

                       -

 Accumulated depreciation

                     -

              10,000

 Accounts payable

                      -

                7,569

 Salaries payable

                      -

                       -

 Interest payable

                      -

                       -

 Unearned revenue

                      -

                8,500

 Loan payable

                      -

              11,500

 Capital stock

                      -

              25,000

 Retained earnings, Jan. 1

                      -

              15,457

 Revenues

                      -

              43,995

 Depreciation expense

                      -

                       -

 Interest expense

                      -

                       -

 Insurance expense

                      -

                       -

 Office expense

               2,500

                       -

 Rent expense

             13,000

                       -

 Salary expense

             12,098

                       -

 Supplies expense

                      -

                       -

 Utilities expense

                      -

                       -

 

 $         122,021

 $          122,021

1. Baltimore Corporation's equipment had an original life of 140 months, and the straight-line depreciation method is used. As of January 1, the equipment was 40 months old.  The equipment will be worthless at the end of its useful life.

2. As of the end of the month, Baltimore Corporation has provided services to customers for which the earnings process is complete. Formal billings are normally sent out on the first day of each month for the prior month's work.  January's unbilled work is $25,000.

3. Utilities used during January, for which bills will soon be forthcoming from providers, are estimated at $1,500.

4. A review of supplies on hand at the end of the month revealed items costing $3,500.

5. The $2,400 balance in prepaid insurance was for a 6-month policy running from January 1 to June 30.

6. The unearned revenue was collected in December of 2014.  60% of that amount was actually earned in January, with the remainder to be earned in February.

7. The loan accrues interest at 1% per month.  No interest was paid in January.

8. At month end, salaries of $2,120 have been earned but not paid.

Attachment:- Assignment.rar

Reference no: EM131113117

Questions Cloud

How maintain validity and reliability of quantitative data : An explanation of how you would maintain validity and reliability of the quantitative data being collected. A statement identifying methods for overcoming the kinds of problems you would expect as you collect the qualitative and quantitative data f..
Find the corresponding diffusion current : Find the corresponding diffusion current.
Calculate the saturation current of the diode : A silicon diode is forward-biased with V = 0.5 V at a temperature of 293 K. If the diode current is 10 mA, calculate the saturation current of the diode.
Phrase in the international economics : Purchasing power parity conversion factor is a common phrase in the international economics. What is the meaning of this phrase?
Calculate cost of goods sold and ending inventory : Assuming the Periodic System and FIFO, calculate Cost of Goods Sold and Ending Inventory. Assuming the Periodic System and LIFO, calculate Cost of Goods Sold and Ending Inventory
Find the source voltage that would yield i = -8µa : Also find the source voltage that would yield I = -8µA.
Evaluate the above recommendation of the working group : suppliers and clients but still equated with their general common interest, which is to safeguard the prosperity and continuity of the company." Evaluate the above recommendation of the working group.
Define benefits brand attributes of brand equity : Compose ideas for test marketing, product introduction, and commercialization of new products to market. Describe and understand the benefits of branding, brand attributes, and significance of brand equity.
Examples of industries that are monopolistically competitive : 1. Give examples of industries that are monopolistically competitive. Find the news articles, books which explain these examples.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Important and significant player

On 1 January 2005, momentous change occurred in respect of Australian accounting standards and the institutional arrangements surrounding them. One of the bodies affected by the changes was the AASB.

  What is the proper adjusting entry at december 31 the end

what is the proper adjusting entry at december 31 the end of the fiscal year based on supplies account balance before

  Which of the following is deductible as a medical expense

The cost of which of the following expenses is NOT deductible as a medical expense on Schedule A, before the 7.5% of adjusted gross income limitation?

  During october shandra company had 97500 of cash receipts

during october shandra company had 97500 of cash receipts and 101250 of cash disbursements. the october 31 cash balance

  Due to new information obtained earlier in the year the

yoshi company completed the following transactions and events involving its delivery trucks. nbspnbspnbsp2012jan.1paid

  Tax forms to the federal government

Mary bought 100 share of Ford Motor Company stock in 2008 at $40 per share. It is now values in 2010 at $50 per share. How much tax liability will Mary have when she submits her 2010 tax forms to the federal government?

  Impact on financial statements of missing step

What is the impact on the financial statements of missing a step when completing the accounting cycle?

  The following events took place for fed inc during october

the following events took place for fed inc. during october 2012 the first month of operations as a producer of road

  Sprinkle inc has outstanding 10000 shares of 10 par value

sprinkle inc. has outstanding 10000 shares of 10 par value common stock. on july 1 2012 sprinkle reacquired 102 shares

  Suppose you are comparing two firms within an industry one

suppose you are comparing two firms within an industry. one is large and the other is small. will relative or absolute

  Explain the alternative accounting treatments available

Prepare any necessary correcting entries under each of the alternatives described in requirement1.

  No income gainedfrom revaluations

No Income Gainedfrom Revaluations- You are required to work as a research team intending to present your findings in a suitable written format

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd