Question: please help me to answer QUESTION 3 (Total 11 marks) Consider the following sensitivity report generated by Excel Solver for Beaver Creek Pottery Company. Variable

please help me to answer QUESTION 3 (Total 11 please help me to answer

QUESTION 3 (Total 11 marks) Consider the following sensitivity report generated by Excel Solver for Beaver Creek Pottery Company. Variable Cells Final Name Value $B$10 Bowls produced 24 $B$11 Mugs produced 18 Cell Reduced Cost 0 0 Objective Allowable Allowable Coefficient Increase Decrease 40 26.67 15 503020 Constraints Cell $E$7 $E$8 Name Labour (hr/unit) Clay (kg/unit) Final Value 40 120 Shadow Price 16 Constraint Allowable Allowable RHS Increase Decrease 40 40 10 120 40 60 i. What is the optimal production plan for the pottery company? What is their expected total revenue by adopting the production plan? ii. What is the range of optimality for units of mugs to be produced by the pottery company? What is the range of feasibility for clay for the pottery company? iv. Is there excess unit of clay for the proposed production plan? Why? v. What is the maximum rate payable for every additional hour of labour

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

only have 45 mins left!! please help Easter is just around the corner! Hot cross buns are traditionally eaten over the Easter religious Christian holiday to symbolise the crucifixion of Jesus on Good...

can you please assist in decision analysis area. I have attached the questions, answers and the spreadsheets needed, but not sure how to get the answers in the solver spreadsheet. thanks for your...

Microsoft Excel 14.0 Answer Report Whether the maximum possible number of model planes should be ordered from the supplier. Which of the Solver reports helps you answer these questions? Objective...

GOODWEEK TIRES, INC. After extensive research and development, Goodweek Tires, Inc., has recently developed a new tire, the SuperTread, and must decide whether to make the investment necessary to...

answer all parts111 Your second essay assignment requires you to critically examine the American Psychological Association code of ethics. But does the code of ethics from your own profession...

Part II Consider a diet company that is looking to create a treatment that requires the client to consume at least 3 12-ounce servings per day. The treatment consists of four ingredients - R, S, T...

Department of Operations Management \& Business Statistics POMG6724: Analytics for Business Decisions Group Project Assessment (40\%) Instructions Project deliverables For this project, each group...

Please answer the questions below the three Excel SOLVER reports shown. Answer Report: Limits Report: Sensitivity Report: 1) Based on the results of your SOLVER run, what is the Return on Sales...

HI, Need assistance with this data case. It does not has to be every single question, any help is much appreciated. Data case 2 Econ 670 Show all your work to receive full credit. Completed...

I need help with this data set, thank you! Data case 2 Econ 670 Show all your work to receive full credit. Completed assignments will include an Excel file. Please use one sheet for each question....

(5 pts) Find the value(s) of k that makes the function continuous over the given interval. lim x (3 pts each) Evaluate the limits or show that it does not exist. lim t- 2 x + 3x 4x - 1 f(x) = 2 4t-1...

Consider the following view, DEPT_SUMMARY, defined on the COMPANY database IN Figure 3.6: State which of the following queries and updates would be allowed on the view. If a query or update would be...

Each diagram shows an object and its image after an enlargement. For each part, write down the scale factor of the enlargement. 12 a y 8 7 65 6 5 image +3 4 3 object 2- 210 0+ 0 1 2 3 4 5 6 7 8 9 10...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...