Log in

View Full Version : How to present this as an Excel spreadsheet


ldeen
Nov 28, 2011, 10:13 PM
Your firm designs PowerPoint slides for computer training classes, and you have just received a request to bid on a contract to produce the slides for an 8-session class. From previous experience, you know that your firm follows an 85 percent learning rate. For this contract it appears the effort will be substantial, running 50 hours for the first session. Your firm bills at the rate of $100/hour and the overhead is expected to run a fixed $600 per session. The customer will pay you a flat fixed rate per session. If your nominal profit margin is 20 percent, what will be the total bid price, the per session price, and at what session will you break even

How do I present this in an excel spreadsheet.

ScottGem
Nov 29, 2011, 04:58 AM
Thank you for asking our help with your homework assignment. However, there are some rules we have for doing so.
Do not simply retype or paste a question from your book or study material

We won't do your homework questions for you. You were given the assignment for you to learn.

If you come up with your own answer or process and post it for us to critique that is acceptable. If you have some SPECIFIC questions that you couldn't find or didn't understand, we may help with that.
But this is your assignment, so show us you have at least attempted to complete it on your own.

Thank you.