Homework Answers
As per policy, only one question or its first four parts are allowed to answer at a time, so answering here Q1 for you:
Answer 1)
|
88000 |
ADF |
|
2000 |
ADF |
|
15000 |
ADF |
|
4000 |
ADF |
|
26000 |
ADF |
|
78000 |
ADF |
|
1000 |
ADF |
|
2000 |
ADV |
|
2220000 |
DMCV |
|
1365000 |
DMCV |
|
18000 |
MOFV |
|
13000 |
MOHV |
|
8000 |
MOHV |
|
24000 |
MOHV |
|
20000 |
MOHV |
|
6000 |
MOHV |
|
79000 |
MOHV |
|
400000 |
MOHF |
|
300000 |
MOHF |
|
50000 |
MOHF |
|
15000 |
MOHF |
|
10000 |
MOHF |
|
60000 |
MOHF |
|
65000 |
MOHF |
|
58000 |
MOHF |
|
72000 |
MOHF |
|
68000 |
MOHF |
|
170000 |
MOHF |
|
93000 |
MOHF |
|
38000 |
MOHF |
|
99000 |
MOHF |
|
12000 |
MOHF |
|
24000 |
MOHF |
|
26000 |
MOHF |
|
18000 |
MOHF |
|
45000 |
MOHF |
|
13000 |
MOHF |
|
165000 |
MOHF |
|
89000 |
MOHF |
|
56000 |
MOHF |
|
48000 |
MOHF |
|
44000 |
MOHF |
|
18000 |
MOHF |
|
165000 |
MOHF |
|
400000 |
SF |
|
120000 |
SF |
|
480000 |
SV |
|
Summary of Costs: |
|
|
Admin Fixed exp. |
214000 |
|
Admin Varia. exp. |
2000 |
|
Direct Cost |
3585000 |
|
Manuf OH fixed |
2221000 |
|
Manuf OH Varia. |
168000 |
|
Selling Fixed |
520000 |
|
Selling Varia. |
480000 |
|
Traditional Income Statement |
|
|
Sales |
8000000 |
|
Less:COGS |
5974000 |
|
Gross Margin |
2026000 |
|
Less:Selling & Admin exp.: |
|
|
Selling |
1000000 |
|
Administrative |
216000 |
|
NOI |
810000 |
|
Contribution Income Statement: |
|
|
Sales |
8000000 |
|
Less: variable exp.: |
|
|
COGS |
3753000 |
|
Variable selling |
480000 |
|
Variable Admin |
2000 |
|
Contribution |
3765000 |
|
Less:Fixed expense: |
|
|
Fixed Manuf. OH |
2221000 |
|
Fixed Selling |
520000 |
|
Fixed Admin |
214000 |
|
NOI |
810000 |
Add Answer to:
AutoSave OFF Esu = ExcelAnalytics_CostConcepts_Template (1) Home Insert Draw Page Layout Formulas Data Review View Tell...
AutoSave OFF Esu = ExcelAnalytics_CostConcepts_Template (1) Home Insert Draw Page Layout Formulas Data Review View Tell...
AutoSave OFF Esu = ExcelAnalytics_CostConcepts_Template (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) "A Insert 11 = = Σν ab Wrap Text Custom 48- 0 DX Delete Paste B I U Av * Merge & Center C%) Ideas Cell Styles Conditional Format Formatting as Table Sensitivity Sort & Filter A Format Find & Select G16 fx A B с D E F G 1 2 Account 3 Equipment depreciation: Molding 4...
Crispin Company’s sales from last year were $8 million. The company maintains no beginning or ending...
Crispin Company’s 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.
2. Using PivotTable and Charts:
a. Calculate the company’s total variable costs
and total fixed costs.
The total variable costs
are.
The total fixed costs are
b. Calculate...
Crispin Company’s sales from last year were $8 million. The company maintains no beginning or ending...
Crispin Company’s 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. (Using
Excel)
1. Go to the “Cost Summary” tab. Using
PivotTable and Charts:
a. Calculate the company’s total product costs
and total period costs.
b. Calculate the portions of the...
Insert Page Layout Formulas Home Data Review View ACROBAT Add-ins Team Tell me Calibri 11 AA==...
Insert Page Layout Formulas Home Data Review View ACROBAT Add-ins Team Tell me Calibri 11 AA== . Wrap Text General Copy BIU. 3. S.A $ Merge & Center - % Format Painter 88 Condit * Format Font Alignment Number - X Manufacturing overhead (MOH) board Requirementi a. Identify the following as either a product cost or a period cost. b. Select the appropriate product cost category, or select expense. Description Cost Classification Coconut flakes used in the cookies. Product Depreciation...
Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to...
Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = = ). General Calibri B I 11 . Font - A A . .A. Wrap Text Merge & Center. U $ . % * 3 Alignment Number Clipboard R14 4. A . B C D G H nter the last 4 digits of your student ID number 4 Name/s: 7 Save this file in EXCEL FORMAT as: P2 Lastname 8 Round all...
Formulas Data Review View Share Comments Home Insert Draw Page Layout C18 A XV fx? B...
Formulas Data Review View Share Comments Home Insert Draw Page Layout C18 A XV fx? B 1 Chapter 1: Applying Excel C D E F G H I J K L M N O P Q R S T U $12.000 3 4 5 8 7 B 9 10 11 Data Salas Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed seling Fixed administrative $6.000 $500 $400 32.500 $1.500 12 13 Enter a famulinda each of...
FILE HOME INSERT P AGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AÁ -...
FILE HOME INSERT P AGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AÁ - A Paste B I U , Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font X A1 for To aid in planning, Jay Corporation is preparing a contribution format income o aid in planning, Jay Corporation is preparing a contribution format income statement. udgeted information for Quarter 1 of Year 3: Sales in units Sales price per unit 17,000...
AutoSave OFF 5 = Home View Insert Draw Page Layout Formulas Data Review Calibri (Body) 11...
AutoSave OFF 5 = Home View Insert Draw Page Layout Formulas Data Review Calibri (Body) 11 A A = = = BIU CA E Paste 2 Wrap Text Merge & Cent 23 x ✓ fx $6,300 A B Question 3 (answer requirements a, b and c) C D н (5 points for part a, 6 points for part b, and 5 points for c) Hudson Incoporated currently uses a job-order costing system and applies manufacturing overhead with a predetermined overhead...
Autent %* Excellerplignment, CNT). Protected in File Home insert Draw Page Layout Formulas Data Review View...
Autent %* Excellerplignment, CNT). Protected in File Home insert Draw Page Layout Formulas Data Review View Help Quichols FOLLCHED VW Be careful files from the more con contain viruses. Une you need to det e to vay in Protected View Enable Iding xo CD GHKLMNL01 1 E1-12 Prepare a cost of goods man actured schedule and a partial income statement 2 Cepeda Corporation has the following cost records for June 2017 Indirect factory labor $4,500 Factory ilities $400 Direct materials...
3 (a) Calculate variable cost per unit. Current Designs.xls Data Review View Home Insert Page Layout...
3 (a) Calculate variable cost per unit. Current Designs.xls Data Review View Home Insert Page Layout Formulas Kevlar Kevlar Resin and supplies Finishing kit (seat, rudder, ropes, etc.) Labor Selling and administrative expenses - variable Total variable costs per unit 2 Resin and supplies 3 Finishing kit (seat, rudder, ropes, etc.) 4 Labor 5 Selling and administrative expenses variable 6 Selling and administrative expenses—fixed 7 Manufacturing overhead-fixed $250 per kayak $100 per kayak $170 per kayak $420 per kayak $400...
AutoSave OFF Esu = ExcelAnalytics_CostConcepts_Template (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) "A Insert 11 = = Σν ab Wrap Text Custom 48- 0 DX Delete Paste B I U Av * Merge & Center C%) Ideas Cell Styles Conditional Format Formatting as Table Sensitivity Sort & Filter A Format Find & Select G16 fx A B с D E F G 1 2 Account 3 Equipment depreciation: Molding 4...
Crispin Company’s 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.
2. Using PivotTable and Charts:
a. Calculate the company’s total variable costs
and total fixed costs.
The total variable costs
are.
The total fixed costs are
b. Calculate...
Crispin Company’s 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. (Using
Excel)
1. Go to the “Cost Summary” tab. Using
PivotTable and Charts:
a. Calculate the company’s total product costs
and total period costs.
b. Calculate the portions of the...
Insert Page Layout Formulas Home Data Review View ACROBAT Add-ins Team Tell me Calibri 11 AA== . Wrap Text General Copy BIU. 3. S.A $ Merge & Center - % Format Painter 88 Condit * Format Font Alignment Number - X Manufacturing overhead (MOH) board Requirementi a. Identify the following as either a product cost or a period cost. b. Select the appropriate product cost category, or select expense. Description Cost Classification Coconut flakes used in the cookies. Product Depreciation...
Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = = ). General Calibri B I 11 . Font - A A . .A. Wrap Text Merge & Center. U $ . % * 3 Alignment Number Clipboard R14 4. A . B C D G H nter the last 4 digits of your student ID number 4 Name/s: 7 Save this file in EXCEL FORMAT as: P2 Lastname 8 Round all...
Formulas Data Review View Share Comments Home Insert Draw Page Layout C18 A XV fx? B 1 Chapter 1: Applying Excel C D E F G H I J K L M N O P Q R S T U $12.000 3 4 5 8 7 B 9 10 11 Data Salas Variable costs: Cost of goods sold Variable selling Variable administrative Fixed costs: Fixed seling Fixed administrative $6.000 $500 $400 32.500 $1.500 12 13 Enter a famulinda each of...
FILE HOME INSERT P AGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AÁ - A Paste B I U , Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font X A1 for To aid in planning, Jay Corporation is preparing a contribution format income o aid in planning, Jay Corporation is preparing a contribution format income statement. udgeted information for Quarter 1 of Year 3: Sales in units Sales price per unit 17,000...
AutoSave OFF 5 = Home View Insert Draw Page Layout Formulas Data Review Calibri (Body) 11 A A = = = BIU CA E Paste 2 Wrap Text Merge & Cent 23 x ✓ fx $6,300 A B Question 3 (answer requirements a, b and c) C D н (5 points for part a, 6 points for part b, and 5 points for c) Hudson Incoporated currently uses a job-order costing system and applies manufacturing overhead with a predetermined overhead...
Autent %* Excellerplignment, CNT). Protected in File Home insert Draw Page Layout Formulas Data Review View Help Quichols FOLLCHED VW Be careful files from the more con contain viruses. Une you need to det e to vay in Protected View Enable Iding xo CD GHKLMNL01 1 E1-12 Prepare a cost of goods man actured schedule and a partial income statement 2 Cepeda Corporation has the following cost records for June 2017 Indirect factory labor $4,500 Factory ilities $400 Direct materials...
3 (a) Calculate variable cost per unit. Current Designs.xls Data Review View Home Insert Page Layout Formulas Kevlar Kevlar Resin and supplies Finishing kit (seat, rudder, ropes, etc.) Labor Selling and administrative expenses - variable Total variable costs per unit 2 Resin and supplies 3 Finishing kit (seat, rudder, ropes, etc.) 4 Labor 5 Selling and administrative expenses variable 6 Selling and administrative expenses—fixed 7 Manufacturing overhead-fixed $250 per kayak $100 per kayak $170 per kayak $420 per kayak $400...
Most questions answered within 3 hours.
-
Which DNA primer would have the HIGHEST melting temperature?
Question 17 options:
a)
GCATCGGC
b)
AATCGGAT...
asked 5 minutes ago -
what is the charge on the chromium ion in Cr2O3.
a -3
b -2
c 0...
asked 5 minutes ago -
which of the following may lead to speciation?
a. a group of individuals from a mainland...
asked 11 minutes ago -
Please I need today answer for This question and it is very
important and I need...
asked 29 minutes ago -
Five years from today, you plan to invest $3,700 for 7
additional years at 5.8 percent...
asked 29 minutes ago -
GDL just paid a dividend of $4.06 per share. You expect
dividends to grow 12% for...
asked 31 minutes ago -
which of the following is a basic compound?
vinegar
orange juice
seltzer
none of the above
asked 34 minutes ago -
5. Suppose you obtained 0.55 g of crude clove oil from 7.0 g of
fresh cloves....
asked 44 minutes ago -
Provide a paragraph of introduction that generally describes
cognitive development over the lifespan.
asked 49 minutes ago -
In a market, when the price increased the total expenditure on
the good also increased. Is...
asked 49 minutes ago -
If 5.70 g of potassium react with water, how many grams of
hydrogen gas, H2, are...
asked 1 hour ago -
How many moles of CO2 and H2O will be
produced by combustion analysis of 0.010 mol...
asked 1 hour ago