Please Excel format. a way to transfer it into Excel.

Instructions: Please fulfill the Process Costing requirements below. Your answers must be in

Excel Spreadsheet format and should be submitted on Canvas. You must name the file with your

last name, first name and project name.

Project Question:

Mind$56$ Company manufactures car seats in its Fresno plant. Each car seat passes through the

assembly department and the testing department. This problem focuses on the assembly

department. The process$-$costing system at Mind$56$ Company has a single direct$-$cost category

$($direct materials$)$ and a single indirect$-$cost category $($conversion costs$).$ Direct materials are

added at the beginning of the process. Conversion costs are added evenly during the process.

When the assembly department finishes work on each car seat, it is immediately transferred to

testing.

Mind$56$ Company uses the weighted$-$average method of process costing. Data for the

assembly department for October $2021$ are as follows:

Use the Weighted Average Method for the prompts below:

For each cost category, compute equivalent units in the assembly department. Show physical

units in the first column of your schedule.

For each cost category, summarize total assembly department costs for October $2021$ and

calculate the cost per equivalent unit.

Assign costs to units completed and transferred out and to units in ending work in process.

Prepare a set of summarized journal entries for all October $2021$ transactions affecting Work

in Process$-$Assembly. Set up a T$-$account for Work in Process$-$Assembly and post your

entries to it$.$