Search for question
Question

Face Cream, Shift 1 Item Labor Stage 1 Labor Stage 2 Water Oils Scents/Colors Emulsifiers Total Body Cream, Shift 1 Item Labor Stage 1 Labor Stage 2 Water Oils Scents/Colors Emulsifiers

Total Hand Cream Shift 1 Item Labor Stage 1 Labor Stage 2 Water Oils SHIFT DETAILS Resource Required 1.50 0.80 8.00 8.00 1.00 0.50 0.50 Scents/Colors Emulsifiers Total Resource Required 1.80 1.00 6.00 3.00 0.30 0.70 Resource Required 1.00 0.50 7.00 2.00 0.40 0.60 $/Unit Cost ($) 0.00 $/Unit Cost ($) 0.00 $/Unit Cost ($) 0.00 Face Cream, Shift 2 Item Labor Stage 1 Labor Stage 2 Water Oils Scents/Colors Emulsifiers Total Body Cream, Shift 2 Item Labor Stage 1 Labor Stage 2 Water Oils Scents/Colors Emulsifiers Total Hand Cream, Shift 2 Item Labor Stage 1 Labor Stage 2 Water Oils Scents/Colors Emulsifiers Total Resource Required 1.50 0.80 8.00 1.00 0.50 0.50 Resource Required 1.80 1.00 6.00 3.00 0.30 0.70 Resource Required 1.00 0.50 7.00 2.00 0.40 0.60 $/Unit $/Unit $/Unit Cost ($) 0.00 Cost ($) 0.00 Cost ($) 0.00/n1 2 3 Cost 4 Labor 11 5 6 7 8 9 Olls 10 Scents/Colors 11 Emulsifiers 12 Amount (FC) 13 Amount (BC) 14 Amount (HC) 15 16 Labor 21 Labor 12 Labor 22 Water 17 A B с D E F Linear Programming Model Formulation (8 production variable, 11 constraints, minimization problem) Face Cream, Face Face Cream, Subcontracted Body Cream, Body Cream, Shift 1 Shift 2 Shift 1 1 Cream, Shift 2 1 1 1 1 G H 1 Body Cream, Hand Cream, Hand Cream, Subcontracted Shift 1 Shift 2 I 1 min S S S S S S S S 2 2 12 J K L M/n▲ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 A B Production Schedule - Based on Sensitivity Analysis Method/Product Shift 1 Shift 2 Vendor Total Total cost: Optimal Production Plan Face Cream 0 0 D Body Cream 0 E Hand Cream N/A F G H I J K L M N/n1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 A B E Graphs with Product Amount Changes - Costs Remain the Same Optimal Production Plan - ORIGINAL Method/Product Face Cream Shift 1 Shift 2 Vendor Total Total cost: Shift 1 Shift 2 Vendor Total 0 0 Total cort: $1,368,178.00 0 0 Body Cream Optimal Production Plan - increase production by 15% Method/Product Face Cream Body Cream 0.00 0 Hand Cream 0 N/A 18,000 Hand Cream 0 F G Optimal Production Plan - increase production by 10% Method/Product Face Cream Body Cream Shift 1 Shift 2 Vendor Total Total cost: Vendor Total H Total cock! 0 0 0 0 0.00 Optimal Production Plan - increase production by 20% Method/Product Face Cream Body Cream Ishift 1 Shift 2 0 0 0 0 0 0 0.00 Hand Cream 0 Hand Cream 0 0 0 0 0 K L M

Fig: 1

Fig: 2

Fig: 3

Fig: 4