Question: Show how to caculate in Excel: 3 . Using the data below, find the EOQ, the total annual cost associated with the economic order quantity,

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 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!

Q:

MBA 280 Fall 2017 Inventory Management Time Frame: Class 5 - Class 6 References: Operations Management Reading: Managing Inventory Simulation: Root Beer Game Played in Class 6, Oct 5th, Check Saclink...

Q:

Question 2 of 3 5 Check My Work (1 remaining) B eBook MamaMia's Pizza purchases its pizza delivery boxes from a printing supplier. MamaMia's delivers on average 340 plzzas each month assume...

Q:

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...

Q:

Determine the reorder point for spatulas. Use a whole number. [1] Tip: Before entering the answer, make sure that your formula uses the daily sales for spatulas, not for other products as may have...

Q:

1 1 . 4 ) MamaMia s Pizza purchases its pizza delivery boxes from a printing supplier. MamaMia s delivers on average 2 4 5 pizzas each month ( assume deterministic demand ) . Boxes cost 5 6 cents...

Q:

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...

Q:

A. B. C. Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their...

Q:

Please put in EXCEL format 1. Apply ABC analysis for the following items: Item Number Item Cost (5) 4.0 1.5 0.25 2.0 A111 B111 C111 D111 E111 F111 G111 H111 I111 J111 K111 L111 Annual Usage (Unit)...

Q:

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...

Q:

MBA 5 1 2 Homework Assignment H 2 - B Chapter 9 Forecasting and Demand Planning Enter Student Name: 0 PROBLEM # 3 "Using the data below, find the EOQ, and the total annual cost associated with the...

Q:

Consider the following two situations: On December 1, 2009, Harshas Cleaning Service, a new business, bought $6,500 of cleaning supplies. At the end of December, the business had $3,400 of supplies...

Q:

Is it appropriate for the federal government to require that all individuals purchase health insurance the so-called individual mandate of the PPACA?

Q:

ans Consider a converging lens with a focal point F . Without changing the shape and size of the lens, what could you do to move the focus closer to the lens? There is nothing you can do: the shape...

Q:

Assume that 1,600 units are sold during 2017. Compute the balance reported as ending inventory on its 2017 balance sheet using a FIFO inventory costing method. Assume Wellman Ltd. reports the...