Assignment:
George is planning to have a one-day stand at the Boy Scout event. He is planning to sell his entire inventory by the end of the day. He has 200 cans of lemonade, 300 cans of Coke, 400 small bottles of Coke. Each can cost him 50 cents. He wants to sell at least 100 lemonade and 200 Coke Cans. The cost of renting the stand for one-day is $100. He wants to price lemonade at $1 each, coke can at $1.5 and bottles at $2. Using Excel Solver calculate the number of individual items he should attempt to sell to maximize his profit.
(Note: Include the rental cost in the price of the individual items)
Using the dataset below spreadsheet, calculate the
- Linear Curve
- Power Curve
- Exponential curve
- Predict the processing time if the # of instructions to the CPU increases to 10K if linear curve is adopted. can you show your work in excel and explan your answer thnaks.
| CPU Time Prediction |
| Business Day |
# of instructions |
CPU Time |
| 1 |
2200 |
610 |
| 2 |
1780 |
500 |
| 3 |
1300 |
380 |
| 4 |
999 |
360 |
| 5 |
1293 |
450 |
| 6 |
9623 |
890 |
| 7 |
9763 |
300 |
| 8 |
9800 |
1302 |
| 9 |
9500 |
928 |
| 10 |
9623 |
449 |
Provide complete and step by step solution for the question and show calculations and use formulas.