Question: answer using EXCEL Pe Es 12. Your firm designs PowerPoint slides for computer training classes, and you have just received a request to bid on

Pe Es 12. 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-ses- sion 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, run- ning 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? 14. Create the spreadsheet for Problem 12 on page 144. Answer the question by using Excel with comments As always put your name on the spreadsheet. Submit the .xlsx to the dropbox
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
