A Company Asked One of Their Analysis Team to Analyze

question 21

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
​
Build a spreadsheet model and then use a two-way data table to show how the savings due to outsourcing changes as a function of different production volume and different bids on per-unit cost for outsourcing. Vary the production volume from 0 to 100,000 in increments of 10,000. The six bids are $3.11, $3.49, $4.50, $4.98, $5.12, and $5.45.

---

Definitions:

Federal Preemption

A legal doctrine allowing federal law to take precedence over conflicting state laws.

Literal Conflict

A situation where two or more laws, provisions, or legal texts directly contradict each other, making it impossible to comply with both simultaneously.

Persuasive Regulation

Regulations or guidelines that aim to influence behavior or decisions without imposing mandatory legal obligations.

General Welfare

Refers to the common well-being or general health, happiness, and safety of the public that governments aim to promote and protect.