Question
Gross profit Calculation - $/Year The gross profit (revenue) is the amount of money the store made before operating expenses. The gross profit figures are
Gross profit Calculation - $/Year The gross profit (revenue) is the amount of money the store made before operating expenses. The gross profit figures are derived from the average profit per customer, the number of customers per hour, and number of hours a store is open. You can calculate the number of hours a store is open using the open and close times for each store. Store hours are given in military time (24 hour clock). These numbers can be found on the Store Info worksheet. Write a formula to calculate the weekday gross profit for one year for store 11001. o Copy the formula down the column to calculate the weekly gross profit of each respective store. Write a formula to calculate the weekend gross profit for one year for store 11001. o Copy the formula down the column to calculate the weekend gross profit of each respective store. Create a column that sums gross profit (by weekday and weekend) for store 11001 and copy the formula down to calculate the costs of each respective store. After the row that contains the calculation for the final store (11005) sum the gross profit for all the stores. Net profit - $/Year Write a formula to calculate the net profit per year of a store. This is the amount of money the store made after expenses are deducted (gross profit less expenses). Copy the formula down the column to calculate net profit of each respective store. After the row that contains the calculation for the final store (11005), include a row to sum the net profit for all the stores. Your completed file should look similar to the file below.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started