The Module 2 excel assignment is from chapter 17, problem 34. Your spreadsheet should have a given section and the initial production report should be completed using the given information. You should set up the problem 17-34 so that you can answer the below "what-if" questions using the production report developed to complete the original textbook problem. In other words, I should see only one production report, that developed to complete the original textbook problem. I should be able to make changes in your given, and the production report outcomes should change simultaneously to be as you presented in your answers to the what-if questions below.

A. What is the total cost of units "transferred out" and in "ending Work-in-Process (WIP)" for each of the following what-if questions:

What if direct materials are added at the beginning of production, cost of beginning WIP direct materials is $9,705,000 and no direct materials costs are added during the period?

What if direct materials are added at the end of production?

What if the cost of units transferred in is 3,500,000?

B. Assuming the original information in problem 17-34, complete part 4 that requires a series of journal entries. Dollar amounts for the journal entries should be linked to the given and original data.

Don't forget to use regression analysis, macros and pivot tables when appropriate if you want to earn the maximum credit for your excel assignment. Good luck on this one. This assignment is due 11:59 pm Friday, February 24th.

i can't upload a spreadsheet here.

17-34

Larsen Company, as you know, is a manufacturer of car seats. Each car seat passes through the assembly department and testing department. This problem focuses on the testing department. Direct materials are added when the testing department process is 90% complete. Conversion costs are added evenly during the testing departments process. As work in assembly is completed, each unit is immediately transferred to testing. As each unit is completed in testing, it is immediately transferred to Finished Goods. Larsen Company uses the weighted-average method of process costing. Data for the testing department for October 2014 are as follows:

Physical Units Transfereed- Direct Conversion

(Car seats) In Cost Material Cost

Work in Progess, October^a 7,500 $2,932,500 $0 $835,460

Tansfered in During October 2014 ?

Completed during October 2014 26,300

Work in progress, October 31^b 3,700

Total cost added during October 2014 $7,717,500 $9,704,700 $3,955,900

a Degree of completion: transferred-in costs,?%; direct materials,?%; conversion costs, 70%. b Degree of completion: transferred-in costs,?%; direct materials,?%; conversion costs, 60%.

Required: 1. What is the percentage of completion for (a) transferred-in costs and direct materials in beginning work-in-process inventory and (b) transferred-in costs and direct materials in ending work-in-process inventory?

2. For each cost category, compute equivalent units in the testing department. Show physical units in the first column of your schedule.

3. For each cost category, summarize total testing department costs for October 2014, calculate the cost per equivalent unit, and assign costs to units completed (and transferred out) and to units in ending work in process.

4. Prepare journal entries for October transfers from the assembly department to the testing department and from the testing department to Finished Goods.