Purchase Solution

OPTIMIZING INVENTORY/TRANSPORTATION (Re-evaluate)

Not what you're looking for?

Ask Custom Question

In case solution 624068
Can you please look over the background ,assignment and solution on this case? I didn't see Assignment Expectations of the report written Danny Wilco (Below)
The report should thoroughly address these aspects in depth and breadth:
• Problem situation: clearly elucidate the problem situation at EBBD
• Assumptions: what are the assumptions that need to be made and your critical evaluation
• Solution: What is your solution for Order Quantities? Discuss how you developed the Solver solution. Keep in mind that your audience is not too technical and do not need a lot of detail on this.
o Make sure you attach the Excel file.
o You should refer to the Excel file when necessary.
• Recommendations: what do you propose for EBBD in terms of using this method in the future and for the other product lines?
• Justification & Explanation: clear reasoning as to why the recommendations were made
• Writing style & Organization: well-formed sentences and paragraphs, well organized with flow of reason, and good use of language that pertain to concepts and terminology
• Use of references & citations

Thanks

Purchase this Solution
Solution Summary

The expert examines optimizing inventory and transportation EBBD problems. The solution is answered in 576 words. A Word file with the report, and an Excel file with the necessary computations are attached.

Solution Preview

I've highlighted the assignment expectations in the report. As for Writing style & Organization, that is not something that can be directly addressed, and is instead incorporated throughout the report. Please note that I did not use any references when writing this report; however, I have included a couple if you are interested in learning how Optimization works.

Report to Danny Wilco

To: Danny Wilco

From: Me

Subject: Quarterly Ordering Decisions

Background

The problem situation at EBBD:
The Import Beer product line consists of 10 products. I have developed an optimization model using the Import Beer line as a test case. The model has been presented as an Excel file, and uses the following information:
• Inventory holding costs (supplied by Accounting)
• Product costs (supplied by Accounting)
• Price markups (supplied by Accounting)
• Quarterly forecast demand for each product
• Annual holding cost rate (4%)
• Max cap (190)
• Inflation ...

Solution provided by:
J Pye, MSc
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Basics of corporate finance

These questions will test you on your knowledge of finance.

View More Free Quizzes
Related BrainMass Solutions

  • Supply chain and sourcing strategy

    The approach that one should take when asked to re-evaluate my organization's current sourcing strategy should be to evaluate the suppliers from whom our company buys.

  • Changing approach to antibiotic use in healthcare

    ., regardless of the duration of the prescription, the antibiotic needs to be re-ordered after four days), in-house drug profiling , and using automatic antibiotic substitutions.

  • Logistics, Warehousing and Inventory Management

    These include purchase of parts and raw materials, inventory control, production processes, finished product, transportation, shipping and distribution etc... Warehousing is definitely a part of that process.

  • Reevaluation of channel arrangements

    Inventory tracking software-this may mean that you need to re-evaluate the number of employees that you have for the inventory process as well as "human monitoring" of products This solution helps go through the re-evaluation of channel arrangements

  • Managing the Supply Chain

    , and optimizing transportation costs with production.

  • Global organization: Importance of quality management, control charts, ERP

    The six important components are production, transportation, inventory management, supply, location and information (Mentzer, 2001). Production Production is the first step in developing goods and services.

  • Operations Management and Supply Chains

    Walmart has automatic recording system which sends a trigger as soon as inventory levels go down. After receiving notification, Walmart sends a re-order based on the re-order quantity.

  • Inventory System and Calculating Revenues, Expense, and Inco

    Nov. 7 Cash 98 Merchandise Inventory 98 4. On November 10, CSI Systems pays $80 cash for transportation costs with the November 1 purchase. Nov. 10 Merchandise Inventory 80 Cash 80 5.

  • EBBD Excel spreadsheet

    624068 EBBD Excel spreadsheet OPTIMIZING INVENTORY/TRANSPORTATION Assignment EBBD EMAIL - for Internal Use Only To: You From: Danny Wilco Subject: Re: Quarterly Ordering Decisions Here is what we would like you to do.

View More Related Solutions