Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Analytics 01-01 (Static) Cost Concepts [LO1-2, LO1-3, LO1-4] Crispin Companys sales from last year were $8 million. The company maintains no beginning or ending

Excel Analytics 01-01 (Static) Cost Concepts [LO1-2, LO1-3, LO1-4]

Crispin Companys sales from last year were $8 million. The company maintains no beginning or ending inventories. It has assembled all of its costs from last year and would like your assistance in sorting these costs into various categories, depicting them graphically, and preparing traditional and contribution format income statements.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

AWN 8,000,000 8,000,000 8,000,000 14 1 Crispin Company 2 Traditional Format Income Statement 3 4 Sales $ 5 Cost of goods sold 6 Gross margin $ 7 Selling and administrative expenses: 8 Selling 9 Administrative $ 10 Net operating income $ 11 12 13 Crispin Company Contribution Format Income Statement 15 Sales $ 16 Variable expenses: 17 Cost of goods sold 18 Variable selling 19 Variable administrative $ 20 Contribution margin $ 21 Fixed expenses: 22 Fixed manufacturnig overhead 23 Fixed selling 24 Fixed administrative $ 25 Net operating income $ 26 27 28 Fill In 29 Auto-Calc 30 31 8,000,000 8,000,000 ulu 8,000,000 NN 3. Refer to the Income Statements tab within your template. Using the SumlF function to quantify the cost of goods sold, the total selling expense, and the total administrative expense: a. Prepare a traditional format income statement. (Hint: The cost of goods sold should include all direct materials, direct labor, variable manufacturing overhead, and fixed manufacturing overhead costs.) b. Based on the traditional format income statement, what is the gross margin? c. Based on the traditional format income statement, what is the total selling and administrative expense? Complete this question by entering your answers in the tabs below. Req 3A Req 3B Req 3C Prepare a traditional format income statement. (Hint: The cost of goods sold should include all direct materials, direct labor, variable manufacturing overhead, and fixed manufacturing overhead costs.) The cost of goods sold in this income statement is Req Req 3B Req 3C Based on the traditional format income statement, what is the gross margin? The gross margin is Req 3A Req 3B Req 3C Based on the traditional format income statement, what is the total selling and administrative expense? The total selling and administrative expense is AWN 8,000,000 8,000,000 8,000,000 14 1 Crispin Company 2 Traditional Format Income Statement 3 4 Sales $ 5 Cost of goods sold 6 Gross margin $ 7 Selling and administrative expenses: 8 Selling 9 Administrative $ 10 Net operating income $ 11 12 13 Crispin Company Contribution Format Income Statement 15 Sales $ 16 Variable expenses: 17 Cost of goods sold 18 Variable selling 19 Variable administrative $ 20 Contribution margin $ 21 Fixed expenses: 22 Fixed manufacturnig overhead 23 Fixed selling 24 Fixed administrative $ 25 Net operating income $ 26 27 28 Fill In 29 Auto-Calc 30 31 8,000,000 8,000,000 ulu 8,000,000 NN 3. Refer to the Income Statements tab within your template. Using the SumlF function to quantify the cost of goods sold, the total selling expense, and the total administrative expense: a. Prepare a traditional format income statement. (Hint: The cost of goods sold should include all direct materials, direct labor, variable manufacturing overhead, and fixed manufacturing overhead costs.) b. Based on the traditional format income statement, what is the gross margin? c. Based on the traditional format income statement, what is the total selling and administrative expense? Complete this question by entering your answers in the tabs below. Req 3A Req 3B Req 3C Prepare a traditional format income statement. (Hint: The cost of goods sold should include all direct materials, direct labor, variable manufacturing overhead, and fixed manufacturing overhead costs.) The cost of goods sold in this income statement is Req Req 3B Req 3C Based on the traditional format income statement, what is the gross margin? The gross margin is Req 3A Req 3B Req 3C Based on the traditional format income statement, what is the total selling and administrative expense? The total selling and administrative expense is

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting International Edition

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel

6th Edition

978-0470623275

More Books

Students also viewed these Accounting questions

Question

Are your goals SMART?

Answered: 1 week ago