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 80 percent learning rate. The effort for this contract will be substantial, running 50 hours for the first session. Your firm bills at the rate of $100/hour the overhead is expected to run a fixed $600 per session and you expect 20% profit. The customer will pay you a flat fixed rate of the revenue per session.

Calculate G H I ONLY

In Excel, create a table that has a session per row and the following 9 columns: a. Session number (1 8)

b. Time for creating the slides (use the Learning Rate formula):

c. Labor cost ($100/hour)

d. Overhead ($600 per session)

e. Total costs (Labor + Overhead)

f. Revenue (20% more than Total Costs)

g. Cumulative Cost

h. Cumulative Revenue (Use ((Total Revenue for all sessions)/8 sessions) (flat rate) for each session)

i. Profit (Cumulative Revenue Cumulative Cost)