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

figurines. 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?