Finely Company is a manufacturer of picture frames. The biggest sellers they have are the Concave and the Round. The Concave sells for $50 and requires 80 ounces of material and 30 minutes of labor. The Round sells for $75 and requires 90 ounces of material 45 minutes of labor. The company pays $0.50 an ounce for material and $0.10 a minute for labor. Seleny will not be able to get more than 25000 ounces of material and no more than 1000 minutes of labor.

1) Construct a spreadsheet model assuming 100 Concave and 200 Round will be produced.
Use the following order ONLY on your sheet: Profit, Material used, labor used, revenue, unit selling price, quantity made, and material per unit, minutes per unit, cost of material used, cost of labor used, cost per lb, cost per minute.

You must use Excel to answer this question

2) Find the optimal solution using the model and What's Best

3) How many Round and Concave should be made and solve graphically.

4) A manager has four jobs that must be assigned. Estimated processing times for each of four employees are shown in the following table:

SMITH JONES GREEN MEHL
1 6.2 8 5.4 4.8
2 6 7.2 5.8 4.4
3 5.5 6 6.6 6.8
4 6.3 6.6 7 7.3

What is the total processing time for the optimal assignment Use Excel and What BEST

Excel file contains spreadsheet model and the optimal solution using the model and What's Best, graph and calculations of the total processing time for the optimal assignment.

Probability, Normal Distribution, Binomial Probabilities. ... the probability by using a binomial probability table P ... 4. Using the simple random sample of weights of ...

...Using a table or calculator, we get that this value is -2.62. ... This probability is 0.749 ... We can't use the same test we used above because the sample size is much ...

... advocate the utilization of the use of Q ... provide quantitative information about the probability of clinical ... result to statistical significance using q values ...

... 1 in 10 chance of being selected using this method. ... to make judgments of the probability that an ... data to more general conditions; we use descriptive statistics ...

... Under what conditions would ... A probability sample would be used when we want to determine ... We would use probability sampling to determine how many students out ...

... signal to a problem with quality using the tracking ... is functioning properly, what is the probability of four ... 5. Use a graphical tool that describes the shape ...

... Thank you for using BrainMass ... way of proceeding that would maximize the probability of an ... correlates with successful psychotherapy," then you would use a process ...

... a. What is the probability that more ... We know that p , the sample proportion used to estimate the population proportion, p , has a normal distribution with ...

... or dissatisfied, that will affect the probability of their ... in basketball with regard to the use of data ... are complexities that you can really study using numbers ...

... Techniques Alternative Solution Risks and Probability Consequence and ... may face when they use the 9-step problem ... management using the 9-step problem solving model ...