basic_excel-_classwork

# basic_excel-_classwork - profit per item time required day1...

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: profit per item time required day1 day2 day3 day4 day5 day6 day7 day8 day9 day10 day11 day12 day13 day14 day15 day16 day17 day18 day19 day20 10 0.2 7 0.4 5 0.5 Product1 Product2 Product3 TotalProfit Time Spent 10 15 50 30 30 40 26 11 38 54 54 58 6 27 52 13 18 8 7 14 17 6 21 24 35 25 25 25 55 31 28 22 59 49 60 19 57 8 44 50 58 31 22 46 24 48 9 16 9 25 32 33 26 59 7 18 5 56 11 19 1. Calculate the Total Profit 2. Calculate the time spent f 3. Calculate the total profit a 4. Calculate the average pro 5. Find the maximum profit a 6. Find the minimum profit a 7. If the time spent for one d 8. If the production for each 9. If total production per day we will add +10 bonus to the If the total production per da 10. Find the days at least on 1. Calculate the Total Profit for each day 2. Calculate the time spent for each day 3. Calculate the total profit and total time for 20 days 4. Calculate the average profit and time in 20 days 5. Find the maximum profit and time in 20 days 6. Find the minimum profit and time in 20 days 7. If the time spent for one day is greater than 48 (assuming 6 labors) then there is overtime. Find the days with over time 8. If the production for each product is below 30 units then it is a slow day, find the slow days and regular days 9. If total production per day is greater than 150 units, then if the production for product 1 is greater than the average total production, we will add +10 bonus to the total profit, otherwise we will add +5 bonus to the profit If the total production per day is less than 150 units, we will add no bonus to the total profit. 10. Find the days at least one product is above the 2 times the average total production in 20 days rage total production, months year January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2003 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2004 2005 2005 2005 2005 2005 2005 2005 2005 Product1 Product2 359 273 384 415 336 521 598 398 369 252 581 493 205 551 478 349 574 405 369 320 259 482 305 454 582 246 357 597 299 567 536 563 Total Production of Product1 in year 2003= Total Production of Product1 in year 2004= Total Production of Product2 in January= number of months production of product 2 >450 number of months in 2004 that product 1 <300 594 525 522 518 506 504 441 405 388 367 267 236 390 515 416 232 260 555 273 518 561 228 408 561 466 592 478 400 296 342 561 420 4979 A B 12 13 4 6 6 7 8 9 A-inverse 10 3 3 7 12 11 0 5 1 3 5 2 B-inverse A_transpose A_determinant= B_determinant= A^sqr Bsqr Equation Editor 5 n ∑∑ X Y i =1 j =1 i 2 j 4 67 34 3 -5 -6 -3 0 1 23 24 45 A*B 1.Create 5 columns and 25 rows random numbers from Uniform(20,100) 2. Create 10 random numbers based on the discrete distribution given on the right Discrete Distribution Value 0 1 2 3 Discrete Distribution with Prob. 0.2 0.1 0.3 0.4 ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online