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:
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...
-
What information attributes is often of great value for local networks that use static addressing?
-
Use a determinant to find the area of the parallelogram with the given vertices. 1. (0, 0), (2, 0), (1, 4), (3, 4) 2. (0, 0), (3, 0), (1, 3), (2, 3)
-
How can a plaintiff enforce a settlement agreement made by the defendant?
-
Florida Car Wash is considering a new project whose data are shown below. The equipment to be used has a 3-year tax life, would be depreciated on a straight-line basis over the project's 3-year life,...
-
If a company no longer meets the listing requirements of the TSX Venture Exchange, what might occur? A It can request to be exempt from the TSX-V requirements. B) It may be listed on the NEX...
-
Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: Quarter Forecast 1...
-
The following expenses relate to land, land improvements and buildings purchased on 1 November 2013. Cost of real estate acquired for a new production facility 365000 The land was valued at 262,800...
-
The method that Tong suggests to add incremental revenue is: A. program trading. B. securities lending. C. attribution analysis. Evan Winthrop, a senior officer of a US-based corporation, meets with...
-
Gunnar Patel is an event-driven hedge fund manager for Senson Fund, which focuses on merger arbitrage strategies. Patel has been monitoring the potential acquisition of Meura Inc. by Sellshom, Inc....
-
The trade algorithm that Wong should consider for the sell order of Music Plus shares is: A. a POV algorithm. B. an arrival price algorithm. C. a liquidity-seeking algorithm. Michelle Wong is a...
-
Which characteristic suggested by Knight to describe the quantitative approach to active management is incorrect? A. Characteristic 1 B. Characteristic 2 C. Characteristic 3 Aleksy Nowacki is a new...
-
Describe three paths for implementing the strategy of Hedge Fund A. After a significant amount of internal discussion, Wallace concludes that the pension fund should invest in either Hedge Fund B or...
-
Supposed a market is in the semi-strong form of market efficiency. In that case, the risk-adjusted returns of a passively managed portfolio relative to an actively managed portfolio are most likely:...
-
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.
-
Briefly explain the connections between values such as effort optimism, utilitarian individualism, and the American economic system. Throughout this chapter, we have identified culture as something...
-
Do you speak a language other than English as a first language? If so, do you want your children and grandchildren to speak that language? In the United States, the tools of government and education...
-
If English is your first language, did your parents or grandparents speak a different first language? How do you feel about your ability (or lack of ability) in that language? In the United States,...
Study smarter with the SolutionInn App