Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the Sales data ( you can copy this data from the Sales data tab to EoW 1 ) , ( 1 a ) Create
Using the Sales data you can copy this data from the Sales data tab to EoW
a Create a column "PromiseShipped Date" with a formula that checks whether the promised date is equal to the shipped date. Create a second column "Days OverUnder to show how many days before or after the promise date customer orders were shipped. How many orders were shipped after the promise date?
b Create a column "Extended Price" with a formula that calculates the quantity sold multiplied by the price of the goods sold. Create a second column that calculates the "NetSalesAmt" with a formula to calculate the total price net of shipping costs. As a validity check, create a column "Recalc" that verifies whether "Extended Price" "NetSalesAmt". Are there any differences and is there any indication of what those might be related to
c Assume a sales tax rate of on all customer orders. Create a column "SalesTaxAmt" with a formula to calculate sales taxes to be added to the total price using an absolute reference.
Step 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