r a combination of any two items. A gift pack is a special combination that contains all three items. Here are some special considerations: 1- If a customer purchases individual items, he does not receive any discount. 2- If a customer purchases a combo pack with two unique items, he gets a 10% discount. 3-If the customer purchases a gift pack, he gets a 25% discount. Write a function for the above scenario. Perform the calculations in code wherever applicable. The function should be your own creation, not copied from any other source. The final output should look like the image attached.

r a combination of any two items. A gift pack is a special combination that contains all three items. Here are some special considerations: 1- If a customer purchases individual items, he does not receive any discount. 2- If a customer purchases a combo pack with two unique items, he gets a 10% discount. 3-If the customer purchases a gift pack, he gets a 25% discount. Write a function for the above scenario. Perform the calculations in code wherever applicable. The function should be your own creation, not copied from any other source. The final output should look like the image attached.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter1: Getting Started With Excel

Section: Chapter Questions

Problem 3.8CP

See similar textbooks

Related questions

Q: Write an application that reads a user basket list and produces the bill receipt. Check the given…

A: Problem: An online grocery store sells items on a web page. A user adds items to a basket and he…

Q: C++ code A simple version of snakes and ladder Implement a game that initially asks how many…

A: code snippet:

Q: Dice game with varying dice (d4-d20) The game will consist of two or more players. Each player…

A: Create a Player class with attributes: name, current score, and turn score.Initialize the attributes…

Q: Python Returning Funtion function name: bound_0_to_100 parameters:a number grade returns: the grade…

A: Pseudocode: Define a function named bound_0_to_100 having grade as its parameter If the grade is…

Q: Serendipity Booksellers has a book club that awards points to its customers based on the number of…

A: Answer : import unittest step-1) write the consumer_rewards method as per the conditions defined…

Q: Broken Cabins Problem Statement: There is an Office consisting of m cabins enumerated from 1 to m.…

A: Here is the code in C++ as required I have kept it very simple to understand

Q: A serendipity bookseller has a book club that awards points to its customers based on the number of…

A: Program is given below with output and proper explanation

Q: C++ A dice game called "21" It is a variation on BlackJack where one player plays against the…

A: Write a C++ program that will find the output according to the conditions given in the question and…

Q: Using Java programming language write a program to manage a hotel with 24 rooms; 10 rooms are…

A: It is defined as

Q: There is only one list of N ingredients in the menu. Every ingredient has its beauty value that does…

A: Given: There is only one list of N ingredients in the menu. Every ingredient has its beauty value…

Q: Write a program that works out the amount a person has to pay for parking in a car park in a tourist…

A: The program is to calculate parking charges. If they say they are disabled, they are told it is…

Q: Compare Numbers - Python Language please! Programming challenge description: Little Tommy is in…

A: Step 1 : STARTStep 2 : implement the function compare_numbersStep 3 : input 2 numbersStep 4 : store…

Q: Write a program that quizzes the user on the names of the capital cities for all the states in the…

A: Solution:-- 1)The given problem has required for the solution which is to be provided for the quiz…

Q: Python Assignment: In India McDonald's has the n number of customers and they are famous for their…

A: Coded in Python 3.

Q: 2. Let x be the first three digits of your matric number, AND y be the last three digits of your…

A: I am considering the matric number as 2210039 Now x = 221 and y - 039 we change 0 in y as 2 so, x =…

Q: C# Programming The Card Game One day, Fred and his N friends were playing a card game in which each…

A: Required: We have to write a code to maximize the sum which we get on the front cards, keeping in…

Q: Use C Language Airline Reservation System A small airline has just purchased a computer for its…

A: Answer :

Q: Serendipity Booksellers has a book club that awards points to its customers based on the number of…

A: Actually, java is an object oriented programming language. It is an platform independent.

Question

100%

This is python3 code please

Develop a catalog for a company. Assume that this company sells three different Items. The seller can sell individual items or a combination of any two items. A gift pack is a special combination that contains all three items. Here are some special considerations:

1- If a customer purchases individual items, he does not receive any discount.
2- If a customer purchases a combo pack with two unique items, he gets a 10% discount. 3-If the customer purchases a gift pack, he gets a 25% discount.

Write a function for the above scenario. Perform the calculations in code wherever applicable. The function should be your own creation, not copied from any other source. The final output should look like the image attached.

Include the following in your submission:

The code for the function that you created.
The output of the code.
A description of what feature(s) your function illustrates.
The code and its output must be explained technically. The explanation can be provided before or after the code, or in the form of comments within the code.

Output:
Online Store
Product (S)
Item 1
Item 2
Item 3
Combo 1(Item 1 + 2)
Combo 2 (Item 2 + 3)
Combo 3(Item 1 + 3)
Combo 4(Item 1 + 2 + 3)
Price
200.0
400.0
600.0
540.0
900.0
720.0
900.0
For delivery Contact:98764678899

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Contextual Understanding

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

estion Completion Status: AIRPORT FLIGHT AIRPORTCODE FLIGHTNUM FK AIRPORT1 CUSTOMER AIRPOR NAME DTIME CUSTOMERNUM CITY DDATE FIRSTNAME ATIME ADATE DESTINATIONAIRPORT PRICE AIRPLANENUM(FK) AIRPORTCODE(FK) STATE MIDDLENAME LASTNAME 3. STREETNUMBER STREETNAME CITY FK AIRPORT I STATE PHONE 1. FK AIRPLANE FK_FLIGHT FK CUSTOMER AIRPLANE AIRPLANENUM PAYMENT FLIGHTNUM(FK AIRPLANENAME CUSTOMERNUM(FK) CAPACITY CREDITCARDTYPE AIRPORTCODE(FK) CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE A. 1 How many primary key in the Flight entity? B.5 How many tables in the system can Customer table retrieve data from? C. 4 How many attributes in the Airport Table? D.5 How many tables in the system? E. 5 How many relationships shown in the system? Click Save and Submit to save and submit. Click Save All Answers to save all ansuwers.
Customer Customer Item Item Category Category date quantity Unit Number Name code Number price name name 4583155 H.Petu 146 keyboard PER Peripherals 2021/01/03 1 150.00 8 4583155 H.Petu Peripherals 2021/01/03 110 mouse PER 1 758.00 keyboard PER Peripherals 2021/01/05 9659103 В. 146 1 150.00 Nixon 8 keyboard Peripherals 2021/01/11 4583155 H.Petu 146 PER 1. 150.00 8. 9659103 В. 780 3D printer PRN printer 2021/01/11 9150.00 Nixon 2 Normalize this data to second normal form
The local DMV processes applications for driver’s license renewals with the following three steps. First, the customer registers with the receptionist, who updates the customer’s information in the database. This first step takes 2 minutes per customer. Then, the customer visits one of two cashiers to pay the associated fees for the license renewal. This takes 8 minutes per customer. Finally, the customer visits one of three license processing stations where the customer’s picture is taken and the license is printed. This final step takes 15 minutes per customer. Assume demand is 20 customers per hour. When the DMV opens in the morning, about how long will it take to process the first 50 customers? (Show your work) A. 3.6 hours B. 3 hours C. 2.8 hours D. 1.9 hours
SAGA (The South African Golf players Association) is hosting a virtual golf competition. Both professional as well as amateur golf players can register to take part in the competition. A professional golf player is defined as a person who is a member of the SAGA and is ranked on the professional list of golf players. Amateur golf players are divided into two categories for the competition, viz.1 - student (university or college) and 2 - adult.On registration the participants need to provide their ID-number and name. Professional golf players also need to indicate the number of years that they have been members of SAGA and their position on the professional golf players’ list. Amateur golf players need to provide the category they will participant in (1 or 2 – see previous paragraph). The information of a number of participants has been captured in the text file players.txt. The text file is provided. Example of the first 4 lines of text in the text file:A registration code must be…
Add/insert the following records to the CLIENTS table: CLIENTS CID CName Gender Address Contact стуре 1521 Ahmed Said Male SLL 92214561 Old 1522 Salma Female MCT 92384792 New Mohammed 1523 Faiza Ahmed Female SLL 97451382 Old 1524 Noaman Said Male NZW New
If you know 100 % thn answer else don't answer i will downvote Expln with neat fig
How should a client deal with failure of a request?
In other words, port definitions.
I am needing help in understanding Question 4. Please provide step by step explanation of each of the anomalies. Thank you
ASAP!! ANSWER
Deliverables: List of actors List of use-cases UML Use-Case Diagram Overview Statement: For its chain of fast food outlets, Chicago Bino's Pizza has recently installed a new online system to speed up deliveries and improve customer satisfaction. When a customer places an online order to have pizza delivered, an employee verifies the order and checks the customers phone number against a data store containing past orders. If the order is for a repeat customer, the system matches the number with the customer database and displays the customer record on the screen. (Customer records contain a variety of information, including whether the customer's dog bites.) For first-time customers, the employee (salesman) verifies the caller's name and address, and creates a record in the customer database. The order taker (salesman) verifies the customer's pizza order within 10 minutes after the customer placed the order online. After 10 minutes from placing the order by the customer and the…
Given below is a table where each ID has a role assigned to it and a password, corresponding to that ID: ID Roll no Password 100 student 10220 101 student 16010 102 student 11002 103 student 22342 104 student 44323 105 student 33354 106 student 87685 107 student 99089 108 student 34562 109 student 44255 110 teacher 32415 111 teacher 90784 112 teacher 78685 113 IT staff 15254 114 IT staff 81973 Write a C++ program that takes ID from the user. Based on the ID determine the role and display appropriate messages to ask the user to enter his/her password (if the role is a student then display “Dear student please enter your password). If the password provided by the user is correct the program will print the greeting message, otherwise, the program will display an error message “You have entered an incorrect value” and the program ends. If the ID does not exist, the program will print Incorrect ID.This should be done using switch and nested switch only.