A&C Distributors
Not what you're looking for?
Problem
1. A&C Distributors is a company that represents many outdoor products companies and schedules deliveries to discount stores, garden centers, and hardware stores. Currently, scheduling needs to be done for two lawn sprinklers, the Water Wave and Spring Shower models. Requirements for shipment to a warehouse for a national chain of garden centers are shown below.
Month Shipping Capacity
Product Minimum Requirement Unit Cost
to Ship Per Unit
Inventory Cost
March 8000 Water Wave 3000 .30 .06
Spring Shower 1800 .25 .05
April 7000 Water Wave 4000 .40 .09
Spring Shower 4000 .30 .06
May 6000 Water Wave 5000 .50 .12
Spring Shower 2000 .35 .07
Let Sij be the number of units of sprinkler i shipped in month j, where i = 1 or 2, and j = 1, 2, or 3. Let Wij be the number of sprinklers that are at the warehouse at the end of a month, in excess of the minimum requirement.
Formulate and Excel Solve, the whole problem, provide the Excel file.
Purchase this Solution
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.