At an International Cosmetics company (referred to as C)’s board meeting, the firm’s chief executive officer (CEO) reported that C was planning its production schedule for the upcoming quarter. She st

At an International Cosmetics company (referred to as C)’s board meeting, the firm’s chief executive officer (CEO) reported that C was planning its production schedule for the upcoming quarter. She stated that the firm did not have the internal capacity to meet the projected demand and that the only short-term possibility was to outsource some of the demand to a third-party supplier. She indicated that C had been reluctant in the past to use vendors in this way because of the proprietary nature of the company’s product line. However, she had been in negotiations with a local supplier that was prepared to sign a secrecy agreement. She indicated that she would need board approval before proceeding down this path. The board’s chairman asked how much of the projected product demand might have to be subcontracted out and cautioned against exposing C’s complete product line to an outside vendor. She stated that the analysis could be completed along with a recommendation within a week using C’s analytics-based linear programming model and a further review of the candidate vendor.

About the company: The company C produces and distributes a wide range of cosmetics offerings through a subscription-based e-commerce model. Customers can choose fromdifferent pricing plans, and the products are delivered to their homes monthly. The subscription model provided C with a stable income stream while continuing to build brand loyalty, particularly with regards to its 3 flagship products: face cream, body cream, and hand cream.

With sales approaching $150 million annually, C had experienced double-digit growth over the past few years. Its marketing department estimated that the demand for the 3 products for the upcoming quarter are 12,000 cartons of face cream, 8,000 cases of body cream, and 18,000 cases of hand cream.

The manufacturing process consisted of a two-stage production procedure that used four ingredients: purified water, oil, scents and colours, and emulsifiers. Stage 1 involved materials preparation and initial mixing while Stage 2 focused on final blending and packaging. The cost for raw materials is $1 per pound for purified water, $1.50 per pound for oil, $3 per pound for scents and colours, and $2 per pound for emulsifiers. 

C’s available first-shift capacity for the next quarter was 15,000 labour-hours for stage 1 and 10,000 for stage 2. The first-shift hourly rate was $8.50 for stage 1 and $9.25 for stage 2. A second shift was available with a 10% reduction in capacity and a 10% increase in wage rates. C could also subcontract with a local supplier identified by CEO for face cream and bodycream at a cost of $40 per carton and $55 per carton, respectively. This vendor had the capacity to meet the demand requirements that were in excess of C’s capabilities.

The production department had available 205,000 pounds of purified water, 50,000 pounds of oil, 7,500 pounds of scents and colours, and 16,000 pounds of emulsifiers.

                               Face Cream       Body Cream          Hand Cream         

Labour (Hours/carton)

Stage 1                         1.5                    1.8                          1.0

Stage 2                         0.8                    1.0                          0.5

Materials (pounds/carton)

Water                           8.0                      6.0                          7.0

Oil                                1.0                      3.0                          2.0

Scents and Colors     0.5                    0.4                           0.4

Emulsifiers                 0.5                     0.7                           0.6

(i) Use the given labor stages and material requirements provided above, what are the costs for producing the three products in-house (i.e.,  the internal production costs per carton)?

(ii) Develop a Linear Optimization model to determine optimal production strategies, including the use of outsourcing. Specify the decision variables, constraints, objective function. What is the optimization class of this model?

(iii) Solve your optimization model from part (ii) using Solver. What production schedule minimizes total cost including outsourcing, and what is the corresponding value of the objective function?

(iv) What labour and material resources are completely used up, and what are the corresponding shadow prices?

(v) Suppose that the board only allows outsourcing one product, i.e., only Face Cream or only Body Cream but not both. Under this additional requirement imposed by the company’s board, what production schedule minimizes total cost including outsourcing?

Excel file is needed with explanation of all steps

Thank you







Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10