Case 2: Maxi’s Grocery Mart
Research-Discuss-Plan-Create
Book Case 3
- Description
Due to your great work with Milligan’s you have been selected by your boss to be the main consultant for a project with Maxi’s Grocery Mart.
Mr. Feronti, the new owner, needs to update the building and needs your help to determin if the business can support the $300,000 loan that would be needed to accomplish this.Your boss gives you additional verbal instructions.“If it turns out that the business can support the load, your spreadsheets will be used in negotiations with the bank. Make sure they are Correct and look great.”
- Deliverables
- Discussion with your cohort about the Excel resources
- Discussion with your cohort about the case issues, concepts, and possible solutions
- Discussion with the class about your cohort’s possible solutions to the case and any unresolved issues
- Personal questions you have about the case and Excel
- A professionally designed and accurate Spreadsheet created by your cohort that indicates if the business can support the loan
- A completed assesment case
- Resources
-
- Case
- Further background on the case: Text pages 13 – 15.
- The design for the solution: Text page 15.
- The information Mr. Feronti needs: Text page 16: Information Specifications
-
- Vocabulary
- Income Statement: a set of data that shows gross sales, the expenses involved in producing sales, operating expenses, and the net income.
- Gross: An amount of a specific type, such a profit, prior to removing anything from it.
- Net: An amount of a specific type, such a profit, that represents what is left over from a gross value after everything that needs to be removed from it , such as expenses, have been.
- Pro forma: something that is a best guess based on related information.
