Activity 1, Module 2 - Calculations

Activity 1, Module 2. (30 minutes)

Calculations 

Instructions 

You are given the order details of a bakery in the table below. Complete the activity by following the instructions. 

1. Open Excel and create the table given in an Excel worksheet

2. Calculate the revenue and tax on the revenue for each of the five products.
3. Calculate the net income of each product.
4. Calculate the total revenue from all products.
5. Calculate the total net income of all products.