How to solve this question? show the excel if needed
Wen, Yi and Ming are the sole partners and workers in a company that produces fine ceramic
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Nowfigurines. Wen and Yi are each available to work a maximum of 40 hours per week at the
company, while Ming is available to work a maximum of 20 hours per week.
The company makes two different types of ceramics: large floor sculptures and small table
items. To make an item, Wen assembles the necessary materials and produces the first
mould while Yi finalises the process including the curing of each item. Ming is responsible for
taking orders and shipping the finished products. The amount of time required for each of
these tasks is shown below.
(e) Provide the optimal solution to Wen, Yi and Ming.
Which of the EXCEL reports helps you answer this question?
(f) Are there any restrictions on Wen, Yi and Ming producing more ceramics? If
so, explain what they are and which report provides that information.
(g) If Wen, Yi and Ming were able to spend more time, let us say 10 hours, in
Material and initial cast processes, could they make a larger profit? If so, how much
more profit could they make? Which report provides this information?
(h) There is an unusual value ‘1E+30’ in one of the reports. What does this value
represent and what does it mean in the context it is shown?
(i) Wen, Yi and Ming enjoy making Figurines more than making Sculptures. If
they were to increase the price of their Figurines, what is the maximum amount they
could increase their price by and not change the optimal solution?
