Quantity discount (3% each question) A manufacturing's demand is 4,200 units yearly There are two suppliers bidding their business to this manufacturer Ordering cost is $42.00 and annual holding cost per unit is 15% of unit price. (easier for your calculations) Annual demand Ordering cost Holding cost Supplier A 3% Annual Quantity <=499 unit price $15.00 order Q product cost Annual ordering cost Annual holding cost Total cost 500-999 $14.50 >=1000 $14.00 Supplier B 3% Annual Quantity unit price order Q product cost Annual ordering cost Annual holding cost Total cost <=400 $15.25 401-799 $14.50 >=800 $14.25 Which Supplier at what amount? Supplier Amount 4200 $42.00 15% Answering the following question: 1. If the firm only allows 5 orders per year (and it has to be 5 times) with the current yearly demand 4,200 units, what will be your decision? (you can use either supplier, i.e., you combine A and B and mix them (say, 2 times from A, 3 times from B at what volume). (this question may not have a standard answer, the purpose is to know how do you make decision based on your logic to reach the lowest total cost) (total order must = 4,200 units, not one unit more, not one unit less) Answers How many A? How many B? What Quantity? What Quantity?
Quantity discount (3% each question) A manufacturing's demand is 4,200 units yearly There are two suppliers bidding their business to this manufacturer Ordering cost is $42.00 and annual holding cost per unit is 15% of unit price. (easier for your calculations) Annual demand Ordering cost Holding cost Supplier A 3% Annual Quantity <=499 unit price $15.00 order Q product cost Annual ordering cost Annual holding cost Total cost 500-999 $14.50 >=1000 $14.00 Supplier B 3% Annual Quantity unit price order Q product cost Annual ordering cost Annual holding cost Total cost <=400 $15.25 401-799 $14.50 >=800 $14.25 Which Supplier at what amount? Supplier Amount 4200 $42.00 15% Answering the following question: 1. If the firm only allows 5 orders per year (and it has to be 5 times) with the current yearly demand 4,200 units, what will be your decision? (you can use either supplier, i.e., you combine A and B and mix them (say, 2 times from A, 3 times from B at what volume). (this question may not have a standard answer, the purpose is to know how do you make decision based on your logic to reach the lowest total cost) (total order must = 4,200 units, not one unit more, not one unit less) Answers How many A? How many B? What Quantity? What Quantity?
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...
Related questions
Question
help me solve this practice problem please
![Quantity discount (3% each question)
A manufacturing's demand is 4,200 units yearly
There are two suppliers bidding their business to this manufacturer
Ordering cost is $42.00 and annual holding cost per unit is 15% of unit price.
(easier for your calculations)
Annual demand
Ordering cost
Holding cost
Supplier A
3%
Annual
Quantity
<=499
unit price
$15.00
order Q
product cost
Annual
ordering cost
Annual
holding cost
Total cost
500-999
$14.50
>=1000
$14.00
Supplier B
3%
Annual
Quantity
unit price
order Q
product cost
Annual
ordering cost
Annual
holding cost
Total cost
<=400
$15.25
401-799
$14.50
>=800
$14.25
Which Supplier at what amount?
Supplier
Amount
4200
$42.00
15%
Answering the following question:
1. If the firm only allows 5 orders per year (and it has to be 5 times) with the current yearly demand 4,200 units, what will be your decision?
(you can use either supplier, i.e., you combine A and B and mix them (say, 2 times from A, 3 times from B at what volume).
(this question may not have a standard answer, the purpose is to know how do you make decision based on your logic to reach the lowest total cost)
(total order must = 4,200 units, not one unit more, not one unit less)
Answers
How many A?
How many B?
What Quantity?
What Quantity?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Faf434c73-38f1-4a89-b981-edd99d760c82%2F1d5af252-4fd1-49c4-820f-9061f18324ea%2Fpznldd_processed.png&w=3840&q=75)
Transcribed Image Text:Quantity discount (3% each question)
A manufacturing's demand is 4,200 units yearly
There are two suppliers bidding their business to this manufacturer
Ordering cost is $42.00 and annual holding cost per unit is 15% of unit price.
(easier for your calculations)
Annual demand
Ordering cost
Holding cost
Supplier A
3%
Annual
Quantity
<=499
unit price
$15.00
order Q
product cost
Annual
ordering cost
Annual
holding cost
Total cost
500-999
$14.50
>=1000
$14.00
Supplier B
3%
Annual
Quantity
unit price
order Q
product cost
Annual
ordering cost
Annual
holding cost
Total cost
<=400
$15.25
401-799
$14.50
>=800
$14.25
Which Supplier at what amount?
Supplier
Amount
4200
$42.00
15%
Answering the following question:
1. If the firm only allows 5 orders per year (and it has to be 5 times) with the current yearly demand 4,200 units, what will be your decision?
(you can use either supplier, i.e., you combine A and B and mix them (say, 2 times from A, 3 times from B at what volume).
(this question may not have a standard answer, the purpose is to know how do you make decision based on your logic to reach the lowest total cost)
(total order must = 4,200 units, not one unit more, not one unit less)
Answers
How many A?
How many B?
What Quantity?
What Quantity?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.