
13 Paste 8 BI UV Ir avar #22 x & fx D Question 1 (answer requirements...
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...
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...
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...
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...