Create solver model to meet demand

Assignment Help Business Management

Reference no: EM132895151

Ingredients R US, Inc. Order Distribution Plan

Shipping Costs from Distribution Center (per pallet) Numberof Items Shipped

Food Retailers Pallet Orders Distribution Ctr. 1 Distribution Ctr. 2 Distribution Ctr. 3 Distribution Ctr. 1 Distribution Ctr. 2 Distribution Ctr. 3 Total Shipped Total Costs

Food Buzz 60 $20.25 $78.15 $27.15 $-

Healthy Stuff 78 $50.85 $50.00 $47.90 $-

Smoothie City 125 $84.00 $38.40 $65.55 $-

Burger Barn 187 $86.65 $25.40 $13.90 $-

Café Organic 313 $108.95 $21.50 $33.95 $-

Dessert Center 567 $116.45 $7.95 $26.20 $-

Total 1330 0 0 0 0

Initial Inventory 1,005 335 275 1,615

Remaining Inventory 1,005 335 275 1,615

Constraints

Instructions:

The ingredients are ordered by pallet and transported from one of three distribution centers.

Depending on order type, the nearest distribution center cannot always be utilized to fill orders.

Ingredients R US, Inc. has tasked you with satisfying demand while minizing total cost to ship product to customers.

Demand must be met and there is enough stock to have pallets left over.

Complete the model above by adding necessary formulas and populate the constraints table.

Create a solver model to meet demand while minimizing total costs.

Reference no: EM132895151

Questions Cloud

Pros and cons as well as comparison of platforms : Analyze each tool, providing a list of pros and cons as well as a comparison of the platforms. Additionally, what one thing does each tool do very well?

How amazon fends off unions : Then watch the video "How Amazon Fends off Unions." Again, while the video looks at an American example, many of the things discussed hold true in Canada as wel

How well demonstrated understanding of gender in society : Discuss how you feel you performed in the class overall and how well you have learned and demonstrated understanding of gender in society

Describe understanding of the gender binary : Describe an example of something in real life (other than what is presented in the material) that you would consider falling under your definition of everyday

Create solver model to meet demand : Create a solver model to meet demand while minimizing total costs.

Discuss one that might be relevant when working with eva : Discuss one that might be relevant when working with Eva - Provide one reason why it is important to ensure that the client participates in setting goals

Does qualitative data analysis result in trustworthy results : Compare and contrast the primary components of qualitative and quantitative data analysis. What are the similarities and differences?

Debt-equity and retained earnings : You will demonstrate your ability to identify how firms raise funds through the use of debt, equity, and retained earnings.

Complete the case management plan : Discuss possible outcomes when client targets are set too high or too low and What are some actions to take/consider when reaching case closure

User Account

All Pages