The Beaver Creek Pottery company employs skilled artisans to produce day bowis and mugs. The two...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
The goal programming model is following Solver parameters are enter... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
The Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large...
-
In Figure particles 1 and 2 are fixed in place on an x axis, at a separation of L = 8.00cm. Their charges are q1 = + e and q2 = ?? 27e.Particle 3 with charge q3 = + 4e is to be placed on the line...
-
Below are several transactions that took place in Mohawk Company last year: a. Bonds were retired by paying the principal amount due. b. Equipment was purchased by giving a long-term note to the...
-
The bank portion of the bank reconciliation for Katsaris Company at August 31, 2014, was as follows: The adjusted cash balance per bank agreed with the cash balance per books at August 31. The...
-
Golds Gym selected a random sample of 10 customers and monitored the number of times each customer used the workout facility in a one-month period. The following data were collected: 10 19 17 19 12...
-
The variable X has a normal distribution with mean and standard deviation . Given that P(X < 32.83) = 0.834 and that P(X 27.45) = 0.409, find the value of and of .
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Calculate the current ratio, the acid-test miam ratio, the debt-to-equity...
-
The Sentry Lock Corporation manufactures a popular commercial security lock at plants in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.50, $37.50,...
-
Question 21 (Mandatory) (2.86 points) A call option's payoff will be equal to its profit when the market price of the underlying asset is equal to the strike price True O False
-
A company wants to locate a distribution center that will serve six of its major customers in a 30 30 mi area. The locations of the customers relative to the southwest corner of the area are given...
-
Describe the features of play-based pedagogy. Explain why it is important and the role it plays in an early childhood teacher's pedagogical approach. (Approximately 250 words)
-
When teachers say they are color blind, they are usually saying that they do not discriminate and that they treat all their students equally. Of course, being fair and treating each student with...
-
Define difference and articulate why it matters to the author (Allen, 2010) and to you. Be thoughtful in your response. Offer examples that support why difference is important to you. Ground your...
-
Identify and explain three principles of risk communication. Identify one person who has been communicating to the public about COVID-19 (this can be Dr. Fauci, the CDC, President Biden, your local...
-
Define a research question that can be answered (in full or in part) with qualitative data. Describe the sample of participants you might obtain to help you answer this research question. Draft an...
-
Description: In this assignment, you will assume the role of staff auditor. Your client is the Parks and Recreation Department in Boston, Massachusetts. Your task is to perform substantive and...
-
PB 11. LO 10.3 Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for B76 Company, considering the following transactions under three different cost allocation methods and...
-
If a process has a six-sigma capability, what is the process capability index? a. 1 b. 2 c. 6 d. 12
-
Given the following network, with activity times in weeks, determine the earliest and latest activity times and the slack for each activity. Indicate the critical path and the projectduration: 3 15...
-
Develop a linear trend line model for the freshman applications data at State University in Problem 33. a. Does this forecast appear to be more or less accurate than the linear regression forecast...
-
When Tracy McCoy wakes up on Saturday morning, she remembers that she promised the PTA she would make some cakes and/or homemade bread for its bake sale that afternoon. However, she does not have...
-
\(45-6 \times 7^{3}\) Perform the indicated calculation.
-
\(72 \div 6+18\) Perform the indicated calculation.
-
\(6^{2} \times 5-13 \times 9^{2}\) Perform the indicated calculation.
Study smarter with the SolutionInn App