Jays Sporting Goods is a chain of sporting goods stores found in 1948 and with locations throughout the United States. One of their top selling products each Spring and Summer are fishing rod & reel combinations. The location in Selinsgrove, PA is trying to expand sales for fishing equipment into the winter months, and has started stocking products by the brand Thirteen Fishing, which include ice fishing equipment. The table below provides data from Q4 of 2023 for rod & reel combo inventory at the Selinsgrove location. The store did not receive any inventory replenishments during this quarter. a) What was the in-stock probability across all rod & reel products in the table above over the quarter? b) What was the in-stock probability of just the ice fishing products in the table above over the quarter? c) A consumer entering the store last quarter wants to buy a Thirteen Fishing branded rod and reel combo listed in the table above. Would this consumer be more likely to find an icefishing product or a non-ice fishing product in-stock?

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

Jays Sporting Goods is a chain of sporting goods stores found in 1948 and with locations throughout the United States. One of their top selling products each Spring and Summer are fishing rod & reel combinations. The location in Selinsgrove, PA is trying to expand sales for fishing equipment into the winter months, and has started stocking products by the brand Thirteen Fishing, which include ice fishing equipment. The table below provides data from Q4 of 2023 for rod & reel combo inventory at the Selinsgrove location. The store did not receive any inventory replenishments during this quarter.

a) What was the in-stock probability across all rod & reel products in the table above over the quarter?

b) What was the in-stock probability of just the ice fishing products in the table above over the quarter?

c) A consumer entering the store last quarter wants to buy a Thirteen Fishing branded rod and reel combo listed in the table above. Would this consumer be more likely to find an icefishing product or a non-ice fishing product in-stock? 

SKU Name
("Thirteen Fishing" branded
products)
Fate FT Casting Combo Rod
Fate FT Spinning Combo
Rod
BlackBetty Ghost Stealth Ice
Fishing Combo
Tickle Stick 3 Ice Rod
Snitch Pro Spin Combo
Wicked Long Stem Ice Fishing
Combo
Noise Ice Spinning Rod
Free Fall Ghost/Fate V3 Ice
Combo
FreeFall Ghost Patriot Ice
Combo
Wicked Stealth Ice Spinning
Combo
Ice
Fishing
Product?
NO
NO
YES
YES
NO
YES
YES
YES
YES
YES
MSRP
$ 99.99
$ 99.99
$130.00
$ 60.00
$79.99
$ 59.99
$29.99
$130.00
$130.00
$ 89.99
Starting
Inventory
15
21
22
8
10
35
18
15
12
20
Ending
Inventory
0
10
20
0
0
33
3
13
11
8
Transcribed Image Text:SKU Name ("Thirteen Fishing" branded products) Fate FT Casting Combo Rod Fate FT Spinning Combo Rod BlackBetty Ghost Stealth Ice Fishing Combo Tickle Stick 3 Ice Rod Snitch Pro Spin Combo Wicked Long Stem Ice Fishing Combo Noise Ice Spinning Rod Free Fall Ghost/Fate V3 Ice Combo FreeFall Ghost Patriot Ice Combo Wicked Stealth Ice Spinning Combo Ice Fishing Product? NO NO YES YES NO YES YES YES YES YES MSRP $ 99.99 $ 99.99 $130.00 $ 60.00 $79.99 $ 59.99 $29.99 $130.00 $130.00 $ 89.99 Starting Inventory 15 21 22 8 10 35 18 15 12 20 Ending Inventory 0 10 20 0 0 33 3 13 11 8
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 12 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.