You are the CFO of Beach Store, Inc. The store sells various beach-related items, such as swimsuits, towels, umbrellas, skimmer boards, etc. There are 5 employees at your store, 4 staff and 1 manager. 1. Label sheet one of the spreadsheet as LABOR. Create a spreadsheet listing each employee's name, the number of hours worked a week, and the hourly wage. Calculate each employee's weekly pay and the total paid the 5 employees each week. 2. Label the next sheet INVENTORY. Create a spreadsheet of 10 items your store sells, the unit cost of each, the cost markup (what % you add to the cost of each item so that you can make a profit), the quantity sold for each of 6 months, the total sales for each item per month, the total sales for the store for each month and the final sales for the 6-month period. 3. Label the next sheet BUDGET. Create a spreadsheet of income (sales and donations) and expenses (payroll, rent, utilities and stocking fee) for the 6-month period. Your values for payroll must come from the LABOR sheet and your values for sales must come from the INVENTORY sheet. Calculate totals for each income and expense, a grand total for the incomes and expenses over the 6-month period, and the net profit (or loss) your store has monthly and at the end of the 6-month period. 4. Be sure that each sheet is formatted attractively (using different fonts, types, borders, etc) and includes your name and section in a header. 5. Create an appropriate graph to compare the unit cost of the 10 items. Label correctly and completely. Indicate, by special appearance, which item is the most expensive. 3. Label the next sheet BUDGET. Create a spreadsheet of income (sales and donations) and expenses (payroll, rent, utilities and stocking fee) for the 6-month period. Your values for payroll must come from the LABOR sheet and your values for sales must come from the INVENTORY sheet. Calculate totals for each income and expense, a grand total for the incomes and expenses over the 6-month period, and the net profit (or loss) your store has monthly and at the end of the 6-month period. 4. Be sure that each sheet is formatted attractively (using different fonts, types, borders, etc) and includes your name and section in a header 5. Create an appropriate graph to compare the unit cost of the 10 items. Label correctly and completely indicate, by special appearance, which item is the most expensive. 6. Create an appropriate graph to compare sales trends of three (3) products over the 6- month period. Label correctly and completely 7. Create an appropriate graph to show how each expense is part of the total expenses for the 6-month period. Label correctly and completely. 8. Create a Word document. The document will be a letter, using your appropriate letterhead and clip art, to the corporate office. The address of the corporate office is: 987 Ocean Way: Ocean City, MD: 21334. The letter should show the office how well, poorly, your store is doing by including a copy of the budget in the letter. Explain how you will increase profits; supply an Excel chart support your plan. For instance, your store has a large payroll. Change the LABOR sheet to reduce pay. Copy original and new pie charts to the Word document to show how decreasing payroll affects the final profit. 9. Submit the entire workbook via the assignment folders in Blackboard, Submit the letter portion of the assignment separately via the marked assignment submission folder. II You are the CFO of Beach Store, Inc. The store sells various beach-related items, such as swimsuits, towels, umbrellas, skimmer boards, etc. There are 5 employees at your store, 4 staff and 1 manager. 1. Label sheet one of the spreadsheet as LABOR. Create a spreadsheet listing each employee's name, the number of hours worked a week, and the hourly wage. Calculate each employee's weekly pay and the total paid the 5 employees each week. 2. Label the next sheet INVENTORY. Create a spreadsheet of 10 items your store sells, the unit cost of each, the cost markup (what % you add to the cost of each item so that you can make a profit), the quantity sold for each of 6 months, the total sales for each item per month, the total sales for the store for each month and the final sales for the 6-month period. 3. Label the next sheet BUDGET. Create a spreadsheet of income (sales and donations) and expenses (payroll, rent, utilities and stocking fee) for the 6-month period. Your values for payroll must come from the LABOR sheet and your values for sales must come from the INVENTORY sheet. Calculate totals for each income and expense, a grand total for the incomes and expenses over the 6-month period, and the net profit (or loss) your store has monthly and at the end of the 6-month period. 4. Be sure that each sheet is formatted attractively (using different fonts, types, borders, etc) and includes your name and section in a header. 5. Create an appropriate graph to compare the unit cost of the 10 items. Label correctly and completely. Indicate, by special appearance, which item is the most expensive. 3. Label the next sheet BUDGET. Create a spreadsheet of income (sales and donations) and expenses (payroll, rent, utilities and stocking fee) for the 6-month period. Your values for payroll must come from the LABOR sheet and your values for sales must come from the INVENTORY sheet. Calculate totals for each income and expense, a grand total for the incomes and expenses over the 6-month period, and the net profit (or loss) your store has monthly and at the end of the 6-month period. 4. Be sure that each sheet is formatted attractively (using different fonts, types, borders, etc) and includes your name and section in a header 5. Create an appropriate graph to compare the unit cost of the 10 items. Label correctly and completely indicate, by special appearance, which item is the most expensive. 6. Create an appropriate graph to compare sales trends of three (3) products over the 6- month period. Label correctly and completely 7. Create an appropriate graph to show how each expense is part of the total expenses for the 6-month period. Label correctly and completely. 8. Create a Word document. The document will be a letter, using your appropriate letterhead and clip art, to the corporate office. The address of the corporate office is: 987 Ocean Way: Ocean City, MD: 21334. The letter should show the office how well, poorly, your store is doing by including a copy of the budget in the letter. Explain how you will increase profits; supply an Excel chart support your plan. For instance, your store has a large payroll. Change the LABOR sheet to reduce pay. Copy original and new pie charts to the Word document to show how decreasing payroll affects the final profit. 9. Submit the entire workbook via the assignment folders in Blackboard, Submit the letter portion of the assignment separately via the marked assignment submission folder