Ashford University Coca Cola Company Sales Portfolio and Inventory Worksheet

User Generated

Ghgbegvghf

Business Finance

ashford university

Description

All worksheets

  • Create a company name (something you choose) to be the worksheet title
  • Add a subtitle that is indicative of the worksheet contents

Unformatted Attachment Preview

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: SALES PORTFOLIO

1

Coca-Cola Company: Sales Portfolio
Student
Institution

SALES PORTFOLIO

2

1. An inventory worksheet
Product ID Product
Name

Quantity
on Hand

Cost

1

1000L

$20000 $20

2

CocaCola
Fanta

Inventory
values at
Cost and
Retail and
Potential
Profit
$4000

800L

$16000 $20

$3200

3

Sprite

755L

$15100 $20

$3020

4

900L

$31500 $35

$6300

5

Minute
maid
Ciel

700L

$16100 $23

$3220

6

Powerade 250L

$5250

$21

$1050

7

Fresca

$5200

$26

$1040

200L

Price/L

Inventory values a...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags