Question

I want only the answer to Q2 and Q3 please show your work step by step...

I want only the answer to Q2 and Q3 please show your work step by step and show how did you do the graph in Q2

Q1). A specialty coffeehouse sells Colombian coffee at a fairly steady rate of 280 pounds annually. The beans are purchased from a local supplier for $2.40 per pound. The coffee house estimates that it costs $45 in paperwork and labor to place an order for the coffee, and holding costs are based on a 20 percent annual interest rate. a. Determine the optimal order quantity for Colombian coffee. b. What is the time between placement of orders? c. What is the average annual cost of holding and setup due to this item? d. If replenishment lead-time is three weeks, determine the reorder level based on the on-hand inventory.

Q2). For the situation described in Problem 1, draw a graph of the amount of inventory on order. Using your graph, determine the average amount of inventory on order. Also compute the demand during the replenishment leadtime. How do these two quantities differ?

Q3). A large automobile repair shop installs about 1,250 mufflers per year, 18 percent of which are for imported cars. (Assume a very steady demand rate.) All of the imported-car mufflers are purchased from a single local supplier at a cost of $18.50 each. The shop uses a holding cost based on a 25 percent cost of capital. The fixed cost for placing an order is estimated to be $28. a. Determine the optimal number of imported-car mufflers the shop should purchase each time an order is placed, and the time between placements of orders. b. If the replenishment lead-time is six weeks, what is the reorder point based on the level of on-hand inventory? c. The current reorder policy is to buy imported-car mufflers only once a year. What is the additional holding and setup cost incurred by this policy?

Homework Answers

Answer #1

Answer 2:- Average inventory on order = Q(?/T) = 229×3/42.53 = 16

Demand during lead time = ?? = 280×3/52= 16

There is no difference between the two.

Qt/T = ??

Answer 3:-

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A specialty coffeehouse sells Columbian coffee for $7 per pound at a fairly steady rate of...
A specialty coffeehouse sells Columbian coffee for $7 per pound at a fairly steady rate of 320 pounds annually. The beans are purchased from a local supplier for $1.80 per pound. The coffeehouse estimates that it costs $30 in paperwork and labor to place an order for the coffee, and holding costs are based on a 12 percent annual interest rate a. Determine the optimal order quantity for Colombian coffee. b. What is the time between placement of orders? c....
A particular type of rubber is used in the production of tennis balls and the company...
A particular type of rubber is used in the production of tennis balls and the company must decide on three different suppliers. Supplier A will sell the rubbers for $1.50 per rubber and will not accept any orders fewer than 7,000. Supplier B will sell the rubbers for $1.40 each but will not consider an order for greater than 8,500 rubbers, and Supplier C will sell the rubbers for $1.35 each but will not accept an order for greater than...
The Ziggys Bicycle Shop operates 364 days a year, closing only on Christmas Day. The shop...
The Ziggys Bicycle Shop operates 364 days a year, closing only on Christmas Day. The shop pays $400 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle is estimated to be 20% of the dollar value of inventory. The shop sells an average of 20 bikes per week. The cost for each order is $225. Determine the optimal order quantity, optimal number of orders, order cycle time, and the total minimum cost. Determine reorder point...
Hotel Singapura uses plastic litter bags for housekeeping. The hotel places orders for these bags only...
Hotel Singapura uses plastic litter bags for housekeeping. The hotel places orders for these bags only when the inventory is below the reorder level. The hotel operates for 52 weeks a year, 7 days per week. The bags come in a pack of 12 and costs $10.75 each. The following information is available about these bags. Demand = 95 packs/week Order cost = $58/order Annual holding cost = 25% of cost Required service level = 90% Lead time = 4...
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from...
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every five weeks. Data for both products are as follows:   ITEM TEGDIW WIDGET   Annual demand 13,000 6,000   Holding cost (% of item cost)...
Weekly demand for the latest TV set at a retailer is normally distributed with a mean...
Weekly demand for the latest TV set at a retailer is normally distributed with a mean of 600 TVs and a standard deviation of 150. Currently, the store places orders to the supplier with a reorder point of 1,500 Tvs. Replenishment lead time is 2 weeks, fixed order cost per order is $200, each TV the retailer $300, and the inventory holding cost is 25% per year. If the retailer wants to achieve a 99% service level (use the z-value...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! You need to buy...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! You need to buy raw materials for your production process. You use 2,000 units of the raw material each year. The supplier quotes you a price of $9.50 per unit for an order size of 499 units or less, a price of $9 per unit for orders of 500 to 1499 units, and a price of $8.50 per unit for an order of 1,500 or more units. You...
For each answer, indicate ‘T’ for TRUE or ‘F’ for FALSE. (Please only specify ‘T’ or...
For each answer, indicate ‘T’ for TRUE or ‘F’ for FALSE. (Please only specify ‘T’ or ‘F’ – the grading criteria requires only a single letter.)  ***Read these carefully*** a) T or F: The longer the lead time for replenishment of inventory, the larger the order size must be. _____ b) T or F: Automating the ordering process so as to reduce the fixed administrative costs for placing orders should result in a reduction in cycle inventory (assuming the proper application...
The INDY Industrial Supply Company has finished a highly-sophisticated project where they separately determined order setup...
The INDY Industrial Supply Company has finished a highly-sophisticated project where they separately determined order setup (S) costs for each of their main suppliers, based on the specific ordering process for that supplier. They have determined that the ACME Supplier, from which they order six different SKUs, the setup cost for an order (which has been highly automated) to be $32.50 per order, with an additional cost of $3.25 for each line on the order. Annual demand data and cost...
A retailer is considering inventory management of one of its products with the annual demand of...
A retailer is considering inventory management of one of its products with the annual demand of 600 units (1 year = 50 weeks). The product is delivered directly from the manufacturer who guarantees that every order is delivered in 2 weeks. The retailer pays the manufacturer $150 per unit. Additionally, every time the manufacturer fills an order from the retailer, machine setup cost of $60 is charged on the retailer. Transportation from the manufacturer costs the retailer $40 per shipment...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT