please show step by step instructions and formulas

i dont know the VLook up function the excel spreadsheet was empty and i need to find all of that

this is the text problem it refers to

This is an Excel spreadsheet each picture from start to bottom goes to the top to the bottom of the XL spreadsheet

Modifications to problem #22 Assume that the variable cost to make copies starts at 5 cents if the daily volume is on average below 200. Then, assume that the variable cost for making copies goes down by 0.5 cents per copy for every additional 200 copies made per day on average, up to 1000 copies. In other words, the variable cost for making cost is $0.05 if the average number of copies made per day is 0 to 199, $0.045 if it is 200 to 399 copies, etc. Cost per copy remains a flat $0.025 for quantities 1000 and more. Setup the cost table in the range E10:F15 and use VLOOKUP in cell C28 to find the cost per copy. 4 10 S #1. Use problem description of 22 from the textbook (60 points) 6 Answer the following questions (a) to (t), ignore the questions from the text. 7a. Set up a model for annual profit. (40 points) 8 Inputs Variable cost per copy for copies made per day 9 Yearly rental cost per copier 5000 No. of copies Cost/copy Other monthly fixed costs 400 0-199 0.05) 11 Price per copy 0.1 200-399 0.045 12 Days per year 365 400-599 0.04 13 Months per year 12 600-799 0,035 14 Copies per copier per year 100000 800-999 0.03 15 1000+ 0.025 16 17 Decision variable HE 19 Copiers rented Ice 19 20 Uncertain variable 21 Daily demand 1000 Cel 22 4 Clast ch G27 > X | 8 22 23 24 Actual copies made Annual capacity Annual demand Actual copies made per year 25 400000 365000 365000 26 27 28 29 Variable cost of making copies per copy Actual copies made per day Variable cost of making copies per copy 1000 #N/A 30 31 32 Annual Revenue Annual revenue 33 34 35 36 Annual Cost Rental cost of copiers rented Other monthly fixed costs per year Variable cost of actual copies made per year Total cost 20000 4800 37 38 39 40 41 Annual profit G27 X F H AA 8 C D E 43 b. Using Data/Table determine the annual profit for the number of copiers and daily 44 demand given below. (10 points) 45 Number of actual copies along the first column and daily demand along the top row 46 1000 1500 2000 2500 47 1 48 2 49 3 50 4 51 5 52 53 c. break FO 54 Copiers rented th SS Breakeven demand CO 56 S7 d. Prepare a line graph with profit from (b) above in Y-axis and number of copiers in X-axis. Plot one line for each demand. 59 (5 points) 59 60 61 62 63 64 2500 0.1 72 73 e. Suppose that the demand follows the probability distribution given below. Determine 74 the expected profits if number of copiers rented is 1, 2, 3, 4, or 5. (5 points) 75 Demand 1000 1500 2000 76 Probability 0.2 0.5 0.2 77 Sum of probabilities --> Expected No. of copiers profit 79 80 81 82 83 78 84 85f. Prepare a barchart for the expected profit with the number of copiers rented in the x-axis. 86 (5 points) 87 88 20 For the expected profit you must use SUMPRODUCT of probabilities and the profits from (b) You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year Modifications to problem #22 Assume that the variable cost to make copies starts at 5 cents if the daily volume is on average below 200. Then, assume that the variable cost for making copies goes down by 0.5 cents per copy for every additional 200 copies made per day on average, up to 1000 copies. In other words, the variable cost for making cost is $0.05 if the average number of copies made per day is 0 to 199, $0.045 if it is 200 to 399 copies, etc. Cost per copy remains a flat $0.025 for quantities 1000 and more. Setup the cost table in the range E10:F15 and use VLOOKUP in cell C28 to find the cost per copy. 4 10 S #1. Use problem description of 22 from the textbook (60 points) 6 Answer the following questions (a) to (t), ignore the questions from the text. 7a. Set up a model for annual profit. (40 points) 8 Inputs Variable cost per copy for copies made per day 9 Yearly rental cost per copier 5000 No. of copies Cost/copy Other monthly fixed costs 400 0-199 0.05) 11 Price per copy 0.1 200-399 0.045 12 Days per year 365 400-599 0.04 13 Months per year 12 600-799 0,035 14 Copies per copier per year 100000 800-999 0.03 15 1000+ 0.025 16 17 Decision variable HE 19 Copiers rented Ice 19 20 Uncertain variable 21 Daily demand 1000 Cel 22 4 Clast ch G27 > X | 8 22 23 24 Actual copies made Annual capacity Annual demand Actual copies made per year 25 400000 365000 365000 26 27 28 29 Variable cost of making copies per copy Actual copies made per day Variable cost of making copies per copy 1000 #N/A 30 31 32 Annual Revenue Annual revenue 33 34 35 36 Annual Cost Rental cost of copiers rented Other monthly fixed costs per year Variable cost of actual copies made per year Total cost 20000 4800 37 38 39 40 41 Annual profit G27 X F H AA 8 C D E 43 b. Using Data/Table determine the annual profit for the number of copiers and daily 44 demand given below. (10 points) 45 Number of actual copies along the first column and daily demand along the top row 46 1000 1500 2000 2500 47 1 48 2 49 3 50 4 51 5 52 53 c. break FO 54 Copiers rented th SS Breakeven demand CO 56 S7 d. Prepare a line graph with profit from (b) above in Y-axis and number of copiers in X-axis. Plot one line for each demand. 59 (5 points) 59 60 61 62 63 64 2500 0.1 72 73 e. Suppose that the demand follows the probability distribution given below. Determine 74 the expected profits if number of copiers rented is 1, 2, 3, 4, or 5. (5 points) 75 Demand 1000 1500 2000 76 Probability 0.2 0.5 0.2 77 Sum of probabilities --> Expected No. of copiers profit 79 80 81 82 83 78 84 85f. Prepare a barchart for the expected profit with the number of copiers rented in the x-axis. 86 (5 points) 87 88 20 For the expected profit you must use SUMPRODUCT of probabilities and the profits from (b) You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year