Excel Expert

Purpose: An upholsterer who refurbishes antiquities ordinarily charges £100 to refurbish a small sofa and £300 for a large sofa but offers some discounts on the total cost as detailed below. For small sofas, the discounts are: 1 small sofa 0%. 2 small sofas 7.5%. 3 small sofas 10%. More than three small sofas 12%. For large sofas, the discounts are: 1 large sofa 15%. More than 1 large sofa 18%. Write a program, which upon receiving information from the customer about the number of items they want refurbished, informs them how much it will cost. The routine must: • allow the customer to enter the number of each type of sofa they would like refurbished. • ensure input data are valid, e.g. ensure that numbers are non-negative. • display appropriate error messages (e.g. through MsgBox). • calculate and then display the cost (e.g. through MsgBox). Once you have successfully completed the basic routine as specified above, work on extending its flexibility and range of usage. Extensions could include, but not limited to, the following considerations: • How can data entry be made simple and straightforward for the user? Is the routine flexible enough to accept data of different formats? • Can the routine be extended for other purposes such as, for example, as an integral component of a larger application such as one that might be used by a larger workshop with larger numbers of customers? • And so on. • we need An Excel file in xlsm format containing your routine. A single pdf document containing the text of your VBA routine.