The ABC Analysis is one of the key methods of determining the optimal combination of products for sale through a movie company. Given the information below, complete the ABC analysis template. The A- item limit should be set at 80% of sales and the B- items at 96% of sales. All of the A items will then be placed in the best/primary locations in the store, the B items in very good locations and the C items in the back- ends of the stores. PRODUCT SKU UNIT UNIT ANNUAL CUMULATIVE CATEGORY USAGE PRICE REVENUE % OF TOTAL y/class (R) REVENUE SKU 1 Horrible man 600 300 | 180 000 "I'm the man" SKU 2 Fallout 500 200 100 000 "On a mission to survive" SKU 3 Dead Ocean 250 60 15 000 "Shark attack" SKU 4 A Quiet room 420 120 50 400 "I am scared mom" SKU 5 Games Day 630 40 25 200 "Which game can you beat me in"

The ABC Analysis is one of the key methods of determining the optimal combination of products for sale through a movie company. Given the information below, complete the ABC analysis template. The A- item limit should be set at 80% of sales and the B- items at 96% of sales. All of the A items will then be placed in the best/primary locations in the store, the B items in very good locations and the C items in the back- ends of the stores. PRODUCT SKU UNIT UNIT ANNUAL CUMULATIVE CATEGORY USAGE PRICE REVENUE % OF TOTAL y/class (R) REVENUE SKU 1 Horrible man 600 300 | 180 000 "I'm the man" SKU 2 Fallout 500 200 100 000 "On a mission to survive" SKU 3 Dead Ocean 250 60 15 000 "Shark attack" SKU 4 A Quiet room 420 120 50 400 "I am scared mom" SKU 5 Games Day 630 40 25 200 "Which game can you beat me in"

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

As a marketing officer, how can banks improve customer segmentation, product development and client relationships going forward post covid
what is Bank of America's industry segment and scope
How would a traditional brick-and-mortar store connect its databases to Amazon's if it decided to utilize FBA?
Name of some entertainment channel?
What is Netflix’s generic strategy before and after COVID-19?
The presence of effective within an individual company and across an economy as a whole, helps to provide a degree of confidence that is necessary for the proper functioning of a market economy. a) Risk assessment b) Monitoring c) Corporate Governance d) Internal Audit
Morningstar serves three key constituents: individual investors, financial advisors, and institutional investors. Institutional investors include Multiple Choice O securities exchanges. pension plans. government agencies.
How has Whole Foods been successfully in the highly competitive supermarket industry?
What is the solution to the “American Express Redefines Its Strategy” case
Provide a brief description of the company’s business, major products, markets, industry sector, founding year. -> British American Tobacco (LSE:BATS)
What are the pros and cons of the “American Express Redefines Its Strategy” case
Is Amazon Web Services a platform at the corporate level?