OMGT2087 2550 A3C34 Study 3
Business, Accounting & Economics
29th Oct 2025
1
For this case,
An Excel file to demonstrate how you use Solver to identify the solutions. You must ensure that the file is in a workable condition. Each model must be implemented in a separate sheet in the same file.
Problem Statement
A small business owner is planning to buy a new inkjet printer for their home office. They found that some new printers have a refillable ink function that is cheaper and more environmentally friendly because they can refill specific colours without throwing the whole cartridge away. They decide to use three main criteria for printer comparison: price, ink cost, and printing quality. They managed to narrow down to the three printers summarised below (legend: E =Epson Eco Tank Photo ET-8500, C = Canon Maxify GX3060 Mega Tank, and H = HP Smart Tank 7605)
Price
|
|
E |
C |
H |
|
E |
1 |
½ |
1/3 |
|
C |
2 |
1 |
1/1.3 |
|
H |
3 |
1.3 |
1 |
Ink Cost
|
|
E |
C |
H |
|
E |
1 |
1/4 |
1/3 |
|
C |
4 |
1 |
2 |
|
H |
3 |
1/2 |
1 |
Printing Quality
|
|
E |
C |
H |
|
E |
1 |
3 |
4 |
|
C |
1/3 |
1 |
2 |
|
H |
1/4 |
1/2 |
1 |
The owner wants to incorporate the three criteria into the final decision. However, the criteria are not equally important. The following matrix summarises the comparisons of the importance of the criteria:
|
|
E |
C |
H |
|
Price |
1 |
3 |
1/3 |
|
Ink Cost |
1/3 |
1 |
½ |
|
Printing Quality |
3 |
2 |
1 |
Based on these matrices, the owner wants you to recommend the best alternative.