Question

In: Computer Science

Exercise 3: Create a worksheet that gives a price quote. You will select an item name...

Exercise 3:

Create a worksheet that gives a price quote. You will select an item name and enter the quantity of that item purchased. Use Data Validation to create a drop down list for your item names. Your worksheet should look up the item name in the Price Table to find the Unit Price. Then it should calculate the Total Before Discount. Look up this amount in the Discount Table to find the discount percent. Then your worksheet should calculate the Discount Amount, the Total After Discount, add in Sales Tax (use an assumption for tax percentage), and give the final Total Due for the order. Place the Price Table, Discount Table and Sales Tax Percentage in the assumptions area.

Use the layout shown below starting your title in A4:

Price Quote (title)

Item:     (input)

Quantity: (input)

Unit Price:

Total Before Discount:

Discount %:

Discount Amount:

Total After Discount:

Sales Tax:

Total Due:

(The price and discount information is shown below…you may need to reconfigure the layout to meet your needs. All information shown below needs to be included in your Lookup Tables, even if it is not used in the problem.)

Price Information:

Unit Price                          Item #                 Item Name        

9.99                                   H5528                 Hat       

5.99                                   L8511                  Lanyard                             

14.99                                 T3592                  T-shirt                                             

19.99                                 D7435                 Drawstring Bag               

Discount Information:

Total Price

Before Discount ($)         Discount

$0 – $99.99                               0%

$100 – $399.99                        5%

$400 – $999.99                      10%

$1000 and over                      15%

Solutions

Expert Solution

Dear Seeker,

Please find the model completed,

Formulas used

References

You can also download the prepared model from below link of G Drive

https://docs.google.com/spreadsheets/d/1MaUdKzsYiciiRPRb9aC741GmlFzyoj6v1OTSczdepjw/edit?usp=sharing

Regards,


Related Solutions

Create a new worksheet and name it as “Roster”. Assume that you are the TA for...
Create a new worksheet and name it as “Roster”. Assume that you are the TA for Mgtop 470. You have the class roster in the worksheet “Roster” and the full names of students are in column A, starting in Cell A3, with last name last and case insensitive (such as Ben ALT). Write a sub that counts the number of names in the list with last name ALT and then displays this count in an MsgBox that is titled “Number...
2.13 Program: Food receipt (Python 3) 1.Enter food item name: hot dog Enter item price: 2...
2.13 Program: Food receipt (Python 3) 1.Enter food item name: hot dog Enter item price: 2 Enter item quantity: 5 RECEIPT 5 hot dog @ $ 2.0 = $ 10.0 Total cost: $ 10.0 2.Enter food item name: hot dog Enter item price: 2 Enter item quantity: 5 RECEIPT 5 hot dog @ $ 2.0 = $ 10.0 Total cost: $ 10.0 Enter second food item name: ice cream Enter item price: 2.50 Enter item quantity: 4 RECEIPT 5 hot...
Select 5 item topics. For each item topic you select, you need to write a minimum...
Select 5 item topics. For each item topic you select, you need to write a minimum of 5 sentences. Any responses that involve one-word answers, responses less than the 5 sentence minimum, or any answers that are copy and pasted (from the book or otherwise) will result in decreased points or a “0.” Points are awarded per instructor discretion. 1.What are the goals of nursing? 2. 5 Steps to achieve critical thinking 3. Critical judgement 4. 3 learning styles 5....
Select 5 item topics. For each item topic you select, you need to write a minimum...
Select 5 item topics. For each item topic you select, you need to write a minimum of 5 sentences. Any responses that involve one-word answers, responses less than the 5 sentence minimum, or any answers that are copy and pasted (from the book or otherwise) will result in decreased points or a “0.” Points are awarded per instructor discretion. 1."Eating your young" ritual 2. What is workplace violence? 3.Lavinia Lloyd Dock 4.Affordable Care Act (ACA) 5.Nursing shortage
Select 5 item topics. For each item topic you select, you need to write a minimum...
Select 5 item topics. For each item topic you select, you need to write a minimum of 5 sentences. Any responses that involve one-word answers, responses less than the 5 sentence minimum, or any answers that are copy and pasted (from the book or otherwise) will result in decreased points or a “0.” Points are awarded per instructor discretion. 1. 3 verbal communication blockers 2. Sentinel events 3. Maslow's hierarchy 4. Evidence- based practice 5. Cultural awareness write a minimum...
1. The Item class includes two fields: a String for the name and a double for the price of an item that will be added to the inventory.
  1. The Item class includes two fields: a String for the name and a double for the price of an item that will be added to the inventory. 2. The Item class will require one constructor that takes a name and price to initialize the fields. Since the name and price will be provided through TextFields, the parameters can be two Strings (be sure to convert the price to a double before storing this into the field). 3. Write...
3. Suppose you bought a call option for $3 with an exercise price of $50 and...
3. Suppose you bought a call option for $3 with an exercise price of $50 and another call option for $2 with an exercise price of $60 per share. Draw a graph of the payout on the investment as a function of the stock price. Label the graph.
4. Create a program that takes in the following CMD arguments: Item name, quantity, cost per...
4. Create a program that takes in the following CMD arguments: Item name, quantity, cost per item, and total cost. Your task then is to take this given information to print a simple receipt as indicated below (Don’t worry about the calculations for now.) 1 Sample run 1: Java lab01_task04 Banana 6 3.25 19.50 Output: Welcome to FCI Fresh Goods Sales ====================== You have purchased: 6 X Banana @ N$ 3.25 including 15% VAT ====================== Total Cost: N$ 19.50 ======================
Which is a better deal on a $39.99 item? Select one: a. 40% off original price...
Which is a better deal on a $39.99 item? Select one: a. 40% off original price with an additional 20% taken at the register b. 45% off original price with an additional 10% off coupon c. 30% off original price with an additional 20% off coupon d. 50% off original price
exercise 4e Construct an IFE Matrix for Your University Purpose this exercise gives you the opportunity...
exercise 4e Construct an IFE Matrix for Your University Purpose this exercise gives you the opportunity to evaluate your online university’s major strengths and weaknesses. As will become clearer in the next chapter, an organization’s strategies are largely based on striving to take advantage of strengths and improving on weaknesses. Instructions Step 1 Join with two other individuals to form a three-person team. Develop a team IFE Matrix for your online university. You may use the strengths and weaknesses determined...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT