1. Suppose that the rate of customer demand for candy bars at Grocery City is constant at a rate of 400 candy bars per week. Each time that Grocery City places an order for more candy bars it must pay processing fees of $15 regardless of the size of the order. Holding costs for candy bars are 80.1 per candy bar per week. Finally, leadtime for the delivery of candy bars is 0 days. Assume that there are 52 weeks in a year. a. Suppose that Grocery City places an order for 600 candy bars each time that its inventory of candy bars reaches 50. Draw a graph showing the number of candy bars that Grocery City has on-hand in inventory at each point in time up until the time when it places its fourth order. Label the points in time at which Grocery City places a new order. What will be Grocery City's average inventory holding costs per unit time? What will be Grocery City's average fixed ordering costs per unit time? Assume that Grocery City starts out with 650 candy bars on day 0. b. Assuming that Grocery City would like to minimize the sum of its average purchasing, fixed ordering and holding costs per unit time, what is the optimal number of candy bars for Grocery City to purchase each time that it places an order and what should be its reorder point? c. Suppose now that it takes 0.5 weeks for each order of candy bars to be delivered. When the quantity of candy bars reaches what level should Grocery City place an order for more candy bars? Assume that Grocery City orders according to the optimal order quantity from part b above.

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

help me with parts a,b,c. and please draw out the graph for me 

1. Suppose that the rate of customer demand for candy bars at Grocery City is constant at a rate
of 400 candy bars per week. Each time that Grocery City places an order for more candy bars it
must pay processing fees of $15 regardless of the size of the order. Holding costs for candy bars are
80.1 per candy bar per week. Finally, leadtime for the delivery of candy bars is 0 days. Assume
that there are 52 weeks in a year.
a. Suppose that Grocery City places an order for 600 candy bars each time that its inventory
of candy bars reaches 50. Draw a graph showing the number of candy bars that Grocery City has
on-hand in inventory at each point in time up until the time when it places its fourth order. Label
the points in time at which Grocery City places a new order. What will be Grocery City's average
inventory holding costs per unit time? What will be Grocery City's average fixed ordering costs
per unit time? Assume that Grocery City starts out with 650 candy bars on day 0.
b. Assuming that Grocery City would like to minimize the sum of its average purchasing, fixed
ordering and holding costs per unit time, what is the optimal number of candy bars for Grocery
City to purchase each time that it places an order and what should be its reorder point?
c. Suppose now that it takes 0.5 weeks for each order of candy bars to be delivered. When the
quantity of candy bars reaches what level should Grocery City place an order for more candy bars?
Assume that Grocery City orders according to the optimal order quantity from part b above.
Transcribed Image Text:1. Suppose that the rate of customer demand for candy bars at Grocery City is constant at a rate of 400 candy bars per week. Each time that Grocery City places an order for more candy bars it must pay processing fees of $15 regardless of the size of the order. Holding costs for candy bars are 80.1 per candy bar per week. Finally, leadtime for the delivery of candy bars is 0 days. Assume that there are 52 weeks in a year. a. Suppose that Grocery City places an order for 600 candy bars each time that its inventory of candy bars reaches 50. Draw a graph showing the number of candy bars that Grocery City has on-hand in inventory at each point in time up until the time when it places its fourth order. Label the points in time at which Grocery City places a new order. What will be Grocery City's average inventory holding costs per unit time? What will be Grocery City's average fixed ordering costs per unit time? Assume that Grocery City starts out with 650 candy bars on day 0. b. Assuming that Grocery City would like to minimize the sum of its average purchasing, fixed ordering and holding costs per unit time, what is the optimal number of candy bars for Grocery City to purchase each time that it places an order and what should be its reorder point? c. Suppose now that it takes 0.5 weeks for each order of candy bars to be delivered. When the quantity of candy bars reaches what level should Grocery City place an order for more candy bars? Assume that Grocery City orders according to the optimal order quantity from part b above.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 1 steps

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