|
The Sombrero Fruit Juice Outlet is a case about a proposed venture in the Abu
Dhabi Emirate. Note that currency amounts are in dirham [DH]. Your assignment
questions are as follows:
- How many customers does Moawia need to break even?
- How many customers doe he need to earn a profit of DH30,000?
- How many customers does he need to break even on a cash basis in order
to avoid bankruptcy?
- Find the current exchange rate between the dirham and the US dollar.
What is Moawia's breakeven revenue in $US?
Please adhere to the following in submitting your work:
- Excel is required. hand written work will not be accepted.
- Read the Rules for Good Spreadsheet Practice and follow them as you do
you work. You read them already? Read them AGAIN. I suspect more students
lose as much credit to poor spreadsheet work as to any other single cause.
- Lay out your work so that I can follow it. I will not hunt for answers.
- Email your file no later than 0745 on 9/22. Subject line is
sombrero; filename is yourlastnamesombrero.xls. Other
subject line and/or filenames will be sent to cyberheaven. Individual work
is required.
- Turn in a hardcopy at the start of class. Proper printing is required.
Your work should be formatted so that when printed it looks professional.
Rows or columns that fall off the edge of the page are a no-no, as is the
overflow symbol [#######] in a cell.
|