Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. a company manufactures a product at its plants in

A company manufactures a product at its plants in A, B, C, and D, then...

60.1K

Verified Solution

Question

Accounting

image
A company manufactures a product at its plants in A, B, C, and D, then ships the product to four customers in P, Q, R, and S, The monthly capacity of plants A, B, C, and D are 9800, 7500, 4500, and 7800 units, respectively. The monthly demand from customers P, Q, R, and S are 9600, 6800, 4200, and 8300 units, respectively. Use Excel Solver to find the optimal distribution plant that will give the lowest total monthly shipping cost if the shipping cost per unit (in dollars per unit) are as follows: from A to P, Q, R, and Sare 3,6,7, and 12 dollars per unit, respectively, from B to P, Q, R, and S are 15, 11, 4, and 9 dollars per unit, respectively; from C to P, Q, R, and S are 12,9,6, and 7 dollars per unit, respectively: from D to P, Q, R, and S are 20, 13, 9, and 4 dollars per unit, respectively. The optimal total shipping costs is dollars per month

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

endocrine function of the kidney

Medical Sciences
Q

Design a Matlab program that records your voice for 5 seconds and then cuts off the...

Electrical Engineering
Q

c. Discuss a work situation in which you, a manager, or other employee had inadequate communications skills...

Economics
Q

ation Spicules Choanocyte Archaeocyte create water currents and engulf food particles Based on your reading...

Biology
Q

A transfusion reaction characterized by high fever shock hemoglobinuria DIC and renal failure O AHTR...

Biology
Q

15 A car is moving round a curve of radius 20 m without slipping on...

Physics
Q

Use the given information to prove that ARUSATUS R U T Statement S Given RS...

Geometry
Q

An exponential function contains the points (1,0.9) and (2, 1.62). What is an exponential functionthat...

Basic Math
Q

1 The vectors and y are drawn as shown below Draw a vector equivalent to...

Calculus
Q

On December 31 Spearmint, Incorporated, issued $450,000 of 9 percent, 3-year bonds for cash of...

Accounting
Q

Question 2 Identify the advantages and disadvantages of the incremental approach to budgeting Question 3...

Accounting
Q

XYZ company purchased a piece of machinery by exchanging one of their used pieces of...

Accounting