Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
A manufacturer has a production facility that requires 15,604 units of component JY21 per year.
Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a
lead time of 7 days. The unit purchase cost is $25.6 per unit. The cost to place and process an order
from the supplier is $121 per order. The unit inventory carrying cost per year is 10.5 percent of the
unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If
the manufacturer uses a constant order quantity of 2,640 units per order, what is the annual holding
cost?
Use at least 4 decimal places.
A large manufacturer purchases a part from a supplier under a continuous review system. The average demand is 400 units a day with a standard deviation of 50 units a day. It costs $55 to process each order.
The holding cost for a part is $0.2 per month and the company has a policy of maintaining a 96% service level. The company operates 315 days per year. The time from when an order is placed to when it arrives at the company from its vendor is 5 days.
a- What is the reorder point?
b- What order quantity would be appropriate
c- What is the total annual cost for this item?
A manufacturing plant procures 100,000 filters per year. Each unit has a fixed order cost is $50. To maintain the inventory in optimal conditions, there is a carrying cost rate of 10% per year. The vendor of filters has offered the following price breaks: for orders of more than 5,000 filters, cost is $4.50/unit; for orders between 1,000 and 5,000 filters, cost is $4.75/unit; orders less than 1,000 filters have a cost of $5.00/unit.
Find the economic order quantity.
Calculate the average annual cost for the optimal solution.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.arrow_forwardYou run a food bar in UCLA Ackerman, and you sell chocolate croissants for breakfast. Your daily demand for chocolate croissants is on average 50, with a standard deviation of 8. The unit cost of a croissant is $0.70, and you sell at a unit price of $3.00. The refrigerated chocolate croissant must be consumed within 7days (one week) after purchased from your supplier, so you dispose leftover inventory and purchase fresh croissants once every week. Assume the demand in each of the seven days is independently distributed. (The z-table for normal distribution is attached.) (a) What is the optimal weekly purchase quantity for the chocolate croissant? What is average inventory? A student leader, Mark, came to you one day and told you that Anderson School would hold a special event next Thursday morning, and there would be additional demand for the chocolate croissant on that day. Mark wants to reserve a certain amount of croissant from you and sell in the special event at the regular price.…arrow_forwardA retailer has two stores selling the same product. Weekly demand at store 1 is normally distributed with a mean of 100 and a standard deviation of 10, while weekly demand at store 2 is normally distributed with a mean of 150 and a standard deviation of 25. Demand at the two stores is independent. The retailer orders from a supplier with a 1 week lead time using a periodic review policy with a review period of 1 week, and targets a 95% service level. If the retailer wants to centralize inventory across the two stores, i.e., hold just one stock of inventory to serve demand from both stores, what should the order-up-to level be? PLEASE SHOW CALCULATIONarrow_forward
- You are a newsvendor selling the New York Times every morning. Before you get to work, you buy the day’s newspaper for $0.90 a copy. You sell a copy of the New York Times for $4.0. Daily demand is distributed normally with a mean of 130 and a standard deviation of 20. At the end of each morning, any leftover copies can be sold to a recycling center for $0.10. How many copies of the New Yorkarrow_forwardConsider a two-tier supply chain with one manufacturer and one retailer whointeract in a single selling season. The manufacturer sells a product to the retailer, who in turn sells in the market. Demand E is uncertain with cumulative distribution function F (·)and probability density function f (·). Since the production lead time is much longer thanthe selling season, the retailer must place a single order before demand is realized and cannotreplenish her inventory during the season. The retailer sells the product at an exogenousand fixed retail price r. The manufacturer produces the product at a unit cost of c. Themanufacturer uses a linear sales rebate contract and determines the following contract terms:For each unit ordered, he charges the retailer a wholesale price w, and for each unit sold, hepays the retailer a rebate s. Assume that the product has zero salvage value at the end ofthe season, and the inventory holding cost during the season is…arrow_forwardDan’s Independent Book Store is trying to decide on how many copies of a book to purchase at the start of the upcoming selling season. The book retails for $28.00. The publisher sells the book to Dan at $20.00. Dan can dispose of all of the unsold copies of the book at 50% off the retail price, at the end of the season. Dan estimates that demand for this book during the season is Normal with a mean of 1000 and a standard deviation of 250. Question 1: What is the quantity that Dan should order to maximize his expected profit?arrow_forward
- Firewire is a high-end manufacturer of surfboards. A surfboard is sourced at a cost of $80 and sold for $125 to surf shops in its home market (United States). One order is placed at the beginning of the summer season. Currently, Firewire disposes any unsold boards to their outlet store affiliates for $70. It costs $10 to hold a board in inventory for the entire season and ship it to outlet affiliates. Demand for this item is forecasted to be normally distributed with a mean of 4,000 units and a standard deviation of 1750 units. A) Please provide ideal service level and order quantity? Expected profits? Expected overstock to outlets?.... under your preferred policy. B) If Firewire chooses instead of outlets to ship to Australia surf shops, the salvage value would increase to $75 per unit (board) including all associated costs (including the aforementioned holding costs). Would this be a better option?….please show each result as in part A for this alternative scenario to justify your…arrow_forwardA book and paper store distributes one specialized monthly magazine. When looking at the sales the last years, they have concluded that the demand for each issue of the magazine will be normally distributed with an expected sale of 250 and a standard deviation of 100. The purchase price for the magazine is $20. and the sales price is $50.The store has an agreement with a second -hand store that buys unsold magazines for $5 each. How many magazines should the store buy of each issue?arrow_forwardYour County has asked you to analyze the purchase of some dump trucks. Each truck wil cost $45,000 and have an operating and maintaining cost that starts at $15,000 the first year and increases by $ 2,000 per year. Assume the salvage value at the end of year is $9,000 and the interest rate is 12%. Estimate the equivalent annual cost of each truck.arrow_forward
- One of the products stocked at Weiss’s paint store, mentioned in Problem 14, is a certain type of highly volatile paint thinner that, due to chemical changes in the product,has a shelf life of exactly one year. Al Weiss purchases the paint thinner for $20 a galloncan and sells it for $50 a can. The supplier buys back cans not sold during the yearfor $8 for reprocessing. The demand for this thinner generally varies from 20 to 70cans a year. Al assumes a holding cost for unsold cans at a 30 percent annual interestrate.a. Assuming that all values of the demand from 20 to 70 are equally likely, what is theoptimal number of cans of paint thinner for Al to buy each year?b. More accurate analysis of the demand shows that a normal distribution gives abetter fit of the data. The distribution mean is identical to that used in part (a), andthe standard deviation estimator turns out to be 7. What policy do you nowobtain?arrow_forwardTorrance Refinery produces approximately 23.1 Million barrels of gasoline per year. A California distributor sources its gasoline from the Torrance refinery. The annual demand for gasoline at the California distributor is 5.3 Million barrels. The cost of storing gasoline is approximately $29 per barrel (per year). The cost of placing an order to the Torrance refinery (including shipping) is $7300 per order. Orders will be received gradually instead of delivered all at once (hence EPQ). At what quantity will the total cost of procurement be the lowest? Round your answer to the nearest whole number. Do NOT include a comma. For example, answer like 103542 and NOT 103,542 Answer: 58845 Checkarrow_forwardAlgro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,