6th Edition

ISBN: 9781260664386

Author: PHILLIPS, LIBB

Publisher: MCG

See similar textbooks

Videos

Textbook Question

Chapter 6, Problem 6SDC

Preparing Multistep Income Statements and Calculating Gross Profit Percentage

Assume that you have been hired by Big Sky Corporation as a summer intern. The company is in the process of preparing its annual financial statements. To help in the process, you are asked to prepare an income statement for internal reporting purposes and an income statement for external reporting purposes. Your boss also has requested that you determine the company’s gross profit percentage based on the statements that you are to prepare. The following adjusted trial balance was created from the general ledger accounts on December 31.

Chapter 6, Problem 6SDC, Preparing Multistep Income Statements and Calculating Gross Profit Percentage Assume that you have , example 1

As the trial balance shows, Big Sky tracks sales returns, allowances, and discounts in separate accounts that are subtracted from the (gross) Sales Revenue to determine Net Sales. These offsetting accounts for Sales Returns and Allowances and Sales Discounts are called “contra-revenue” accounts. Your boss wants you to create the spreadsheet in a way that automatically recalculates net sales and any other related amounts whenever changes are made to the contra-revenue accounts. To do this, you know that you’ll have to use formulas throughout the worksheets and even import or link cells from one worksheet to another. Your friend Owen, an accountant, is willing to help.

From:	Owentheaccountant@yahoo.com
To:	Helpme@hotmail.com
Cc:
Subject:	Excel Help

Sounds like you are going to get some great experience this summer. Okay, to import a number from another spreadsheet, you first click on the cell where you want the number to appear. For example, if you want to enter the Net Sales balance in the external income statement, click on the cell in the external income statement where the Net Sales number is supposed to appear. Enter the equals sign (=) and then click on the tab that takes you to the worksheet containing the internal income statement. In that worksheet, click on the cell that contains the amount you want to import into the external income statement and then press enter. This will create a link from the internal income statement cell to the external income statement cell. Here’s a screen shot showing the formula that will appear after you import the number.

Chapter 6, Problem 6SDC, Preparing Multistep Income Statements and Calculating Gross Profit Percentage Assume that you have , example 2

Don’t forget to save the file using a name that indicates who you are.

Required:

Enter the trial balance information into a spreadsheet and complete the following:

1. Prepare a multistep income statement that would be used for internal reporting purposes, by classifying sales returns and allowances and sales discounts as contra-revenue accounts, and subtracting them from Sales Revenue to show Net Sales.
2. Prepare a multistep income statement that would be used for external reporting purposes, beginning with the amount for Net Sales.
3. Compute the gross profit percentage (round to one decimal place).

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 6, Problem 5SDC

Chapter 6, Problem 1CC

Students have asked these similar questions

Micah Levi works in the payroll department at Radiance Windows. The employer has determined that the payroll functions should be moved to a Cloud-based platform that can support its 500 employees, be used remotely, and has requested recommendations. What options could Micah propose? check all that apply SSL, VPN, and CAPTCHA tools Administration of payroll Employee security and confidentiality Online options with mobile access

Grass Reed Bayou is a bottling company in The Netherlands. The company uses a normal costing system in which factory overhead is applied on the basis of direct labor costs. Budgeted factory overhead for the year was $680,000, and management budgeted $320,000 of direct labor costs. During the year, the company incurred the following actual costs. Direct materials used $ 382,000 Direct labor 313,000 Factory overhead 650,700 The January 1 balances of inventory accounts are shown below. Materials-all direct $ 64,000 Work-in-process 41,400 Finished goods 25,600 The December 31 balances of these inventory accounts were ten percent lower than the balances at the beginning of the year. The cost of goods manufactured during the year is:

Magna Carta Interiors is a job-order manufacturer. The company uses a predetermined overhead rate based on direct labor hours to apply overhead to individual jobs. For the current year, estimated direct labor hours are 150,000 and estimated factory overhead is $1,140,000. The following information is for September. Job X was completed during September, while Job Y was started but not finished. September 1, inventories: Materials $ 25,700 Work-in-process (All Job X) 55,100 Finished goods 107,300 Materials purchases $ 174,000 Direct materials requisitioned: Job X $ 75,700 Job Y 69,700 Direct labor hours: Job X 8,700 Job Y 7,200 Labor costs incurred: Direct labor ($7.70 per hour) $ 122,430 Indirect labor 50,100 Factory supervisory salaries 12,800 Rental costs: Factory $ 11,000 Administrative offices 4,900 Total equipment depreciation costs: Factory $ 12,100 Administrative offices 4,500 Indirect materials used $ 30,400 The total…

Chapter 6 Solutions

FUNDAMENTALS OF FINANCIAL ACCOUNTING

Ch. 6 - Prob. 1Q Ch. 6 - If a Chicago-based company ships goods on...Ch. 6 - Define goods available for sale. How does it...Ch. 6 - Define beginning inventory and ending inventory.Ch. 6 - Describe how transportation costs to obtain...Ch. 6 - What is the main distinction between perpetual and...Ch. 6 - Why is a physical count of inventory necessary in...Ch. 6 - What is the difference between FOB shipping point...Ch. 6 - Describe in words the journal entries that are...Ch. 6 - What is the distinction between Sales Returns and...

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Solution Summary: The author explains how to prepare the multi-step income statement for internal reporting purposes and calculate the gross profit percentage of Corporation B.

Videos

Want to see the full answer?

Chapter 6 Solutions