Question

In: Accounting

Chapter 5 Assignment 5-1 Below you will find descriptions of nine (9) transactions. On the excel...

Chapter 5

Assignment 5-1

Below you will find descriptions of nine (9) transactions.

On the excel attachment, complete the journal entries by typing in your answers in the boxes provided for the following merchandising transactions for both the PERPETUAL and PERIODIC inventory systems.

You are asked to forward you completed excel assignment answer back to me using C4. If that is not possible, print out the excel page and complete the answer by hand, and then either scan it back using C4, or take a picture of it and scan it back using C4.

a)   Nov 1    Purchased merchandise from Costmore Ltd. for $3,000 on credit with terms of 1/10, n/30, FOB shipping point.

b)   Nov 3    Paid $200 for shipping charges for the purchase of Nov 1.

c)   Nov 10 Paid Costmore Ltd. for the merchandise purchased on Nov 1.

d)   Nov 11 Returned 10% of the merchandise to Costmore Ltd. from the Nov 1 purchase.

e)   Nov 13 Sold merchandise to Cedar Inc. for $2,000 on account (cost of the merchandise was $750) terms 2/15, n/60 FOB destination.

f)    Nov 14 Paid the $50 transportation charges to deliver the merchandise sold to Cedar Inc.

g)   Nov 16 Cedar Inc. returned an item from the November 13th sale. The item had sold for $200 and cost $75.The item will be returned to inventory.

h)   Nov 20 Cedar Inc. received a price reduction of $100 regarding the November 13 sale.

I)    Nov 27 Cedar Inc. paid the balance due from sale on November 13.

Solutions

Expert Solution

Perpetual Inventory System

Date Account Titles Debit Credit
Nov-01 Inventory $          3,000
      Accounts Payable $         3,000
Nov-03 Inventory $             200
      Cash $            200
Nov-10 Accounts Payable $          3,000
       Inventory $              30
       Cash $         2,970
Nov-11 Accounts Payable $             297
       Inventory $            297
Nov-13 Accounts Receivable $          2,000
      Sales Revenue $         2,000
Cost of Goods Sold $             750
       Inventory $            750
Nov-14 Delivery Expense $               50
      Cash $              50
Nov-16 Sales Returns and Allowances $             200
      Accounts Receivable $            200
Inventory $               75
       Cost of Goods Sold $              75
Nov-20 Sales Returns and Allowances $             100
      Accounts Receivable $            100
Nov-27 Cash $          1,666
Sales Discount $               34
      Accounts Receivable $         1,700

Periodic Inventory System

Date Account Titles Debit Credit
Nov-01 Purchase $          3,000
      Accounts Payable $         3,000
Nov-03 Freight In $             200
      Cash $            200
Nov-10 Accounts Payable $          3,000
       Purchase Discount $              30
       Cash $         2,970
Nov-11 Accounts Payable $             297
       Purchase Returns $            297
Nov-13 Accounts Receivable $          2,000
      Sales Revenue $         2,000
Nov-14 Delivery Expense $               50
      Cash $              50
Nov-16 Sales Returns and Allowances $             200
      Accounts Receivable $            200
Nov-20 Sales Returns and Allowances $             100
      Accounts Receivable $            100
Nov-27 Cash $          1,666
Sales Discount $               34
      Accounts Receivable $         1,700

Related Solutions

Chapter 9: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and...
Chapter 9: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B30 enter the formula "= B20". Notes: In the text, variances are always displayed as positive numbers. To accomplish this, you can use the ABS() function in Excel. For example, the formula in cell C31 would be "=ABS(E31?B31)". Cells D31 through D39 and G31 through G39 already contain formulas to compute...
Below are nine concepts, 1-9, and nine definitions, A-I. Match each definition to its concept by...
Below are nine concepts, 1-9, and nine definitions, A-I. Match each definition to its concept by writing the correct letter in the extreme left-hand margin. ____       1.    Nonexcludable ____       2.    Nonrival ____       3.    Private good ____       4.    Public good ____       5.    Free rider ____       6.    Forced rider ____       7.    Club good ____       8.    Common resources ____       9.    Tragedy of the commons ------------------------------------------------------------------------------------------------------------------------------- A         Goods that are nonexcludable but rival B          Someone who enjoys the benefits of a public good without...
This assignment assumes you have completed Programming Challenge 1 of Chapter 9 ( Employee and ProductionWorker...
This assignment assumes you have completed Programming Challenge 1 of Chapter 9 ( Employee and ProductionWorker Classes). Modify the Employee and ProductionWorker classes so they throw exceptions when the following errors occur: ● The Employee class should throw an exception named InvalidEmployeeNumber when it receives an employee number that is less than 0 or greater than 9999. ● The ProductionWorker class should throw an exception named InvalidShift when it receives an invalid shift. ● The ProductionWorker class should throw an...
Chapter 6 Excel Assignment - Managerial Accouting NEED FORMULAS
 The Chapter 6 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text.Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula "= B17".After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in Review Problem 1.The LIFO inventory flow assumption is used throughout the problem.Check your worksheet by...
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in...
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year. (10 points) Hint: I suggest you use formulas with an IF function regarding the gross profit section of your speadsheet because your spreadsheet should be able to calculate correct answers whether a contract generates a profit or loss. 2- Using...
What is Mirr? how do you find it using excel without using excel formula? Below is...
What is Mirr? how do you find it using excel without using excel formula? Below is cash flow. I found IRR is 15.59% and required return is 12% CF Y0 Y1 Y2 Y3 Y4 Y5 Y6 Capital spen $ (30,000,000.00) $ 15,062,400.00 Opp cost $   (5,000,000.00) NWC $   (1,120,000.00) $      (150,000.00) $      (170,000.00) $      140,000.00 $   1,300,000.00 OCF $     9,015,600.00 $ 11,392,500.00 $ 12,193,200.00 $ 10,435,800.00 $ (2,640,000.00) $   (3,960,000.00) CF $ (36,120,000.00) $     8,865,600.00 $ 11,222,500.00 $ 12,333,200.00 $...
CHAPTER 9 LAB 1. Prepare the journal entries to record the transactions and events of AC/DC...
CHAPTER 9 LAB 1. Prepare the journal entries to record the transactions and events of AC/DC on the "transactions" tab.  Use the "JE tab" to journalize the transactions.   2. Prepare a year-end adjusting journal entry as of December 31, 2018 for each separate situation (use the "AJE tab" to journalize the adjustment):     (a) Bad debts are estimated to be $16,800 by an analysis of the A/R aging.  The unadjusted balance in the allowance for doubtful accounts is a debit of $1,000.     (b)...
Assignment 5 Directions: Read Chapter 8 of the text. This assignment will be divided in two...
Assignment 5 Directions: Read Chapter 8 of the text. This assignment will be divided in two parts (Part A and Part B), but will be submitted as one document - Make sure that you have also included the name of the assignment and your name on the assignment sheet. Text is FROM PRODUCTS TO SERVICES by Laurie Young. · Part A. Differences in Product and Service Marketing Select 5 of the 10 subcategory descriptions of differentiating product and service marketing...
FIN 505 Chapter 9 Assignment Problem 1 Seth Bullock, the owner of Bullock Gold Mining, is...
FIN 505 Chapter 9 Assignment Problem 1 Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company’s geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for five years, after which the mine would be worth nothing. Dan has taken an estimate of the gold deposits to Alma Garrett, the company’s financial officer. Alma has been asked by Seth...
1.     Base your answers on the Excel spread sheet that I attached to assignment 5. Calculations...
1.     Base your answers on the Excel spread sheet that I attached to assignment 5. Calculations based on two decimal places and eleven iterations of the loan-deposit-reserve process. When the initial open market purchase is $500 and the reserve requirement is 10%, M1 increases by $5,000. (allow for a discrepancy of + or - $100 between your answer and my answer) True False
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT