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

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
Please do not give solution in image format thanku
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 gift shop sells 400 boxes of scented candles a year. The ordering cost is $50 for scented candles, and holding cost is $25 per box per year. What is the economic order size for scented candles?
5
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.)
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?
SKU One is sold at retail store for $8 per unit. SKU One has a weekly demand of 975 units with an average lead time of 5 weeks and a standard deviation of lead time of 2 weeks. Based on the information and a 95% service level, what is the reorder point for SKU One? please show work how to solve

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