need help with this homework question and need all requirements on the rubric to be met please. The class is spreadsheet modeling for business.

Problem 1 The Beaver Creek Pottery company employs skilled artisans to produce day bowls 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 avold layoffs, the company does not want to use fewer than 40 of labor hours per day. 2. The company would like to earn at least $1,600 profit per day. 3. Because the day must be stored in a 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. Labor Profit Clay Bowl 1 $40 4 Mug 2 $50 3 Productor Over Balance Goal Goals Achieved Under Labor Profit Clay Already achieved Deviations Labor Profit Clay Overtime Module/Week 6 Homework Rubric BUSA 3315: Spreadsheet Modeling with Business Applications Problem Maximum points 2 Pottery Company Items for grading Formula for Balance Formulas for Four Deviations Values in Already Achieved Balance Constraint Solver 10 2 2 4