Reference no: EM131234976
Three products, Product1 and Product2 and Product3, are produced in annual amounts A1, A2 and A3 respectively. Producti (for each i = 1, 2, 3) has annual demand Ai (as above), fixed cost per order ki, unit cost per item ci, annual holding cost hi, and order quantity Qi; where we shall sometimes write the optimal order quantity Q*i simply as Qi (i = 1, 2, 3).
Upon being produced and delivered, each Qi of each product Producti is made into a circle, which has radius ri = Qi /(2π). Due to a misunderstanding in business negotiations and specifications (regarding the area of land that length Qi can enclose), the profit Profiti given will equal the area of this circle, π ri2 or, equivalently, π [Qi /(2π)]2, or equivalently, Qi2/(4π).
We know that ki/(2π ci hi) = (2ki/(ci hi))/(4π) takes the following values:
k1/(2π c1 h1) = $35, k2/(2π c2 h2) = $30, and k3/(2π c3 h3) = $32.
Due to conflicting demand for rival products, we have the following constraints on the annual demands Ai for the products Producti whose profits (as above) are Qi2/(4π). Here are the relevant constraints:
9 A1 + 5 A2 + 8 A3 <= 3132
A1 + A2 + A3 <= 400
12 A1 + 17 A2 + 13 A3 <= 5760.
a) Formulate this problem appropriately.
b) Create a spreadsheet model for this problem.
c) Are there any other constraints that should be stated?
If so, give these constraints
d) Solve the problem - using Microsoft Excel Solver, generating the minimum cost to satisfy the constraints.
What is the minimum cost?
e) Keeping all variables fixed except k3, Q3 and A3, by what proportion or factor would k3 have to change in order to change Q3 and A3?
Question about economic order quantity
|
Time-constraint-scope-accept and cost-enhance
: Discuss the importance of structure in relationship to strategy. Explain which of these factors should come first, and why. How can cultural issues arises within an organization? And give three real life examples to support your claim. What does it m..
|
|
Determine the gravitational potential of a spherical shell
: Attraction of a Spherical Shell Determine the gravitational potential of a spherical shell with inner radius R1 and outer radius R2
|
|
Write a program to produce a sales receipt
: Write a program to produce a sales receipt. Use a class level variable to track the sum of the prices.
|
|
Identifying and discussing dsm disorder you have selected
: Provide a brief introductory paragraph identifying and discussing the DSM disorder you have selected (furnish appropriate APA citations and References). Write ten interview questions that will bring out the information you need.
|
|
About economic order quantity
: Three products, Product1 and Product2 and Product3, are produced in annual amounts A1, A2 and A3 respectively. Producti (for each i = 1, 2, 3) has annual demand Ai (as above), fixed cost per order ki, unit cost per item ci, annual holding cost hi, an..
|
|
Visual basic essential training
: Using the knowledge from the Lynda.com® "Visual Basic Essential Training" video series, complete the following assignment: Design, implement, test, and debug a Visual Basic® program to create a simple aquarium cost calculator.
|
|
Determine the equation of the least squares regression line
: STA510 Business Statistics Determine the equation of the least squares regression line and explain the regression equation - what is the standard error of the estimate (Se)? Comment on the size of the standard error for this regression model.
|
|
Determine the gravitational attraction force of m
: Attraction of a Sphere Consider a uniform sphere with radius R and mass M, as shown in Figure 2.59. Determine the gravitational attraction force of M on a particle m at a distance a from the center of M.
|
|
Algorithm design and applications
: For each of the following statements about wavl trees, determine whether it is true or false. If you think it is true, provide a justification. If you think it is false, give a counter example.
|