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
In the context of the six sections of the Position Analysis Questionnaire (PAQ), _____ represent the reasoning, decision-making,
emmainna [20.7K]

Answer: B. mental processes

Explanation: In the context of the six sections of the Position Analysis Questionnaire (PAQ), _____ represent the reasoning, decision-making, planning, and information-processing activities involved in performing a job.

A. job contexts

B. mental processes

C. special codes

D. information inputs

The Position Analysis Questionnaire (PAQ) is relatively complex, and requires that an employee must have the reading level of a college graduate to be able to complete it and evaluates job skill level and basic characteristics of applicants for a set match of employment opportunity. It measures the characteristics of a job and relates them to human characteristics, such as information input, mental processes, work output, relationships with others, job context, and so on.

Mental processes in the context of the six sections of the Position Analysis Questionnaire (PAQ) represents the reasoning, decision-making, planning, and information-processing activities involved in performing a job.

7 0
2 years ago
Technical skills: A. help you understand the potential and the limitations of information technology. B. help you work with end
Lera25 [3.4K]

Answer:  A. help you understand the potential and the limitations of information technology

Explanation: Helping you understand some, if not all of the potential and limitations of information technology is among the usefulness of technical skills which are skills, abilities, knowledge or expertise that are needed to perform complex tasks, processes or actions that are computational, mechanical, scientific or relating to information technology. Examples include the knowledge of programming languages, mechanical tools, design programs etc.

3 0
3 years ago
Gerritt wants to buy a car that costs $31,000. The interest rate on his loan is 5.67 percent compounded monthly and the loan is
gregori [183]

Answer:

$594.57

Explanation:

For computing the monthly payment we need to apply the PMT formula i.e to be shown in the attachment below:

Given that,  

Present value = $31,000

Future value or Face value = 0

Rate = 5.67% ÷ 12 months = 0.4725

NPER = 5 years × 12 = 60 years

The formula is shown below:  

= PMT(RATE;NPER;-PV;FV;type)  

The present value come in negative  

So, after applying the formula, the monthly payment is $594.57

5 0
3 years ago
A company purchased a computer system at a cost of $34,000. The estimated useful life is 8 years, and the estimated residual val
Iteru [2.4K]

Answer:

Year 2= $4,687.5

Explanation:

Giving the following information:

Purchase price= $34,000

Useful life= 8 years

Salvage value= $9,000

<u>To calculate the depreciation expense under the double-declining-balance, we need to use the following formula:</u>

<u></u>

Annual depreciation= 2*[(book value)/estimated life (years)]

Year 1= [(34,000 - 9,000)/8]*2= $6,250

Year 2= [(25,000 - 6,250)/8]*2= $4,687.5

3 0
3 years ago
The _______ is the act of Limiting the amount of certain goods that civilians can buy
Drupady [299]

Rationing is is the act of Limiting the amount of certain goods that civilians can buy. Rationing became common during the Second World War. Ration stamps were often used. These were redeemable stamps or coupons, and every family was issued a set number of each kind of stamp based on the size of the family, ages of children and income.

7 0
3 years ago
Other questions:
  • Accounting provides information to
    9·1 answer
  • Why are junk bonds more popular during a bear market
    10·1 answer
  • 1. Alejandro and Roger are working on a group project for class that requires writing a paper and designing charts to explain th
    5·1 answer
  • Your company's intranet Web server has crashed. You must help re-create the server. A server administrator has copied a script f
    7·1 answer
  • Brian has just finished college. He wants to set up a small business to make and sell fireworks. He registers his company and ac
    5·2 answers
  • Consider the market for a breakfast cereal. The​ cereal's price is initially ​$3.003.00 and 7070 thousand boxes are demanded per
    6·1 answer
  • A 10-year maturity, 8% coupon bond paying coupons semiannually is callable in five years at a call price of $950. The bond curre
    7·1 answer
  • What are the depleted amounts of tangible assets and intangible assets known as?
    14·1 answer
  • Explain the required steps to complete a work sheet by placing the following steps in the correct order. (Put the first step at
    12·1 answer
  • According to Dr. Ridel's Levels of Critical Thinking in Chapter 1, what level of critical thinking applies to your current statu
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!