Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 5R
To determine
Analyze the pattern of behavior of quarterly sales and actual gross profit. Also, comment on the favorable and unfavorable trends.
To determine
Compute the ending merchandise inventory.
To determine
Prepare a chart showing the relationship between gross profit percentage and ending merchandise inventory.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Presented below is information for Oriole Co. for the month of January 2025. Cost of goods sold Freight-out Insurance expense Salaries and wages expense Income tax expense (a) $208,050 9,000 14,400 62,700 7,750 Prepare a multiple-step income statement. Rent expense Sales discounts Sales returns and allowances Sales revenue ORIOLE CO. Income Statement $33,900 9,000 19,500 393,500
The following is select account information for August Sundries: Sales: $850,360; Sales Returns and Allowances: $148,550; Cost of Goods Sold: $300,840; Operating Expenses: $45,770; and Sales Discounts: $231,820.
PLEASE NOTE: All dollar amounts will have "$" and commas, where needed (i.e. $12,345).
If August Sundries uses a multi-step income statement format, what is their gross margin?
Freedman Company estimates that sales this year of $12,000 will be returned next year and customers will be granted a full refund. Which of the following journal entries would Freedman Company record as part of its year-end adjustments assuming it uses the perpetual inventory system?
a.Debit Estimated Returns Inventory for $12,000 and credit Income Summary for $12,000
b.Debit Sales Returns and Allowances for $12,000 and credit Cost of Goods Sold for $12,000
c.Debit Inventory Short and Over for $12,000 and credit Merchandise Inventory for $12,000
d.Debit Sales Returns and Allowances for $12,000 and credit Customer Refunds Payable for $12,000
Chapter 8 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Similar questions
- The following is select account information for August Sundries. Sales: $850,360; Sales Returns and Allowances: $148,550; COGS: $300,840; Operating Expenses: $45,770; Sales Discounts: $231,820. If August Sundries uses a multi-step income statement format, what is their gross margin?arrow_forwardThe following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and Allowances: $34,890; COGS: $120,470; Sales Discounts: $44,760. Given this information, what is the Gross Profit Margin Ratio for Sunrise Motors? (Round to the nearest whole percentage.)arrow_forwardGolden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.arrow_forward
- Bay Book and Software has two sales departments: Book and Software. After recording and posting all adjustments, including the adjustments for merchandise inventory, the accountant prepared the adjusted trial balance (shown on the next page) at the end of the fiscal year. Merchandise inventories at the beginning of the year were as follows: Book Department, 53,410; Software Department, 23,839. The bases (and sources of figures) for apportioning expenses to the two departments are as follows (rounded to the nearest dollar): Sales Salary Expense (payroll register): Book Department, 45,559; Software Department, 35,629 Advertising Expense (newspaper column inches): Book Department, 550 inches; Software Department, 450 inches Depreciation Expense, Store Equipment (property and equipment ledger): Book Department, 7,851; Software Department, 2,682 Store Supplies Expense (requisitions): Book Department, 205; Software Department, 199 Miscellaneous Selling Expense (volume of gross sales): Book Department, 240; Software Department, 110 Rent Expense and Utilities Expense (floor space): Book Department, 9,000 square feet; Software Department, 7,000 square feet Bad Debts Expense (volume of gross sales): Book Department, 1,029; Software Department, 441 Miscellaneous General Expense (volume of gross sales): Book Department, 364; Software Department, 156 Required Prepare an income statement by department to show income from operations, as well as a nondepartmentalized income statement (using the Total columns) to show net income for the entire company.arrow_forwardUnder the periodic inventory system, what account is credited when an estimate is made for sales made this year, but expected to be returned next year? (a) Merchandise Inventory (b) Customer Refunds Payable (c) Sales (d) Sales Returns and Allowancesarrow_forwardRiverbed Company had the following account balances at year-end: Cost of Goods Sold $62,380, Inventory $14,410, Utilities Expense $32,500, Sales Revenue $126,790, Sales Discounts $1,170, and Sales Returns and Allowances $1,700. A physical count of inventory determines that merchandise inventory on hand is $12,360. They use the perpetual inventory system. (a) Prepare the adjusting entry necessary as a result of the physical count. (List all debit entries before credit entries. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Account Titles and Explanation Debit Credit enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount (b) Prepare closing entries. (List all debit entries before credit entries. Credit account titles are automatically…arrow_forward
- The Happy Auto Shop has the following annual information: Gross Sales, $700,000; Net Sales, $696,000; Gross Profit, $448,000. What are the shop’s returns and allowances and cost of goods sold? Give an overall detailed response.arrow_forwardAssume the perpetual inventory system is used unless stated otherwise. Round all numbers to the nearest whole dollar unless stated otherwise. Journalizing sales transactions Journalize the following sales transactions for Salem Sportswear. Explanations are not required. The company estimates sales returns at the end of each month.arrow_forwardThe Happy Auto Shop has the following annual information: gross sales,$700,000; net sales, $696,000; and gross profit, $448,000. What are theshop’s returns and allowances and cost of goods sold?arrow_forward
- Presented below is information for Pharoah Company for the month of March 2020. Cost of goods sold $217,820 Rent expense $32,720 Freight-out 7,150 Sales discounts 8,080 Insurance expense 5,680 Sales returns and allowances 13,270 Salaries and wages expense 57,060 Sales revenue 386,560 Prepare a multiple-step income statement. (If there is a net loss then enter the amount using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Compute the gross profit rate. (Round answer to 2 decimal places, e.g. 25.20%.)arrow_forwardAt the end of the year, a company has to record an adjusting entry for the amount of sales made in the current year that it expects will be returned in the next year. Assuming the periodic inventory system is used, which of the following adjusting entries would record this estimate? a.Debit Sales Returns and Allowances and credit Merchandise Inventory b.Debit Income Summary and credit Estimated Returns Inventory c.Debit Estimated Returns Inventory and credit Cost of Goods Sold d.Debit Sales Returns and Allowances and credit Customer Refunds Payablearrow_forwardCARDO Company suspects that there is missing inventory in its warehouse at December 31, 2021. All sales and purchases were made on account. Also, the gross profit rate based on net sales is consistent every year. To aid in your investigation, you obtained the following: How much is the cost of sales based on the historical gross profit rate?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,