Janitorial Services Calculation - $/ Year Your costs for annual janitorial services (cost of cleaning the store) will vary by how often each area is cleaned and the cost per square foot to clean. Each store is made up of several different areas: office, merchandise, and warehouse. These different areas of the store get cleaned at different intervals (weekly, monthly, and quarterly). The cost of cleaning also varies by area type. Based on the data in the worksheets Janitorial Costs, Store Info, and Misc Dato worksheets - Write a formula to calculate the annual Janitorial costs of the office area (for one year) of store 11001 - Copy the formula down the column to calculate the costs for each respective store - Write a formula to calculate the annual Janitorial costs of the merchandise area (for one year) of store 11001 . - Copy the formula down the column to calculate the costs for each respective store - Write a formula to calculate the annual Janitorial costs of the warehouse area (for one year) of store 11001 - Copy the formula down the column to calculate the costs for each respective store - Create a column that sums all the annual janitorial costs 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 janitorial costs (by office area) for all the stores. Salaries and Wages Calculation(s) - $/ Year The stores hire part-time hourly employees, full-time hourly employees and salaried employees. The Wages worksheet lists their pay rate (wages in dollars per hour for hourly employees and per year for the salaried employees). Part-time hourly employees work 20 hours per week, 52 weeks per year, and full-time hourly employees work 40 hours per week, 52 weeks per year. These values can be found on the Misc Data worksheet. You will need to address the number of each type of employee (part time, full time, salaried) for a given store, the hours worked per week, and their pay rate. - Write a formula to calculate the yearly cost of wages for part-time workers of store 11001. Copy the formula down the column to calculate the yearly cost of wages for part-time employees for each respective store. - Write a formula to calculate the yearly cost of full-time non-salaried workers of store 11001. Copy the formula down the column to calculate the yearly cost of full-time wage non-salaried workers for each respective store. - Write a formula to calculate the yearly cost of salaried workers of store 11001. Copy the formula down the column to calculate the yearly cost of wages for salaried workers for each respective store. - Create a column that sums all the annual costs of wages for store 11001 (for Part Time, Full Time, and Salaried workers combined) 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 salaries and wages (by categorypart-time, full-time, and salaried) for all the stores. \begin{tabular}{|l|l|r|} \hline 1 & \multicolumn{1}{|c|}{ Miscellaneous Data } \\ 2 & Number of Stores & 5 \\ \hline 3 & Part Time (Hrs per week for each Employee) & 20 \\ \hline 4 & Full-time (Hrs per week for each Employee) & 40 \\ 5 & Weeks per Quarter & 13 \\ \hline 6 & Week per Year & 52 \\ \hline 7 & Weekdays per Week & 5 \\ 8 & Weekend Days per Week & 2 \\ \hline 9 & Quarters per Year & 4 \\ 10 & Number of Months per Year & 12 \\ \hline 11 & Yearly Property Taxes (per SF) & 0.2 \\ \hline 12 & \end{tabular} SportsMans Store Information Janitorial Services Calculation - $/ Year Your costs for annual janitorial services (cost of cleaning the store) will vary by how often each area is cleaned and the cost per square foot to clean. Each store is made up of several different areas: office, merchandise, and warehouse. These different areas of the store get cleaned at different intervals (weekly, monthly, and quarterly). The cost of cleaning also varies by area type. Based on the data in the worksheets Janitorial Costs, Store Info, and Misc Dato worksheets - Write a formula to calculate the annual Janitorial costs of the office area (for one year) of store 11001 - Copy the formula down the column to calculate the costs for each respective store - Write a formula to calculate the annual Janitorial costs of the merchandise area (for one year) of store 11001 . - Copy the formula down the column to calculate the costs for each respective store - Write a formula to calculate the annual Janitorial costs of the warehouse area (for one year) of store 11001 - Copy the formula down the column to calculate the costs for each respective store - Create a column that sums all the annual janitorial costs 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 janitorial costs (by office area) for all the stores. Salaries and Wages Calculation(s) - $/ Year The stores hire part-time hourly employees, full-time hourly employees and salaried employees. The Wages worksheet lists their pay rate (wages in dollars per hour for hourly employees and per year for the salaried employees). Part-time hourly employees work 20 hours per week, 52 weeks per year, and full-time hourly employees work 40 hours per week, 52 weeks per year. These values can be found on the Misc Data worksheet. You will need to address the number of each type of employee (part time, full time, salaried) for a given store, the hours worked per week, and their pay rate. - Write a formula to calculate the yearly cost of wages for part-time workers of store 11001. Copy the formula down the column to calculate the yearly cost of wages for part-time employees for each respective store. - Write a formula to calculate the yearly cost of full-time non-salaried workers of store 11001. Copy the formula down the column to calculate the yearly cost of full-time wage non-salaried workers for each respective store. - Write a formula to calculate the yearly cost of salaried workers of store 11001. Copy the formula down the column to calculate the yearly cost of wages for salaried workers for each respective store. - Create a column that sums all the annual costs of wages for store 11001 (for Part Time, Full Time, and Salaried workers combined) 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 salaries and wages (by categorypart-time, full-time, and salaried) for all the stores. \begin{tabular}{|l|l|r|} \hline 1 & \multicolumn{1}{|c|}{ Miscellaneous Data } \\ 2 & Number of Stores & 5 \\ \hline 3 & Part Time (Hrs per week for each Employee) & 20 \\ \hline 4 & Full-time (Hrs per week for each Employee) & 40 \\ 5 & Weeks per Quarter & 13 \\ \hline 6 & Week per Year & 52 \\ \hline 7 & Weekdays per Week & 5 \\ 8 & Weekend Days per Week & 2 \\ \hline 9 & Quarters per Year & 4 \\ 10 & Number of Months per Year & 12 \\ \hline 11 & Yearly Property Taxes (per SF) & 0.2 \\ \hline 12 & \end{tabular} SportsMans Store Information
