User Account

All Pages

Use the spreadsheet to determine the total profit for each

Assignment Help Basic Statistics
Reference no: EM13590095

1) Consider a resource-allocation problem having the following data:

Resource             1 Activity       2   Amount resource available

                A             1             0              5

                B             0            1              4

                C             2            1              9

                D             3           4              21          

Unit profit               30          20

The objective is to determine the number of units of each activity to undertake so as to maximize the total profit.

(a) Formulate a spreadsheet model for this problem. 

(b) Graph the feasible region. Use this graph to identify all the corner points.

(c) Use the spreadsheet to determine the total profit for each of these corner points. Then use this information to identify an optimal solution. 

(d) Use the Excel Solver to confirm this optimal solution. 

(e) Use the graphical method to confirm this optimal solution

Reference no: EM13590095

Questions Cloud

Discuss earnings management as it relates to estimates : discuss earnings management as it relates to estimates that are required in formulating the financial statements.
Nick has made the decision to seek this outside financing : warf computers inc. was founded 1 5 years ago by nick warf a computer programmer. the small initial investment to start
Mfg company experiences the following cost behavior : mfg company experiences the following cost behavior patterns each week fixed costs supervisors salary 2000 factory rent
If machine 2 was purchased on november 1 instead of april 1 : in recent years howard company has purchased three machines. because of fre- quent employee turnover in the accounting
Use the spreadsheet to determine the total profit for each : 1 consider a resource-allocation problem having the following
Calculate the indifference point between the two cost : the cost structure of two firms competing in the same industry is represented by the following cost formulas company x
There have been many theories regarding how the pyramids at : choose one 1 of the topics below and develop a three to four 3-4 paragraph essay of at least 250-500 words which
A newspaper ad submitted and published this week with the : 1. financial statement ratios support informed judgments and decision making most effectivelya. when viewed for a
A contractor susan meyer has to haul gravel to three : a contractor susan meyer has to haul gravel to three building sites. she can purchase as much as 18 tons at a gravel

Reviews

Write a Review

Basic Statistics Questions & Answers

  Relationships according to the signs

If there is a negative dependent variable of -0.55, and independent variables Y1 of +0.75 and Y2 of -3.0, how do I interpret the relationships according to the signs?

  Probability of the events related to environment

The rest have no opinion. " Suppose that a a sample of 100 American adults is quizzed on the subject. What is the probability of the following events?

  What sample size estimate the true weight with an error

What sample size would be necessary to estimate the true weight with an error of +/- 0.03 grams with 90 percent confidence?

  Mean output of solar cells of three types are measured six

Mean output of solar cells of three types are measured six times under random light intensity over a period of 5 minutes, yielding the results shown. Research Question: Is the mean solar cell output the same for all cell types?

  Find df for determining mean weight of adult women

A standard deviation of 12.4. A local census taken several years ago shows the mean weight of adult women was 115 lbs. The df for determining tcrit

  Probability that no ship have hairline cracks

In a shipment of 52 vials, only 12 do not have hairline cracks. If you randomly select 2 vials from the shipment, what is the probability that none of the 2 vials have hairline cracks?

  Probability that sample of students have mean verbal score

What is the probability that a random sample of 36 students will have a mean verbal sat score that is great than 535?

  Description of quotient and remainder

Evette has 41 1/2ft. of string. She wants to cut it into pieces 3 3/4ft. long. How many pieces of string will she have? how much string remains, if any?

  The selected material adequate

Failure testing of a steel alloy resulted in the following S-N curve:N=(1.23*10^28)S^-14.85

  Hypothesis testing for population mean

The null hypothesis is that there was no change in average liquor consumption. State this formally in terms of µ.

  Finding probability based on cards

You draw two cards from a standard deck of 52 cards, but before you draw the second card, you put the first one back and reshuffle the deck.

  Z-score calculations for statistics students

The weight of cans of fruit is normally distributed with a mean of 1,000 grams and a standard deviation of 50 grams. What percent of the cans weigh 860 grams or less?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd