What is the optimal order quantity

Assignment Help Business Management
Reference no: EM131454421

Please show work and answer question in Excel QM:

Omar Harris receives 5,000 tripods annually from Top-Grade Suppliers to meet his annual demand. Omar runs a large photographic outlet, and the tripods are used primarily with 35mm cameras. The ordering cost is $15 per order, and the carrying cost is $.50 per unit per year.  Weekly demand is 100 tripods.

a) What is the optimal order quantity?

b) Top-Grade is offering a new shipping option. When an order is placed, Top-Grade will ship one-third of the order every week for three weeks instead of shipping the entire order at one time. What is the order quantity if Omar chooses this option? To simplify your calculations, assume that the average inventory is equal to one-half of the of the maximum inventory level for Top-Grade's new option.

c) Suppose Top-Grade Suppliers offers to ship one-fifth of the order every week for five weeks. What is the order quantity under this option? Make the same assumption as in part (b).

d) Calculate the total cost for each option. What do you recommend?

Reference no: EM131454421

Questions Cloud

Real-world organization and apply quality management : In this project, you will research a business process in a real-world organization and apply quality management tools that are introduced in this course.
Estimate the second stage of a two-stage procedure : Consider the stack loss data that were given in Table. Use the Minitab macro RWLSIDFB followed by RWLS2DFB for this data set.
What kind of flow meter they should use : the efficiency of the gear pump and the centrifugal pump can be related to both the rotational speed and the flow rate to see how one affects the other.
Discuss some recovery site options : Include at least 250 words in your reply. Indicate at least one source or reference in your original post.
What is the optimal order quantity : What is the optimal order quantity?
Write a paper on a current event article : Write a paper on a current event article (since December, 2016) relating to the leadership abilities exhibited by a current CEO of a publicly traded company
Creating and modifying excel spreadsheets : Please explain the following basic Excel features and explain why you believe they are important to you while creating and modifying Excel spreadsheets:
Compute the hkb ridge constant : Using some computer program, such as the Minitab macro RIDGE, construct the ridge trace for the last 26 observations in Table.
Establishing strategic pay plans : It is not uncommon for employers to get in trouble with the Department of Labor for incorrectly classifying employees as exempt or nonexempt.

Reviews

Write a Review

Business Management Questions & Answers

  Elements of internal and external environment

What elements of internal and external environment contributed to Facebook's success? Which elements of internal/external context create challenges for facebook?

  Write a report for senior management

You are a manager with 5 years of experience and need to write a report for senior management on how your firm can avoid the threat of a Federal Trade Commission investigation if you were to merge with other health care organizations.

  Physical presence of jesus

1. One of the best arguments that Heaven is real is the physical presence of Jesus. 2. God designed hell to punish those angels that rebelled against his authority. 3. What does immanency mean? Christ could return at any time

  What attitude and ideologies legitimate wars and terrorism

show what attitudes and ideologies legitimate wars and terrorism - what steps could be taken to diminish the possibility of war and terrorist acts

  Amounts of inventory on hand

Question to be answered. Consider the examples below. Please identify which of the three "E's" each example represents. Discuss how the evaluation of the three "E's" fits into the specific objectives of the operational audit. Examples:

  Important information about management information system

Write six closed questions that cover the subject of decision-making style for the manager described in the scenario.

  The current exchange rate

Currently a basket of goods costs 50 pounds in England and 100 euros in France.  Next year at the same time, we expect 10% inflation in England and 65% inflation in France.  Based on the above information and the PPP concepts, the current exchange ra..

  Employee of the dun construction corp

Defamation. Richard is an employee of the Dun Construction Corp. While delivering materials to a construction site, he carelessly backs Dun's truck into a passenger vehicle driven by Green.

  Guideline topics found in the cpt code

This week you will select one of the following guideline topics found in the CPT code book located in one of the six sections of part I and create a presentation that will explain the guidelines for that particular service.

  Write paper discussing your work experience and observations

Write a paper discussing your work experience, observations, and/or outside reading on a topic involving practical risk management (e.g. disaster recovery, changes in project scope, technology risk, etc.).

  Discuss boeing expectations of supplier

Consider the major influences on business buyers found in the Boeing Supplier wesbite and then discuss Boeing's expectations of supplier.

  What are the ethical and legal issues depicted in the movie

What are the ethical and legal issues depicted in the movie, John Q? Describe John's decision-making process and identify the various factors and outside stakeholders who influenced his decisions.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd