Purchase Solution

Probability and Using Whats Best

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution
Solution Summary

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.

Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

View More Free Quizzes
Related BrainMass Solutions

  • Normal Distribution, Sampling, Confidence interval

    c) Whats the 95% confidence interval for the estimate? d) Whats the best estimate for the mean number of telephones of all homes? see attached file Answers to questions on estimation, probability calculations based on Normal Distribution.

  • Monte Carlo Simulation:grocery store quantities of fresh produce

    Whats your confidence interval for the mean profit? In other words, whats the 95% confidence interval for the true mean profit. Find upper and lower bounds. What is the impact of risk on your decision?

  • Hypergeometric Question on Training Enrollment

    Usually E(x) = np, but I'm not sure if 0 is my p and 20 is my n. Whats the probability that no one will drop out?

  • Expected return

    285896 High Flier's common stock: Whats is the expected return? High Flier's common stock is expected to return 28 percent in a boom economy,14 percent in a normal economy, and -32 percent in a recession.

  • Calculating NPV, capital structure, current ratio

    The annual payment would be $8,319.72 This amount is obtained by using the following formula: PV = Payment/interest rate * (1 - (1 / 1 + interest rate^number of payment periods)) 3 Whats the net present value of a project which requires

  • Algebra Opposite Numbers

    23927 Algebra Opposite Numbers 1-Three times the opposite of a number is 40 greater than 5 times the number. whats the number. 2-The product of 7 and the opposite of a number is decreased by 28.

  • Velocity, Inflation, and Money Supply

    This is the money created by the Fed, and used to control economic growth. Best of luck on your assignment and thank you for using BrainMass. The following problem helps with a problem involving velocity, inflation and money supply.

  • E-Commerce Entrepreneurship

    q=%20commerce%20fallacies http://www.ecommercetimes.com/story/E-Commerce-Innovations---Whats-Now-and-Whats-Next-68106.html 335 words; 3 references; importance of e-commerce in creating a strategy and how it is an example of innovation

  • Calculating the Internal Rate of Return

    The machine will increase revenues by $10,000 per year and incur a maintenance cost of $4,000 every year. The machine has a 5-year useful life after which can be sold for $2,000. The project has a negative NPV at 12%. Whats is IRR?

View More Related Solutions