Share

Cut

Liberation San $*$

$12$

A

Wrap Text

Merge & Center

Text

Formatting $-$

Table $-$ Styles ~

Insert Delete Format

AutoSum

Format Painter

B $I{U}_{?}$

Font

Alignment

Number

Styles

Cells

Clear

Sort & Find &

Filter $-$ Select $$

Editing

A

Formula: Add, Subtract; Cell Referencing

Using Excel to Calculate Manufacturing Costs

PROBLEM

Presented below are incomplete manufacturing cost data.

$\backslash$table$[[\backslash$table$[[$Direct$],[$Materials$]],$Direct Labor,$\backslash$table$[[$Factory$],[$Used$]],\backslash$table$[[$Total$],[$Osed$]]],[$$$40,000,$$$61,000,$$$50,000,$Manufacturing$],[$Costs$,,,]]$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Use the SUM function when indicated.

Determine the missing amounts for three different situations.

Total manufacturing costs $ $14,{000}^T$

Direct materials used $ $15,000$

Direct labor used

$ $14,000$

Enter Answer

Type here to search

$3$:$07$ PM

$1/16/2025$