You are the owner of Everybody Loves To Ski Travel Agency. You want to compare various travel package ideas to produce information that will lead to making some important decisions. Below are the travel packages the company sells along with the, the cost per unit for each travel package, and the margin. You will be developing formulas to complete the information to calculate the profit for selling 75 units (Profit per 75 Sales) and profit for selling 100 units (Profit per 100 Sales) during the Summer months. You will need to open a worksheet uploaded on eCampus called Chapter 2 Printout Project Original Worksheet Modified to practice_nd.xlsx which contains the data a company with their top 6 travel packages (see picture below).

Everybody Loves To Ski Travel Agency
Winter Sales Forecast
Travel Package	Cost per Unit	Margin	Selling Price	Profit per 75 Sales	Profit per 100 Sales
Burlington, VT	$ 400.00	25%
Denver, CO	600.00	30%
Lake Placid, NY	300.00	20%
St. Moritz, Switzerland	1,500.00	45%
Whistler, BC, Canada	800.00	40%
Solden, Austria	1,200.00	52%
Total
Average
Minimum
Maximum
Notes:
Cost per unit: The dollar value each unit of the product costs before it is actually sold.
Margin: The % of money a firm expects to increase the cost by (also referred to as the profit margin); for example, your organization intends to mark up the costs.
Selling Price: The price that the firm expects to charge. Selling price takes into account the cost per unit and the margin the firm expects to earn when selling the product

Figure 1shows all the worksheets your project must have

Formatting Instructions for Original worksheet:

1. Open Excel Document Chapter 2 Printout Project Original Worksheet Modified to practice_nd.xlsx uploaded on eCampus. Save the file as follows:

Last Name First Name Chapter 2 Printout Project

2. Apply the Retrospect Theme to the worksheet

3. Format the worksheet: Page: Landscape Orientation, Fit to 1 by 1; Margins: Centered on page vertically and horizontally

4. Custom Header: Left - Chapter 2 Printout Exam, Center - Your Name, Right - IT115-StudenID#

5. Custom Footer: Right Sheet Name

6. Merge and center the worksheet title. Format the title by applying the Title cell style. Change font to 22 points

7. Merge and center the worksheet subtitle. Format the subtitle by applying the Heading 2 cell style; Increase the font to 16 points.

8. Autofit column widths for columns A and B; Change the width for columns C, D, E and F to 14

9. Format row 3 to 40 points

10. Format the column titles by applying the Heading 3 cell style; center the column titles

11. Delete rows 16 to 19

Everybody Loves To Ski Travel Agency
Winter Sales Forecast
Travel Package	Cost per Unit	Margin	Selling Price	Profit per 75 Sales	Profit per 100 Sales
Burlington, VT	$ 400.00	25%
Denver, CO	600.00	30%
Lake Placid, NY	300.00	20%
St. Moritz, Switzerland	1,500.00	45%
Whistler, BC, Canada	800.00	40%
Solden, Austria	1,200.00	52%
Total
Average
Minimum
Maximum