A Company Asked One of Their Analysis Team to Analyze

question 18

Essay

A company asked one of their analysis team to analyze and create models that help decide whether they should manufacture a particular product or outsource its production. The different components are given below.
Fixed Cost, FC = $25,000
Material Cost per Unit, MC = $2.15
Labor Cost per Unit, LC = $2.00
Outsourcing Cost per Unit, O = $4.50
​
a. Build an influence diagram that illustrates how to calculate the difference in cost of manufacturing and outsourcing.
b. Using mathematical notation, construct a mathematical model for calculating the difference in cost of manufacturing and outsourcing.
c. Implement your model from part (b) in an Excel spreadsheet model using the principles of good spreadsheet design.
d. Using the spreadsheet model, what will be the resulting savings due to outsourcing if the company wants to make 30,000 units of a particular product?
​

Differentiate between Super's concepts of life span and life space.

Understand how Super's theories are applied in career counseling models.

Understand the importance of satisfaction and satisfactoriness in work adjustment.

Comprehend the role of independence and autonomy in workplace adjustment.

---

Definitions:

Revised

Updated or altered from its original form, often to include new information or corrections.

Pre-menstrual Dysphoric Disorder

A severe form of premenstrual syndrome that significantly affects a woman's emotional and physical health.

DSM-IV

The fourth edition of the Diagnostic and Statistical Manual of Mental Disorders, a guide for diagnosing mental disorders.

Appendix

A small tube-shaped sac attached to the lower end of the large intestine, whose function in humans is considered vestigial.