Question: Please include excel calculations 3. Using the data below, find the EOQ, the total annual cost associated with the economic order quantity, the reorder point,

Please include excel calculations

3. Using the data below, find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year, and the time between orders.

Annual Demand	15,600 units
Weeks Operating	52 weeks/year
Set up Cost	$60/order
Holding rate	20%
Unit cost	$80 /unit
Lead-Time	5 weeks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Show how to caculate in Excel: 3 . Using the data below, find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year and the time...

Using the data below, find the EOQ, the total annual cost associated with the economic order quantity, and the reorder point. Annual Demand: 8,000 units Weeks Operating: 52/year Ordering Cost:...

Can you please write it clear? Step by step? Because I posted this 4 times and I don't understand. And write numbers, i.e., 2 ( a), 2 ( b), etc. Thanks! MBA612 - Homework Assignment - H2-B Chapter...

MBA612 - Homework Assignment - H2-B Chapter 9Forecasting and Demand Planning You must show all formulas, calculations, and circle correctanswers. PROBLEMS 1. Using the data shown below, compute the...

Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year and the time between orders. Annual Demand 15,600 units Weeks Operating...

Basic Inventory Management: When to Order & How Much to Order Learning objectives. 1. Building initial skills to solve basic inventory management problems. 2. Learning to model problems in Excel and...

pler 11: Assignment Assignments Chapter 1 Assignment Sert Sign for Gorg Questions Problem 11-06 Algorithme .. ched My Work Ciremainino 1 . 3 B DO OOOOOO ebook Mama's purchase its plaza delivery boas...

Component SM-782 has an annual demand of 3,500. The ordering cost is $200 per order with a lead time of 4 days. Inventory holding cost is $140 per unit per year. Assuming 350 working days per year,...

You are the manager of an independent high street shoe store, specializing in fashionable shoes for men and women. Your staff comprises a small team of eight salespeople who all take part in selling...

-14x + 21y + 7

A large retail corporation repurchases 2 5 percent of its outstanding common stock from the open ( secondary ) market using cash. This activity will most likely result in: A decrease in total assets....

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...