MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition

6

Excel—Advanced Design Techniques

16

Up the Hill Bakery

Building Remodel Proposal

EXCEL TEACHING CASE: ADVANCED LEVEL

Submission Instructions Complete Case 16 in Excel. Answer the questions at the end of this case and insert the answers on an Answer Sheet in Case 16 Excel spreadsheet. Ask your instructor for submission instructions.

Preview The owners of Up the Hill Bakery would like to remodel their bakery and create a larger eating area and a larger kitchen. The bakery is currently a 900 square feet, and they would like to add another 400 to 1,100 square feet depending on the cost of materials for the remodel. They have several loan amounts and several different bids for the remodel.

Skill Set

PMT function Data validation Solver Data table Formula audit Scenario manager

Background Jack and Susan want you, as the manager of the bakery, to help with their remodeling budget by creating a spreadsheet application they can use to evaluate different combinations of cost and loan amount scenarios for their remodeling project.

Up the Hill Bakery has done very well in the past year, especially the restaurant part of the business. Jack and Susan have decided to build an addition to their bakery and make the dining room larger as well as the kitchen. They would like to change the flooring; ...