Question
University Ceramics manufactures plates, mugs, and steins that include the campus name and logo for sale in campus bookstores. The time required for each item
University Ceramics manufactures plates, mugs, and steins that include the campus name and logo for sale in campus bookstores. The time required for each item to go through the two stages of production (molding and finishing), the material required (clay), and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Plates Mugs Steins Available Molding (minutes) 4 6 3 2400 Finishing (minutes) 8 14 12 7200 Clay (ounces) 5 4 3 3000 Unit Profit $3.10 $4.75 $4.00 A linear programming model has been formulated in a spreadsheet to determine the production levels that would maximize profit. The solved spreadsheet model and corresponding sensitivity report are given. Answer the following questions based off of the sensitivity report. Each question is independent (i.e., any change made in one part does not apply to any other parts). a. Suppose the profit per plate decreases from $3.10 to $2.80. Will this change the optimal production quantities? What can be said about the change in total profit? b. Suppose a worker in the molding department is sick. Now eight fewer hours are available that day in the molding department. How much would this affect total profit? Would this change the optimal production quantities? GRBU 503 he allowable decrease in the mugs objective coefficient and the shadow price for the available clay constraint are both missing from the sensitivity report. What numbers should be there? Explain how you were able to deduce each number.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started