Basic economic order quantity model in excel

Assignment Help Operation Management

Reference no: EM132112296

In this assignment you’ll solve the basic economic order quantity (EOQ) model in Excel using two methods: (A) a trial-and-error approach to find a very good but approximate answer, and (B) the EOQ formula to find the “exact” answer. Set up your spreadsheet similar to that shown below.

The situation: Roxie is responsible for purchasing the paper used in all copy machines and laser printers at Budco. After looking at her records, Roxie has found demand for paper averages 600 boxes per month. The price of a box of paper is $20 (regardless of the number ordered). Placing and handling an order costs $70. Annual unit holding costs per box are 25% of the unit price. Last year, Roxie ordered paper once every 2 months, but she wants to know if another ordering policy would be cheaper.

B. EOQ (Exact) Formula

2. What order quantity Q* minimizes total annual order + holding costs? boxes

3. The Excel cell formula required for cell E5 is SQRT(2*B1*B3/B4). What Excel cell formula is required for cell F5?

4. At Q*, what are the total annual ordering + holding costs?

5. How many times per year will Roxie place an order of size Q*?

6. Last year, Roxie ordered every 2 months. Her total annual ordering+holding costs were _____

7. What is the percentage reduction in annual ordering + holding costs achieved by Roxie in following the optimal inventory policy instead of last year’s ordering policy?

Reference no: EM132112296

Questions Cloud

Describe features of copyrights and risk control measures : Describe the features of copyrights and risk control measures for copyright loss exposures.

Adjust your strategy based on your division goals : How will you monitor effectiveness and adjust your strategy based on your division's goals?

Big firms fail to see disruptive technologies as threat : Why do big firms fail to see disruptive technologies as a threat?

Augusta case since this publication : Augusta Case Since this publication of this 3rd edition. Who are the women that we granted membership? Develop a profile on each.

Basic economic order quantity model in excel : In this assignment you’ll solve the basic economic order quantity (EOQ) model in Excel using two methods:

How much will the account be worth at the given time : For the last 19 years, Mary has been depositing $500 in her savings account , which has earned 5% per year, compounded annually and is expected to continue.

What is the best production order quantity : What is the best production order quantity? How many days is a required production run?

Foods galore is major distributor to restaurants : Foods Galore is a major distributor to restaurants and other institutional food users.

Periodic review inventory management system : Thomas Toys Ltd. uses a periodic review inventory management system.

User Account

All Pages