Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.image text in transcribed

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 ACN

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 17 - Off-Balance-Sheet Shams

Authors: Kate Mooney

1st Edition

0071719393, 9780071719391

More Books

Students also viewed these Accounting questions