Overview: Data analysis is an essential part of informing business decisions and helps provide a solid rationale to gain stakeholder buy-in. Knowing what data toanalyze is also important.
Prompt: You will now calculate and analyze data based on information provided in the scenario to inform and support the decisions necessary to resolve the organizational challenges. Your analysis will explore the production schedule and vendor optimization by running a linear programming model and sensitivity analysis. You will submit this section as an Excel spreadsheet to show your programming. Please refer to your syllabus for instructions on how to access your case study.
Specifically, you must address the critical elements listed below.
II. Data Analysis:
-
Calculate the labor stages and material requirements for each product.
-
Based on the results of your calculation, develop a summary table for linear programming analysis.
-
Next, calculate the production schedule, determining what will be produced, the quantity, and when the output will be produced.
-
Conduct a sensitivity analysis on the cost of the products using a decision tree.
-
Generate labeled graphs to demonstrate changes, if any, in product cost.
E. Graphs + cost (5) cream Use in Bhibit 1: Product Production Requirements Face Hand Criter/Vendor Cream Body Cream Cream Labor hour/carton Stage 1 1.518 10 Stage 2 0.8 100.5 Material poundcarton) W 3.0 60 70 OL 1.0 3.0 2.0 Scents and Colors 0.5 03 0.4 Emuliers 0.5 07 0.6 Data A. Labor Stages - Material Reg B. Summary Table C. Production Schedule D. Decision Tree SHIFT DETAILS TRE Face Cream SNR Item Required s/Unit Couto Face Cream, Shit 2 Item Required Unit Labor 1.50 Labor Stage 1 1.50 Libore Labert OND Water 1.00 Water LOD Jouls 100 Oils 1.00 Scent Colors 0.50 Scents Color 0.50 Emuliers 0.53 Emulsifiers 0.50 Total 0.00 Total Resource Resource Body Cream, SNR 1 item Required S/Unit Cost1 Body Cream, Shit 2 Item Required s/Unit Labore 1.80 Laber Stage 1 1.80 Labor Stage 2 1.00 Labor Stage 2 1.00 water 6.00 Water 6.00 als 1.00 Oils 1.00 Scent Color Scent Color 9:30 Emisiers 0.70 Emulsifiers 0.70 Total 0.00 Total Resource Resource Hand Cream SNR 1 item Required 5/Unit Cost Hand Cream, Shi 2 ter Required S/Unit Labor Star 100 Labor Stage 1 1.00 Labor Stage 2 0.50 Laber Stage 2 0.50 Water 7.00 water 7.00 Oils 2.00 Dils 2.00 Scent/Colors 04 ScentsColor 0.45 Emulsiers 0.60 flers 60 Total 0.00 Total Data A. Labor Stages - Material Req B. Summary Table C. Production Schedule D. Decision Tree Linee Programming Model formulation production variable, 11 constraints, minimit.ansroblem Face Cream Face Cream Face Cream Fare cream rece Cream Body Creamy Cream, Body C Shini sina Subcontracted subcontracted Shift Shit Cout mi Labor 11 Labor21 Labor 12 13 Lober 22 3 0.00 Cost (5) 0.00 C153 0.00 E. Gros + 13 Is 1s ON Sercolor Emulders Amount Amount Amount 112 Data A Labor Stages Materiale B. Summary Table Production Schedule D. Decision Tree E Graphs + Production Schedule Based on Sensitivity Analysis Optimal Production Plan Face Cream Body Cream Hand Cream Method/Product Shiti Shirt 2 Vendo Total 0 NA Total cost Data A. Labor Stages. Material Reg B. Summary Table C. Production Schedule D. Decision Tree E Graphs + Crearte Production Decision Tree . Data A Labor Stages. Material Reg Summary Table C. Production Schedule D. Decision Tree E. Graphs + Graphs with Product Amount Changes Costa Romain the same Hand Cream Optima Production Plan Increase production by 10% Method/Product Pace Cream Body Cream Hand Crean Optimal Production Plan.ORIGINAL Method/ Product Pace Cream Body Cream Swift 1 Shift 0 Vendor IT a SNR: Shift Vendor Total 0 0 O 0 NA O 18.000 Totalcoat Todo 51,368,178.00 Totalco D.DO Hand Cream Mand Cream Optimal Production Plan-increase production by 15% Mathed/Product Face Cream Body Cream Shill 1 0 Shift 2 0 Vendor Tata Optima Production Plan increase production by 20% Method/Product Face Cream Day Cream SHR1 Shin 2 Vendor totd Tatlon 0.00 Totalco 0.00 A Labor Stages. Material Reg B. Summary Table Production Schedule D. Decision Tree E. Graphs E. Graphs + cost (5) cream Use in Bhibit 1: Product Production Requirements Face Hand Criter/Vendor Cream Body Cream Cream Labor hour/carton Stage 1 1.518 10 Stage 2 0.8 100.5 Material poundcarton) W 3.0 60 70 OL 1.0 3.0 2.0 Scents and Colors 0.5 03 0.4 Emuliers 0.5 07 0.6 Data A. Labor Stages - Material Reg B. Summary Table C. Production Schedule D. Decision Tree SHIFT DETAILS TRE Face Cream SNR Item Required s/Unit Couto Face Cream, Shit 2 Item Required Unit Labor 1.50 Labor Stage 1 1.50 Libore Labert OND Water 1.00 Water LOD Jouls 100 Oils 1.00 Scent Colors 0.50 Scents Color 0.50 Emuliers 0.53 Emulsifiers 0.50 Total 0.00 Total Resource Resource Body Cream, SNR 1 item Required S/Unit Cost1 Body Cream, Shit 2 Item Required s/Unit Labore 1.80 Laber Stage 1 1.80 Labor Stage 2 1.00 Labor Stage 2 1.00 water 6.00 Water 6.00 als 1.00 Oils 1.00 Scent Color Scent Color 9:30 Emisiers 0.70 Emulsifiers 0.70 Total 0.00 Total Resource Resource Hand Cream SNR 1 item Required 5/Unit Cost Hand Cream, Shi 2 ter Required S/Unit Labor Star 100 Labor Stage 1 1.00 Labor Stage 2 0.50 Laber Stage 2 0.50 Water 7.00 water 7.00 Oils 2.00 Dils 2.00 Scent/Colors 04 ScentsColor 0.45 Emulsiers 0.60 flers 60 Total 0.00 Total Data A. Labor Stages - Material Req B. Summary Table C. Production Schedule D. Decision Tree Linee Programming Model formulation production variable, 11 constraints, minimit.ansroblem Face Cream Face Cream Face Cream Fare cream rece Cream Body Creamy Cream, Body C Shini sina Subcontracted subcontracted Shift Shit Cout mi Labor 11 Labor21 Labor 12 13 Lober 22 3 0.00 Cost (5) 0.00 C153 0.00 E. Gros + 13 Is 1s ON Sercolor Emulders Amount Amount Amount 112 Data A Labor Stages Materiale B. Summary Table Production Schedule D. Decision Tree E Graphs + Production Schedule Based on Sensitivity Analysis Optimal Production Plan Face Cream Body Cream Hand Cream Method/Product Shiti Shirt 2 Vendo Total 0 NA Total cost Data A. Labor Stages. Material Reg B. Summary Table C. Production Schedule D. Decision Tree E Graphs + Crearte Production Decision Tree . Data A Labor Stages. Material Reg Summary Table C. Production Schedule D. Decision Tree E. Graphs + Graphs with Product Amount Changes Costa Romain the same Hand Cream Optima Production Plan Increase production by 10% Method/Product Pace Cream Body Cream Hand Crean Optimal Production Plan.ORIGINAL Method/ Product Pace Cream Body Cream Swift 1 Shift 0 Vendor IT a SNR: Shift Vendor Total 0 0 O 0 NA O 18.000 Totalcoat Todo 51,368,178.00 Totalco D.DO Hand Cream Mand Cream Optimal Production Plan-increase production by 15% Mathed/Product Face Cream Body Cream Shill 1 0 Shift 2 0 Vendor Tata Optima Production Plan increase production by 20% Method/Product Face Cream Day Cream SHR1 Shin 2 Vendor totd Tatlon 0.00 Totalco 0.00 A Labor Stages. Material Reg B. Summary Table Production Schedule D. Decision Tree E. Graphs