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
One disadvantage of the BYOD strategy is the potential for __________. Group of answer choices cost savings increased flexibilit
topjm [15]

The Potential<u> </u><u>Privacy and Security Issues</u> is a major flaw of the BYOD Strategy.

<h3>What is the BYOD Strategy?</h3>

BYOD a strategy in telecommunications security that allows business partner and workers to use their own devices to access the company's network, applications, and access company information.

Whilst it is cost savings in terms of hardware and provides convenience, it exposes the company to a lot of insecurity.

See the link below for more about the BYOD Strategy:

brainly.com/question/7229227

5 0
3 years ago
You purchased 1,000 shares of the New Fund at a price of $20 per share at the beginning of the year. You paid a front-end load o
Mazyrski [523]

Answer:

6.37%

Explanation:

Rate of return

= (Aggregate investment value after one year - Investment value) / investment value   ----- equation 1

Cost of shares =number of shares* price per share

             = 1000* $20 =$20,000

Total amount invested = Purchasing cost /(1- front-end load)

               = $20,000 / (1-0.04)

                =$20,000 / 0.96 = $20,833.333

Investment value after one year

           = Total Investment*( 1+ price increase-expense ratio)

         = $20,000( 1 +0.12 -0.012)

          = $20,000(1.12-0.012) = $20,000 * 1.108 = $22,160

From equation 1 above

Rate of return = ($22,160 - $ 20,833.333) / $20,833.333

        $ 1,326.667 / $ 20,833.333

= 0.06368001701

  = 0.0637

Since rates of return are expressed as %, we multiply the result by 100 to get

  0.0637*100 =6.37%

My rate of return on the fund will be 6.37% if I sell the shares at the end of the year.

7 0
3 years ago
_________ policy involves the decision to pay out earnings to shareholders or to retain and reinvest them in the firm. When dist
Norma-Jean [14]

Answer:

The blanks anwers are below

Explanation:

Kindly consider blanks in order:

Payout policy

Repurchasing

Maximize

Payout

Rise/Increase

Decline

Decrease

Sustainaible

maximizes

Some blanks may not match. The answers are correct although.

3 0
3 years ago
Bill was 150 pounds overweight but his insurance premiums significantly dropped after he lost weight by going to a local health
Serggg [28]

The kind of measures that Bill took which made his insurance premiums to drop is a preventative measure.

<h3>What is a preventative measure?</h3>

In insurance, a preventative measure can be defined as a kind of measure that typically involves reducing the degree of risk associated with an insurance object, and mitigating (decreasing) the negative impact of potential insurance-related accidents on the insured.

In this context, we can infer and logically deduce that the kind of measures that Bill took which made his insurance premiums to drop is a preventative measure.

Read more on insurance here: brainly.com/question/16789837

#SPJ1

7 0
2 years ago
John and Sally Claussen are considering the purchase of a hardware store from John Duggan. The Claussens anticipate that the sto
Marina CMI [18]

Answer:

Explanation:

Calculate maximum that should pay:

Compute present value of cash flows from the store, year 1 to 5 :

Annual cash flows are $70,000

Desired rate of return on investment for 1 to 5 years is 7%

Number of years is 5

Present value of cash flows generated during 1 to 5 years =

= $287,013.82

Compute present value of cash flows from the store for years 6 to 10

Annual cash flows are $70,000

Desired rate of return on investment for 6 to 10 years is 10%

Desired rate of return on investment for 1 to 5 years is 7%

Number of years is 5

Present value of cash flows generated during 6 to 10 years = annual cash flows x PVIFA (10%,5) x PVIF (7%,5)

= $70,000 x 3.79079 x 0.7130 = $189,198.33

Compute present value of cash flows from the store for years 11 o 20

Annual cash flows are $70,000

Desired rate of return on investment for 11 to 20 years is 12%

Desired rate of return on investment for 6 to 10 years is 10%

Desired rate of return on investment for 1 to 5 years is 7%

Number of years is 10

Present value of cash flows generated during 11 to 20 years = [annual cash flows x PVIFA (12%,10)] x PVIF (10%,5) x PVIF (7%,5)

= $70,000 x 5.65022 x 0.62092 x 0.7130  = $175,100.98

Calculate present value of estimated sale amount to be received for sale of store

Present value of estimted sale amount to be received = [Estimated sale amount x PVIF (12%,10)] x PVIF (10%,5) x PVIF (7%,5)

=$400,000 x 0.32197 x 0.62092 x 0.7130=

=$57,016.50

Calculate total maximum amount that should be paid

Particulars Amount ($)

Present value of cash flows during 1 to 5 years         $287,013.82

Present value of cash flows during 6 to 10 years $189,198.33

Present value of cash flows during 11 to 20 years $175,100.98

Present value of estimated sale value                  $57,016.50

Maximum amount that C should pay to JD for store $708,329.63

Therefore, Maximum amount that should be paid $708,329.63

4 0
3 years ago
Other questions:
  • Melody's Piano School operations for the month of May are summarized in the following three transactions: - Provided $1,150 of i
    15·1 answer
  • Following are financial statement numbers and ratios for CVS Health Corporation for the year ended December 31, 2016. Total reve
    8·1 answer
  • FreeSpirit is a premium clothing brand. The brand's advertisements feature models of all age groups. In the given scenario, Free
    14·1 answer
  • What is the typical relationship between time and interest rate?
    8·2 answers
  • In the current year, Hermanson Corporation reported net income of $240,000, paid dividends of $25,000 on common stock, and $40,0
    5·1 answer
  • If the total cost of producing 4 units is $150 and the marginal cost of producing the fifth unit is $20, then the total cost of
    14·1 answer
  • A firm's dividends have grown over the last several years. 3 years ago the firm paid a dividend of $1. Yesterday it paid a divid
    7·1 answer
  • Find the total cost of a 36 month car lease, if: monthly payment = $175 down payment = $1,500 residual value = $10,000 A. $11,67
    15·1 answer
  • When an accounts payable ledger is used, the Accounts Payable account in the general ledger becomes a(n) __________ account.
    15·1 answer
  • A balanced federal budget and a balance of trade are secondary goals of macroeconomics, while growth in the standard of living (
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!