Given the following information, you need to conduct an ABC analysis on the number of items...
Fantastic news! We've Found the answer you've been seeking!
Question:
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2022/10/635264d986e5e_1666344411155.jpg)
Transcribed Image Text:
Given the following information, you need to conduct an ABC analysis on the number of items sold versus the annual value of usage. Item A1 A2 A3 A4 45 AS 46 Ab A7 AT A8 AD A9 A10 A11 A12 A13 A14 A15 Number of Units Sold 782 687 835 415 372 372 35 25 577 577 420 420 539 430 282 819 565 867 550 Unit Cost 48.38 63.19 77.13 6.86 92.88 89.60 89.60 62.46 Quantity 82.91 78.49 5.34 3:34 0.08 14.64 2.14 64.38 71.03 Note: you need to make a two-dimensional array as below and specify corresponding items for each cell. Then it would help if you discussed strategic versus non-strategic things. Then interpret and discuss the findings for each cell of the below table. For instance, what would be your suggestion regarding the B-C items? But you need to discuss all cells. Your discussion should be like a brief report to your manager. The threshold for A categories is 80%, B category is 15%, and C category is 5%. Tip: You need to open an excel file. And copy the items twice. Regarding the Value analysis, you must first determine the total annual value (NO times Unit Cost) and then sort things based on the yearly value in descending order. In the second table, you need to sort the items in descending order and conduct the ABC analysis for the quantity analysis. Tip: Once you complete the ABC analysis separately for quantity and annual usage value, you complete the below table as we exercised in class. A B C A Value B C Given the following information, you need to conduct an ABC analysis on the number of items sold versus the annual value of usage. Item A1 A2 A3 A4 45 AS 46 Ab A7 AT A8 AD A9 A10 A11 A12 A13 A14 A15 Number of Units Sold 782 687 835 415 372 372 35 25 577 577 420 420 539 430 282 819 565 867 550 Unit Cost 48.38 63.19 77.13 6.86 92.88 89.60 89.60 62.46 Quantity 82.91 78.49 5.34 3:34 0.08 14.64 2.14 64.38 71.03 Note: you need to make a two-dimensional array as below and specify corresponding items for each cell. Then it would help if you discussed strategic versus non-strategic things. Then interpret and discuss the findings for each cell of the below table. For instance, what would be your suggestion regarding the B-C items? But you need to discuss all cells. Your discussion should be like a brief report to your manager. The threshold for A categories is 80%, B category is 15%, and C category is 5%. Tip: You need to open an excel file. And copy the items twice. Regarding the Value analysis, you must first determine the total annual value (NO times Unit Cost) and then sort things based on the yearly value in descending order. In the second table, you need to sort the items in descending order and conduct the ABC analysis for the quantity analysis. Tip: Once you complete the ABC analysis separately for quantity and annual usage value, you complete the below table as we exercised in class. A B C A Value B C
Expert Answer:
Answer rating: 100% (QA)
To conduct an ABC analysis on the number of items sold versus the annual value of usage we will follow these steps 1 Calculate the annual value for each item Value Unit Cost Number of Units Sold 2 Sor... View the full answer
Related Book For
Managerial Decision Modeling with Spreadsheets
ISBN: 978-0136115830
3rd edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Posted Date:
Students also viewed these banking questions
-
What ingredients would you need to conduct a traditional equity method valuation for Foursquare? If you had the necessary projections, do you think that they would also suggest the $80$100 million...
-
You need to conduct an extensive literature review (low-rise buildings, aerodynamics of low-rise buildings, flow characteristics) and formulate your aim and methodology. You will prepare a 4-page...
-
You are given the following information about Sasha Company's inventory for the month of April. Instructions (a) Calculate the cost of goods available for sale and the number of units of ending...
-
Two forces are acting on the 5 kg object, with only one of them shown in Fig. 1. Knowing that F = 20 N, 0 = 30 and that the object is moving at a constant acceleration of a = 12 m/s, find the second...
-
Glans Company purchased equipment on account on April 6, 2012, at an invoice price of $442,000. On April 7, 2012, it paid $4,000 for delivery of the equipment. A one-year, $3,000 insurance policy on...
-
In the preceding question, assume that Cee Co. obtains an award from the ICSID tribunal. Cee Co. now seeks to enforce the award in a State C court. State D pleads that it is immune from the...
-
16. Mike is working his way through college and trying to make ends meet. Tara, a friend, is graduating soon and tells Mike about a really great job opportunity. She is the onsite manager for an...
-
In this lean operations world, in an effort w lower handling costs, speed delivery, and reduce inventory, retailers are forcing their suppliers to do more and more in the way of preparing their...
-
! Required information [ The following information applies to the questions displayed below. ] While You Wait Copy purchased a new copy machine. The new machine cost $ 1 1 6 , 0 0 0 including...
-
Brown Corporation has the following items for Year 1. Its income statement is as follows. Income Sales Cost of goods sold Gross Profit Dividends received from stock investments in Less than 20% owned...
-
I am including the answers but just need to see how they are worked out. Stroud Corporation is an 80%-owned subsidiary of Pennie, Inc., acquired by Pennie several years ago. On January 1, 20X2,...
-
2. See US Debt Clock and answer the following: (Hint: Take a screenshot of the Debt Clock) (2) A. What is the current US deficit and the total federal debt? (1) B What is the net interest...
-
Q. Is GDP per capita a good measure of a society's welfare? Why or why not? (150 Words)
-
On May 3, the Happy Company wrote off the $4,300 uncollectible account of its customer, A. Johnson. The entry or entries Happy makes to record the write off of the account on May 3 is: Allowance for...
-
Who is responsible for the financial statements and maintaining effective internal control over financial reporting? Where did you find this in the annual report? What accounting rules are required...
-
8. Chad owned an office building that was destroyed in a tornado. The adjusted basis of the building at the time was $890,000. After the deductible, Chad received an insurance check for $850,000. He...
-
Please complete the remaining parts of the problem and show the steps made to reach the answer. 1 Branson Co. received its bank statement for the month ending May 31, 2019, and reconciled the...
-
In your readings, there were many examples given for nurturing close family relationships in this ever-evolving technological society we live in Based upon your readings and research describe three...
-
The electronics firm in Problem 1-20 is now considering purchasing the new equipment and increasing the selling price of its product to $1.20 per unit. Even with the price increase, the new volume is...
-
A hospital kitchen needs to make a fruit salad that contains at least 6,500 units of vitamin A and 1,800 units of vitamin C. Data on five available fruits are shown in the following table. It is...
-
What different types of models are mentioned in this chapter? Give examples of each.
-
Describe the difference between accounting for governmental funds and proprietary funds. AppendixLO1
-
What is the difference between an enterprise fund and an internal service fund? AppendixLO1
-
What is the difference between a permanent fund and a private-purpose trust fund? AppendixLO1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App