Bell Computers purchases integrated chips at $350 per chip. The holding cost is $35 per unit per year, the ordering cost is $119 per order, and sales are steady at 400 per month. The company's supplier, Rich Blue Chip Manufacturing, Inc., decides to offer price concessions in order to attract larger orders. The price structure is shown below. Rich Blue Chip's Price Structure Quantity Purchased 1-99 units Price/Unit $350 $325- $300 100-199 units 200 more units a) What is the most cost-effective order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips, using the data and discount choices provided, and using a fixed holding cost? The most cost-effective order quantity (assuming they take the most cost-effective discount, and use a fixed holding cost) is units (enter your response as a whole number). At the chosen level of quantity discount, and using the fixed holding cost, what is the total annual cost for Bell computers to order, purchase, and hold the integrated chips : $ (round your response to the nearest whole number).

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
Can someone please help me with this ?
**Bell Computers Integrated Chip Purchasing Analysis**

Bell Computers purchases integrated chips at $350 per chip. The holding cost is $35 per unit per year, the ordering cost is $119 per order, and sales are steady at 400 per month. The company's supplier, Rich Blue Chip Manufacturing, Inc., offers price concessions to attract larger orders. The price structure is shown below.

**Rich Blue Chip's Price Structure**

| Quantity Purchased | Price/Unit |
|--------------------|------------|
| 1-99 units         | $350       |
| 100-199 units      | $325       |
| 200 or more units  | $300       |

---

**Analysis Questions**

a) What is the most cost-effective order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips, using the data and discount choices provided, and using a fixed holding cost?

- The most cost-effective order quantity (assuming they take the most cost-effective discount, and use a fixed holding cost) is ___ units (enter your response as a whole number).

- At the chosen level of quantity discount, and using the fixed holding cost, what is the total annual cost for Bell computers to order, purchase, and hold the integrated chips: $ ___ (round your response to the nearest whole number).

b) Bell Computers wishes to recalculate using a 10% holding cost rather than the fixed $35 holding cost in part a. What is the most cost-effective order quantity, and what is the corresponding annual cost?

- The most cost-effective order quantity (assuming they take the most cost-effective discount, and use a percentage-of-price holding cost) is ___ units (enter your response as a whole number).

- At the chosen level of quantity discount, and using the percentage-of-price holding cost, what is the total annual cost for Bell computers to order, purchase, and hold the integrated chips: $ ___ (round your response to the nearest whole number).
Transcribed Image Text:**Bell Computers Integrated Chip Purchasing Analysis** Bell Computers purchases integrated chips at $350 per chip. The holding cost is $35 per unit per year, the ordering cost is $119 per order, and sales are steady at 400 per month. The company's supplier, Rich Blue Chip Manufacturing, Inc., offers price concessions to attract larger orders. The price structure is shown below. **Rich Blue Chip's Price Structure** | Quantity Purchased | Price/Unit | |--------------------|------------| | 1-99 units | $350 | | 100-199 units | $325 | | 200 or more units | $300 | --- **Analysis Questions** a) What is the most cost-effective order quantity and the minimum annual cost for Bell Computers to order, purchase, and hold these integrated chips, using the data and discount choices provided, and using a fixed holding cost? - The most cost-effective order quantity (assuming they take the most cost-effective discount, and use a fixed holding cost) is ___ units (enter your response as a whole number). - At the chosen level of quantity discount, and using the fixed holding cost, what is the total annual cost for Bell computers to order, purchase, and hold the integrated chips: $ ___ (round your response to the nearest whole number). b) Bell Computers wishes to recalculate using a 10% holding cost rather than the fixed $35 holding cost in part a. What is the most cost-effective order quantity, and what is the corresponding annual cost? - The most cost-effective order quantity (assuming they take the most cost-effective discount, and use a percentage-of-price holding cost) is ___ units (enter your response as a whole number). - At the chosen level of quantity discount, and using the percentage-of-price holding cost, what is the total annual cost for Bell computers to order, purchase, and hold the integrated chips: $ ___ (round your response to the nearest whole number).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar 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.