This week you will look at the case study "Using Excel to Make Strategic Managerial Decisions."

Jacobs, A., Robinson, D. F., DePaolo, C. A. (2016). Using Excel to make strategic managerial decisions.Journal of Information Systems Education,27(2), 93-98.

https://csuglobal.idm.oclc.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=bth&AN=120639924&site=eds-live(Links to an external site.)

As the manager of the Caf', you should base your decision on data analysis. You will need to use an Excel data sheet workbook and provide a written report addressing each of the managerial questions below.

1. Evaluate the situation, do you recommend that an additional register (handling both cash and credit/debit cards) be purchased? What about a card-only tablet for processing card transactions? Explain your reasons for these decisions.
2. Evaluate if the caf should charge a fee of $0.25 per transaction for credit card purchases under $1.25, considering the gain from fees, assuming a profit margin of 40% of total sales and an estimated 30% in lost sales (for items $1.25 or less). Is there any potential gain worth the possibility of loss of customers?
3. Assess the breakeven point. Considering only the $855 startup costs, the first week of sales (obtainable from the data), and assuming a 30% profit margin on sales, did the caf "break even" when it decided to hire previous employees in order to open one week earlier (five business days) in the semester? Show your calculations and assumptions.
4. Conclusion based on findings.

Be sure to:

• Show calculations for all questions (no hard coding of answers).
• Support writing portion of the assignment (if applicable), with credible sources.
• Use terms, evidence, and concepts from class readings, including professional business language.
• Review the week's CT Assignment grading rubric for more information on expectations and how you will be graded.