My Math Forum  

Go Back   My Math Forum > College Math Forum > Linear Algebra

Linear Algebra Linear Algebra Math Forum


Reply
 
LinkBack Thread Tools Display Modes
October 26th, 2018, 06:24 AM   #1
Newbie
 
Joined: Oct 2018
From: usa

Posts: 5
Thanks: 0

list from various arrays optimization

so,
  • a store with many sellers
  • all of the sellers have the exact same products
  • each seller has different prices for his products
  • each seller asks for a fixed delivery costs (the quantity of products bought from his store does not matter)
  • a customer buys a random list of products.
how can i minimize the costumer's costs?

for example:


Buyer list optimized list

Prices Seller A Seller B Seller C Seller D Items Prices Items Prices
item1 20 15 15 - item1 15 item1 15
item2 30 25 30 - item2 25 item2 25
item3 40 35 45 - item3 35 item3 35
item4 45 43 - 40 item4 40 item4 43
item5 53 55 - 50 item5 50 item5 55
item6 60 65 - 60 item6 60 item6 65
item7 80 75 - 75 item7 75 item7 75
item8 98 95 - 95 item8 95 item8 95
item9 100 - 60 - item12 5 item12 5
item10 110 - 75 - item13 10 item13 10
item11 120 - - - item14 13 item14 15
item12 - 5 5 10 item15 19 item15 20
item13 10 - 10 20 Total 442 Total 458
item14 - 15 15 13
item15 20 30 20 19 Delivery1 20 Delivery1 20
item16 - 110 25 25 Delivery2 15 Delivery2 15
item17 - 120 30 - Delivery3 25
Delivery4 25
Delivery 20 15 25 25
t. Delivery 85 t. Delivery 35

total 527 total 493

Diiference 34
  1. We have 4 Sellers selling different items with different prices and different fixed delivery charges
  1. Customer selects the cheapest items from all 4 suppliers and delivery charges for 4 suppliers are added to total
  1. Customer list shows the total item sum = 442 and total delivery charges 85 and grand total 527
  1. In optimized list the we use 2 suppliers total item sum = 458 and total delivery charges 35 and grand total 493

Last edited by Niro87; October 26th, 2018 at 07:19 AM.
Niro87 is offline  
 
October 26th, 2018, 06:38 AM   #2
Global Moderator
 
Joined: Dec 2006

Posts: 19,868
Thanks: 1833

You haven't attached an image file.
skipjack is offline  
October 26th, 2018, 07:22 AM   #3
Newbie
 
Joined: Oct 2018
From: usa

Posts: 5
Thanks: 0

the quality of the image is bad so the example is in the table
Niro87 is offline  
October 26th, 2018, 09:02 AM   #4
Global Moderator
 
Joined: Dec 2006

Posts: 19,868
Thanks: 1833

Can you redo the table without using tab characters?
skipjack is offline  
October 27th, 2018, 01:16 AM   #5
Newbie
 
Joined: Oct 2018
From: usa

Posts: 5
Thanks: 0

Hi, i am uploading the example table again
optimization with multiple lists example.jpg
Niro87 is offline  
October 27th, 2018, 01:17 AM   #6
Newbie
 
Joined: Oct 2018
From: usa

Posts: 5
Thanks: 0

looks like it's not working, thanks!
Niro87 is offline  
Reply

  My Math Forum > College Math Forum > Linear Algebra

Tags
arrays, list, optimization



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiplication arrays breefie Computer Science 11 September 15th, 2012 06:19 PM
Finding the Set Difference given two arrays restin84 Computer Science 1 March 18th, 2012 02:32 PM
Arrays in Data Structures eulerrules1 Computer Science 1 February 21st, 2012 01:20 PM
Trying to master Arrays samthewildone Computer Science 2 June 21st, 2011 03:14 PM
Circles and arrays problem dpochet Algebra 1 April 23rd, 2009 06:50 AM





Copyright © 2018 My Math Forum. All rights reserved.