Homework Help is Here – Start Your Trial Now!
Business
Operations Management
PROBLEM 2 a) Once the ABC classification of the articles has been carried out: - List the articles of group A -- Write down how the percentages of each of the groups were GROUP % OF USE VALUE % VALUE OF ITEM A B b) ARTICLE Qo TICO

PROBLEM 2 a) Once the ABC classification of the articles has been carried out: - List the articles of group A -- Write down how the percentages of each of the groups were GROUP % OF USE VALUE % VALUE OF ITEM A B b) ARTICLE Qo TICO

Practical Management Science
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
icon
Related questions
Question
Edit question

Solve the problem using the answer sheet (Problem 2)

SOLVE STEP BY STEP PLEASE

 

2. A company that manufactures office furniture is required to make an ABC classification of its articles according to the following information: CONSUMPTION Cu (S/ Unit) ARTICLE (Units / year) 15000 Secretarial chair 480 Executive chair 850 11500 Individual chair 270 7500 Secretarial desk 920 1020 1250 5200 Execuțive desk Computer table Individual armchair 300 640 3300 1000 1060 Large armchair Round table 380 690 1330 Oval table 980 900 a) Perform the ABC classification of the articles b) Calculate Economic Lot and Optimal Incremental Total Cost for each of the items in Group "A" according to the data in the following table and considering consumption as annual demand. Cp ($/lote) 275 ARTICLE P Cm Secretarial chair (Units / year) 18300 The annual cost of keeping a unit in inventory is equal to 10 times the last digit of your ballot number expressed in $ / unit- year NOTE: If the last number of your ballot is 0 (zero) consider Cm = $ 100 per unit at Executive chair 13800 490 Individual chair 8850 155 Secretarial desk 1180 530 Execuțive desk 5900 720 Computer table Individual armchair 3700 175 1100 370 year Large armchair 410 610 Round table 1410 400 Oval table 940 565
Transcribed Image Text:2. A company that manufactures office furniture is required to make an ABC classification of its articles according to the following information: CONSUMPTION Cu (S/ Unit) ARTICLE (Units / year) 15000 Secretarial chair 480 Executive chair 850 11500 Individual chair 270 7500 Secretarial desk 920 1020 1250 5200 Execuțive desk Computer table Individual armchair 300 640 3300 1000 1060 Large armchair Round table 380 690 1330 Oval table 980 900 a) Perform the ABC classification of the articles b) Calculate Economic Lot and Optimal Incremental Total Cost for each of the items in Group "A" according to the data in the following table and considering consumption as annual demand. Cp ($/lote) 275 ARTICLE P Cm Secretarial chair (Units / year) 18300 The annual cost of keeping a unit in inventory is equal to 10 times the last digit of your ballot number expressed in $ / unit- year NOTE: If the last number of your ballot is 0 (zero) consider Cm = $ 100 per unit at Executive chair 13800 490 Individual chair 8850 155 Secretarial desk 1180 530 Execuțive desk 5900 720 Computer table Individual armchair 3700 175 1100 370 year Large armchair 410 610 Round table 1410 400 Oval table 940 565
PROBLEM 2 a) Once the ABC classification of the articles has been carried out: - List the articles of group A -- Write down how the percentages of each of the groups were GROUP % OF USE VALUE % VALUE OF ITEM A B b) Qo TICO ARTICLE
Transcribed Image Text:PROBLEM 2 a) Once the ABC classification of the articles has been carried out: - List the articles of group A -- Write down how the percentages of each of the groups were GROUP % OF USE VALUE % VALUE OF ITEM A B b) Qo TICO ARTICLE
Expert Solution
Given Details:

Find the Given details below:

Given details:
Article Cu
($/unit)		 Consumption
(Units/Year)		   Article P
(Units/Year)		 Cp
($/lote)
Secretarial Chair 480 15000 Secretarial Chair 18300 275
Executive Chair 850 11500 Executive Chair 13800 490
Individual chair 270 7500 Individual chair 8850 155
Secretarial desk 920 1020 Secretarial desk 1180 530
Executive desk 1250 5200 Executive desk 5900 720
Computer Table 300 3300 Computer Table 3700 175
Individual armchair 640 1000 Individual armchair 1100 370
Large armchair 1060 380 Large armchair 410 610
Round table 690 1330 Round table 1410 400
Oval table 980 990 Oval table 940 565
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS