please complete problem and steps through excel ...
60.1K
Verified Solution
Question
Accounting
please complete problem and steps through excel
E5-35A. Complete five-step procedure in first department (Learning Objective 3) Paulson Winery in Albany, New York, has two departments: Fermenting and Packaging. Direct materials are added at the beginning of the fermenting process (grapes) and at the end of the packaging process (bottles). Conversion costs are incurred evenly throughout each process. Data from the month of March for the Fermenting Department are as follows: Gallons: Beginning work in process inventory 2,100 gallons Started production 5,860 gallons Completed and transferred out to Packaging in March 6,560 gallons Ending work in process inventory 180% of the way through the 1,400 gallons fermenting process) Costs: Beginning work in process inventory ($2,500 of direct materials and $3,715 of conversion cost) $6,215 Costs added during March: Direct materials Direct labor Manufacturing overhead $9,440 600 1,829 Total costs added during March $11,869 1. Draw a timeline for the Fermenting Department. 2. Summarize the flow of physical units and compute the total equivalent units. 3. Summarize total costs to account for and compute the cost per equivalent unit for direct materials and conversion costs. 4. Assign total costs to units (gallons): a. Completed and transferred out to the Packaging Department b. In the Fermenting Department ending work in process inventory 5. What is the average cost per gallon transferred out of Fermenting into Packaging? Why would the company's managers want to know this cost
please complete problem and steps through excel



Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.