Answered step by step
Verified Expert Solution
Question
1 Approved Answer
First-In, First-Out Method; Equivalent Units Aztec Inc. produces soft drinks. Mixing is the first department, and its output is measured in gallons. Aztec uses the
First-In, First-Out Method; Equivalent Units | |||||||||||||||||||||||
Aztec Inc. produces soft drinks. Mixing is the first department, and its output is measured in gallons. Aztec uses the FIFO method. All manufacturing costs are added uniformly. For July, the mixing department provided the following information: | undefined | ||||||||||||||||||||||
| |||||||||||||||||||||||
DATA | undefined | ||||||||||||||||||||||
Production: | |||||||||||||||||||||||
Units in process, July 1, | 80% | complete | 60,000 | gallons | |||||||||||||||||||
Units completed and transferred out | 414,000 | gallons | |||||||||||||||||||||
Units in process, July 31, | 75% | complete | 48,000 | gallons | |||||||||||||||||||
Costs: | |||||||||||||||||||||||
Work in process, July 1 | $72,000 | ||||||||||||||||||||||
Costs added during July | 882,900 | ||||||||||||||||||||||
Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Amount column. Use the blue cells (C18:C20, C26:C28) for intermediate calculations. Transfer the numeric results for the green entry cells (C21, C23, C29, C31) into the appropriate fields in CNOWv2 for grading. | undefined | ||||||||||||||||||||||
Required: | |||||||||||||||||||||||
1. | Amount | Formulas | undefined | ||||||||||||||||||||
Units in BWIP | undefined | ||||||||||||||||||||||
Units started and completed | undefined | ||||||||||||||||||||||
Units in EWIP | undefined | ||||||||||||||||||||||
Total equivalent units for July | undefined | ||||||||||||||||||||||
2. Unit cost | undefined | ||||||||||||||||||||||
3. Cost of units transferred out: | |||||||||||||||||||||||
BWIP Cost | undefined | ||||||||||||||||||||||
Units in BWIP | undefined | ||||||||||||||||||||||
Units started and completed | undefined | ||||||||||||||||||||||
Total cost of units transferred out | undefined | ||||||||||||||||||||||
Cost of units in EWIP | undefined | ||||||||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started