1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Ugo [173]
3 years ago
10

A company produces products at 2 plants each of which have a capacity of producing 75 units. 50 units of each product must be sh

ipped to each of three customers. We know the cost of shipping a unit of the product from each plant to each customer. Our goal is to minimize the total cost of shipping the needed units to the customers. If we use the Excel Solver to try and minimize the total cost of meeting customer demand we will need how many variable cells?
Business
1 answer:
zalisa [80]3 years ago
7 0

Answer:

the answer is 6

Explanation:

In this case we would need to have a combination of each plant with each customer. So the variable would be in this way (3C X 2P)

              Customer1            Customer2           Customer3

Plant1      P1C1                      P1C2                     P1C3

Plant2     P2C1                     P2C2                    P2C3

Once you have this you can calculate the best combination to minimize the cost of shipping

You might be interested in
Supply costs at Lattea Corporation's chain of gyms are listed below: Client-Visits Supply Cost March 11,665 $28,579 April 11,461
mario62 [17]

Answer:

<em>$0.48 per client-visit; $22,856 per month</em>

Explanation:

Where,

y2 is the total cost at highest level of activity;                                                                       y1 is the total cost at lowest level of activity;                                                                      x2 are the number of units/labor hours etc. at highest level of activity; and                           x1 are the number of units/labor hours etc. at lowest level of activity

<em>Variable Cost per Unit </em>

= (28,904 -28,227) / (12,600-11,199)

= $0.48

<em> Total Fixed Cost </em>

= y2 ? bx2

= 28,904 - $0.48 * 12600

= $22,856.00

3 0
3 years ago
Read 2 more answers
2-a. Refer to the original data. How much will net operating income increase (decrease) per month if the company uses higher-qua
Vadim26 [7]

The original data is :

Data for Hermann Corporation

                                          Per unit     Percent of sales

Selling price                         $ 75              100%

Variable expenses                  51                 68

Contribution margin             $ 24               32%

The fixed expenses are $ 75,000 per month and the company is selling 4000 units per month.

Solution :

                                                     Present             Proposed

Sales                                             300000            375000

Less : Variable cost                      204000           275000

Contribution margin                     96000               100000

Less : Fixed expenses             <u>    75000     </u>      <u>     75000    </u>

Net income                                   21000                25000

The net operating income :      Increases          4000

Net operating income = increased sales Net income - current sales net income.

Therefore the higher quality component should be used.                                                            

8 0
3 years ago
William wrote a check for $150.00 for his gas bill, but he only has 96.26 in his checking account. What will happen to the check
TEA [102]

Answer:

The person will ask William to check his checking account and then William would have to lower the check amount he had previously wrote.

Explanation:

If you write a check or make a purchase for more than you have in your checking account, your bank may cover the difference. This line of credit offered by the bank is called overdraft protection. ... Furthermore, if your account remains overdrawn, your bank may also charge you daily interest on the loan.

7 0
3 years ago
Why​ wouldn't investors invest all of their money in software companies instead of in less profitable​ companies? (Focus on risk
Tamiku [17]

Answer and Explanation:

Risk and return are equal companions if we invest in a market with a higher risk that's mean this type of market provides a higher return.

If Investors invest their whole money in the high-risk market for there high return, may they get a huge loss.

So, The exposure must be balanced by investments in diversified markets with different risk weights.

7 0
3 years ago
As an elected official, you have been informed that real GDP is below its potential and that action should be taken to encourage
telo118 [61]

Answer:

The answer is 2.5

Explanation:

Mpc = marginal propensity to consume

Mps = marginal propensity to save

Multiplier = 1/ 1-mpc= 1/ mps

Multiplier = 1/ 1-0.6 = 1/ 0.4 = 2.5

8 0
3 years ago
Other questions:
  • Urgent!!
    10·1 answer
  • Cash sales rung up by cashiers totaled $120,500. Cash in the drawer was counted and found to be $126,000. The journal entry to r
    15·2 answers
  • Charlie Stone wants to retire in 30 years, and he wants to have an annuity of $1,000 a year for 20 years after retirement. Charl
    5·1 answer
  • What is Sharpie's target market?
    11·1 answer
  • An increase in the minimum wage​ ______. A. decreases employment and increases unemployment if it is set above the equilibrium w
    15·2 answers
  • Which is a contract used when two or more individuals create a business?
    11·2 answers
  • If there are five goods in a barter​ economy, one needs to know ten prices in order to exchange one good for another.​ If, h
    14·1 answer
  • The Allowance for Doubtful Accounts is a contra-asset account. Increases to the account (to record the period's estimated bad de
    8·1 answer
  • Most companies with well-developed project management systems insist that a project must pass an approval of some kind to move f
    5·1 answer
  • What can be said of the correlation between the brand of an automobile and its quality?
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!