Solution-Determine the optimal ordering quantities

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.

User Account

All Pages

Determine the optimal ordering quantities

Reference no: EM13887048

Reference no: EM13887048

Questions Cloud

Reviews

Write a Review

Supply Chain Management Questions & Answers

Supply chain network design for cwc

Criteria when making new location decisions

Draw the project network

Compare and contrast economic - market, and relevancy

Brushing up on inventory control

Supply chain strategy

What is the economic order quantity for fans in units

What factors reduce the capacity of the organization

What is the total annual cost

Supply chain management questions

Explain the supply chain management concept

How warehouses can add value in the supply chain

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT