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...
-
Use Simpsons rule with n = 10 to estimate the arc length of the curve. Compare your answer with the value of the integral produced by your calculator.
-
You can select one or more answers. Note you must get the complete right combination to get your marks, no partial marks. Which statement(s) is/are FALSE? A. For all a, b, c ER\O, a+(b+c)=(a+b)+(a+c)...
-
List three or four criteria you could use to qualify a lead as a likely prospect. How would you find out if the lead meets these criteria?
-
An inexperienced accountant prepared this condensed income statement for Hight Company, a retail firm that has been in business for a number of years. HIGHT COMPANY Income Statement For the Year...
-
The UPS Strike of 1996 Win-Lose Negotiation (case study) 1.This was a distributive negotiation. Based on in-class discussion and readings, what are the reasons that this was a distributive situation?...
-
Record the following petty cash transactions of Lexite Laminated Surfaces in general journal form (explanations are not required): Apr. 1 Established a petty cash fund with a $200 balance. 30 The...
-
Lonely Planet provides travel services on the Internet, 2011 was an important year for Lonely Planet as it reported positive operating income after 3 years of operating losses. In the first quarter...
-
According to ASC 410-20, is an oral agreement between parties a legally enforceable obligation? a. Yes. b. No. c. It depends.
-
In some contracts the contractor is required to set aside a portion of its share of production for sale in the local market. This provision is referred to as______________. a. Capital uplift b....
-
Are full cost companies required to book AROs? a. Yes. b. No. c. It depends.
-
Give examples of events or circumstances that may trigger impairment testing.
-
_______________ is an incentive offered by the government to encourage the contractor to maximize investment. a. Cost oil b. Profit oil c. Capital uplift d. Overriding royalty e. Domestic market...
-
Consider a supermassive black hole with mass: MBH = 106 Msun. An observation station is in a circular orbit around the black hole at a distance of 1,000,000 km from the event horizon. The distant...
-
In Exercises find dy/dx by implicit differentiation. xy - y = x
-
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):...
-
Briefly explain the budgetary variances and the way it is used.
-
What do we mean by budgeting, and how would this process serve the firm?
-
Briefly describe the two most common types of budget.
Study smarter with the SolutionInn App