Sales information related to Knox Socks is as follows: Cost (per pair of socks) Customer Wholesalers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales information related to Knox Socks is as follows: Cost (per pair of socks) Customer Wholesalers Retailers Sale Price (per pair of socks) $ Online Customers $ 5.00 $ 7.00 $ 10.00 $ 2.25 2/10, 1/30 4.55 Cash Discount Terms 7.50 1/15, n/30 n/30 Credit Card Discount % 2.50% During the month of January, Knox Socks had the following transactions occur: Date Transaction 1/1 1/5 1/8 1/10 1/12 1/30 Return Policy 100% refund offered if socks are returned new with tags attached within 60 days of purchase. Sold 1,000 pairs of socks to a Wholesaler on account. Sold 400 pairs of socks to an Online Customer on account. Received payment in full from Wholesaler. Sold 700 pairs of socks to a Retailer on account. Online Customer returned 100 pairs of socks in new condition with tags. Received payment via Credit Card from Retailer for half the balance owed. Complete the transactions by date in the space provided on the following page. Ignore any cost of goods sold or inventory entries related to these transactions; record only the transactions that affect sales revenue, cash and accounts receviable, including any related contra-revenue accounts. Remember: Use the power of Excel to calculate totals within transactions. Copying/pasting or typing directly into the cells will not earn full credit! A1 File 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Home A 1/12 1/30 Date 1/1 Date 1/5 Date 1/8 Date 1/10 Insert Date 1/12 Lato Date 1/30 Draw B Page Layout ✓11 X ✓ fx QUESTION #1 C B Formulas Data Calculation Mode: Automatic Workbook Statistics D Av E Complete the transactions by date in the space provided on the following page. Ignore any cost of goods sold or inventory entries related to these transactions; record only the transactions that affect sales revenue, cash and accounts receviable, including any related contra-revenue accounts. Review View Online Customer returned 100 pairs of socks in new condition with tags. Received payment via Credit Card from Retailer for half the balance owed. Remember: Use the power of Excel to calculate totals within transactions. Copying/pasting or typing directly into the cells will not earn full credit! Automate F Help General Sold 1,000 pairs of socks to a Wholesaler on account. Sold 400 pairs of socks to an Online Customer on account. Received payment in full from Wholesaler. Sold 700 pairs of socks to a Retailer on account. Online Customer returned 100 pairs of socks in new condition with tags. = Instructions & Overview Question #1 Question #2 Question #3 Question #4 Question #5 + Received payment from Retailer for half the balance owed. $ G ←.0 .00 H .00 →→.0 Sales information related to Knox Socks is as follows: Cost (per pair of socks) Customer Wholesalers Retailers Sale Price (per pair of socks) $ Online Customers $ 5.00 $ 7.00 $ 10.00 $ 2.25 2/10, 1/30 4.55 Cash Discount Terms 7.50 1/15, n/30 n/30 Credit Card Discount % 2.50% During the month of January, Knox Socks had the following transactions occur: Date Transaction 1/1 1/5 1/8 1/10 1/12 1/30 Return Policy 100% refund offered if socks are returned new with tags attached within 60 days of purchase. Sold 1,000 pairs of socks to a Wholesaler on account. Sold 400 pairs of socks to an Online Customer on account. Received payment in full from Wholesaler. Sold 700 pairs of socks to a Retailer on account. Online Customer returned 100 pairs of socks in new condition with tags. Received payment via Credit Card from Retailer for half the balance owed. Complete the transactions by date in the space provided on the following page. Ignore any cost of goods sold or inventory entries related to these transactions; record only the transactions that affect sales revenue, cash and accounts receviable, including any related contra-revenue accounts. Remember: Use the power of Excel to calculate totals within transactions. Copying/pasting or typing directly into the cells will not earn full credit! A1 File 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Home A 1/12 1/30 Date 1/1 Date 1/5 Date 1/8 Date 1/10 Insert Date 1/12 Lato Date 1/30 Draw B Page Layout ✓11 X ✓ fx QUESTION #1 C B Formulas Data Calculation Mode: Automatic Workbook Statistics D Av E Complete the transactions by date in the space provided on the following page. Ignore any cost of goods sold or inventory entries related to these transactions; record only the transactions that affect sales revenue, cash and accounts receviable, including any related contra-revenue accounts. Review View Online Customer returned 100 pairs of socks in new condition with tags. Received payment via Credit Card from Retailer for half the balance owed. Remember: Use the power of Excel to calculate totals within transactions. Copying/pasting or typing directly into the cells will not earn full credit! Automate F Help General Sold 1,000 pairs of socks to a Wholesaler on account. Sold 400 pairs of socks to an Online Customer on account. Received payment in full from Wholesaler. Sold 700 pairs of socks to a Retailer on account. Online Customer returned 100 pairs of socks in new condition with tags. = Instructions & Overview Question #1 Question #2 Question #3 Question #4 Question #5 + Received payment from Retailer for half the balance owed. $ G ←.0 .00 H .00 →→.0
Expert Answer:
Answer rating: 100% (QA)
Record the sales revenue For each sale record the sales revenue in the Sales Revenue column of the t... View the full answer
Related Book For
Financial Accounting
ISBN: 9781618533111
6th Edition
Authors: Michelle L. Hanlon, Robert P. Magee, Glenn M. Pfeiffer, Thomas R. Dyckman
Posted Date:
Students also viewed these accounting questions
-
Describe deliberately on the accident of Southwest Airlines Flight 1380. Review the NTSB report and/or any other resources related to the accident. Represent your unique thoughts on what you will...
-
Read the Change Metaphor Entitled Who Moved My Cheese and Critically Reflect on the Following Points 1) Being a metaphor in the story, what the Cheese represents in the real life change situation?...
-
The assembly consists of two 20-kg bars which are pin connected. The bars are released from rest when 8 = 60 The 7-kg disk at C has a radius of 0.5 m and rolls without slipping. (Eigure 1) Part A...
-
(a) Employing the intercept technique, determine the average grain size for the steel specimen whose microstructure is shown in Figure (a); use at least seven straight-line segments. (b) Estimate the...
-
In the microscopic view of electrical conduction in a copper wire, electrons are accelerated by an electric field and then collide with metal atoms after traveling about 3.9 10-8 m. If an electron...
-
A school district found that the number of absences in a school increased with the decrease in temperatures. When a correlation coefficient between absences and temperatures was calculated, it was...
-
Change \(12.3 \times 10^{2}\) by moving the decimal five places to the right.
-
The Green Thumb Gardener is a retail store that sells plants, soil, and decorative pots. On December 31, 2016, the firms general ledger contained the accounts and balances that appear below. ACCOUNTS...
-
Holding cash is important to an individual as well as organisation. As a financial manager, you plan to conduct a discussion on "reasons for holding cash from a business organisation point of view"....
-
The University of the Bahamas has two operating departments: School of Business and School of Education. Each of the operating departments uses the services of the company's two support departments:...
-
(i) A 0.54 kg stone is launched vertically from the surface of Earth with an initial speed of 20.0 m/s. Ignoring air resistance, calculate: (a) the maximum height reached by the stone and (b) its...
-
When catering for people in an environment where they have no other catering option such as a care home, aged care, institution etc. It's very important that a range of options exist to cater for...
-
3. A woman's eyebrows are what are called "unibrow". That is, a person can either have two eyebrows, one over each eye, or one fused eyebrow called a unibrow. She seeks genetic counseling to find out...
-
Write an essay of 750 to 1,000 words addressing the following: How can Christian leadership in the criminal justice system assist in the administration of incarcerated persons? Discuss whether an...
-
Explain the user's role in an OS. Explain the differences between kernel applications of the OS and the applications installed by an organization or user. Describe the embedded OS. Describe how the...
-
What role do emerging technologies, such as artificial intelligence, machine learning, blockchain, and augmented reality, play in shaping the future of organizational development, and how can...
-
#2.1: 6-1 How would a financial manager determine optimal capital structure? How this would fit in with the company's capital expenditures, growth plans and operating results? #2.2: 6-2 In a "perfect...
-
In Exercises delete part of the domain so that the function that remains is one-to-one. Find the inverse function of the remaining function and give the domain of the inverse function. f(x) = 16x4 -3...
-
On January 1 of the current year, Yetman Company purchases 40% of the common stock of Livnat Company for $250.000 cash. During the year. Livnat reports $80.000 of net income and pays $60.000 in cash...
-
At the beginning of January, the first month of the accounting year. the supplies account had a debit balance of $825. During January, purchases of $260 worth of supplies were debited to the account....
-
John Wiley and Sons, Inc. publishes books, periodicals, software, and other digital content. Its April 30, 2018, balance sheet reported the following amounts for accounts receivable($ thousands):...
-
7. Plaintiff Miss Universe, Inc., owns the trademark "Miss U.S.A." For decades, the company has produced the Miss U.S.A. beauty pageant, seen by many millions of people in the United States. William...
-
8. YOU BE THE JUDGE WRITING PROBLEM Should trials be televised? Here are a few arguments to add to those in the chapter. You be the judge. Arguments against Live Television Coverage: We have tried...
-
10. ROLE REVERSAL The Role Reversal feature challenges you to create your own exam question. The goal is to think creatively and accurately. Crafting questions is a good way to reinforce what you...
Study smarter with the SolutionInn App