As the cost manager/accountant of XYZ Company, you have been provided with the following information. Use...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As the cost manager/accountant of XYZ Company, you have been provided with the following information. Use Excel to complete the assignment. EXAMPLE EXCEL FILE FORMAT All blank spaces should be formulas using the data provided from this Word Document. Units charged to production: Inventory in process, January 1 Karachi Carpet Company Cost of Production Report-Cutting Department For the Month Ended January 31 Unit Information Equivalent Units Whole Units Direct Materials Conversion Specifics Amount ($) Inventory in process, April 1, 7,000 gallons: Direct materials cost, for 7,000 gallons 7,000 Conversion costs, for 7,000 gallons, 70% completed 3,225 Total inventory process, April 1 10,225 Direct materials cost for April, 62,000 gallons 68,000 Received from Weaving Department Total units accounted for by the Cutting Department Units to be assigned costs: Inventory in process, January 1 Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Direct labor cost for April 12,500 Total units to be assigned cost Factory overhead applied for April 9,275 Total production cost to account for 100,000 Gallons transferred to Packaging in April (includes units in process ? Cost per equivalent unit: on April 1), 64,000 gallons Inventory in process, April 30, 5,000 gallons, 25% conversion costs ? Total costs for January in Cutting Department Total equivalent units Cost per equivalent unit Costs assigned to production: Requirements Inventory in process, January 1 Costs incurred in January a. Turn in EXCEL file using FORMULAS to complete the cost sheet. (50 points) b. Find the total number of units to be assigned cost during the month of April? (5 points) c. What are the total equivalent units for Direct materials? (5 points) d. What are the total equivalent units for conversion cost? (10 points) e. What is the cost per equivalent unit for direct materials? (5 points) f. What is the convention cost per equivalent unit? (5 points) Total costs accounted for by the Cutting Department Costs allocated to completed and partially completed units: Inventory in process, January 1 balance To complete inventory in process, January 1 Cost of completed January 1 work in process Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Total costs assigned by the Cutting Department g. Allocate cost to units transferred out and partially completed. (10 points) h. Considering the current economic conditions, would you recommend your company outsource raw materials from China or get them from the U.S. Explain the reason for your decision in paragraph format. (10 points) Cost Information Direct Materials Conversion Direct Materials Conversion Total As the cost manager/accountant of XYZ Company, you have been provided with the following information. Use Excel to complete the assignment. EXAMPLE EXCEL FILE FORMAT All blank spaces should be formulas using the data provided from this Word Document. Units charged to production: Inventory in process, January 1 Karachi Carpet Company Cost of Production Report-Cutting Department For the Month Ended January 31 Unit Information Equivalent Units Whole Units Direct Materials Conversion Specifics Amount ($) Inventory in process, April 1, 7,000 gallons: Direct materials cost, for 7,000 gallons 7,000 Conversion costs, for 7,000 gallons, 70% completed 3,225 Total inventory process, April 1 10,225 Direct materials cost for April, 62,000 gallons 68,000 Received from Weaving Department Total units accounted for by the Cutting Department Units to be assigned costs: Inventory in process, January 1 Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Direct labor cost for April 12,500 Total units to be assigned cost Factory overhead applied for April 9,275 Total production cost to account for 100,000 Gallons transferred to Packaging in April (includes units in process ? Cost per equivalent unit: on April 1), 64,000 gallons Inventory in process, April 30, 5,000 gallons, 25% conversion costs ? Total costs for January in Cutting Department Total equivalent units Cost per equivalent unit Costs assigned to production: Requirements Inventory in process, January 1 Costs incurred in January a. Turn in EXCEL file using FORMULAS to complete the cost sheet. (50 points) b. Find the total number of units to be assigned cost during the month of April? (5 points) c. What are the total equivalent units for Direct materials? (5 points) d. What are the total equivalent units for conversion cost? (10 points) e. What is the cost per equivalent unit for direct materials? (5 points) f. What is the convention cost per equivalent unit? (5 points) Total costs accounted for by the Cutting Department Costs allocated to completed and partially completed units: Inventory in process, January 1 balance To complete inventory in process, January 1 Cost of completed January 1 work in process Started and completed in January Transferred to finished goods in January Inventory in process, January 31 Total costs assigned by the Cutting Department g. Allocate cost to units transferred out and partially completed. (10 points) h. Considering the current economic conditions, would you recommend your company outsource raw materials from China or get them from the U.S. Explain the reason for your decision in paragraph format. (10 points) Cost Information Direct Materials Conversion Direct Materials Conversion Total
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...
-
Define the following terms: Developed land Easement Improvement
-
Why are variances usually written off to cost of goods sold?
-
Let X be a random variable with the following probability distribution. Determine (a) Pr(X = 3). (b) Pr(X (c) Pr(X > 0). (d) Pr(1 (e) Pr(X = 2|X (f) Pr(Z Pr(X=x) |
-
Example 2 referred to an elevator with a maximum capacity of 4000 lb. When rating elevators, it is common to use a 25% safety factor, so the elevator should actually be able to carry a load that is...
-
The following scenarios describe situations faced by hypothetical companies that currently have a centralized organization structure. As you review each of the scenarios, provide your opinion as to...
-
The following (1 through 18) are the balance-related, transaction-related, and presentation and disclosure related audit objectives. Balance-Related Audit Objectives 1. Existence 2. Completeness 3....
-
Describe the growth of organized labor. What were some of the early unions that appeared at this time? What important strikes occurred at this time?
-
Riverbed Company has prepared a graph of flexible budget data. At zero direct labor hours, the total budgeted cost line intersects the vertical axis at $24,380. At 10,600 direct labor hours, the line...
-
Floretta Sutphin has worked for several years as an employee of a Canadian public company that has annual gross revenues of $190 million. In September 2021, Floretta was granted options to acquire...
-
reply to Authorized shares are the maximum number the company can legally issue. Issued shares represent the actual number distributed, which may be less than the authorized amount. Outstanding...
-
Wrote a creative brief that will serve as a roadmap for content creators. Considered your unique selling and value propositions, objectives, and goals you want to achieve. Also, included which social...
-
What are the responsibilities of the Gaming Control Board's Investigations Division? What are the responsibilities of the Gaming Control Board's Enforcement Division? Explain what is meant by...
-
What is the tax benefit rule? How is income recognized under the tax benefit rule? When can it be excluded from gross income? when the debtor is insolvent
-
A company purchases inventory as shown: Date Units Cost of each Cost of purchase January 1 20 $3.00 $60.00 January 6 20 $2.80 $56.00 January 12 20 $2.70 $54.00 January 26 20 $2.50 $50.00 January 29...
-
Determine the annual percentage yield for a loan that charges a monthly interest rate of 1.5% and compounds the interest monthly.
-
Consider a strictly risk averse agent endowed with initial wealth \(w_{0}\) and with a strictly increasing and twice differentiable utility function. Let \(r_{f}\) and \(\tilde{r}\) denote the return...
-
Consider a quadratic utility function \(u(x)=x-\frac{b}{2} x^{2}\), an initial wealth \(w_{0}=100\), a risk free rate \(r_{f}=1.1\) and a risky asset with expected return...
-
Consider the optimal portfolio choice problem in the presence of \(N\) risky assets with returns \(\left(\tilde{r}_{1}, \ldots, \tilde{r}_{N} ight)\) and of a risk free asset with return \(r_{f}>0\)....
Study smarter with the SolutionInn App