Question: Chapter 6: Applying Excel Please show equations in each cell with a '?' Data Selling price per unit $50 Manufacturing costs: Variable per unit produced:

Chapter 6: Applying Excel Please show equations in each cell with a '?'

Data

Selling price per unit

$50

Manufacturing costs:

Variable per unit produced:

Direct materials

$11

Direct labor

Variable manufacturing overhead

Fixed manufacturing overhead per year

$120,000

Selling and administrative expenses:

Variable per unit sold

Fixed per year

$70,000

Year 1

Year 2

Units in beginning inventory

Units produced during the year

10,000

6,000

Units sold during the year

8,000

Enter a formula into each of the cells marked with a ? below

Review Problem 1: Contrasting Variable and Absorption Costing

Compute the Ending Inventory

Year 1

Year 2

Units in beginning inventory

Units produced during the year

Units sold during the year

Units in ending inventory

Compute the Absorption Costing Unit Product Cost

Year 1

Year 2

Direct materials

Direct labor

Variable manufacturing overhead

Fixed manufacturing overhead

Absorption costing unit product cost

Construct the Absorption Costing Income Statement

Year 1

Year 2

Sales

Cost of goods sold

Gross margin

Selling and administrative expenses

Net operating income

Compute the Variable Costing Unit Product Cost

Year 1

Year 2

Direct materials

Direct labor

Variable manufacturing overhead

Variable costing unit product cost

Construct the Variable Costing Income Statement

Year 1

Year 2

Sales

Variable expenses:

Variable cost of goods sold

Variable selling and administrative expenses

Contribution margin

Chapter 6: Applying Excel

Data
Selling price per unit	$50
Manufacturing costs:
Variable per unit produced:
Direct materials	$11
Direct labor	$6
Variable manufacturing overhead	$3
Fixed manufacturing overhead per year	$120,000
Selling and administrative expenses:
Variable per unit sold	$4
Fixed per year	$70,000

	Year 1	Year 2
Units in beginning inventory	0
Units produced during the year	10,000	6,000
Units sold during the year	8,000	8,000

Enter a formula into each of the cells marked with a ? below
Review Problem 1: Contrasting Variable and Absorption Costing

*Compute the Ending Inventory*
	Year 1	Year 2
Units in beginning inventory	0	?
Units produced during the year	?	?
Units sold during the year	?	?
Units in ending inventory	?	?

*Compute the Absorption Costing Unit Product Cost*
	Year 1	Year 2
Direct materials	?	?
Direct labor	?	?
Variable manufacturing overhead	?	?
Fixed manufacturing overhead	?	?
Absorption costing unit product cost	?	?

*Construct the Absorption Costing Income Statement*
	Year 1	Year 2
Sales	?	?
Cost of goods sold	?	?
Gross margin	?	?
Selling and administrative expenses	?	?
Net operating income	?	?

*Compute the Variable Costing Unit Product Cost*
	Year 1	Year 2
Direct materials	?	?
Direct labor	?	?
Variable manufacturing overhead	?	?
Variable costing unit product cost	?	?

*Construct the Variable Costing Income Statement*
	Year 1		Year 2
Sales		?		?
Variable expenses:
Variable cost of goods sold	?		?
Variable selling and administrative expenses	?	?	?	?
Contribution margin		?		?
Fixed expenses:
Fixed manufacturing overhead	?		?
Fixed selling and administrative expenses	?	?	?	?
Net operating income		?		?

Fixed expenses:

Fixed manufacturing overhead

Fixed selling and administrative expenses

Net operating income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1. Change all of the numbers in the data area of your worksheet so that it looks like this: Data Selling price per unit $292 Manufacturing costs: Variable per unit produced: Direct materials $125...

M5 Variable Costing and Segment Reporting Data Selling price per unit $68 Manufacturing costs: Variable per unit produced: Direct materials $17 Direct labor $8 Variable manufacturing overhead $4...

2. Change all of the numbers in the data area of your worksheet so that it looks like this: B A 1 Chapter 7: Applying Excel 2 3 Data 336 $ $ 144 52 $ 25 $ 92,000 4 Selling price per unit 5...

2. Change all of the numbers in the data area of your worksheet so that it looks like this: B B 1 Chapter 6: Applying Excel 2 4 375 149 $ $ 57 $ 37 10 3 Data Selling price per unit 5 Manufacturing...

Data Selling price per unit $50 Manufacturing costs: Variable per unit produced: Direct materials $11 Direct labor $6 Variable manufacturing overhead $3 Fixed manufacturing overhead per year $120,000...

Data Selling price per unit $50 Manufacturing costs: Variable per unit produced: Direct materials $11 Direct labor $6 Variable manufacturing overhead $3 $120,000 Variable per unit sold $4 Fixed per...

I need to know how to get "cost of goods sold" I dont need the answer, I just need to know how to do it. Thank you Data Selling price per unit $50 Manufacturing costs: Variable per unit produced:...

Please give formulas and show working for every solution. Thank you! Data Selling price per unit $298 Manufacturing costs: Variable per unit produced: Direct materials $114 Direct labor $65 Variable...

Dexter Corporation produces and sells a single product, a wooden hand loom for weaving small items such as scarves. Selected cost and operating data relating to the product for two years are given...

LISA Company produces and sells handbags. Below are the information regarding the product for two most recent years: LISA Company produces and sells handbags. Below are the information regarding the...

Solve the system by inverting the coefficient matrix and using the following theorem: If A is an invertible n x n matrix, then for each nx 1 matrix b, the system of equations Ax = b has exactly one...

During the period, Sanchez Company sold some excess equipment at a loss. The following information was collected from the companys accounting records: No new equipment was bought during the period....

How did the fixed exchange rate against the dollar that Argentina adopted in the 1990s benefit the economy?

How do industry manage demand fluctuaction

3.121 Sally Firefly purchases hardwood lumber for a custom furniture-building shop. She uses three suppliers, Northern Hardwoods, Mountain Top, and Spring Valley. Lumber is classified as either clear...

3.117 Note that this exercise represents a completely imaginary situation. Suppose that a statistics class contained exactly 8 men and 8 women. You have discovered that the teacher decided to assign...

3.116 A record-store owner assesses customers entering the store as high school age, college age, or older, and finds that of all customers 30%, 50%, and 20%, respectively, fall into these...