The Beaver Creek Pottery company employs skilled artisans to produce day bowis and mugs. The two...

  

 

Transcribed Image Text:

The Beaver Creek Pottery company employs skilled artisans to produce day bowis and mugs. The two primary recourses are special pottery clay and skilled labor. The resource requirements for the production of the two products and profit per item are listed in the template below. The pottery company has several objectives that are listed in order of importance. 1. To avoid layoffs, the company does not want to use fewer than 40 of labor hours per day. 2. The companywould like to earn at least $1,600 profit per day. 3. Because the day must be stored ina special place so that it does not dry out, the company prefers not to keep more than 120 pound on hand each day. 4. The company wants to minimizeovertime hours used. Use the Goal Programming method to find the best production plan for the company. Bowl Mug Labor 2 Profit $40 Sso Clay 4 3 Productor Goals Achieved Under Over Balance Goal Labor Profit Clay Already Deviations achieved Labor Profit Clay Overtime Module/Week 6 Homework Rubric BUSA 3315: Spreadsheet Modeling with Business Applications Maximum Problem Items for grading points Formula for Balance 10 Pottery Company Formulas for Four Deviations Values in Already Achieved Balance Constraint Solver 4 The Beaver Creek Pottery company employs skilled artisans to produce day bowis and mugs. The two primary recourses are special pottery clay and skilled labor. The resource requirements for the production of the two products and profit per item are listed in the template below. The pottery company has several objectives that are listed in order of importance. 1. To avoid layoffs, the company does not want to use fewer than 40 of labor hours per day. 2. The companywould like to earn at least $1,600 profit per day. 3. Because the day must be stored ina special place so that it does not dry out, the company prefers not to keep more than 120 pound on hand each day. 4. The company wants to minimizeovertime hours used. Use the Goal Programming method to find the best production plan for the company. Bowl Mug Labor 2 Profit $40 Sso Clay 4 3 Productor Goals Achieved Under Over Balance Goal Labor Profit Clay Already Deviations achieved Labor Profit Clay Overtime Module/Week 6 Homework Rubric BUSA 3315: Spreadsheet Modeling with Business Applications Maximum Problem Items for grading points Formula for Balance 10 Pottery Company Formulas for Four Deviations Values in Already Achieved Balance Constraint Solver 4

Answer rating: 100% (QA)

The goal programming model is following Solver parameters are enter... View the full answer