Question
1. In cell C7 enter a Projected Price Increase of 4.00 , In cell C6 enter a Unit Price of $2.25 , In cell K12
1. In cell C7 enter a Projected Price Increase of 4.00 , In cell C6 enter a Unit Price of $2.25 , In cell K12 calculate the Projected Sales in $ using the Units Sold, the Projected Price Increase % in cell C7 and the Unit Price in cell C6. Use the appropriate cell names created for absolute cell reference. Copy formula to the rest of the cells in the column. In cell K1 use the appropriate function to calculate the total Projected Sales in $ for all orders.
2. Use Goal Seek to determine the Unit Price required to achieve a total Sales in $ of $2,350,000.Enter the Unit Price result from goal seek.
3.In cell L12 use the appropriate function to extract the Day from the Order Date. Copy formula to the rest of the cells in the column. In cell L1 use the approprite function to count how many orders were placed on Day 9. Enter answer here.
4. In cell M12 use the appropriate function to extract the Month from the Order Date. Copy formula to the rest of the cells in the column. In cell M1 use the approprite function to count how many orders were placed after Month 2. Enter answer here.
5. In cell N12 use the appropriate function to extract the Year from the Order Date. Copy formula to the rest of the cells in the column. In cell N1 use the approprite function to count how many orders were placed before 2018. Enter answer here.
6. In cell O12 use the appropriate function to calculate the number of days between the Order Date and the Ship Date. Copy formula to the rest of the cells in the column. In cell O1 use the approprite function to count how many orders shipped in less than 6 days. Enter answer here.
7. In cell P12 use a formula to calculate the number of years between the Order Date and the Reference Date in cell C8. Assume that each year has 365 days. Copy formula to the rest of the cells in the column.In cell P1 use the approprite function to count how many orders were placed less than 3 years before the Reference Day. Enter answer here.
Purpose: Created By: To analyze data and perform What if Analysis Arshdeep Singh 623924 $1,403,829.00 958 Constants Unit Price Price Increase % Reference Date $2.25 4.00% 1/31/2021 Customer ID City Sales in $ Projected Sales in $ Day M Order Number T001 TOO2 T003 T004 Johnston King Western Trading Inc Supply and Demand The Mirrors Place Black Crystal Lodge Marianne's Multiple Layers The Art Shoppe Albert's Retail Payment Rating Method 3 Cash 3 Cash 4 Cheque 4 Cheque 1 Cheque 5 Cash 1 Cash 2 Cheque 4 Cheque Mississauga Mississauga North York Etobicoke Toronto Etobicoke Scarborough Toronto Mississauga TO05 T006 T007 T008 T009 Order Ship Units Ship Via Date Date Sold United Parcel Service 42372 42381 435 United Parcel Service 42372 42381 747 Federal Express 42375 42379 722 Federal Express 42375 42379 943 Federal Express 42377 42385 382 Federal Express 42377 42386 395 Airborne Express 42377 42382 364 Airborne Express 42377 42383 659 United Parcel Service 42378 42388 588 $978.75 $1,680.75 $1,624.50 $2,121.75 $859.50 $888.75 $819.00 $1,482.75 $1,323.00 ACN Purpose: Created By: To analyze data and perform What if Analysis Arshdeep Singh 623924 $1,403,829.00 958 Constants Unit Price Price Increase % Reference Date $2.25 4.00% 1/31/2021 Customer ID City Sales in $ Projected Sales in $ Day M Order Number T001 TOO2 T003 T004 Johnston King Western Trading Inc Supply and Demand The Mirrors Place Black Crystal Lodge Marianne's Multiple Layers The Art Shoppe Albert's Retail Payment Rating Method 3 Cash 3 Cash 4 Cheque 4 Cheque 1 Cheque 5 Cash 1 Cash 2 Cheque 4 Cheque Mississauga Mississauga North York Etobicoke Toronto Etobicoke Scarborough Toronto Mississauga TO05 T006 T007 T008 T009 Order Ship Units Ship Via Date Date Sold United Parcel Service 42372 42381 435 United Parcel Service 42372 42381 747 Federal Express 42375 42379 722 Federal Express 42375 42379 943 Federal Express 42377 42385 382 Federal Express 42377 42386 395 Airborne Express 42377 42382 364 Airborne Express 42377 42383 659 United Parcel Service 42378 42388 588 $978.75 $1,680.75 $1,624.50 $2,121.75 $859.50 $888.75 $819.00 $1,482.75 $1,323.00 ACNStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started