Question: Solve using R programming language You are tasked to provide a programming solution to evaluate supplier quotations for five structural components. The prices per unit
You are tasked to provide a programming solution to evaluate supplier quotations for five structural components. The prices per unit will vary according to different supplier pricings. which will be provided to you as one spreadsheet (or comma separated value) file per supplier (see example in Table 1). Table 1. Supplier1.csv Unit Price per unit 1 m3 4000 N m3 45 Component Concrete in beam Steel in beam Brickwork Plaster work Formwork m3 5 3 4 m2 120 5 m2 250 Your programming solution must scan through multiple supplier quotation files and recommend the most cost-optimal supplier selection, given any quantities for al components provided in an Order Form as shown in Table 2 Table 2. Orderform.csv Unit Quantities 1 m3 20 2 m3 1600 Component Concrete in beam Steel in beam Brickwork Plaster work Formwork 3 m3 40 4 m2 120 5 m2 100 Your code must: only use the base library (no external packages) consists of appropriate input/output/connection(s) include own defined function(s) be fully commented run without error You are tasked to provide a programming solution to evaluate supplier quotations for five structural components. The prices per unit will vary according to different supplier pricings. which will be provided to you as one spreadsheet (or comma separated value) file per supplier (see example in Table 1). Table 1. Supplier1.csv Unit Price per unit 1 m3 4000 N m3 45 Component Concrete in beam Steel in beam Brickwork Plaster work Formwork m3 5 3 4 m2 120 5 m2 250 Your programming solution must scan through multiple supplier quotation files and recommend the most cost-optimal supplier selection, given any quantities for al components provided in an Order Form as shown in Table 2 Table 2. Orderform.csv Unit Quantities 1 m3 20 2 m3 1600 Component Concrete in beam Steel in beam Brickwork Plaster work Formwork 3 m3 40 4 m2 120 5 m2 100 Your code must: only use the base library (no external packages) consists of appropriate input/output/connection(s) include own defined function(s) be fully commented run without error
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
