Four days of sales data for the campus bookstore are listed below. Design a cash sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Four days of sales data for the campus bookstore are listed below. Design a cash sales journal in a spreadsheet to record this data so each day is a SINGLE row. Use column headings to indicate the items to record and whether an entry in that column is a debit or credit. Also be sure to include a miscellaneous debit and credit columns with an accompanying column for the account number. Which columns would you total? What do you do with these totals? Include appropriate formulas for those totals. Day 1 $4,687.52 $50.12 $200.88 $212.52 $2,020.32 $1,089.99 $715.67 $900.02 Cash Postage expense Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Day 2 $4,023.44 $300.11 $50.09 $188.06 $1,570.21 $615.02 $1,220.27 $780.08 Cash Drawing – owner Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Day 3 $4,808.95 $215.23 $445.55 $235.77 $2,845.12 $810.03 $890.01 $688.80 Cash Store expense Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Day 4 $4,533.86 $65.01 $100.87 $202.12 $1,460.67 $900.92 $1,020.78 $1,115.25 Cash Freight-in expense Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Four days of sales data for the campus bookstore are listed below. Design a cash sales journal in a spreadsheet to record this data so each day is a SINGLE row. Use column headings to indicate the items to record and whether an entry in that column is a debit or credit. Also be sure to include a miscellaneous debit and credit columns with an accompanying column for the account number. Which columns would you total? What do you do with these totals? Include appropriate formulas for those totals. Day 1 $4,687.52 $50.12 $200.88 $212.52 $2,020.32 $1,089.99 $715.67 $900.02 Cash Postage expense Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Day 2 $4,023.44 $300.11 $50.09 $188.06 $1,570.21 $615.02 $1,220.27 $780.08 Cash Drawing – owner Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Day 3 $4,808.95 $215.23 $445.55 $235.77 $2,845.12 $810.03 $890.01 $688.80 Cash Store expense Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous Day 4 $4,533.86 $65.01 $100.87 $202.12 $1,460.67 $900.92 $1,020.78 $1,115.25 Cash Freight-in expense Sales returns Sales tax payable Sales – textbooks Sales – other books Sales – paper and printing Sales – miscellaneous
Expert Answer:
Answer rating: 100% (QA)
Account Credited Total Sale Sale Debited Net Sales Day Cash Ac Debited Sales Text Book Sales ... View the full answer
Related Book For
Introduction to Probability and Statistics
ISBN: 978-1133103752
14th edition
Authors: William Mendenhall, Robert Beaver, Barbara Beaver
Posted Date:
Students also viewed these mathematics questions
-
In Exercise 12.77 we presented sales data for the Lexus GX, a mid-size sport utility vehicle (SUV) sold in North American and Eurasian markets by Lexus. The sales of the Lexus GX 470 from its...
-
Sales data for the fiscal years 2012, 2013, and 2014 for Bed Bath & Beyond follows (dollars in billions): According to the financial statements, sales increased by 21 percent from 2012 to 2014....
-
Sales data for the fiscal years 2006, 2007, and 2008 for Bed Bath & Beyond follows (dollars in billions): 200620072008 Sales $6.6$7.0$7.2 According to the financial statements, sales creased by 9...
-
Sherene Nili manages a company that produces wedding gowns. She produces both a custom product that is made to order and a standard product that is sold in bridal salons. Her accountant prepared the...
-
You are required to calculate the correlation between intelligence and prejudice in adults. The correlation was -.83. The means and standard deviations necessary for prediction are as follows: a....
-
RCB Ltd. is a large entertainment company with an established customer base and a diversified product portfolio. The company has performed very well and has constantly beaten market's earnings...
-
Shape memory alloys can undergo a reversible phase transformation. These materials display dramatic shape memory temperature-induced deformations that are recoverable. Investigators want to evaluate...
-
Adams, Inc., acquires Clay Corporation on January 1, 2010, in exchange for $510,000 cash. Immediately after the acquisition, the two companies have the following account balances. Clays equipment...
-
1. A scientist measures a piece of steel using a scale in the lab. The scale reports out a mass of 190 grams. However, for their calculations the scientist needs the mass to be in kg. What is the...
-
Suppose there are three types of individuals: high productivity (HP), medium productivity (MP) and low productivity (LP). LP and MP workers amount for a proportion of sizes qL and qM of the entire...
-
What is the tax benefit rule? How is income recognized under the tax benefit rule? When can it be excluded from gross income? when the debtor is insolvent
-
Who oversees developing the value engineering mindset when most of the work is very technical in nature?
-
What are the trends in digital transformations?
-
What are some of the challenges born of organizational culture that you can think of?
-
How prepared are organizations in regard to market segmentation in light of digital transformation on industrial markets to determine the potential acquisition of novel industrial smart services?
-
Should AI be considered a source of costs or revenues?
-
Andretti Company has a single product called a Dak. The company normally produces and sells 81,000 Daks each year at a selling price of $60 per unit. The company's unit costs at this level of...
-
Question 6.10 Current and deferred tax worksheets and tax entries From the hip Ltd?s statement of profit or loss for the year ended 30 June 2007 and extracts from its statements of financial position...
-
Refer to Exercise 6.41. Use the normal approximation to calculate P(x = 5) and P(x 7). Compare with the exact values obtained from Table 1 in Appendix I.
-
Suppose the number of successes observed in n = 500 trials of a binomial experiment is 27. Find a 95% confidence interval for p. Why is the confidence interval narrower than the confidence interval...
-
According to the EPA, chloroform, which in its gaseous form is suspected of being a cancer-causing agent, is present in small quantities in all of the country's 240,000 public water sources. If the...
-
See the option quote on IBM from the CBOE Web site on the next page showing options expiring in March and April 2022. a. Which option contract had the most trades that day? b. Which option contract...
-
You are an options dealer who deals in non-publicly traded options. One of your clients wants to purchase a one-year European call option on HAL Computer Systems stock with a strike price of \($20.\)...
-
It is February 21, 2022, and you have decided to purchase 10 June call contracts on eBays stock with an exercise price of \($57.50.\) Because you are buying, you must pay the ask price. How much...
Study smarter with the SolutionInn App