Model.xlsx - Nowlin Plastics Fixed Cost 3000 Variable Cost...

This preview shows page 1 - 5 out of 9 pages.

Nowlin Plastics Fixed Cost 3000 Variable Cost Per Unit 2 Selling Price Per Unit 5 Models Production Volume 1000 Total Cost $ 5,000 Total Revenue $ 5,000 Total Profit(Loss) $ - Goal Seeker to find break even point
normal distribution x 40000 mean 36500 Standard deviation 5000 0.758036347776927 30092.24 Inverse: looking for X binomial n 10 p 0.3 x 4 in 10 trials 0.200120949
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Ch7 Report Created: 2/24/2020 1:59:27 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$15 Tons Produced Fuel Additive 25 0 40 20 16 $C$15 Tons Produced Solvent Base 20 0 30 20 10 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$20 Material 1 Amount Used 20 33.333333333 20 1.5 6 $B$21 Material 2 Amount Used 4 0 5 1E+030 1 $B$22 Material 3 Amount Used 21 44.444444444 21 9 2.25
RMC Material Requirements Material Fuel Additive Solvent Base Amount Available Material 1 0.4 0.5 20 Material 2 0 0.2 5 Material 3 0.6 0.3 21 Profit Per Ton 40 30 Model Decision Variables Fuel Additive Solvent Base

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture