File

Home

Insert

Draw

Page Layout

Formulas Data

Review

View

Automate

Help

PROTECTED VIEW

Be careful$-$files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.

Enable Editing

A$1$

Function: SUM; Formula: Multiply; Cell Referencing

$4.$

A

B

C

D

E

F

G

$H$

I

J

K

L

PROBLEM

Required: Provide input into cells shaded in yellow in this

Work in Process

template. Use mathematical formulas with cell references to the

For the month of September, the Wilber Pickle Company had Problem or work area as indicated. Use the SUM function with the following costs per equivalent unit for materials $($pickles$,$ cell references to calculate totals. vinegar, spices, etc.$)$ and conversion costs $($labor and overhead$).$

Determine the cost of the ending Work in Process inventory and

Cost per equivalent unit the cost of items completed and transferred to Finished Goods Materials inventory.

Conversion costs

$$0\mathrm{.}80$

$0\mathrm{.}90$

At Wilber Pickle, units are measured in quarts. The company provided the following concerning the number of quarts of pickles on hand, in process, and completed during the month, and the percentages of completion.

$19$

$20$

$21$

$22$

$23$

$24$

$25$

$26$

$27$

$28$

$\backslash$table$[[$Quarts at beginning of month,$600],[$Quarts completed during the month,$4,500],[$Quarts In process at month end,$950],[$Completion of in$-$process units,$],[,$ Materials,$100\%$