Cogent Technology Retail Store (profit/tablet) Supply Vendor Location Store 1 Store 2 Store 3 Store 4 Store 5 Store 6 Alum Rock $ 9 $ 8 $11 $12 $7 $ 8 26 Berkeley 10 10 8 6 7 40 Concord 6 6 7 4 20 Daly City 4 6 8 10 40 East Foothills 12 10 8 6 7 45 Demand 25 15 30 18 27 35

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

Cogent Technology has computer stores on the West Coast. Their stores are set up like warehouse clubs focusing on high volume. Cogent Technology has a hub set up for their distribution. For instance, to serve the Silicon Valley area, a Cogent Technology warehouse is set up in San Jose to serve nearby stores. Cogent Technology warehouse managers generally purchase their items in bulk to get volume discounts from their vendors. Cogent Technology warehouse has an agreement with the vendors that they can return unsold inventory if it does not sell in six months. Cogent Technology has a policy of fulfilling all customer orders. In some cases when the store managers foresee a stockout situation, they are authorized to buy from other vendors rather than wait for the warehouse to deliver their items. In some cases, the prices bought directly by the store managers are cheaper than what the warehouses buy in bulk.

A good example of a sellable item is tablets. Cogent Technology warehouses purchase their stock from vendors based in Alum Rock, Berkeley, Concord, Daly City, and East Foothills and then ships it to its six stores in Silicon Valley. The vendors know that Cogent Technology retail stores are authorized to buy directly from other vendors so they decide to limit the number of tablets the warehouse can purchase. The table below shows the profit that Cogent Technology makes per tablet, based on which location the item is purchased and at which warehouse it is sold. The table also includes the available tablets per week at the retail locations and the display space available at each retail store per week.

1) Determine the most optimal model for Cogent Technology to maximize their profits. You may use a computer application to solve this problem.

2) If a Cogent Technology warehouse can buy all its tablets from a local store that will result in a profit of $7 per tablet at store 5; $8 per tablet at stores 2 and 6; and $9 per tablet at stores 1, 3, and 4, should Cogent Technology purchase all, some or none of its tablets from this vendor? Explain your answer quantitatively and qualitatively.

3) Recommend a strategy for Cogent Technology.

 

### Supply and Demand Analysis for Cogent Technology Retail Store

This table illustrates the profit per tablet (in dollars) that various Cogent Technology Retail Stores can generate from different Vendor Locations. It provides insight into the supply and demand dynamics across these locations.

#### Vendor Locations and Profits:

- **Alum Rock**: 
  - Store 1: $9
  - Store 2: $8
  - Store 3: $11
  - Store 4: $12
  - Store 5: $7
  - Store 6: $8
  - Total Supply: 26 tablets

- **Berkeley**:
  - Store 1: $10
  - Store 2: $10
  - Store 3: $8
  - Store 4: $6
  - Store 5: $9
  - Store 6: $7
  - Total Supply: 40 tablets

- **Concord**:
  - Store 1: $8
  - Store 2: $6
  - Store 3: $6
  - Store 4: $5
  - Store 5: $7
  - Store 6: $4
  - Total Supply: 20 tablets

- **Daly City**:
  - Store 1: $4
  - Store 2: $6
  - Store 3: $9
  - Store 4: $5
  - Store 5: $8
  - Store 6: $10
  - Total Supply: 40 tablets

- **East Foothills**:
  - Store 1: $12
  - Store 2: $10
  - Store 3: $8
  - Store 4: $9
  - Store 5: $6
  - Store 6: $7
  - Total Supply: 45 tablets

#### Demand by Retail Store:

- **Store 1**: 25 tablets
- **Store 2**: 15 tablets
- **Store 3**: 30 tablets
- **Store 4**: 18 tablets
- **Store 5**: 27 tablets
- **Store 6**: 35 tablets

This data is crucial for understanding where the greatest potential for profit exists and how supply can meet demand across different
Transcribed Image Text:### Supply and Demand Analysis for Cogent Technology Retail Store This table illustrates the profit per tablet (in dollars) that various Cogent Technology Retail Stores can generate from different Vendor Locations. It provides insight into the supply and demand dynamics across these locations. #### Vendor Locations and Profits: - **Alum Rock**: - Store 1: $9 - Store 2: $8 - Store 3: $11 - Store 4: $12 - Store 5: $7 - Store 6: $8 - Total Supply: 26 tablets - **Berkeley**: - Store 1: $10 - Store 2: $10 - Store 3: $8 - Store 4: $6 - Store 5: $9 - Store 6: $7 - Total Supply: 40 tablets - **Concord**: - Store 1: $8 - Store 2: $6 - Store 3: $6 - Store 4: $5 - Store 5: $7 - Store 6: $4 - Total Supply: 20 tablets - **Daly City**: - Store 1: $4 - Store 2: $6 - Store 3: $9 - Store 4: $5 - Store 5: $8 - Store 6: $10 - Total Supply: 40 tablets - **East Foothills**: - Store 1: $12 - Store 2: $10 - Store 3: $8 - Store 4: $9 - Store 5: $6 - Store 6: $7 - Total Supply: 45 tablets #### Demand by Retail Store: - **Store 1**: 25 tablets - **Store 2**: 15 tablets - **Store 3**: 30 tablets - **Store 4**: 18 tablets - **Store 5**: 27 tablets - **Store 6**: 35 tablets This data is crucial for understanding where the greatest potential for profit exists and how supply can meet demand across different
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 9 steps with 6 images

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.