Question

Offered Price $15.00

Maths - Beverly Ann Cosmetics

Question # 00012808
Subject: Mathematics
Due on: 05/12/2014
Posted On: 04/19/2014 04:02 PM

Rating:
4.1/5
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
4722
Tutorials:
4991
Feedback Score:

Purchase it
Report this Question as Inappropriate
Question
I have the following in statistics:
Beverly Ann Cosmetics has created two new perfumes: Summer Passion and Ocean Breeze. It costs $5.25 to purchase the fragrance needed for each bottle of Summer Passion and $4.70 for each bottle of Ocean Breeze. The marketing department has stated that at least 30% but no more than 70% of the product mix be Summer Passion; the forecasted monthly demand is 7,000 bottles and is estimated to increase by 8 bottles for each $1 spent on advertising. Summer Passion sells for $42.00 per bottle and Ocean Breeze, for $30.00 per bottle. The forecasted monthly demand for Ocean Breeze is 12,000 bottles and is estimated to increase by 15 bottles for each $1 spent on advertising. A monthly budget of $100,000 is available for both advertising and purchase of the fragrances. Develop and solve a linear optimization model to determine how much of each type of perfume should be produced to maximize the net profit. See attached chart.
Can somebody answer this assignment.? Study the problem “Beverly Ann Cosmetics” and the attached spreadsheet CosmeticsData.xlsx.

Complete the linear program: compute item profit for each perfume; compute monthly profit; enter maximum monthly budget for advertising and purchases. Determine the optimal solution. Run sensitivity analysis. Answer the case questions.

Tutorials for this Question
Available for
$15.00

Maths - Beverly Ann Cosmetics

Tutorial # 00012357
Posted On: 04/19/2014 04:03 PM
Posted By:
Best Tutors for school students, college students vikas
Expert tutors with experiences and qualities
Questions:
4722
Tutorials:
4991
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …CosmeticsMaths…
Attachments
Maths_-_Beverly_Ann_Cosmetics_Solution.xlsx (18.52 KB)
Preview: for xxxxxx PassionMax xxxxxxxxxx requirement for xxxxxx PassionDemand on xxxxxx PassionDemand xx xxxxx BreezeBudget xxxxxxxxxx on advertising xxx purchaseSign<=>=Microsoft Excel xx 0 xxxxxx xxxxxxxxxxxxxxxx [CosmeticsData xxxxxxxxxx SetupResult: Solver xxxxx a solution xxx Constraints xxx xxxxxxxxxx.....
Purchase this Tutorial @ $15.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
List of Main Subjects
Accounting
Anthropology
Architecture
Art
Asian Studies
Astronomy
Biology
Business
Chemistry
Communications
Computer Science
Economics
Education
Engineering
English
Finance
Foreign Languages
Gender Studies
General Questions
Geography
Geology
Health Care
History
Kindergarten
Law
Linguistics
Literary Studies
Marketing
Mathematics
Music
Nursing
Performing Arts
Philosophy
Physics
Political Science
Psychology
Religious Studies
Sociology
Statistics
Urban Planning and Policy
View all subjects...
Loading...