Decision Variable

User Generated

QeOrna

Business Finance

Description

I have attached snips of the answers, I need the answers transferred to excel sheets with the provided formulas. No changes required just transferring the data using the formulas.

Unformatted Attachment Preview

G Briley Cosmetics Inc. Briley X + M Black Friday Festival #Da X S Feed Site | Studypool X S X SOLUTION: Briley Cosmetics X C Briley Cosmetics Manufactu X www.chegg.com/homework-help/questions-and-answers/briley-cosmetics-manufactures-distributes e c a Search x III n AB. = Chegg Study TEXTBOOK SOLUTIONS EXPERT Q&A Search D Was this answer helpful? 151 Po Anonymous answered this 2,984 answers Decision variable: Let, F1 Number of Cartons of Face cream to be produced in Shift 1 F2 Number of Cartons of Face cream to be produced in Shift 2 B1 Number of Cartons of Body cream to be produced in Shift 1 B2 Number of Cartons of Body cream to be produced in Shift 2 Hi Number of Cartons of Hand cream to be produced in Shift 1 H2 Number of Cartons of Hand cream to be produced in Shift 2 Fs Number of Cartons of Face cream to be subcontracted to local vendor Bs Number of Cartons of Body cream to be subcontracted to local vendor Objective is to minimize the total production and subcontracting cost producing the products while satisfying demand, labor hours, and raw materials constraint. The excel formulation is as shown below: Activate Windows Go to Settings to activate Windows. A F ! M B Decision variable Labor at stage 1 с F1 1.5 D B1 1.8 1 2. E H1 1 F2 G B2 0 J Bs H H2 0 Fs K Available 15000 L Cost $8.50 0 0 0 M Black Friday Festival #Da X S Feed Site | Studypool Х X S SOLUTION: Briley Cosmetics X C Briley Cosmetics Manufactu X G Briley Cosmetics Inc. Briley X + x III www.chegg.com/homework-help/questions-and-answers/briley-cosmetics-manufactures-distributes e c Q Search n AB. = Chegg Study TEXTBOOK SOLUTIONS EXPERT Q&A Search D satisfying demand, labor hours, and raw materials constraint. The excel formulation is as shown below: A D 1 J L M G B2 Bs Shift 1 0 0 B Decision variable Labor at stage 1 Labor at stage 1 Labor at stage 1 Labor at stage 1 A B E H1 1 0.5 0 0 с F1 1.5 0.8 0 0 5 7 F F2 0 0 1.5 0.8 B1 1.8 1 0 0 8 0 0 H H2 0 0 1 0.5 Fs 0 0 0 K Available 15000 10000 13500 9000 200000 150000 1.8 0 Cost $8.50 $9.25 $9.35 $10.18 $1 $1.50 Shift 2 0 0 1 8 1 2 3 4 5 5 6 7 8 9 10 11 12 5 3 0 0 RM 3 9 7 4 9 0 0 Cost Optimal Production aty $35.65 0 $38.55 3750 $29.63 $37.67 8250 0 $41.01 0 $30.94 6750 $40.00 10000 $55.00 $1,066,546.88 Total Cost 1250 LHS RHS 0 0 10000 10000 = 10,000 13 3750 0 1250 5000 5,000 14 8250 6750 15000 15,000 15 1.5 1.8 1 0 0 0 0 0 15000
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

It has been pleasure working with you, Thank you so much and welcome again.

Decision variable:
Let,
F1
Number of Cartons of Face cream to be produced in Shift 1
F2
Number of Cartons of Face cream to be produced in Shift 2
B1
Number of Cartons of Body cream to be produced in Shift 1
B2
Number of Cartons of Body cream to be produced in Shift 2
H1
Number of Carto...


Anonymous
Great! 10/10 would recommend using Studypool to help you study.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags