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

5

Excel—Intermediate Design Techniques

13

Up the Hill Bakery

Financial Projections

EXCEL TEACHING CASE: INTERMEDIATE LEVEL

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

Preview The bakery has hired you as a management consultant. You are going to analyze their financial performance for a possible expansion of their business. You need to create an annual financial projection spreadsheet to better understand the finances of the bakery. You want to research their revenue streams as well as their net profit. You will create a quarterly financial breakdown to review the possibilities of their catering division.

Skill Set

If function Statistical functions 3-Dimensional workbook Chart Format worksheets

Background The owners of the bakery have hired you as a management consultant to analyze their financial performance for a possible expansion of their business. They have kept track of the total monthly sales for five sales categories: bakery items, beverages, breads, breakfast, and lunch. They have also calculated the bakery's average percentage that goes toward the cost of each sales category; this percentage ...