This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: EXCEL Homework Your EXCEL Homework will put your EXCEL skills to test. In the case of this assignment, the word "better" means the less money paid overall for the items! Plan your spreadsheets out carefully, show all work, and think through all aspects of the problem It will also help you to read the entire assignment before starting to solve the problem. Instructions You have a position with the Flickering Light Candle Company and management needs help finding a loan for an emergency project. A client needs 1,000,000 candles and in order to fill the order you will need extra supplies. You find out that you need 500,000 pounds of wax which costs $.10 (10 cents) per pound and you will also need 100,000 yards of wick which costs $.50 (50 cents) per yard. Once you arrive at the total price, you find out you cannot negotiate the price any lower. Before you sits two offers from local banks offering you financing deals. You must use your Excel program to figure which of the two deals is "better" for you. Open a new Excel spreadsheet. You will save this file immediately as "loan.xlsx” Bank 1 Change the "sheet1" tab to read "bank1". Place your name in cell A1 and your section number in cell A2. Type in the current date in cell A3....
View Full Document
- Spring '11
- Flickering Light Candle Company