New England Glass, Mfg., is a large, Massachusetts-based company specializing in manufacturing products made of glass, including windows, glass doors, and mirrors. New England Glass is building a new facility in a Boston suburb. Until now, the company has rented office furniture for a monthly amount. However, now corporate management has decided to buy office furniture instead of continuing to rent it and has given the task of purchasing the furniture to the centralized Purchasing Department. Keeping track of what discounts may be taken on purchases by various quantity breaks is a common business function known as Purchasing. Therefore, Lyndon, the Purchasing Manager, has been "shopping around" for the best value. Lyndon chose Unique Office Designs to supply desks, chairs, credenzas, and bookshelves for the new building. The main reason was that Unique Office Designs offered New England Glass an attractive discount on the purchase if the company bought a minimum amount of sales. If the total purchase price is greater than $7,000, they could take a 10% discount. Lyndon needs to analyze the deal to determine whether discounts may be taken on the purchases. To solve this business problem, this case study will focus on using functions in worksheet formulas. 

1. Design a solution to the business problem.

 2. Build a spreadsheet based on the designed solution. Open a new workbook called NEW ENG and create a spreadsheet with the following information in this workbook. Provide an item total as well as a grand total.

Answer rating: 100% (QA)

The solution to the business problem is to determine if New England Glass ... View the full answer