Al Maha Company is specialized in mangoes distribution in the city of Muscat. Sales are 480 units per month. It costs OR 10 to make and receive an order and holding cost is OR 3.5 per unit per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the what is the total annual cost of the best option including purchasing cost

Al Maha Company is specialized in mangoes distribution in the city of Muscat. Sales are 480 units per month. It costs OR 10 to make and receive an order and holding cost is OR 3.5 per unit per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the what is the total annual cost of the best option including purchasing cost

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

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.
1. XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost ? Round -up to the nearest integer a. 164 units b. 199 units c. 500 units d. 180 units E. None is correct
XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR 2.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost? Round - up to the nearest integer?? a. 199 units O b. None is correct 500 units d. 180 units e. 220 units
XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 400 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is COR 3.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the best decision that minimizes the total annual inventory cost is
12. XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR 3.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the best decision that minimizes the total annual inventory cost is a. 185 units, Total cost = 30,649 b. 500 units, Total cost = 24,995 c. 200 units, Total cost =27,240 d. None is correct e. 450 units, Total cost = 23,500
11. XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 100 to make and receive an order and holding cost is OR 4.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost? Round - up to the nearest integer ?? a. 600 units b. 180 units C. 199 units d. None is correct e. 164 units f. 517 units
A local outdoor vegetable stand has exactly 1,000 square feet of space to displaythree vegetables: tomatoes, lettuce, and zucchini. The appropriate data for theseitems are given in the following table.ItemTomatoes Lettuce ZucchiniAnnual demand 850 1,280 630(in pounds)Cost per pound $0.29 $0.45 $0.25The setup cost for replenishment of the vegetables is $100 in each case, and thespace consumed by each vegetable is proportional to its costs, with tomatoes requiring 0.5 square foot per pound. The annual interest rate used for computingholding costs is 25 percent. What are the optimal quantities that should be purchased of these three vegetables?
A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a year, andordering costs are $96. The following price schedule applies. Determine the following:a. The optimal order quantityb. The number of orders per yearNumber of Boxes Price per Box1,000 to 1,999 $1.25 2,000 to 4,999 1.205,000 to 9,999 1.1510,000 or more 1.10
ABC Company has correctly computed its economic order quantity at 1,000 units; however, management feels it would rather order in quantities of 1,500 units. How should ABC’s total annual purchase order cost and total annual carrying cost for an order quantity of 1,500 units compare to the respective amounts for an order quantity of 1,000 units? A. Lower purchase order cost and lower carrying cost B. Lower purchase order cost and higher carrying cost C. Higher purchase order cost and higher carrying cost D. Higher purchase order cost and lower carrying costs
The catering manager of La Vista Hotel, Lisa Ferguson, is distu rbed 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 enough knives. She decides she needs to order some more silverware, but wants to take advantage of any quantity discounts her vendor willoffer.For a small order (2,000 or fewer pieces), her vendor quotes a price of$1.80 piece.I f she orders 2,001- 5,000 pieces, the price drops to $ 1.60/piece. 5,001- 10,000 pieces brings the price to $1.40/ piece, and I 0,00 I and above reduces the price to $1.25.Lisa's order costs are $200 per order, her annual holding costs are 5%, and the annual demand is 15,000 pieces. For the best 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 a re the annual costs of the silverware itself with an optimal order quantity?e) What is the total annual cost, including…
The campus store at a large Midwestern university sells writing tablets to students, faculty, and staff. They sell more tablets near exam time. During a typical 10-week quarter,the pattern of sales is 2,280, 1,120, 360, 3,340, 1,230, 860, 675, 1,350, 4,600, 1,210.Thepads cost the store $1.20 each, and holding costs are based on a 30 percent annual interest rate. The cost of employee time, paperwork, and handling amounts to $30 per order.Assume 50 weeks per year.b. The bookstore manager has decided that it would be more economical if thedemand were the same each week. In order to even out the demand he limits weeklysales (to the annoyance of his clientele). Hence, assume that the total demand forthe 10-week quarter is still the same, but the sales are constant from week to week.Determine the optimal order policy in this case and compare the total holding andordering cost over the 10 weeks to the answer you obtained in part (a). (You may assume continuous time for the purposes of your…
The campus store at a large Midwestern university sells writing tablets to students, faculty, and staff. They sell more tablets near exam time. During a typical 10-week quarter,the pattern of sales is 2,280, 1,120, 360, 3,340, 1,230, 860, 675, 1,350, 4,600, 1,210.Thepads cost the store $1.20 each, and holding costs are based on a 30 percent annual interest rate. The cost of employee time, paperwork, and handling amounts to $30 per order.Assume 50 weeks per year.a. What is the optimal order policy during the 10-week quarter based on theSilver–Meal heuristic? Using this policy, what are the total holding and orderingcosts incurred over the 10-week period?