Question: In the table below is the data on shipping costs per unit for a transportationproblem for O'Neill Company. A and B are the sources. 1,

In the table below is the data on shipping costs per unit for a transportationproblem for O'Neill Company. A and B are the sources. 1, 2, and 3 are the destinations.

	Destination	Supply
1	2	3
Source
A	$6	$7	$4	40
B	$5	$8	$6	60
Demand	30	40	30

Formulate and solve a linear programming model for this problem using Excel. 1) What is the formula you used for the objective function cell? (1) 2) How many constraints do you have in your model? Explain. (1) 3) How many of units should be shipped from A to 1, 2, and 3 and how many units should be shipped from B to 1, 2, and 3?(2) 2) What is the total cost?(1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

2. Give the value of each statement. If the value does not exist, write "DNE". [8 marks] a. lim f(x) = x3 b. f(3) = f(x) C. lim f(x) = x-1 d. f(1) = e. lim f(x) = x2 f. lim f(x) = x-2 g. lim f(x) =...

Zone Technology is a toy manufacturer that makes innovative simple toys for fast food restaurants around the world. As 3-D printing technology has become much cost-effective, the company plans to set...

Task 2 : Introduction to Optimization Modeling ( Related to Learning Outcome 1 : Apply Business Analytics Tools ) A logistics company wants to minimize the cost of shipping goods between warehouses...

PLEASE RIGHT CLICK ON IMAGE AND CLICK OPEN IMAGE IN NEW TAB TO VIEW THE QUESTION Zone Technology is a toy manufacturer that makes innovative simple toys for fast food restaurants around the world. As...

PLEASE RIGHT CLICK ON IMAGE AND CLICK OPEN IMAGE IN NEW TAB TO VIEW THE QUESTION QUESTION 4 Zone Technology is a toy manufacturer that makes innovative simple toys for fast food restaurants around...

I want you to summerize these 7 items. !Please be different from other answers! !Please get a little quick! Thanks. You should summarize the 7 items in the photo. Max 125 words! reading 1....

You should summarize the 7 items in the photos. Max.250 words! !Different answer another chegg answer please! 1. Introduction currently missing from the literature (Trioman et al. 2010: De mirkan and...

Write a program to declare and initialize an array of size 5 and place odd numbers 3, 5, 7,9 and 11 in it. Declare and initialize another array of size 5 and place even numbers 4, 6, 8,10 and 12 in...

Calls & Puts Calls Expand collapse All Bid/ Bid Size 0.88 758 1.20 110 0.42 260 0.07 546 0.01 360 Following are the option prices for calls and puts for Ford (F) with July 21, 2017 expiration date....

You have been asked to accept a change to a project. What should you reference to make the best decision?

At the beginning of the year, Hernandez Company had total assets of $800,000 and total liabilities of $500,000. Answer the following questions. (a) If total assets increased $150,000 during the year...

A straight fin fabricated from 2024 aluminum alloy (k = 185 W/m K) has a base thickness of t = 3 mm and a length of L = 15 mm. Its base temperature is Tb = 100C, and it is exposed to a fluid for...

Two bumper cars in an amusement park ride collide elastically as one approaches the other directly from the rear (Fig. 7-34). Car A has a mass of 450 kg and car B 550kg, owing to differences in...

A 68.5-kg astronaut is doing a repair in space on the orbiting space station. She throws a 2.25-kg tool away from her at 3.20 m/s relative to the space station. With what speed and in what direction...

Gwynne Supply Co. has the following transactions related to notes receivable during the last 2 months of the year. Nov. 1 Loaned $60,000 cash to B. Akey on a 1-year, 7% note. Dec. 11 Sold goods to R....

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Explain the concepts of hypothetical construct and operational definition.

Why, in the United States, is prejudice generally assumed to refer to Whites prejudice against Blacks? If you are a student outside the United States, what groups define the implicit meaning of...

Explain the concepts of reliability and validity of measurement. How are reliability and validity related to one another?