Question: I need the solution using Excel Solver, please Statement of the situation Lip & Gloss is a small business that emerged at the beginning of



I need the solution using Excel Solver, please
Statement of the situation Lip & Gloss is a small business that emerged at the beginning of November 2020, sell handmade glosses and resale various products like exfoliants, lip tints and balms from different brands. Over the months sales have increased, known various suppliers, improved formulas and has given publicity to the business. But we want these actions to be reflected in the profits. The majority of our stock is nearing completion, so it is a good time to buy back raw materials and resale products. The prices of the raw material is not intended to be minimized since they are good quality products and are the base of satisfied customers. Raw materials Amount Price Versagel 496 ml $6000 Container 5ml 50 Pieces $576 Coconut Oil 3L $250 Almond Oil 21 $378 Strawberry essence 30 ml $146 Pack of five different pigments 30 ml $1400 Vitamin E 500 gr $800 We have a few options of products for resale: Resale products Units Price Lip tint Dear Darling 12 $148 Lip balm Baolishi 24 $528 Lip scrub Meover 6 $119 Lip scrub Klean Color 6 $348 Lip balm Glazzi 6 $107 6 $119 Lip plumper tinted Ultramo Lip tint Huda Bear 12 $219 Statement of the objective of the model . Maximize the product purchased with a budget of $15,000.00 Statement of assumptions of the model . There is no loss of raw material when manufacturing. During the company's operating time, no defective products have been presented, nor have defective materials been acquired. The purchase prices of raw materials and products for resale will not have a price increase in the near future. The costs of packaging material, small gifts for the consumer, shipping, utensils for manufacturing are not included in the model. Possible discounts are not contemplated when buying raw materials or resale products. You have a budget of $15,000.00 to buy all raw materials and products for resale. There is no problem of over material because it can be used in another manufacturing batch. . . Model 1 Variable definition o o 0 o X1= Number of Versagel buckets to buy. X2= Number of Containers 5ml packs to buy. X3= Number of Coconut Oil bottles to buy. X4= Number of Almond Oil bottles to buy. X5= Number of Strawberry essence jars to buy. o X6= Number of Packs of pigments to buy. X7= Number of Vitamin E boxes to buy. X8= Number of Lip tint Dear Darling packs to buy. X9= Lip balm Baolishi packs to buy. X10= Lip scrub Meover packs to buy. o X11= Lip scrub KleanColor packs to buy. X12= Lip balm Glazzi packs to buy. X13= Lip plumper tinted Ultramo packs to buy. o X145 Lip tint Huda Bear packs to buy. Objective function o O Max Z = 6000x, +576x, + 250xz + 378x4 + 146x5 + 1400xg + 800x, + 148xg +528x, +119x10 + 348x11 + 107x12 +119 X13 +219x14 Constraints The maximum budget is $15,000.00 6000x; +576x, + 250xz + 378x4 + 146x5 + 1400x6 + 800x7 + 148xg + 528x9 +119x10 + 348x11 + 107x12 + 119 X13 +219x14 = $15,000 At least one bucket of Versagel needs to be buy X, 211 At least two packs of Containers 5ml needs to be buy *222 o Only need to buy one of each product: Coconut Oil bottles, Almond Oil bottles, Strawberry essence jars, Packs of pigments, Vitamin E boxes. X3, X4, X5, X6, X, = 1 o Only need to buy a packet of Baolishi Lip balm because it is only demanded by some consumers. Xg = 1 o Buy at least three packs of Lip plumper tinted Ultramo *1333Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
