Purchase Solution

A&C Distributors

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution provided by:
Gaurav Agarwal, MS
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.

View More Free Quizzes
Related BrainMass Solutions

  • Net Period of Delta Distributors

    If 30% of Delta's credit customers receive a discount by paying within 10 days and the remainder of Delta's customers pay in 40 days, what is the net period that Delta maintains? A. 19 days B. 31 days C. 37 days D. 40 days E.

  • Market intelligence methods

    Step 1 The potential hazards a company might face by relying too heavily on distributors, retailers, or other intermediaries for market intelligence is that distributors, retailers and other intermediaries may not have a reliable system in place to

  • Marketing Channels for IPOD

    (Kotler 2005) Reference - Principles of Marketing, Kotler (2005) c.

  • National income equilibrium

    c) What is the multiplier for investment spending for this economy? d) What is the marginal propensity to save? a) The formula for income is Y = C+I+G. There is no G, so this reduces to Y = C+I.

  • Brett's discovery of HoBoy Distributors financial discrepancies

    276998 Brett's discovery of HoBoy Distributors financial discrepancies Brett, in his first year as a CPA with the firm Dewy, Cheatem, and Howe, is auditing a bank client. Last month Brett audited another firm called HoBoy Distributors.

  • Sampling and Standard Error

    a. Compute the sampling error. b. Compute the standard error of the sampling distribution of sample means. c. Compute the probability that the sample of 25 bottles would have a mean of 2.005 liters or more. 14.

  • Linear Programming- Thompson Distributors

    289993 Linear Programming- Thompson Distributors Can you help me get started with this assignment? Thanks!! ---------- Thompson distributors packages and distributes industrial supplies.

  • E-Commerce Business Information Systems

    References: a) http://www.eservglobal.com/uploads/files/index.pdf b) https://www.priv.gc.ca/resource/fs-fi/02_05_d_51_cc_e.pdf c) http://www.dialogic.com/~/media/products/docs/whitepapers/12023-cloud-computing-wp.pdf d) http://www.gov.pe.ca/photos

  • Taxation of International Transactions

    Independent foreign manufacturers producing similar running shoes typically earn a gross profit mark-up (expressed as a percentage of the manufacturing costs) of 15%. c) Tomco, a domestic corporation, owns 100% of Swissco, a Swiss corporation.

View More Related Solutions