Biz Café Excel Operations Assignment #5 What price should you charge for your coffee? When do you know when is make sense to change the price of your coffee?
These and other questions should be part of your weekly team discussion. This is a simple assignment to prepare you for the Biz Café Excel Capstone
assignment. You will need to be able to determine your gross profit to form the basis for answering several questions relating to forecasting and change in
demand in the Capstone. Our simulation provides you with detailed reporting but for this assignment we are keeping it simple. I have provided the definitions
to use for this assignment. • Revenue – the income you earn from selling your coffee. • Cost of Goods Sold – the cost, to you, for the coffee and cup you sell
to customers. • Gross Profit – the income you have after subtracting the cost of your coffee and cups from your revenue. Note, this is not Net Profit. Net
Profit is your profit after paying all your bills and employees. You will use the information from your café for this assignment. Under “Data for Assignment”
you pick a decision period and use the information about your café for that period. Under A4 add the decision period you are using for this assignment.
Sample Solution
