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

11

Celebrations for Charity

Break-Even Analysis

EXCEL WORKING CASE: BEGINNING LEVEL

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

Preview You work in Finance, which takes care of the event budgets for the year. Each event is outsourced to two main companies—a catering company and a security company—and you want to find out if the yearly scheduled events are turning a profit. As part of the finance team your objective is to create a break-even analysis spreadsheet, which will allow you to see the difference between total revenue and total expenses paid for each event. You will be analyzing the spreadsheet to find out your profit margins to increase revenue.

Skill Set

Format spreadsheet

Absolute reference

Sum, maximum, minimum functions

Date function

Goal seek (question at end of case)

If function

Vlookup table

AutoFilter

Center merge

Chart (question at end of case)

Background Celebrations for Charity is a nonprofit organization in southern California that donates their profits to various causes around the geographic region. Each summer they produce five annual events: Prom Dress Dinner, Battle of the Chefs, Fun in the Sun Fashion Show, Bike Wine Country, and Canine Best-In-Show. They ...