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
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...
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
steps

Step by step

Solved in 3 steps with 2 images

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.