NEED A PERFECT PAPER? PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:

Data Sheet Analysis Support (Calculations, Etc.) I need help with this sample assignment.  See the prompt below and attached template:  “Prompt: You will

Data Sheet Analysis Support (Calculations, Etc.) I need help with this sample assignment.  See the prompt below and attached template:

 “Prompt: You will

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Data Sheet Analysis Support (Calculations, Etc.) I need help with this sample assignment.  See the prompt below and attached template:

 “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:  

A. Calculate the labor stages and material requirements for each product.  

B. Based on the results of your calculation, develop a summary table for linear programming analysis.  

C. Next, calculate the production schedule, determining what will be produced, the quantity, and when the output will be produced.  

D. Conduct a sensitivity analysis on the cost of the products using a decision tree. 

E. Generate labeled graphs to demonstrate changes, if any, in product cost.”

I need the attached template filled out to reflect the asks (see: Sections  A -E) made by the prompt.  Thanks so much for your help. 🙂

Please let me know the cost estimate, as well as time estimate.  I’ll be able to pay this Fri, so don’t expect any work to begin until then.  Thanks again! Data

Use in Exhibit 1: Product Production Requirements

Criteria/Vendor Face Cream Body Cream Hand Cream

Labor (hour/carton)

Stage 1 1.5 1.8 1.0

Stage 2 0.8 1.0 0.5

Material (pounds/carton)

Water 8.0 6.0 7.0

Oil 1.0 3.0 2.0

Scents and Colors 0.5 0.3 0.4

Emulsifiers 0.5 0.7 0.6

A. Labor Stages – Material Req

SHIFT DETAILS

Face Cream, Shift 1 Item Resource Required $/Unit Cost ($) Face Cream, Shift 2 Item Resource Required $/Unit Cost ($)

Labor Stage 1 1.50 Labor Stage 1 1.50

Labor Stage 2 0.80 Labor Stage 2 0.80

Water 8.00 Water 8.00

Oils 1.00 Oils 1.00

Scents/Colors 0.50 Scents/Colors 0.50

Emulsifiers 0.50 Emulsifiers 0.50

Total 0.00 Total 0.00

Body Cream, Shift 1 Item Resource Required $/Unit Cost ($) Body Cream, Shift 2 Item Resource Required $/Unit Cost ($)

Labor Stage 1 1.80 Labor Stage 1 1.80

Labor Stage 2 1.00 Labor Stage 2 1.00

Water 6.00 Water 6.00

Oils 3.00 Oils 3.00

Scents/Colors 0.30 Scents/Colors 0.30

Emulsifiers 0.70 Emulsifiers 0.70

Total 0.00 Total 0.00

Hand Cream Shift 1 Item Resource Required $/Unit Cost ($) Hand Cream, Shift 2 Item Resource Required $/Unit Cost ($)

Labor Stage 1 1.00 Labor Stage 1 1.00

Labor Stage 2 0.50 Labor Stage 2 0.50

Water 7.00 Water 7.00

Oils 2.00 Oils 2.00

Scents/Colors 0.40 Scents/Colors 0.40

Emulsifiers 0.60 Emulsifiers 0.60

Total 0.00 Total 0.00

B. Summary Table

Linear Programming Model Formulation (8 production variable, 11 constraints, minimization problem)

Face Cream, Shift 1 Face Cream, Shift 2 Face Cream, Subcontracted Body Cream, Shift 1 Body Cream, Shift 2 Body Cream, Subcontracted Hand Cream, Shift 1 Hand Cream, Shift 2

Cost min

Labor 11 ≤

Labor 21 ≤

Labor 12 ≤

Labor 22 ≤

Water ≤

Oils ≤

Scents/Colors ≤

Emulsifiers ≤

Amount (FC) 1 1 1 ≥

Amount (BC) 1 1 1 ≥

Amount (HC) 1 1 ≥

C. Production Schedule

Production Schedule – Based on Sensitivity Analysis

Optimal Production Plan

Method/Product Face Cream Body Cream Hand Cream

Shift 1 0

Shift 2 0 0

Vendor N/A

Total

Total cost:

D. Decision Tree

Create a Production Decision Tree

E. Graphs

Graphs with Product Amount Changes – Costs Remain the Same

Optimal Production Plan – ORIGINAL Optimal Production Plan – increase production by 10%

Method/Product Face Cream Body Cream Hand Cream Method/Product Face Cream Body Cream Hand Cream

Shift 1 0 Shift 1 0 0 0

Shift 2 0 0 Shift 2 0 0 0

Vendor N/A Vendor 0 0 0

Total 18,000 Total 0 0 0

Total cost: $1,368,178.00 Total cost: 0.00

Optimal Production Plan – increase production by 15% Optimal Production Plan – increase production by 20%

Method/Product Face Cream Body Cream Hand Cream Method/Product Face Cream Body Cream Hand Cream

Shift 1 0 Shift 1 0

Shift 2 0 0 Shift 2 0 0

Vendor 0 Vendor 0

Total Total

Total cost: 0.00 Total cost: 0.00

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality