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

  Describes a framework to address right post-tender

Describes a framework to address right post-tender negotiation process based on documentation and justification of why you decided to start with PTN.

  What risks do managers take

What risks do managers take when they view their firm's performance solely in financial terms?

  Analyzing these sites as relate to supply chain management

Prepare a 1,050- to 1,400-word paper analyzing these websites as they relate to supply chain management. Include a history of the organization or industry, the market in which it operates, the role of government regulations on it, and any issues or..

  Explain the supply chain of milk

Explain the supply chain of milk

  Prepare a supply chain assessment

Prepare a supply chain assessment. Develop a transportation plan that addresses how to move goods to the chosen country.

  Define supply chain and list the activities

Define supply chain and list the activities that are involved and what are some service industries that utilize B2B; list at least three and then describe how they utilize this application.

  Explain role of business intelligence in an organization

Describe the role of Business Intelligence in an organization and understand the data mining process and its related issues.

  Human population growth

Human population growth.

  Explain the thinking behind quick response logistics

Explain the thinking behind quick response (QR) logistics. How could QR help a retailer to plan and control product lines for a new fashion season? Document your sources.

  Minimizes the total supply chain costs

What quantity discount price results in the retailer ordering the quantity that minimizes the total supply chain costs?

  Supply chain manager of organization

Outline the background and purpose of this report (about 100 words) and provide key information about the selected organization - supply chain manager of this organization

  Which is a reason for making a component

Which of the following is a reason for making a component rather than buying it?

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