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

$$\frac{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.

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$)$:

$T_n=T_1{n}^r,r=log($ learning rate$)\frac{?}{log(2)}$

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$)$

During what session will you break even? $($When will the revenue $=$ costs?$).$ Plan to cut

and paste your Excel table into the Word document.

Suppose the planned cost for an activity in a smartphone design project was $$13,000$ but the

actual cost to date is $$12,000$ so far with only $80\%$ completion. What is the cost and schedule

variances? Is the client pleased or angry?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.

In Excel, create a table that has a session per row and the following $9$ columns:

a$.$ Session number $(18)$

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$)$

During what session will you break even? $($When will the revenue $=$ costs?$).$ Plan to cut

and paste your Excel table into the Word document.