Answered: Determine the optimal order quantity if…

Name: A Motor Vehicle parts supplier has a regional engine oil warehouse in
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: A Motor Vehicle parts supplier has a regional engine oil warehouse in Lusaka. One popular engine oil, Castrol GTX, has estimated demand of 25,000 next year. It costs the supplier $100 to place an order for this oil, and the annual carrying cost is 30

Business

Operations Management

Determine the optimal order quantity if the supplier quotes these prices for the oil:

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Long last Appliance Store has a demand of 1300 units per month for one of its fast selling portable smoothie machine (model G), it incurs a fixed order placement, transportation and receiving cost of $3000 each time an order is delivered. Each machine cost the company $550 and the company has a holding cost of 12%. The company has two other models of the smoothie machine which are also popular with consumers. Evaluate the company’s inventory management policy if lots for each model are ordered and delivered independently by determining the following: The optimal order size The cycle inventory The number of orders per year The annual ordering and holding cost The total cost of the inventory Briefly state rationale for the approach used for (a-e)
Andria Mullins, financial manager of Webster Electronics, has been asked by the firm's CEO, Fred Weygandt, to evaluate the company's inventory control techniques and to lead a discussion of the subject with the senior executives. Andria plans to use as an example one of Webster's "big ticket" items, a customized computer microchip which the firm uses in its laptop computer. Each chip costs Webster P200, and in addition it must pay its supplier a P1,000 fee on each order. Further, the minimum order size is 250 units; Webster's annual usage forecast is 5,000 units; and the annual carrying cost of this item is estimated to be 20 percent of the average inventory unit cost. Andria plans to begin her session with the senior executives by reviewing some basic inventory concepts, after which she will apply the EOQ model to Webster's microchip inventory. Question: Why is inventory management vital to the financial health of most firms?
Consider a supply chain with a manufacturer (M) and a retailer (R). The manufacturer produces a product A at a cost of c = $50. The manufacturer offers the product to the retailer at a wholesale price of w = $70, and fixes the sale price to p = $90. The market demand is normally distributed with mean of 10,000 units and standard deviation of 1000. Answer the following questions: a. What is the optimal order quantity for the retailer? b. What is the optimal order quantity if the wholesale price is changed to $60? Does the optimal order quantity increase or decrease compared to 1a? Why? c. What is the optimal order quantity if the wholesale price is changed to $80? Does the optimal order quantity increase and decrease compared to 1a? Why? d. If the actual market demand is equal to the mean demand, then what are the profits of the manufacturer and the retailer?
A newspaper publisher uses roughly 800 feet of baling wire each day to secure bundles of newspapers while they are being distributed to carriers. The paper is published Monday through Saturday.Lead time is six workdays. What is the appropriate reorder point quantity, given that the companydesires a service level of 95 percent, if that stockout risk for various levels of safety stock is as follows: 1,500 feet, .10; 1,800 feet, .05; 2,100 feet, .02; and 2,400 feet, .01?
A newspaper publisher uses roughly 880 feet of baling wire each day to secure bundles of newspapers while they are being distributed to carriers. The paper is published Monday through Saturday. Lead time is six workdays. What is the appropriate reorder point quantity, given that the company desires a service level of 95 percent, if that stockout risk for various levels of safety stock is as follows: 1,500 feet, .10; 1,900 feet, .05; 2,100 feet, .02; and 2,400 feet, .01?
ANT Infra orders two kinds of precast items: A and B for use in its projects from two different suppliers. The precasts are needed throughout the entire 52-week year. Precast A are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. While, precast B is ordered from a supplier who delivers by every three weeks. Data for both precast items are as follows:Item Precast A Precast BAnnual demand 10,000 5,000Holding cost (% of item cost)20% 20%Order cost $150 $25Lead time 4 weeks 1 weekSafety stock 55 units 5 unitsItem cost $10.00 $2.00 a. Employ Q system for precast A and calculate the EOQ, the reorder point, total inventory cost? b. Employ P system for precast B and estimate the target level inventory and total inventory cost?
Grand Styles Furniture Store is overstocked in (has excess inventory of) one type of chair. Based on the Price-Demand Relationship, what advice would you provide to the store manager to deal with this problem? Fancy Fashions sells jeans for $59 and sweaters for $39. To increase sales of jeans and sweaters, Fancy Fashions promotes this Product Price Bundle: “Buy a pair of jeans and a sweater for $98”. Will this Product Price Bundle will work well to increase the sales of jeans and sweaters?
The following table lists the demand for Betty’s Deluxe Chocolate Chip Muffins. Unsold muffins are given to a food bank with a salvage value of $1.00 per muffin. The cost is $2.50 per muffin. The muffins sell for $3.50 each. Using the single-period model, what is the optimal order quantity in number of muffins the supermarket should order? Quantity Probability Cumulative Probability 5 0.2 0.2 6 0.3 0.5 7 0.4 0.9 8 0.1 1.02.5 a. 7 b. 6 c. 5 d. 8 e. None of these are correct
The catering manager of La Vista Hotel, LisaFerguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enoughknives. She decides she needs to order some more silverware,but wants to take advantage of any quantity discounts hervendor will offer.For a small order (2,000 or fewer pieces), her vendorquotes a price of $1.80Ypiece.If she orders 2,001–5,000 pieces, the price drops to$1.60Ypiece. 5,001–10,000 pieces brings the price to$1.40Ypiece, and 10,001 and above reduces the price to $1.25.Lisa’s order costs are $200 per order, her annual holdingcosts are 5%, and the annual demand is 45,000 pieces. For thebest option:a) What is the optimal order quantity?b) What is the annual holding cost?c) What is the annual ordering (setup) cost?d) What are the annual costs of the silverware itself with anoptimal order quantity?e) What is the total annual cost, including ordering,…
ABC firm uses roughly 3,400 pounds of chemical dye a year. Currently, the firm purchases 300 pounds per order and pays P120.00 per pound. The supplier has just announced that orders of 1,000 pounds or more will be filled at a price of P80.00 per pound. The manufacturing firm incurs a cost of P4,000.00 each time it submits an order and assigns an annual holding cost of 17% of the purchase price per pound. a. Determine the order size that will minimize the total cost.b. If the supplier offered the discount at 1,500 pounds instead of 1,000 pounds, what order size would minimize total cost?
H&M’s chief demand planner has estimated that 9,250,000 units of clothing will be sold in 2021. H&M’scost of placing and processing an order is R250, while the annual cost of holding a unit in its distributioncentre is projected at 5% of the unit purchase price. Both costs are expected to be constant for theforeseeable future. On average H&M sells a unit of clothing for R300.00 at cost plus 50%. Orders arereceived two weeks after being placed with the supplier. Assume a 365-day year and that demand isconstant throughout the year.Furthermore, as part of the drive towards operational efficiency, the chief demand planner is thinkingabout using the seasonally-adjusted moving average method to forecast demand for H&M’s clothingfor the 2021 financial year. In this regard, Mrs Masuku has retrieved from the retailer’s database thefollowing information on number of clothing sold over a four–year period.Year Quarterly sales (‘000 units)Q1 Q2 Q3 Q42016 1300 1500 1200 20002017 1600…
A confectioner buys plastic boxes in bulk and uses them to pack chocolates. The annual requirement of these boxes is 1,200, and each box costs $30. The ordering and carrying costs are $10 per order and 20%, respectively. The supplier from whom the confectioner purchases these boxes sells them only in lots of 25, that is, you only purchase quantities in multiples of 25 boxes. If the supplier offers 2% discount on the cost of each box when the purchases are in quantities of 300 at a time, should the confectioner accept this offer?