A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Shipping Costs ($/unit) Customer 2 Factory/Capacity A/190 units Customer 1 10 Customer 3 8 10 11 12 9 B/180 units C/140 units 6 5 12 Requirement-255 units Requirement-85 units. Requirement-170 units. Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "0" wherever required.) Answer is complete but not entirely correct. Shipping Costs ($/unit) Customer Customer Factory Customer 3 1 2 A 0 95 x B 105 0 75 x C 55 85 0 What is the total cost of meeting customer requirements each day? Answer is complete and correct. Total cost 4,295 95 X

A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Shipping Costs ($/unit) Customer 2 Factory/Capacity A/190 units Customer 1 10 Customer 3 8 10 11 12 9 B/180 units C/140 units 6 5 12 Requirement-255 units Requirement-85 units. Requirement-170 units. Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "0" wherever required.) Answer is complete but not entirely correct. Shipping Costs ($/unit) Customer Customer Factory Customer 3 1 2 A 0 95 x B 105 0 75 x C 55 85 0 What is the total cost of meeting customer requirements each day? Answer is complete and correct. Total cost 4,295 95 X

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Only sure experts solve it correct complete solutions need. Don't use guideline explanation. Just do…

A: Given, figure : We need to locate the centroid of a composite area in a figure composed of two…

Q: I already know the meaning of descriptive , predictive and prescriptive. However , I have not read…

A: Business analytics makes use of different tools of statistics, artificial intelligence, and data…

Q: Is it possible for one process to become unresponsive in the midst of running? Please explain why…

A: A process can be defined as a group of steps or action that is taken to achieve a particular goal.…

Q: Inappropriate or inefficient communication and support of the entity's values is evident Choose.…

A: Fraud Fraud is defined as the time when an individual or an organization purposely works towards…

Q: Management Decision Systems (MDS) is a consulting company that specializes in the development of…

A: Find the given details below:

Q: Is there a company that specializes in food and drink that utilizes these five different MIS…

A: Management Information Systems (MIS) are software applications that businesses use to manage…

Q: Only 100% sure experts solve it correct complete solutions handwriting okk

Q: Don't use chat gpt solve accurate not guidelines type ok . Full 100% sure experts solve it correct…

Q: Are there instances where subjective performance evaluations might be better (or more feasible)…

A: Performance Evaluations A performance evaluation is used to assess a candidate's ability to succeed…

Q: The services provided by a personal fitness trainer are best described as which of the following:…

A: Customer service is the art of serving the customers before and after the purchase of a product. The…

Q: Using the guide below prepare a group reflection of the group’s experience in the cesim simulation…

A: Group: A group refers to the collection of people who are interrelated to each other through a…

Q: 4. Explain Henry Mintzberg’s concept of 5-Ps in your own words with example.

A: Henry Mintzberg created 5 strategic visions for the associations that specify the execution of a…

Q: (a) Construct the project network. (Submit a file with a maximum size of 1 MB.) This answer has not…

A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

Q: Management Decision Systems (MDS) is a consulting company that specializes in the development of…

A: The critical path is the longest path through the project network and determines the minimum project…

Q: Only 100% sure experts solve it correct complete solutions handwriting okk

A: 1). 2).

Q: 2. (Quantity Discount) County Hospital orders syringes from a hospital supply firm. The hospital…

A: Find the Calculation methods below: Economic Order Quantity = 2DSHTotal Cost = D*h + (DQ*S) +…

Q: A fourteen day job to install 10,000 linear feet of pipe is coming up. If each worker can install 10…

A: Total linear feet of pipes = 10000 Linear feet installed per hour by one worker = 10 feet Total…

Q: Management Effectiveness is to use the more resource to attain the organizations goal. Select one:…

A: Effectiveness in management refers to the capacity of the management to attain the goals within a…

Q: What is the significance of the concept of Pareto efficiency in game theory? a) It represents a…

A: Pareto efficiency in game theory refers to an allocation of resources or an outcome in a strategic…

Q: What type of objective is listed below: By the end of session 4, 80% of women attending the Eat…

A: Objectives are used to meaningfully assess a program's accomplishments and failures, as well as to…

Q: Can you show it on excel similar to how you answered the question about he farm

A: Based on the LP model which is already being formulated, Excel Model formulation is done by using…

Q: Sure experience expert solve it no chat gpt okkk clean handwriting

A: I. Rounding off numbersIn rounding off numbers, the general rule is that if the number you're…

Question

This is what the excel solver game me and it's also wrong for the ones that it says wrong.

actory/Capacity
/190 units
3/180 units
C/140 units
total cost
Customer 1 Customer 2
82.22222214
117.7777779
55
255
4295
0
0
85
85
Customer 3
107.7777779
62.22222214
0
170
190
180
140
510

A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without
shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the
capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer.
Shipping Costs ($/unit)
Customer 2
Customer 3
Factory/Capacity
A/190 units
Customer 1
10
10
8
11
12
9
B/180 units
C/140 units
6
5
12
Requirement-255 units.
Requirement-85 units
Requirement-170 units
Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to
enter "0" wherever required.)
> Answer is complete but not entirely correct.
Shipping Costs ($/unit)
Customer
Factory
Customer
1
Customer
3
2
A
95 x
0
95 X
B
105 x
0
75 x
C
55
85
0✓
What is the total cost of meeting customer requirements each day?
Answer is complete and correct.
Total
cost
4,295

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Trending now

This is a popular solution!

Step by step

Solved in 7 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

I need answer typing clear urjent no chatgpt used i will give 5 upvotes
A company calls itself reliable and competent in all of its advertising, but its equipment breaks down, and its shipping department is always slow and unreliable in filling orders on time. It’s company logo focuses on warmth and joy instead of capability. This is specifically an example of
Does anybody know of a good reason why a business shouldn't have access to a variety of SIS options? What, if anything, can be done to make this better?
A little over two years ago, Avondale Industries acquired a company that produces a line of adhesives and sealants used in the aerospace industry. The acquisition was shortly followed by providing the best and brightest employees in the division with training every three months on topics selected by the group. A year later, the adhesives and sealants division developed a new sealant that lasts longer, is less expensive to produce, and is more effective in preventing the spread of fire or flames from the engine compartment to the airplane and preventing air leakage. The new product resulted in a sustainable competitive advantage in the market. Which of the following statements best explains how training contributed to the division’s new competitive advantage? The training gave the employees the opportunity to demonstrate their many skills and competencies to the company. The training taught the employees how to look at competitors’ products and determine how to make them…
Suppose that you wanted to determine if a drug improves students abilities to concentrate and study. A study conducted by a pharmaceutical company recruited 125 students with averge IQ’s to participate in a randomized clinical trial. The drug company split the recruits into two groups. Group 1, the placebo group was given a sugar pill. The second group, Group 2, the treatment group was given the drug. They were then asked to asked to complete a very difficult task and the amount of time they took before they quit was calculated. They claim that the placebo group will have different focus times from the treatment group. You will test the claim with a significance of .01. What is the null hypothesis?