Question

In: Accounting

Excel complete exercises E6-10 E6-10, E6-17, and E6-18 BE6–18 Refer to the BE6–11 Shankar Company uses...

Excel complete exercises E6-10 E6-10, E6-17, and E6-18

BE6–18 Refer to the BE6–11 Shankar Company uses a perpetual system to record inventory transactions. The company purchases inventory on account on February 2 for $40,000.

, but now assume that Shankar uses a periodic system to record inventory transactions. Record the purchase of inventory on February 2, including the freight charges.

E6–10 Sundance Systems has the following transactions during July.

July ?5

Purchases 40 LCD televisions on account from Red River Supplies for $2,500 each, terms 3/10, n/30.

July ?8

Returns to Red River two televisions that had defective sound.

July 13

Pays the full amount due to Red River.

July 28

Sells remaining 38 televisions from July 5 for $3,000 each on account.

Required:

Record the transactions of Sundance Systems, assuming the company uses a perpetual inventory system.

E6–18 Refer to the transactions in E6–10.

Required:

1.

Record the transactions of Sundance Systems, assuming the company uses a periodic inventory system.

2.

Record the period-end adjustment to cost of goods sold on July 31, assuming the company has no beginning inventory.

Solutions

Expert Solution

1) Assuming the company uses a perpetual inventory system

Jul-05

Inventory

100,000

Accounts payable

100,000

Jul-08

Accounts payable

5,000

Inventory

5,000

Jul-13

Accounts payable

95,000

Inventory

2,850

Cash

92,150

95,000*3% = 2850

100,000 - 5,000 - 2850 = 92150

Jul-28

Accounts receivable

114,000

Sales revenue

114,000

Jul-28

COGS

92,150

Inventory

92,150

?

2) Assuming the company uses a periodic inventory system.

Jul-05

Purchases

100,000

Accounts payable

100,000

Jul-08

Accounts payable

5,000

Inventory

5,000

Jul-13

Accounts payable

95,000

Inventory

2,850

Cash

92,150

95,000*3% = 2850

100,000 - 5,000 - 2850 = 92150

Jul-28

Accounts receivable

114,000

Sales revenue

114,000

Jul-28

No journal entry required

3) Assuming the company has no beginning or ending inventory

Jul-31

COGS

92,150

Purchases return

5000

Purchases discount

2,850

Purchases

100,000

?

?


Related Solutions

Use the following information to answer Exercises E6-16 through E6-18. Golf Unlimited carries an inventory of...
Use the following information to answer Exercises E6-16 through E6-18. Golf Unlimited carries an inventory of putters and other golf clubs. The sales price of each putter is $119. Company records indicate the following for a particular line of Golf Unlimited’s putters: Date Item Quantity Unit Cost Nov. 1 Balance 24 $ 53 6 Sale 20 8 Purchase 30 ?70 17 Sale 30 30 Sale ?2 E6-16 Measuring and journalizing merchandise inventory and cost of goods sold—FIFO Learning Objective 2...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14 14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18 11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18 18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...
Cork price 16 10 15 10 17 11 14 13 11 14 11 16 18 16...
Cork price 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14 14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18 11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18 18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...
Low Medium High 14 18 16 6 17 20 11 23 18 12 17 16 11...
Low Medium High 14 18 16 6 17 20 11 23 18 12 17 16 11 10 15 9 20 16 6 15 16 12 17 17 14 25 11 11 11 13 4 18 22 9 18 16 7 20 10 12 21 18 12 27 9 17 13 19 11 22 16 8 17 12 Our worksheets lists the number of 3+ syllable words in each magazine grouped by education level. Use your spreadsheet program to conduct a...
15 17 15 18 13 13 15 18 17 11 (i) Use a calculator with sample...
15 17 15 18 13 13 15 18 17 11 (i) Use a calculator with sample mean and standard deviation keys to find x and s. (Round your answers to two decimal places.) x = s =
Compound Interest In Exercises 17 and 18, determine the time necessary for $1000 to double if...
Compound Interest In Exercises 17 and 18, determine the time necessary for $1000 to double if it is invested at interest rate compounded (a) annually, (b) monthly, (c) daily, and (d) continuously 17. r = 11% 18. r = 10 1/2%
Constructing Confidence Intervals In Exercises 17 and 18, you are given the sample mean and the...
Constructing Confidence Intervals In Exercises 17 and 18, you are given the sample mean and the sample standard deviation. Assume the variable is normally distributed and use a normal distribution or a t-distribution to construct a 90% confidence interval for the population mean u. If convenient, use technology to construct the confidence intervals. (a) In a random sample of 10 adults from the United States, the mean waste generated per person per day was 4.54 pounds and the standard deviation...
Conduct a ONE WAY ANOVA using the following data in Excel. Group 1 : 11, 17,...
Conduct a ONE WAY ANOVA using the following data in Excel. Group 1 : 11, 17, 22, 15 Group 2 : 21, 15, 16 Group 3 : 7, 8, 3, 10, 6, 4 Group 4 : 13, 6, 17, 27, 20
Exercise 11-17 Cost of a natural resource; depletion and depreciation; Chapters 10 and 11 [LO11-2, 11-3]...
Exercise 11-17 Cost of a natural resource; depletion and depreciation; Chapters 10 and 11 [LO11-2, 11-3] Jackpot Mining Company operates a copper mine in central Montana. The company paid $1,650,000 in 2018 for the mining site and spent an additional $730,000 to prepare the mine for extraction of the copper. After the copper is extracted in approximately four years, the company is required to restore the land to its original condition, including repaving of roads and replacing a greenbelt. The...
Module 6 Worksheet: Chapter 10 Capital Budgeting – Complete in Excel Please complete the following and...
Module 6 Worksheet: Chapter 10 Capital Budgeting – Complete in Excel Please complete the following and upload this to the drop box by Sunday 11:55PM        A project has and initial cost of $32,000, expected net cash inflows of $9,500 per year for 7 years, and a cost of capital of 10%.        What is the project’s NPV?        What is the project’s IRR?          What is the projects payback period?           Your division is considering two investment projects, each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT