OI AFG Company supplies an electronic amplifier to a company that incorporates these amplifiersto AC units and other home appliances. The annual demand for these amplifiers is 4000 units, andthis demand is constant throughout the year. The cost per unit is $10, and the inventory holding rateis estimated to be 5% of the unit cost per year. The ordering cost is $40 per order.a) To minimize cost, how many units should be ordered each time an order is placed?b) Estimate the total cost assuming the order quantity as in a?c) Suppose that the company was adopting a policy of ordering 1200 unit per order, what is thetotal cost under this policy and by how much it will be higher/lower than the total cost in b?d) For the ordering policy in c to be optimal, how much should be the ordering cost per order?

Given- Annual Demand (D) = 4000 Units Unit Cost (P) = $10 Holding Cost (H) = 5% of Unit Cost =…

Answered: QI AFG Company supplies an electronic…

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

Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field service offices. The yearly demand for these connectors is 15,200 units. Southeastern estimates its annual holding cost for this item to be 323 per unit. The cost to place and process an order from the supplier is $73. The company operates 300 days per year, and the lead time to receive an order from the supplier is 2 working days. a) What is the economic order quantity? units (round your response to the nearest whole number). b) What are the annual holding costs? $ (round your response to the nearest whole number) c) What are the annual ordering costs? S (round your response to the nearest whole number). d) What is the reorder point? units (round your response to the nearest whole number).
Wood County Hospital consumes 1,500 boxes of bandages per week. The price of bandages is $36 per box, and the hospital operates 52 weeks per year. The cost of processing an order is $15, and the cost of holding one box for a year is 20 percent of the value of the material. a. The hospital orders bandages in lot sizes of 900 boxes. What extra cost does the hospital incur, which it could save by using the EOQ method? $ 435.37 (Enter your response rounded to two decimal places.) b. Demand is normally distributed, with a standard deviation of weekly demand of 150 boxes. The lead time is 2 weeks. Refer to the standard normal table for z-values. What safety stock is necessary if the hospital uses a continuous review system and a 95 percent cycle-service level is desired? 348 boxes. (Enter your response rounded to the nearest whole number.) What should be the reorder point? boxes. (Enter your response rounded to the nearest whole number.) pm oints
Matthew Liotine's Dream Store sells water beds and assorted supplies. His best-selling bed has an annual demand of 405 units. Ordering cost is $38; holding cost is $5 per unit per year. a) To minimize the total cost, how many units should be ordered each time an order is placed? EOQ = units (round your response to the nearest whole number). b) If the holding cost per unit was $6.00 instead of $5, what would the optimal order quantity be? New EOQ = units (round your response to the nearest whole number). A
The manager of a car wash received a revised price list from the vendor who supplies soap, and a promise of a shorter lead time for deliveries. Formerly the lead time was four days, but now the vendor promises a reduction of 25 percent in that time. Annual usage of soap is 4,500 gallons. The car wash is open 360 days a year. Assume that daily usage is normal, and that it has a standard deviation of 2 gallons per day. The ordering cost is $30 and annual carrying cost is $3 a gallon. The revised price list (cost per gallon) is shown in the following table: Quantity 1 - 399 400 799 800 + Unit Price $2.00 1.70 1.62 Click here for the Excel Data File a. What order quantity is optimal? (Round your intermediate calculations to 2 decimal places and final answer to the nearest whole number.) Optimal order quantity ROP b. What ROP is appropriate if the acceptable risk of a stockout is 1.5 percent? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) gallons…
A daily newspaper is stocked by a coffee shop so its patrons can purchase and read it while they drink coffee. The newspaper costs $1.17 per unit and sells for $1.75 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of $1 per unit. Assume that daily demand is approximately normally distributed with μ = 150 and a = 30. (a) What is your recommended daily order quantity for the coffee shop? (Round your answer to the nearest integer.) (b) What is the probability that the coffee shop will sell all the units it orders? (Round your answer to four decimal places.) (c) In problems such as these, why would the supplier offer a rebate as high as $1? For example, why not offer a nominal rebate? Find the recommended order quantity at 25¢ per unit. (Round your answer to the nearest integer.) What happens to the coffee shop's order quantity as the rebate is reduced? The higher rebate ---Select-- the quantity that the coffee shop should order.
Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 3,000 rolls. The cost per roll is $1,000, and the annual holding cost is 28 percent of the cost. Each order costs $75. Part 2 a. How many rolls should Yellow Press order at a time? Yellow Press should order enter your response here rolls at a time. (Enter your response rounded to the nearest whole number.) Part 3 b. What is the time between orders? (Assume 200 workdays per year.) The time between orders is enter your response here days. (Enter your response rounded to one decimal place.)
Please do not give solution in image formate thanku. Race One Motors is an Indonesian car manufacturer. At its largest manufacturing facility, in Jakarta, the company produces subcomponents at a rate of 300 per day, and it uses these subcomponents at a rate of 12,500 per year (of 250 working days). Holding costs are $22 per item per year, and ordering costs are $32 per order. a) What is the economic production quantity b) how many production runs will be made each year c) what is the max inventory level d) what percentage of time will the facility be producing components e) what is the annual cost of ordering and holding inventory
A retailer anticipates selling 5,400 units of its product at a uniform rate over the next year. Each time the retailer places an order for æ units, it charged a flat fee of $100. Carrying costs are $27 per unit per year. How many times should the retailer reorder each year and what should be the lot size to minimize inventory costs? What is the minimum inventory cost? Use the formula EOQ to obtain your answers. They should order units The minimum inventory cost is $ times a year.
Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to answer the below questions. Annual demand 3,000 mufflers Standard deviation of daily demand 6 mufflers per working day Item cost $30 per muffler Annual holding cost 25% of item value Review period 15 working days Ordering cost $50 per order Service probability 90% Lead time 2 working days Working days 300 per year What is the optimal target level (order-up-to level)? Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number. If the service probability requirement is 95 percent, the optimal target level will: multiple choice Increase Decrease Stay the same
Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of order-ing tape is $1, and carrying costs are 40 cents per roll a year. Lead time is three days. a. What is the EOQ?b. What ROP will provide a lead time service level of 96 percent?
As the Manager of Branson’s Department Store, you are responsible for ensuring that reorder quantities for the various items have been correctly established. You decide to test one item and choose product Z. A continuous review inventory policy has been used, so you examine this as well as other records and come up with the following data: Cost per unit $35 Holding cost 20 percent of unit cost Average daily demand 10 units Ordering cost $30 per order Standard deviation of daily demand 3 units Delivery lead time 4 days Because customers generally do not wait but go elsewhere, you decide on a service probability of 90 percent. Assume that Branson’s Department Store operates 320 days per year. [What is the annual demand (D)? Determine the optimal order quantity, Q*. Determine the reorder point (R) if demand is constant. Determine the reorder point (R) if demand is varies.
Please do not give solution in image format thanku Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of ordering tape is $1 per order, and carrying costs are 40 cents per roll a year. Lead-time is three days. a) Ignoring the demand uncertainty (i.e., looking only at average values), find the economic order quantity (EOQ) and the reorder point (ROP). b) Consider now the uncertainty. The order quantity remains the same. If the target is to have a 99% annual service level, what should be the ROP

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS