Unit 1 Portfolio Assignment – Sales All worksheets • • Create a company name (something you choose) to be the worksheet title Add a subtitle that is indicative of the worksheet contents Create an inventory worksheet • Include at least 7-10 products/services. Include the following columns: • Product ID or Item # • Product Name or Description, • Quantity on Hand • Cost • Price • Inventory values at Cost and Retail, and potential Profit for your 7-10 products • Calculate the total for the Inventory values at Cost and Retail and Potential Profit columns Create a quantity sold worksheet • Copy the Product ID or Item # and the Product name or description from the Inventory worksheet to the new Quantity Sold worksheet • You are tracking monthly quantity sold for two quarters (six months). The month names will be the column headings. Keep the 6 months together; do not break them up with any other calculations • Enter quantity sold values for each item for each month • Total all columns and rows Create a sales worksheet • Copy the Sales Tracking Quantity Sold worksheet to a new worksheet. This will become the Sales Revenue Tracking worksheet. • Delete the values for the quantities sold only. Do not delete any formulas • Using the appropriate cell reference, calculate the Sales revenue for each product and each month by creating a formula, that will multiply the quantity sold (from the quantity sold worksheet) by the retail prices(on the inventory worksheet). Ensure all appropriate calculations are included so anyone viewing the worksheet can easily find monthly, quarterly, and 6 month totals for each product/service as well as totals of all products/services for each month, quarter, and grand total. • Include a new column to show the percentage of each item to the total of all sales for the 6-month period. STOP! Save this workbook AS IS as your project name followed by Scenario I (for example Taylor FIT1040 Project Scenario 1) Your supplier has increased prices by 25% • On the inventory sheet, using a formula, increase your product costs by 25% • Save this workbook as your project name followed by Scenario 2 (for example Taylor FIT1040 Project Scenario 2) Questions: Answer the following questions below in a separate word document. Record the total potential profit from the Inventory worksheet for each scenario in the spaces below: Total Potential Profit Scenario 1: ____________________________ Total Potential Profit Scenario 2: ____________________________ How has the change in costs for your products affected potential profit? __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ What might you do to counter effect the results? __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ 
Purchase answer to see full attachment