Prescriptive modelling solver

Assignment Help Business Management

Reference no: EM132694295

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: EM132694295

Questions Cloud

Describe the purpose most affected by the program : Describe the purpose and the resource(s) most affected by the program. Write an essay that identifies and selects a military installation that is implementing

Pros and cons as well as comparison of the 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?

What is the maximum potential profit : Suppose you purchase one XYZ August 100 call contract at $6.5 and write one XYZ August 110 call contract at $0.5.

Determine the amount of depletion expense : Glacier Mining Co. acquired mineral rights for $494,000,000. Determine the amount of depletion expense for the current year

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

How does a job differ from a career : How does a job differ from a career and what are some demographic and economic factors that affect career opportunities?

What is superfund : What is Superfund? If a remedy (that is, a proposed cleanup project) leaves hazardous materials on a site, what standard must it meet?

What was the depreciation for the first year : Equipment was acquired at the beginning of the year at a cost of $465,000. What was the depreciation for the first year

What is the npv of the replacement : One year? ago, your company purchased a machine used in manufacturing for $120,000. You have learned that a new machine is available that offers many? advantage

User Account

All Pages