Kitchen Appliances R US is a specialist white goods store established by George Black and his…

Kitchen Appliances R US is a specialist white goods store established by George Black and his wife Georgina. They stock a supply of kitchen white goods (ovens, stoves, range hoods, fridges and dishwashers).

George has chosen to stock a limited range of manufacturers and sells them at discount prices. He has calculated different discounts for each manufacturer based on his analysis of the difference between the cost price of items to him and the recommended retail price (See the Manufacturer Discounts table). Before selling an item to a customer the discount is deducted from the recommended retail price.

Goods are delivered to customers via an external courier service. In the past George offered free delivery to all customers. However, this policy proved very costly and George has modified his policy so that only customers purchasing items which cost $2000.00 or more receive free delivery.

Georgina keeps a record of all sales. She realises that there is a lot of valuable information in the sales records that could be used to run the business more effectively and has decided to record sales data in a simple spreadsheet model.

In the spreadsheet which Georgina plans to develop she needs to record:

  • The percentage discount for each item sold
  • The actual discount($) for each item sold
  • Sales Price, after Discount
  • The total received for all sales
  • Whether free delivery applies

Complete the following IPO chart using the numbers 1, 2 and 3 to show which cell you are referring to:

INPUT

PROCESSING

OUTPUT

For each sale:

Item Manufacturer

Manufacturer Discounts table

1

% discount for each item sold

2

Recommended retail price multiplied by % discount.

Discount ($)

For each item sold:

Recommended retail price

Discount ($)

Recommended retail price minus Discount ($)

3

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Literature
Thank you!
Customer 453145, April 19th, 2022
Nursing
Thank you
Customer 453087, March 5th, 2022
English 101
Thank you for this excellent analysis of the Alchemist.
Customer 453213, June 15th, 2022
Management
It's the second time I use this service and it does not let me down. Work quality is so good for its price!
Customer 452985, December 3rd, 2021
Management
It was gotten well after time I needed to make needed additions, but it is something that did help me. I could not get the concept of ho to start such a project but now reading this, I was over thinking the project it seems.
Customer 452801, July 19th, 2021
Social Sciences
Very fast report with excellent information on the topic. Thank you for your speedy service in such a short time.
Customer 453213, June 15th, 2022
Classic English Literature
It was my first time using such a service. Essay was good and nicely formatted.
Customer 452441, February 16th, 2022
Human Resources Management (HRM)
I finished the first deliverable of a project presentation but had no time to finish my second deliverable. The writer revamped my first deliverable and made it much more appealing! Not only was I impressed with the content but I was so grateful for the time they took to redo the background. I have been under a lot of pressure at work and at home so this has been a great service when I have had little time! I appreciate the detail and help! Always on time and always exceeding expectations!
Customer 453077, April 5th, 2022
Business Studies
Thank you so much! I had to take my dog to the ER and had no time for the assignment. I really appreciate your help! I can't thank you enough! I really appreciate the work and integrity put into it. Thank you for taking it seriously and not bullshiting the paper.
Customer 452815, July 26th, 2021
English 101
very good paper thank you.
Customer 453083, February 18th, 2022
IT, Web
Awesome paper in such a short amount of time. Was in a jam with another service who didn't deliver, but Theresa did the job correctly. I will use her again to do my essays for sure!
Customer 452967, November 27th, 2021
English 101
great summery in terms of the time given. it lacks a bit of clarity but otherwise perfect.
Customer 452747, June 9th, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp

Are You Looking For Assignment Help? We Can Certainly Assist You