Assignment2- Modeling, Sensitivity Analysis & Financial Functions

A factory produces 2500 toys every month. Last month only 2200 toys were sold. The selling price is 2.75 per unit. The material cost is 0.25 per unit and the labor cost per unit is equal to 0.75. The total fixed cost is budgeted at 500 per month.

1) Develop a spreadsheet model to calculate the monthly Revenue, Total Cost and Profit.

2) Can the factory reach the profit of 4000 If the price increased by %15?

3) Find how many units should be sold to get a profit of 4000, If the factory the price increased by %15?

4) Can the factory reach the profit of 3000 If the ratio between units produced and units sold should be between 75% and 100% (unit sold should be at least 75% of units produced and at most 100% of units produced)?

5) Find how many units should be sold to get a profit of 3000, when the ratio between units produced and units sold should be between 75% and 100% (unit sold should be at least 75% of units produced and at most 100% of units produced)