help please, please show the work and answers only in excel please send screenshot of excel 1. a. Determine an A-B-C classification for these items:ItemUnit CostAnnual Volume (00)1$10025803015605010117060851060b. Find the EOQ given this information: D = 4,500 units/year, S= $36, and H= $10 per unit per year.%3Dc. Find the economic production quantity given this information.D= 18,000 units/year, S = $100, H = $40 per unit per year, p = 120 units per day,and u = 90 units/dayHom cample2.4567

1. a. Determine an A-B-C classification for these items: Item Unit Cost Annual Volume (00) $100 25 80 30 3. 15 60 4. 50 10 5. 11 70 6. 60 85 7 10 60 b. Find the EOQ given this information: D = 4,500 units/year, S $36, and H=$10 per unit per year. c. Find the economic production quantity given this information. D= 18,000 units/year, S $100, H = $40 per unit per year, p = 120 units per day, and u = 90 units/day

1. a. Determine an A-B-C classification for these items: Item Unit Cost Annual Volume (00) $100 25 80 30 3. 15 60 4. 50 10 5. 11 70 6. 60 85 7 10 60 b. Find the EOQ given this information: D = 4,500 units/year, S $36, and H=$10 per unit per year. c. Find the economic production quantity given this information. D= 18,000 units/year, S $100, H = $40 per unit per year, p = 120 units per day, and u = 90 units/day

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

I own a coffee shop. Please identify the possible STRENGTHS, WEAKNESSES, OPPORTUNITIES and THREATS. thanks
What kinds of education and work experience are required to get a job in a sector that deals with artificial intelligence and machine learning?
Direct Selling in China With over 1.2 billion people China represented an extremely attractive market for direct sellers such as Amway, Avon Products, Mary Kay Cosmetics, Sara Lee, and Tupperware. Also, in the 1990s the restructuring of state-owned enterprises had reduced workforces, providing an ample supply of people interested in becoming direct sellers, many of whom made door-to-door sales calls. With the Asian and Russian financial crises beginning in 1997 the supply of potential direct sales personnel increased further. In 1995 Amway opened a factory in Guangzhou and began sales in China. By 1997 it had 70,000 independent sales agents in China producing revenue of $178 million.62 Avon’s revenue in China was $75 million. Companies such as Amway and Avon operated by enlisting independent sales agents who bought product from the company and sold it door-to-door. Amway used its standard business model in China with the exception that all other markets were supplied from U.S.…
So, I changed one of my user's phone plans to allow for international calling, awhile back, but when I received the bill from Verizon, it turns out that some of the countries in Africa that was visited do not have reliable or managed cellular service. It made me wonder about not only cellular coverage but also access to the Internet. 1) "A country that wants to progress economically and provide opportunities for its citizens must ensure that Internet access is widely available." Do you agree with this statement? Why or why not? 2) Net neutrality has been described as the preservation of an open Internet and the ability to communicate freely online. How does this relate to the workplace?
After a financial crisis hits the country of Cinfuria, 2 million people become unemployed. If 65 million individuals are lucky enough to keep their jobs, what is the unemployment rate? Please specify your answer to two decimal places. unemployment rate:
When Google initially started operating in China, the company ran across a number of problems.
4. What is the price at which the quantity of goods demanded, and the quantity of goods supplied are equal .6 .8 A) The going rate B) The margin rates C) The market price D) The optimum price 5. What marks the key difference between economic systems 9 A) The way they manage the factors of production B) The way they transport goods within their borders 10 .11 C) The way rules and regulations are legislated D) The way workers are relocated to different regions
Question 6 Please select the core idea of the theory proposed by David Ricardo in his book 'Principles of Political Economy and Taxation' Comparative advantage Trickle Down economics Market Competition International Division of labor
Duaa Lipa works for an international company and has been promoted to a role where she will need to maintain global financial management systems. She recognizes that operating globally is not without its challenges, and wants your guidance in helping make sure that the global financial management systems run well. Which of the following is not an obstacle to using global information systems? -Diverse regulatory practices -Cultural differences -Unwillingness to delegate control of information systems to host countries -Standardization -poor telecommunication infrastructure
Can you guys help me on this? Thank you! Here is the question: Is it possible for a country's economy to be based entirely on services? Here's my classmate's reply: No, a country can’t rely only on services for its economy. Even those focused on services still need farming, manufacturing, and imports for essential items like food and products. Relying solely on services could lead to trade issues and difficulties with global changes. For example, without manufacturing, a country would struggle to produce necessary goods like machinery or electronics. Imports become crucial to supply items not produced domestically. Additionally, a balance between services and goods helps manage economic risks and supports job creation across various sectors. This diverse approach allows for better adaptation to economic shifts and global market demands. Having both services and goods ensures long-term economic stability and growth. Can you provide feedback on my classmate's reply? Thank you!
Maria sat in the bright sunshine on the patio of her favourite Montreal deli waiting for her friend to join her for lunch. While waiting, she thought about her career options. Maria had finished her last exam for her honours business degree only five weeks earlier. She was graduating at a time when downturns in the energy and manufacturing sectors impacted both the overall economy and the job market. In addition, parts of the economy had yet to recover from the worldwide financial crisis of 2008 and consumer spending was down. The trickle-down effects impacted hiring of entry-level workers in industries from consumer packaged goods to insurance, banking, natural resource extraction, even the retail sector. Many new business graduates struggled to find work of any kind. She had originally planned to go into international development after completing her degree. She was especially interested in programs that helped develop entrepreneurship skills in economically disadvantaged areas. She…