Determine the optimal ordering quantities

Assignment Help Supply Chain Management
Reference no: EM13887048

Here is what we would like you to do. We want you to use the Import Beer product line as a test case for developing an optimization program. Use the Excel file that we have developed with the forecast information for the import beer product line.

Other information that you will need has been provided by Accounting: inventory holding costs, product costs and price markups. This information with the Sales Forecast and costs and prices has been provided in the Excel file.

We want you to develop a method that will determine the optimal ordering quantities so that we maximize the gross profits and also take into account inventory holding costs.

After you have developed this method, write a short report to management explaining what you did and how this method can be used going forward on a quarter by quarter basis and for the other product lines.

Attachment:- EBBD Imports Data.xlsx

Reference no: EM13887048

Questions Cloud

Factors that impact the validity of assessment tools : Review this week's Learning Resources, and consider the factors that impact the validity and reliability of various assessment tools and diagnostic tests
Find the current in the capacitors : A total charge 200 pC is imparted to identical parallel plate capacitors connected in parallel. At t = 0, the plates of the capacitor are 0.1 mm apart. The plates of first capacitor moves towards each other with approach velocity 0.001 m/s and pla..
How audit documentation provide evidence related to audit : What audit evidence is necessary for opining on a client's financial statements? How does audit documentation provide evidence related to audit quality?
What is the purpose of vendor account groups? : What is the purpose of Vendor Account Groups?
Determine the optimal ordering quantities : Develop a method that will determine the optimal ordering quantities so that we maximize the gross profits and also take into account inventory holding costs.
Explain and apply the phases of the project management life : Explain and apply the phases of the project management life cycle
Principles of pharmacokinetics and pharmacodynamics : Review this week's media presentation with Dr. Terry Buttaro, as well as Chapter 2 of the Arcangelo and Peterson text, and the Scott article in the Learning Resources. Consider the principles of pharmacokinetics and pharmacodynamics
Write about weakness that could be included in audit report : Assume that the engagement team makes a decision that there is a material weakness in internal controls. Write two or three paragraphs describing those weaknesses that could be included in the audit report.
Write equation for the auto ionisation : Suggest a solvent in which aniline acts as strong base. Write equation for the auto ionisation of (i) HCOOH, (ii) NH3.

Reviews

Write a Review

Supply Chain Management Questions & Answers

  How will this affect the southeastern location

Based on the available information, is Atlanta the best location for a distribution center to serve the southeastern region? If not, what would you recommend - The Fireside transportation department projects a 25 percent rate increase in 2013 from..

  What would happen to fill rates and cycle service levels

Would fill rates go up, go down, or stay the same? Would cycle service levels go up, go down, or stay the same?

  Improve performance without major disruption

What are the unspoken rules that give Toyota its competitive edge and how do they make it possible for the company to change and improve performance without major disruption?

  Discuss the impact of disintermediation

Discuss the impact of disintermediation and how some intermediaries have fought back againsts manufacturers who attempt this practice

  Analysis of global leadership concerns for the future

Analysis of global leadership concerns for the future in the context of the organization -  Global leadership strengths and fit with the leadership position.

  Describe how the supply chain function has improved

Describe how the supply chain function has improved over time for the organization - Analyze the current technology used and the impact of this technology on supply chain capability.

  How many shirts must gina sell to break even

What is the EOQ, in minimizing cost, how many orders would be made each year and what is the time between orders?

  Explain the significance of third-party logistics services

The usage and significance of third-party logistics (3PL) services has grown dramatically during the past two decades or so. Explain why this has occurred and what the benefits are, if any? Document your sources.

  How to submit homework how to submit homework how to submit

how to submit homework how to submit homework how to submit homework how to submit homework how to submit homework how

  What was the innovative supply chain strategy

Review Essilor: Building an Efficient Supply Chain to Serve the Company's Mission - What was Essilors mission and what was the innovative supply chain strategy used to support the mission

  What is the effect of different rates

What is the e ffect of di fferent defective rates on optimal order quantity, backorder quantity and expected total pro t per unit? Please display your results graphically as well as a brief description.

  What can or should be done to provide the supplying division

What can or should be done to provide the supplying division an incentive to reduce manufacturing costs when the transfer price is cost-based?

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