Maximization Model - the beaver creek pottery PDF

Preview

Summary

the beaver creek pottery...

Description

St. Louis College Valenzuela 5 Maysan Rd., Valenzuela City COLLEGE DEPARTMENT

Maximization Model Beaver Creek Pottery Company

Submitted by: YAMBAO, ELAINE M. VALENCIA, JOANNE G. Submitted to: MR. CARLO ABULENCIA

St. Louis College Valenzuela 5 Maysan Rd., Valenzuela City COLLEGE DEPARTMENT

Case: Beaver Creek Pottery Company ● ● ●

Beaver Creek Pottery Company is a small crafts operation run by a Native American tribal council. The company employs skilled artisans to produce clay bowls and mugs with authentic Native American designs and colors. The two primary resources used by the company are special pottery clay and skilled labor.

Type of Problem: To maximize the profit gained from each bowl and mug using a linear programming model

Excel Model:

Sensitivity Analysis and Report: A bowl has 24 units produced with a revenue of 960. A mug has 8 units produced with a revenue of 400.

Constraints: A bowl requires 1 hr of labor. A mug requires 2 hrs of labor. ● Labor hours: 1x1 + 2x2...