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
EastWind [94]
3 years ago
10

Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producin

g a kitchen chair at each of the two plants is given here. Aynor: Cost = 80Q1 + 7Q12 + 93 Spartanburg: Cost = 20Q2 + 3Q22 + 147
WhereQ1 = number of Chairs produced at Aynor
Q2 = Number of Chairs produced at SpartanburgAndalus needs to Manufacture a total of 40 Kitchen Chairs to met an order just received. Howmany chairs should be made at Aynor and how many should be made at Spartanburg in order tominimize production costs.
Min + 100) +s.t. Q1 + Q2 = 40Q1,Q2≥0

a. Using Excel Solver What is the optimal solution for this problem
Business
1 answer:
Bad White [126]3 years ago
5 0

Answer:

9 in Aynor and 31 in Spartanburg

Explanation:

we need to build the following:

    A              B           C

           units    COST

Aynor          9           =93 + 80*B2 + POWER(B2;2)*7

Spartanburg 31           =147 + 20*B2 + POWER(B2;2)*3

             =b2 + b3   = c2 + c3

We stablish that we want to minimize c3

changing cell b2 and b3

with the restriction that must be integer solution and b4 should equal 40

You might be interested in
How did speculative investing weaken the stability of the stock market
Lena [83]
The main way in which speculative investing weakened the stability of the stock market was that it it led to high overvaluation of a company's worth, meaning that people began to divest quickly, leading to a run on the banks. 
7 0
3 years ago
Dunay Corporation is considering investing $750,000 in a project. The life of the project would be 11 years. The project would r
photoshop1234 [79]

Answer:

The Net Present Value is - $20324

Explanation:    

We can use our financial calculator to work out the NPV using the cashflows from the different periods and using the discount rate given. Which is 18%.

We have 11 periods. Starting off with CF 0. ( CF = cashflow ) We will work in Thousands to make it easier to read and compute. $ ' 000

CF 0 Machine Investment (750) Working Capital Investment (25) Total=(775)

CF 1 160 inflow

CF 2 160 inflow

CF 3 160 inflow

CF 4 160 inflow

CF 5 160 inflow

CF 6 160 inflow

CF 7 160 inflow

CF 8 160 inflow

CF 9 160 inflow

CF 10 160 inflow

CF 11 160 inflow. 35 salvage value from machine. Working capital 25. Total Cashlow = 220

We now use our financial calculator and input these amounts into the calculator.

We start of by entering the data and hitting ENT and do so for every Cash flow. At the end we press 2nd function CFI on our calculator. We then enter the discount rate of 18%. and press down button to get to NPV and then press COMP.

We get an answer of -20,32400407

We now need to put the amount into thousands. Thus = -20324,004

rounded to the nearest dollar we get - $ 20324

7 0
3 years ago
When the economy suffers a downturn and the incomes of many people decrease, vacationers are more likely to take car trips than
inysia [295]

Answer: Air travel is a normal good and vacation travel by car is an inferior good

Explanation: What is a normal good and what is an inferior good.

Normal goods are those goods for which the demand rises as consumer income rises. While inferior goods are goods whose demand increases when consumer income decreases.

This therefore means that the demand of inferior goods is inversely related to the income of the consumer.

From the question above, we can say that car trips are inferior goods while the air travel are normal goods.

3 0
4 years ago
Read 2 more answers
Recently Anheuser-Bush, an American Corporation, and InBev, a Belgian Corporation, finalized a multibillion dollar merger to for
bulgar [2K]

Answer:

Horizontal merger

Explanation:

An horizontal merger is a consolidation or merging of companies that are the same industry. Merging of companies in the same industry helps the companies to have a greater market share of the industry.

As seen in the question below, both companies are beer companies and are consolidating or merging to form the largest beer company in the world. This wold give them a global coverage as opposed to the few countries they were restricted to before the merger.

Cheers.

4 0
3 years ago
8. If the unemployment rate is below its natural rate, then ________. Group of answer choices output is above its potential leve
fgiga [73]

Answer:

Output is below its potential level.

4 0
3 years ago
Other questions:
  • Players will be issued what color cards for fouls, depending on the seriousness of the penalty.
    10·1 answer
  • WACKO Ltd. has $30 million in debt, equity of $55 million, an after-tax cost of debt of 6 percent, a cost of equity of 9 percent
    14·1 answer
  • A subtle form of racial discrimination in housing is​ "racial steering." racial steering occurs when real estate agents show pro
    14·1 answer
  • Plack Co. purchased 10,000 shares (2o/o ownership) of Ty Corp. on February 14, Year 1. Plack received astock dividend of 2,000 s
    10·1 answer
  • For a bank, when a person deposits money into the bank, this: a creates a liability and an asset for the bank. b creates a liabi
    12·1 answer
  • Which set of materials includes the fewest number of ingredients that are needed to make a lemon into an effective battery that
    15·1 answer
  • Josh is an HR Manager at RoxCom LLC. He is responsible for conducting performance appraisals for all entry-level employees in hi
    15·1 answer
  • Selma operates a contractor's supply store. She maintains her books using the cash method. At the end of the year, her accountan
    14·1 answer
  • A company issued 5-year, 7% bonds with a par value of $200,000. The market rate when the bonds were issued was 6.5%. The company
    14·1 answer
  • Yolinda and Wes decide to go into business together as a partnership. As part of their business, they lease a car, with each pay
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!