Where there is a ? mark, there needs to be a formula (+B15-B5) Thanks!
A | B | C | E | F | |
1 | |||||
2 | |||||
3 | Data | ||||
4 | selling price per unit | 50 | |||
5 | manufacturing cost | ||||
6 | variable per unit produced | ||||
7 | direct materials | 11 | |||
8 | direct labor | 6 | |||
9 | variable manufacturing overhead | 3 | |||
10 | fixed manufacturing overhead per year | 120000 | |||
11 | selling and administrative expenses | ||||
12 | variable per unit sold | 4 | |||
13 | fixed per year | 70000 | |||
14 | |||||
15 | year 1 ($) | year 2($) | |||
16 | units in beginning inventory | 0 | |||
17 | units produced during year | 10000 | 6000 | ||
18 | unit solld during year | 8000 | 8000 | ||
19 | |||||
20 | |||||
21 | contrasting variable and absorption costing | ||||
22 | |||||
23 | compute ending inventory | ||||
24 | year 1 ($) | year 2($) | |||
25 | units in beginning inventory | 0 | 2000 | ||
26 | units produced during year | = C17 | =D17 | ||
27 | unit sold during year | =C18 | =D18 | ||
28 | units in ending inventory | =C25+C26-C27 | =D25+D26-D27 | ||
29 | |||||
30 | compute absorption costing unit product cost | ||||
31 | year 1 ($) | year 2($) | |||
32 | direct material | =C7 | =C7 | ||
33 | direct labor | = B8 | = B8 | ||
34 | variable manufacturing overhead | = B9 | = B9 | ||
35 | fixed manufacturing overhead | =B10/B17 | =B10/C17 | ||
36 | absorption costing unit product cost | =SUM(C33:C36) | =SUM(D33:D36 | ||
37 | |||||
38 | construct absorption costing income statement | ||||
39 | year 1 ($) | year 2($) | |||
40 | sales | =B4*B18 | =B4*B18 | ||
41 | cost of goods sold | =B18*C37 | =C18*D37 | ||
42 | gross margin | =C41-C42 | =D41-D42 | ||
43 | selling and admin expenses | =B13+B12*B18 | =B13+B12*C18 | ||
44 | net operating income | =C43-C44 | =D43-D44 | ||
45 | |||||
46 | compute variable costing unit product cost | ||||
47 | year 1 ($) | year 2($) | |||
48 | direct material | =B7 | =B7 | ||
49 | direct labor | =B8 | =B8 | ||
50 | variable manufacturing overhead | =B9 | =B9 | ||
51 | variable costing unit product cost | = SUM(C49:C51) | =SUM(D49:D51) | ||
52 | |||||
53 | construct variable costing income statement | ||||
54 | year 1 ($) | year 2 ($) | |||
55 | sales | =B4*B18 | =B4*B18 | ||
56 | variable expenses | ||||
57 | variable cost of goods sold | = C51*B18 | = D51*C18 | ||
58 | variable selling and admin expenses | =B18*B12 | =C58+C59 | =C18*B12 | =SUM(E58:E59) |
59 | contribution margin | =D56-D59 | =F56-F59 | ||
60 | fixed expenses | ||||
61 | fixed manufacturing expenses | =B10 | =B10 | ||
62 | fixed selling and admin expense | =B13 | =C62+C63 | =B13 | =SUM(E62:E63) |
63 | net operating income | =D60-D63 | =F60-F63 |
Where there is a ? mark, there needs to be a formula (+B15-B5) Thanks! A 1...
Variable vs. Absorption Costing Selling price per unit 50.00 No Video for this worksheet $ Mandturing cost Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead per year 11.00 6.00 REQUIRED: Calculate the unit cost and prepare a traditional Income statements using absorption costing. Calculate the unit cost and prepare a variable costing Income statement. Check your work using the values on the check figure tab. $ 120,000 Selling and administrative expenses Variable per unit...
Variable vs. Absorption Costing $ 50.00 No Video for this worksheet Selling price per unit Manufacturing costs Variable per unit produced: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead per year $ 11.00 REQUIRED: Calculate the unit cost and prepare a traditional 6.00 $ 3.00 120,000 Selling and administrative expenses Variable per unit sold Fixed per year $ 4.00 70,000 Year 1 Units in beginning inventory Units produced during the year Units sold during the year Units in...
Please solve for the cells with question marks and show excel equation A1 X fx Chapter 4: Applying Excel A $4 3 Data 4 Selling price per unit $50 5 Manufacturing costs: 6 Variable per unit produced: 7 Direct materials $11 8 Direct labor $6 9 Variable manufacturing overhead $3 10 Fixed manufacturing overhead per year $120,000 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $70,000 14 15 Year 1 Year 2 16 Units...
Complete Absorption Costing vs. Variable Costing Income statements for Randeris Company, Year 1 & Year 2. RANDERIS COMPANY - YEAR ONE 30,000 25,000 30 $ $ 10 Number of units produced Number of units sold Unit sales price Variable costs per unit: Direct materials, direct labor variable mfg. overhead Selling & administrative expenses Fixed costs per year: Manufacturing overhead Selling & administrative expenses $ 3 $ 150,000 $100,000 RANDERIS COMPANY - YEAR TWO 20,000 25,000 5,000 30 $ Number of...
Lynch Company manufactures and sells a single product. The following costs were incurred during the company's first year of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative $ 15 $ 5 $ 1 $ 1 $ 286,000 $ 196,000 During the year, the company produced 26,000 units and sold 22,000 units. The selling price of the company's product is $46...
value: 4.00 points Lynch Company manufactures and sells a single product. The following costs were incurred during the company's first year of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative $ $ $ $ 13 7 1 1 $ 288,000 $ 198,000 During the year, the company produced 24,000 units and sold 20,000 units. The selling price of the company's...
Lynch Company manufactures and sells a single product. The following costs were incurred during the company's first year of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative $385.000 $295,000 During the year, the company produced 35,000 units and sold 17,000 units. The selling price of the company's product is $58 per unit. Required: 1. Assume that the company uses absorption...
Review Problem 1: Contrasting Variable and Absorption Costing 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 below: 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....... $4 Fixed per...
Exercise 5-9 Variable and Absorption Costing Unit Product Costs and Income Statements [LO5-1, LO5-2, LO5-3] Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expenses $ $ 240,000 60,000 During its first year of operations, Walsh produced 50,000 units and sold...
Rainbow Concrete Corporation has provided the following data for its two most recent years of operation: Selling price per unit $88 Manufacturing costs: Variable manufacturing cost per unit produced: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead per year Selling and administrative expenses: Variable selling and administrative expense per unit sold Fixed selling and administrative expense per year 360,000 74,000 Year 1 Units in beginning inventory Units produced during the year Units sold during the year Units in...