(a)ADIDAS has made significant sales on their new football boot design, Adidas Timepo. Increase of Adidas Timepo sales is assumed to be affected by the commercial aired on television. Below are the recorded data of the sales and commercial expenditure.

Monthly Adidas Timepo Sales ('000s)

Television Commercial

45

90

38

67

26

23

(i)Using the information given above, fill in the details in X and Y column, in the spreadsheet below. (3 marks)

(ii)Refer to the spreadsheet above, what is the Excel formula for the Excel cell

i.C7 (1 mark)

ii.D8 (1 mark)

iii.G7 (1 mark)

iv.H7(1 mark)

v.D10(1 mark)

vi.D11(1 mark)

(b)Nusantara Bus Sdn Bhd is the leading manufacturer of bus in Malaysia. The company manufacturer busses specifically divided into two market segments: Mini Bus and Express Bus. Both of the bus design requires installation of specific number of chairs and engine capacity.

Express Bus has bigger engine capacity where the engine needs to be 4500 HP and the seating would be able to cater for 38 passengers on a trip. The Mini Bus design has a smaller engine capacity of 2800 HP and catering 28 sitting passengers at a time. While there is only limited engine manufacturing capacity of 150,000 HP of and a total of 150 seats available in the factory. Each two bus type will contribute RM 45,000 to the profit, equally.

Formulate the problem as a linear programming model