Problem

SpreadsheetsSuppose that you are trying to come up with a budget for an engineering design...

Spreadsheets

Suppose that you are trying to come up with a budget for an engineering design project. Your salary is about $6,000 per month, and the technician with whom you work earns about $3,500 per month. You need $5,000 for materials and supplies, $1,200 for traveling to a sales meeting, and you have to contribute 8% of the direct dollars you spend to support clerical staff. In addition, you have to pay 80% of the entire contract cost, including the 8% clerical charges, to overhead that supports the general operation of the company. Write a spreadsheet program that can help determine the maximum number of person- months that you’ll be able to charge to the project if the total budget must not exceed $100,000. You’d like your technician to work at least half time on the project.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search