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.
An Excel file in xlsm format containing your routine.
A single pdf document containing the text of your VBA routine.
14 фрилансеров(-а) готовы выполнить эту работу в среднем за €25
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.
Greetings . I hope you had a very nice day. I am willing to work tirelessly to satisfy you in a twenty four hour period. I am avid at excel and hope that I am your choice for the job. Thank you in advance.