Stat Eazzy
Stat Eazzy
  • 25
  • 855
Linear Programming Using Excel. Example 2
Glueco produces three types of glue on three different production lines. The company has currently 15 workers in total. Workers are paid $500 per week on production line 1, $600 per week on production line 2, and $700 on production line 3. A week of production costs $1,000 to set up production line 1, $2,000 to set up production line 2, and $3,000 to set up production line 3. During a week on a production line, each worker produces the number of units of glue shown in the table below. Each week, at least 220 units of glue 1, at least 350 units of glue 2. For production to be economically feasible, at least 400 units of glue 3 must be produced. Formulate an IP to minimize the total cost of meeting weekly demands. Finally, the company can either choose to run production line 2 or 3, not both during a week.
Formulate and find the optimal solution for this problem.
Переглядів: 16

Відео

Creating Pivot tables in excel
Переглядів 482 місяці тому
Statistical Analysis using pivot tables in excel. Pivot tables help in making summaries about a data.
Splitting data or columns (text to column) in excel
Переглядів 252 місяці тому
The tutorial shows steps involved in splitting a column or cell in excel. Also known as text to column.
Merging or Concatenating cells in Excel
Переглядів 152 місяці тому
The tutorial shows the steps involved in merging two cells or columns in excel through the use of concatenate function
Solving Linear Programming Example in Excel
Переглядів 152 місяці тому
The video solves a Linear Programming Problem Elizabeth Bailey is the owner and general manager of Princess Brides, which provides a wedding planning service in Southwest Louisiana. She uses radio advertising to market her business. Two types of ads are available-those during prime-time hours and those at other times. Each prime-time ad costs $390 and reaches 8,200 people, while the off-peak ad...
Drawing a chart with primary and secondary axis in excel (Combo chart in excel
Переглядів 472 місяці тому
Tutorial shows procedure of drawing a chart with 2 y axis in excel. For example a column and line chart .
Column and bar chart in Excel
Переглядів 442 місяці тому
Column and bar chart in Excel
Drawing Boxplot in Excel
Переглядів 62 місяці тому
Drawing Boxplot in Excel
Pie Chart in Excel
Переглядів 1802 місяці тому
Plotting Graphs in Excel
IF, AND & OR Functions in Excel
Переглядів 912 місяці тому
Logical functions in excel
Count If in Excel
Переглядів 92 місяці тому
Logical function in excel
AND & OR Functions in Excel
Переглядів 72 місяці тому
Logical functions in excel
If Statement and Nested If in Excel
Переглядів 52 місяці тому
The video shows the use of logical function if () in evaluating statements.
Independent, ungrouped T test in Excel
Переглядів 353 місяці тому
Independent T-test in excel and hypothesis testing
Dependent, related, paired T test in Excel
Переглядів 273 місяці тому
Dependent T-test in Excel and hypothesis testing
Scatter Plot and Correlation analysis in Excel
Переглядів 503 місяці тому
Scatter Plot and Correlation analysis in Excel
Descriptive Statistics in Excel using Functions and data analysis toolpack
Переглядів 433 місяці тому
Descriptive Statistics in Excel using Functions and data analysis toolpack
Two Way Anova with replication and Interaction Plot
Переглядів 183 місяці тому
Two Way Anova with replication and Interaction Plot
Two way Anova without Replication in Excel
Переглядів 1023 місяці тому
Two way Anova without Replication in Excel
One Way ANOVA in Excel
Переглядів 103 місяці тому
One Way ANOVA in Excel
Multiple Linear Regression
Переглядів 153 місяці тому
Multiple Linear Regression
Simple Linear Regression in Excel
Переглядів 153 місяці тому
Simple Linear Regression in Excel
Installing Excel Solver in Ms Excel
Переглядів 45 місяців тому
Installing Excel Solver in Ms Excel
Installing Data Analysis Tool pack in Excel
Переглядів 257 місяців тому
Installing Data Analysis Tool pack in Excel
Text Aligning in Excel; Merging and Angle tilting
Переглядів 47 місяців тому
Text Aligning in Excel; Merging and Angle tilting