Answered: PROBABILITY 0.24 0.08 0.21…

PROBABILITY 0.24 0.08 0.21 0.16 0.08 0.23 VALUE 1 2 3 4 5 6 PURCASE COST C = 12 SELLING PRICE P = 28 SALVAGE VALUE V = 4 What is the optimal order quantity?

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

See similar textbooks

Similar questions

Please help to solve step by step.
Current decision to buy: Ross White's machine shop uses 300 brackets each month during the course of a year. This usage is relatively constant throughout the year. Currently, these brackets are purchased from a supplier 100 miles away for $25 each and the lead time is 2 days. The holding cost per bracket per year is $3.75 (15% of the unit cost) and the annual ordering cost per order is $18.50. There are 240 working days per year. Possible future decision to make in-house: Ross White is reconsidering his decision of buying the brackets and is considering making the brackets in-house. He has determined the set up costs would be $22.50 in machinist time and lost production time. Forty eight brackets could be produced in a day once the machine has been set up. Ross estimates that the cost (including labor and materials) of producing one bracket would be $22.85. The holding cost would be 12% of the cost. What is the EOQ given Ross' current decision to buy the brackets? What is the…
Josie Gall's firm has developed the supply, demand, cost, and inventory data that follow. Supply Available Period 1 2 3 Regular Time 40 35 40 Overtime 15 15 15 Subcontract 10 10 10 Demand Forecast 30 units $100 $150 $200 $6 50 65 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period, and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is (Enter your response as a whole number.)
10. A company will sell remote control devices online. Expected yearly demand is 3000 units and it is sold per 250TL. The controllers can be purchased from supplier A. Ordering cost is 40 TL and annual holding cost is 25% of the price. a. Calculate the economic order quantity for the company. b. Calculate the number of orders per year. c. List the assumptions of EOQ model that you used to calculate the value in part A.
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is $6. Allen Mfg. Quantity 1-499 Baker Mfg. Unit Price Quantity Unit Price $16.00 1-399 $16.10 15.50 15.00 400-799 800+ 500-999 1000+ 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 381 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? The optimal order quantity is ☐ with a total cost of $ (round your responses to the nearest whole number).
Q4: Suppose that the demand for a product is 400 per year, and the items are withdrawn uniformly. The order cost is $25 and the inventory holding cost is $0.5 per item per year. If shortages cost $1 per item per year, find: 1. The economic order quantity. 2. Maximum inventory. 3.Shortage allowable quantity.
7. SBS Juices sell orange juice. Every morning (7am) the manager has to decide on the amount (liter) of juice to make for customers arriving between 8am and 9am. Demand for the juice follows a normal distribution with a mean of 20 liters per day and a standard deviation of 5 liters per day. Price per liter is $48.067, material cost per liter is $40, and salvage value per liter is $10. What is the optimal level of juice to make each morning to maximize expected profit?
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $45, and annual holding cost per unit is $4. Allen Mfg. Quantity 1-499 500-999 1000+ Baker Mfg. Unit Price $16.00 15.50 15.00 Quantity 1-399 400-799 800+ Unit Price $16.10 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 435 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? (round your responses to the nearest whole number). The optimal order quantity is ☐ with a total cost of $
The seasonal demand for a particular product is given below: Period 123 4 5 6 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity
Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Period 1 W N 3 Regular Time 30 35 40 Overtime 15 15 20 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract 10 10 10 Subcontract cost per unit Carrying cost per unit per month 20 units $100 $160 $250 $2 Demand Forecast 40 55 60 Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number).
1. Suppose the demand of a product in a retail store is 800 per year and it occurs at a constant rate. Placement of an order of this product to an outside supplier by the store is 40 Dollar. The super market authority has calculated the inventory holding cost per unit per year as 90 cents. Assuming no occurrence of shortages of the product, find a) i. the minimal order quantity of the product from the outside supplier if the product is not allowed to sell during production. ii. the minimal number of orders per year. Explain whether the nearest integer number of orders per year is justified. iii. the cycle time of a lot in months. iv. the annual minimal total cost of ordering and inventory holding for that minimal order quantity. v. the reorder point if the lead time of delivering a lot is 2 days,? b) If the production rate of processing the product is 1200 per year and the set up cost per set up is 65 Dollar. If the selling of the product is allowed during production, determine i) the…
Chris usually sells 120 copies of newspaper each day and believe that sale are normally distributed, with a standard deviation of 15 papers. He pays 70 cents for each paper, which sells $1.25. For each unsold paper, he receives 30-cent credit. a) determine how many papers he should order each day b) calculate the stockout risk for that quantity.