Additional analysis 1) Journal entry needed WIP- Forming WIP-Blending 2) Total cost per unit: Blending DM...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Additional analysis 1) Journal entry needed WIP- Forming WIP-Blending 2) Total cost per unit: Blending DM 3) 4) Inventory Analysis WIP Inventory- Blending WIP Inventory Forming Finished Goods Inventory 5A) Total cost per unit 1405976 Henkel Industries Income Statement For the Month Ending May 31 Per unit Ending Units Total Total Cost 1405976 Units Sold Sales price/unit Reconciling UNITS in End FG Inv Beg FG + Made -Sold -End FG DIRECTIONS Now that you have completed the production cost report, the controller would like you to do a few more tasks. Use the space at the left to document your responses. IMPORTANT NOTE: Every figure on this spread sheet (dollar amounts and units) should be cell referenced from elsewhere (not typed in) EXCEPT for the blue boxes (number of units sold, Sales price per unit, and WIP-Forming End units and cost). Line labels and account names will need to be typed in. To reference a cell in another worksheet, first select the cell where you want the answer and type=. Then, select the cell you want to get from a different sheet, and hit the Enter button. 1) How much cost, in total, needs to get transferred to the Forming Department? Complete the journal entry with the appropriate amount. 2) The controller wants to know the cost of making one unit of product in May, from START to FINISH (including both the Blending and Forming Departments). Show your calculations by listing each of the costs per EU from all of the departments that make up the total cost (e.g., Blending DM, Blending CC, etc.). FORMAT the cost per unit in dollars and cents and HIGHLIGHT the total cost per unit (use the spilling paint bucket icon to fill in the cell with neon yellow color.) 3) The controller would like you to prepare a draft of the company's income statement. In addition, she would like to see the sales price per unit, cost per unit, and gross profit per unit. Hint: See general ledger for the information about transactions that occurred during the month. Make sure you format everything in dollars and cents. 4) At the beginning of May, the company had no Finished Goods inventory and no WIP in the Forming Department. All units transferred out of the Blending Dept. in May also made it completely through the Forming Dept. in May. The controller would like you to prepare an analysis of the company's ending WIP and FG inventory at May 31. The controller wants to know the following: a) How many units are in each Department's ending WIP Inventory? b) What is the cost balance for each Department's ending WIP Inventory? c) How many units are in ending Finished Goods Inventory? (Use side purple box to figure it out.) d) What is the total cost balance in ending Finished Goods Inventory? 5) Although the production manager said that the units in WIP at the end of May were 80% of the way through the process, the controller knows that figure is somewhat subjective. She has talked to the assistant production manager, who believes the units were only about 60% complete. She wants you to run your spreadsheet using 60% as the percent of completion to see what impact the estimate has on A) total cost per unit, and B) the company's income statement for the month. IMPORTANT: BEFORE doing the analysis in Step 5, copy your May production cost report worksheet to a new tab and rename it "What-if 60 % ?" To do this, right click on the May tab at the bottom of the screen and choose "move or copy" 5B) 5C) Henkel Industries Income Statement For the Month Ending May 31 Per unit Total Difference in operating income: 5D) Briefly explain the reason for the difference. Lower or higher when 60% is used? SE) If managers want to inflate earnings in a particular period, what can they do? rename it "What-if 60%? " To do this, right click on the May tab at the bottom of the screen and choose "move or copy" then check the box, "make a copy". Then right click on the new copled spreadsheet and choose "rename". 5A) Calculate the total cost per unit, using 60% as the percentage of completion. 5B) Complete the company's income statement for the month, using 60% as the percentage of completion. 5C) Calculate the difference in operating income between the two possible percentages of completion (80% vs 60%) 5D) Briefly explain WHY the difference in income occurs. SE) In general, if managers want to inflate earnings in a particular period, what could they do? Department Data Information about units: Units in Beginning WIP Started during month Units in Ending WIP Percentage of completion: Direct materials. Conversion Costs in Beginning WIP DM in beginning WIP Conversion custs in beginning WIP Cost information for the current month: DM traced to Dept during the month 25,000 220,000 30,000 100% 80% 132500 78300 1153750 45000 DL traced to Dept during the month MOH allocated to dept during the month 617600 NOTE: The blue box contains the data you'll need for completing the Production Cost Report (tan box). Certain figures in the blue box must be typed in. Other figures in the blue box can be cell referenced from another worksheet (= cell address). ALL cells in the Production Cost Report (tan box) should be formulas or cell-referenced to figures in the blue box. DO NOT TYPE ANY FIGURES on the Production Cost Report or you will lose points on the assignment. Your goal is to create a Production Cost Report that can be used every month by just changing the data in the blue box. Production Cost Report: Blending Department - MAY FLOW OF UNITS Physical Units DM EU Units to account for: Beginning work in pracess Started in production Total units to account for Units accounted for Completed and transferred out Ending WIP Total units accounted for FLOW OF COSTS Costs to account for Beginning work in process. Costs added during month Total costs to account for Cost per equivalent unit Costs accounted for: Completed and transferred out Ending WIP Total costs accounted for 25,000 220,000 245,000 ********* 215000 30,000 245,000 www Total 210800 1816350 2027150 8.35 1795250 231900 2027150 215,000 30,000 245,000 DM 132500 1153750 1286250 5 1,128,750 157500 1,286,250 Conversion EU 215000 24,000 239,000 Conversion 78300 662600 740900 666,500 74400 740,900 May General Journal Entries- Partial list WIP-Blending Wages Payable (to record DL traced to the Blending Dept) WIP-Blending Raw materials inventory (to record DM traced to the Blending Dept) WIP- Blending MOH (to record MOH allocated to the Blending Dept) WIP. Forming Wages Payable (to record DL traced to the Forming Dept) WIP-Forming Raw materials inventory (to record DM traced to the Forming Dept) WIP. Forming MOH-Forming (to record MOH allocated to the Forming Dept) Salary Expense Wages Payable (to record solaries and wages of selling, general and admin. staff) Rent Expense Rent Payable (to record monthly rent) Insurance Expense Prepaid Insurance. (to record Insurance on selling, general, and admin. Building) $ 45,000 $ 1,153,750 $ 617,600 $ $ $ S 750,000 $ 45,000 617,600 275,000 $ 25,000 30,000 $ 45,000 $ 1,153,750 $ 617,600. $ 750,000 $ 45,000 $ 617,600 $ 275,000 $ 25,000 $ 30,000 For Income Statement: Total Operating Expenses = Use a formula to find the total operating expenses for the month. Insurance Expense Prepaid Insurance (to record Insurance on selling, general, and admin. Building) Accounts Receivable Sales Revenue (to record the sale of 180,000 units at a price of $20 per unit) Utilities Expense Utilities Payable (to record Insurance on selling, general, and admin. Building) Advertising expense Accounts Payable (to record advertising expenses) $ 30,000 $ 3,600,000 $ 10,000 $ 120,000 $ 30,000 $ 3,600,000 $ 10,000 $ 120,000 Additional analysis 1) Journal entry needed WIP- Forming WIP-Blending 2) Total cost per unit: Blending DM 3) 4) Inventory Analysis WIP Inventory- Blending WIP Inventory Forming Finished Goods Inventory 5A) Total cost per unit 1405976 Henkel Industries Income Statement For the Month Ending May 31 Per unit Ending Units Total Total Cost 1405976 Units Sold Sales price/unit Reconciling UNITS in End FG Inv Beg FG + Made -Sold -End FG DIRECTIONS Now that you have completed the production cost report, the controller would like you to do a few more tasks. Use the space at the left to document your responses. IMPORTANT NOTE: Every figure on this spread sheet (dollar amounts and units) should be cell referenced from elsewhere (not typed in) EXCEPT for the blue boxes (number of units sold, Sales price per unit, and WIP-Forming End units and cost). Line labels and account names will need to be typed in. To reference a cell in another worksheet, first select the cell where you want the answer and type=. Then, select the cell you want to get from a different sheet, and hit the Enter button. 1) How much cost, in total, needs to get transferred to the Forming Department? Complete the journal entry with the appropriate amount. 2) The controller wants to know the cost of making one unit of product in May, from START to FINISH (including both the Blending and Forming Departments). Show your calculations by listing each of the costs per EU from all of the departments that make up the total cost (e.g., Blending DM, Blending CC, etc.). FORMAT the cost per unit in dollars and cents and HIGHLIGHT the total cost per unit (use the spilling paint bucket icon to fill in the cell with neon yellow color.) 3) The controller would like you to prepare a draft of the company's income statement. In addition, she would like to see the sales price per unit, cost per unit, and gross profit per unit. Hint: See general ledger for the information about transactions that occurred during the month. Make sure you format everything in dollars and cents. 4) At the beginning of May, the company had no Finished Goods inventory and no WIP in the Forming Department. All units transferred out of the Blending Dept. in May also made it completely through the Forming Dept. in May. The controller would like you to prepare an analysis of the company's ending WIP and FG inventory at May 31. The controller wants to know the following: a) How many units are in each Department's ending WIP Inventory? b) What is the cost balance for each Department's ending WIP Inventory? c) How many units are in ending Finished Goods Inventory? (Use side purple box to figure it out.) d) What is the total cost balance in ending Finished Goods Inventory? 5) Although the production manager said that the units in WIP at the end of May were 80% of the way through the process, the controller knows that figure is somewhat subjective. She has talked to the assistant production manager, who believes the units were only about 60% complete. She wants you to run your spreadsheet using 60% as the percent of completion to see what impact the estimate has on A) total cost per unit, and B) the company's income statement for the month. IMPORTANT: BEFORE doing the analysis in Step 5, copy your May production cost report worksheet to a new tab and rename it "What-if 60 % ?" To do this, right click on the May tab at the bottom of the screen and choose "move or copy" 5B) 5C) Henkel Industries Income Statement For the Month Ending May 31 Per unit Total Difference in operating income: 5D) Briefly explain the reason for the difference. Lower or higher when 60% is used? SE) If managers want to inflate earnings in a particular period, what can they do? rename it "What-if 60%? " To do this, right click on the May tab at the bottom of the screen and choose "move or copy" then check the box, "make a copy". Then right click on the new copled spreadsheet and choose "rename". 5A) Calculate the total cost per unit, using 60% as the percentage of completion. 5B) Complete the company's income statement for the month, using 60% as the percentage of completion. 5C) Calculate the difference in operating income between the two possible percentages of completion (80% vs 60%) 5D) Briefly explain WHY the difference in income occurs. SE) In general, if managers want to inflate earnings in a particular period, what could they do? Department Data Information about units: Units in Beginning WIP Started during month Units in Ending WIP Percentage of completion: Direct materials. Conversion Costs in Beginning WIP DM in beginning WIP Conversion custs in beginning WIP Cost information for the current month: DM traced to Dept during the month 25,000 220,000 30,000 100% 80% 132500 78300 1153750 45000 DL traced to Dept during the month MOH allocated to dept during the month 617600 NOTE: The blue box contains the data you'll need for completing the Production Cost Report (tan box). Certain figures in the blue box must be typed in. Other figures in the blue box can be cell referenced from another worksheet (= cell address). ALL cells in the Production Cost Report (tan box) should be formulas or cell-referenced to figures in the blue box. DO NOT TYPE ANY FIGURES on the Production Cost Report or you will lose points on the assignment. Your goal is to create a Production Cost Report that can be used every month by just changing the data in the blue box. Production Cost Report: Blending Department - MAY FLOW OF UNITS Physical Units DM EU Units to account for: Beginning work in pracess Started in production Total units to account for Units accounted for Completed and transferred out Ending WIP Total units accounted for FLOW OF COSTS Costs to account for Beginning work in process. Costs added during month Total costs to account for Cost per equivalent unit Costs accounted for: Completed and transferred out Ending WIP Total costs accounted for 25,000 220,000 245,000 ********* 215000 30,000 245,000 www Total 210800 1816350 2027150 8.35 1795250 231900 2027150 215,000 30,000 245,000 DM 132500 1153750 1286250 5 1,128,750 157500 1,286,250 Conversion EU 215000 24,000 239,000 Conversion 78300 662600 740900 666,500 74400 740,900 May General Journal Entries- Partial list WIP-Blending Wages Payable (to record DL traced to the Blending Dept) WIP-Blending Raw materials inventory (to record DM traced to the Blending Dept) WIP- Blending MOH (to record MOH allocated to the Blending Dept) WIP. Forming Wages Payable (to record DL traced to the Forming Dept) WIP-Forming Raw materials inventory (to record DM traced to the Forming Dept) WIP. Forming MOH-Forming (to record MOH allocated to the Forming Dept) Salary Expense Wages Payable (to record solaries and wages of selling, general and admin. staff) Rent Expense Rent Payable (to record monthly rent) Insurance Expense Prepaid Insurance. (to record Insurance on selling, general, and admin. Building) $ 45,000 $ 1,153,750 $ 617,600 $ $ $ S 750,000 $ 45,000 617,600 275,000 $ 25,000 30,000 $ 45,000 $ 1,153,750 $ 617,600. $ 750,000 $ 45,000 $ 617,600 $ 275,000 $ 25,000 $ 30,000 For Income Statement: Total Operating Expenses = Use a formula to find the total operating expenses for the month. Insurance Expense Prepaid Insurance (to record Insurance on selling, general, and admin. Building) Accounts Receivable Sales Revenue (to record the sale of 180,000 units at a price of $20 per unit) Utilities Expense Utilities Payable (to record Insurance on selling, general, and admin. Building) Advertising expense Accounts Payable (to record advertising expenses) $ 30,000 $ 3,600,000 $ 10,000 $ 120,000 $ 30,000 $ 3,600,000 $ 10,000 $ 120,000
Expert Answer:
Related Book For
An Introduction to Derivative Securities Financial Markets and Risk Management
ISBN: 978-0393913071
1st edition
Authors: Robert A. Jarrow, Arkadev Chatterjee
Posted Date:
Students also viewed these accounting questions
-
How do you feel about whistle-blowing now that you have read about it? Are you now more sympathetic or less sympathetic to whistle-blowers? Explain.
-
You can graduate only if you have completed the requirements of your major and you do not owe money to the university and you do not have an overdue library book. Express your answer in terms of g:...
-
Now that you have completed the book and are on your way to mastering derivatives, briefly discuss your views as to whether derivatives are good or bad? Feel free to use the Internet to get some...
-
Amato is preparing a resume to apply for a higher-level management position with Amato's current company. The position Amato is applying for is in a different location from Amato's current job. What...
-
Consider the diode circuit shown in the figure. The Current i D and the voltage v D can be determined from the solution of the following system of equations: i D = I o (e qvp/kT - 1), i D = V s - V D...
-
Describe several project evaluation criteria.
-
Identify sources of information to find out more about the career in which you are interested.
-
Doughty Sawmill, Inc., (DSI) purchases logs from independent timber contractors and processes the logs into three types of lumber products: Studs for residential buildings (walls, ceilings)...
-
Required information [The following information applies to the questions displayed below] A manufactured product has the following information for June. Direct materials Direct labor Standard...
-
Many small-business owners have a difficult time finding financing to start or expand their business. The Small Business Administration is one potential source of financing for many types of small...
-
ogress Marigold Company had the following stockholders' equity as of January 1, 2025 Common stock, $5 par value, 19,600 shares issued $98,000 Paid-in capital in excess of par-common stock 299,000...
-
Formation of a Peptide Bond Amino acids are assembled into proteins during protein synthesis or translation. Peptide bonds are formed between the amino group of one amino acid and the acid group of...
-
Use the case study "Shifting the diversity climate: the Sodexo solution" elaborate on: 1- Internal and External forces (SWOT analysis) 2-Analysis tools ( VRIO & Porter's five forces) 3- Alternatives...
-
Why is it important before making decisions to know the price preferred by customers when making purchases? What happens when you make price decisions that are above the price range? How does this...
-
On 1/1/2022, Morar Inc purchases equipment, promising to pay $30,000 on 12/31/2025. The seller is financing the purchase. If Morar Inc pursued a loan instead to purchase the equipment, the interest...
-
Amber Mining and Milling, Incorporated, contracted with Truax Corporation to have constructed a custom - made lathe. The machine was completed and ready for use on January 1 , 2 0 2 4 . Amber paid...
-
I need help with part g. Wildhorse's Style manufactures dining room tables for both home and restaurant locations. Kevin Jason, the company's controller, developed the following standard costs for...
-
In a nonmagnetic medium, E = 50 cos (10 9 t 8x) a y + 40 sin (10 9 t 8x) a z V/m find the dielectric constant r and the corresponding H.
-
Consider an American put option with maturity date time 3 and strike price $0.96 on the three-period zero-coupon bond. What is the value of this put option?
-
Suppose Your Beloved Machines Inc. has a February cycle for options trading. State the months for which regular equity options on YBM (which expire on the third Friday of the month) trade on the...
-
Briefly describe options trading that took place in 1500 1700 Amsterdam and in nineteenth- century London and New York City.
-
Tropical Products Inc. is in the process of negotiating a lease of equipment with a fair value of \(\$ 50,000\), and it must determine the proper lease classification. The following table describes...
-
Referring to the information in Brief Exercise 17-44, and assuming that the building has a fair value of \(\$ 2,000,000\) at the commencement of the lease, what amount would Property Inc. recognize...
-
On January 1, 2020, Baker Inc. enters into an operating lease of equipment for one year for \(\$ 1,000\) per month on January 1, 2020. The equipment cost \(\$ 200,000\) and has a useful life of 10...
Study smarter with the SolutionInn App