Question: Fill in the missing values in excel. 1 Discount Cost in 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Fill in the missing values in excel.

1 Discount Cost in 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 OrderNumber Orderitem Date Day of the Week 100099 30 2/27/2007 100099 40 2/27/2007 100099 50 2/27/2007 100100 10 2/28/2007 100100 20 2/28/2007 100100 30 2/28/2007 100100 40 2/28/2007 100100 50 2/28/2007 100100 60 2/28/2007 100100 70 2/28/2007 100100 80 2/28/2007 100101 10 2/28/2007 100101 20 2/28/2007 100101 30 2/28/2007 100101 40 2/28/2007 100101 50 2/28/2007 Custome CustDescr 13000 Airport Bikes 13000 Airport Bikes 13000 Airport Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 15000 Bavaria Bikes 16000 Capital Bikes 16000 Capital Bikes 16000 Capital Bikes 16000 Capital Bikes 16000 Capital Bikes City Frankfurt Frankfurt Frankfurt Mnchen Mnchen Mnchen Mnchen Mnchen Mnchen Mnchen Mnchen Berlin Berlin Berlin Berlin Berlin Salesorg Country Product DSOO DE PRRD3000 - Road Bike Carbon Campagnolo DSOO DE CAGE1000 - Water Bottle Cage DSOO DE KPAD1000 - Knee Pads DSOO DE DXTR1000 - Deluxe Touring Bike-Black DSOO DE DXRD2000 - Road Bike Alu SRAM DSOO DE RHMT1000 - Road Helmet DSOO DE FAID1000 - First Aid Kit DSOO DE PUMP1000 - Air Pump DSOO DE PRRD2000 - Road Bike Carbon SRAM DSOO DE PUMP1000 - Air Pump DSOO DE ORWN1000 - Women's Off Road Bike Fully DNOO DE ORMN1000 - Men's Off Road Bike Fully DNOO DE OHMT1000 - Off Road Helmet DNOO DE PUMP1000 - Air Pump DNOO DE BOTL1000 - Water Bottle DNOO DE PRRD1000 - Road Bike Carbon Shimano Category Sale Quantity Revenue USC Discount USO Costs in US Revenue Roadbike (ROB) SEA 24841.79 745.26 13500 Accessories ( ACC 7EA 139.13 4.17 63 Accessories ( ACC 2EA 165.62 4.97 75 Touring Bike ( TOU4EA 13233.18 661.65 5600 Roadbike (ROB) 8EA 14556.52 727.82 7600 Accessories ( ACC SEA 441.06 22.05 200 Accessories ( ACC 2EA 88.23 4.42 40 Accessories ( ACC GEA 185.25 9.26 84 Roadbike (ROB) 4EA 18526.46 926.33 9400 Accessories ( ACC 4EA 123.5 6.18 56 Offroad Bike ( ORB 27EA 74436.82 3721.84 33750 Offroad Bike ( ORB BEA 21173.13 635.19 9600 Accessories ( ACC 4EA 220.53 6.61 100 Accessories ( ACC SEA 154.37 4.63 70 Accessories ( ACC 6EA 132.33 3.97 60 Roadbike (ROB) 1EA 4411.06 132.33 2200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

HW8.3 (Genetic Algorithm): A steel needs to cool 17 pieces of steel. The weight and due date for each piece are listed in the file ISE251-10-HW8.3-cooling 17 steel pieces-template-with more...

Question #2. [13] You are buying a car for $35,000 with $0 down and an 84-month car loan from the local bank ABC. The following is the amortization table of your car loan. A B D 1 rate 5% 2 value of...

help! general journal and worksheet 3 5. Transaction 01, 02, 03, 04, 05, 06, 07. 08. 09, Description of transaction June 1: Hudson Bloom invested $112,378.00 cash and computer equipment with a fair...

Some citizens complained to city council members that there should be equal protection under the law against the occurrence of crimes. The citizens argued that this equal protection should be...

IDENTIFICATION :Wi'itEt he word or group of words that identify each of the following statements. 1. An articial being created by operation of law formed by ve or more persons. 2. 3 4. 5 10 11. 12....

Remaining Time: 1 hour. 09 minutes, 56 seconds. Question Completion Status: 1 2 3 4 5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 A Moving to another question will save this response....

One of Natalie's friends, Curtis Lesperance, runs a coffee shop where he sells specialty coffees and prepares and sells muffins and cookies. He is eager to buy one of Natalie's fine European mixers,...

detailed budget for your project that is in a suitable format to be presented to the project sponsor or executives. Load all work package tasks from your WBS (unit 4) into the table. Remember, you...

Question 2 Read the scenario below and answer the questions that follow: Jordan Family Trust Danny Jordan (61 years old) and his wife Glenys (51 years old) are married out of community of property....

Question 1 Read the scenario below and answer the questions that follow: Donations Tax for Florence Gules Florence Gules, a resident of the Republic, attained the age 69 on 1 September 2019. She is...

Mentioning OSHA to employers can result in a variety of reactions, many of which aren't very favorable. Organizations often feel that the regulations are costly to follow, require them to implement...

Guti company is planning a new product and market research has revealed that the product should sell 10,000 units at $21 per unit. The company seeks to make a mark-up of 40% product cost. It is...

The FHA charges the homeowner to insure an FHA mortgage. 5 2 Multiple Choice 0 . 5 percent of the loan amount $ 5 0 0 1 percent of the loan amount $ 1 , 5 0 0 nothing

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...