You have been asked to price out a project for a customer based on a firm-fixed price. Table below shows the numbers that you arrived at in determining the bid amount for the project that should be submitted.
As you know, before a bid is submitted to a potential customer, the bid must be reviewed by a committee of senior managers that can question the validity of the numbers as well as look for “hidden” costs that may have been omitted. For each of the situation below, revise your table and re-calculate the final price to be submitted to the customer.
State your assumptions, if any, and complete the Revised Amount column accounting for all the amounts.
Item # |
Category |
Type of cost |
Original Amount |
Revised Amount |
1 |
Direct Labor |
Engineering |
$88,200 |
|
Manufacturing |
$52,500 |
|||
2 |
Indirect Labor |
Subcontractors |
$10,000 |
|
Consultants |
$2,000 |
|||
3 |
Total Labor |
$152,700 |
||
4 |
Corporate G&A |
10% of Total Labor |
$15,270 |
|
Total Cost |
$167,970 |
|||
Target Profit |
20% of Total Cost |
$33,594 |
||
Bid Amount |
$201,564 |
|||
Item # |
Category |
Type of Cost |
Original Amount |
Revised Amount |
1 |
Direct Labor |
Engineering |
$88,200.00 |
$88,200.00 |
Manufacturing |
$52,500.00 |
$52,500.00 |
||
2 |
Indirect Labor Cost |
Subcontractors |
$10,000.00 |
$10,000.00 |
Consultants |
$2,000.00 |
$2,000.00 |
||
3 |
Total Labor Cost |
$152,700.00 |
$152,700.00 |
|
4 |
Corporate G&A |
10% of Total Labor |
$15,270.00 |
$15,270.00 |
5 |
Shipping Cost |
Insurance, Packaging and handling |
$0.00 |
$800.00 |
6 |
Capital Cost |
$0.00 |
$6,000.00 |
|
Total Cost |
$167,970.00 |
$174,770.00 |
||
7 |
Profit |
Target profit is 20% of total cost |
$33,594.00 |
$34,954.00 |
8 |
Summary Cost |
Management for 10% of total cost |
$0.00 |
$17,477.00 |
9 |
Travel |
Airfare, ground travel, meals and lodging |
$0.00 |
$4,500.00 |
Covid-19 Safety Kit |
$0.00 |
$5,400.00 |
||
Bid Amount |
$201,564.00 |
$227,201.00 |
5. For shipping cost, $800 for total deliverables (as will be included in profit.
6. Capital cost of $6000 (as will be included in profit)
7. Profit will be calculated on the total cost accountable for providing the service to the company. Hence it will include direct and indirect labor, shipping and capital cost.
8. Summary profit is 10% of the total cost. (as the management will have this, the profit wont be added to this)
9. For travel, we have to include $1500 per trip for 3 trips (total $4500). Also the covid-19 kit is $1800 per trip for 3 trips (total $5400). Travel cost is for the employees, hence wont be counted in profit. Hence this will be added after calculating the profit.
Profit cost includes only the cost that will be utilized in the whole process. Hence the profit includes Direct and indirect labor, shipping cost, Corporate G&A, capital cost only. The travel cost, and summary cost is utilized on the employees and hence don’t participate in the profit part.
IF YOU LIKE THE ANSWER, PLEASE GIVE AN UP-VOTE OR THUMB UP. THIS WILL ENCOURAGE ME TO ANSWER MORE!!
You have been asked to price out a project for a customer based on a firm-fixed...
_NEED EXCEL PLEASE! You are an experienced machinist with a small tool shop. You have been asked to submit a bid to produce twelve (12) special clamps for a new die that is under construction. You estimate that the material costs (metal and fasteners) for each clamp are $150.00. You also estimate that 10.00 labor hours are needed to produce the first clamp. The value of your labor is $50/hour. From similar orders in the past, you estimate that there...
Assignment Details Scenario You have been asked to be the project manager for the development of an information technology (IT) project. The system to be developed will allow a large company to coordinate and maintain records of the professional development of its employees. The company has over 30,000 employees who are located in four sites: Florida, Colorado, Illinois, and Texas. The system needs to allow employees to locate and schedule professional development activities that are relevant to their positions. Sophisticated...
_NEED EXCEL PLEASE! You are an experienced machinist with a small tool shop. You have been asked to submit a bid to produce twelve (12) special clamps for a new die that is under construction. You estimate that the material costs (metal and fasteners) for each clamp are $150.00. You also estimate that 10.00 labor hours are needed to produce the first clamp. The value of your labor is $50/hour. From similar orders in the past, you estimate that there...
The Speedy Wind Turbine Company (SWTC) won a bid to build ten wind turbines sold to a long time loyal customer. The fourth wind turbine was completed in 600 hours. The crew working on the project have demonstrated a 75% learning curve. a. How long should it take the same crew to finish the last six turbines? (5 points) b. There are 4 crewmembers working on the project. The average labor cost per hour per crewmember, including health benefits and...
From the last question.... You are an experienced machinist with a small tool shop. You have been asked to submit a bid to produce twelve (12) special clamps for a new die that is under construction. You estimate that the material costs (metal and fasteners) for each clamp are $150.00. You also estimate that 9.49 labor hours are needed to produce the first clamp. The value of your labor is $50/hour. Your potential customer is receptive to your bid from...
Saratoga Company manufactures jobs to customer specifications. The company is conducting a time driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs Number of employees Average salary per employee Veeks of employment per year Hours worked per week Practical capacity percentage 85 Requisition Processing Evaluation Bid Minutes per...
Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs: 16 $ 25,000 Number of employees Average salary per employee Weeks of employment per year Hours worked per week Practical capacity percentage 52 40 85% Requisition Processing...
Extended Learning Exercise. You have been asked to prepare a quick estimate of the construction cost for a coal-fired electricity generating plant and facilities. A work breakdown structure (levels one through three) is shown in the table below EE! Click the icon to view the work breakdown structure Click the icon to view the available information What is your estimated 2019 cost for building the coal-fired generating facility? Summarize your calculations in a cost estimating worksheet, and state the assumptions...
In working on a bid for project you have determined that $245,000 of fixed assets will be required and that they will be depreciated straight-line to zero over the 5-year life of the project, and you can get $23,200 for these fixed assets at the end of 5 years. You will also need to increase net working capital by 15,000 initially and recoup the investment in net working capital at the end of the project. You have also determined that...
Question 2: You have just been assigned as Project Manager (PM) to the Kuraiz-Reconda Fiber Optic Cable (KRFOC) project. You are preparing your cost estimate for the project and your Project Engineer (PE) tells you it will take 425 hours to complete the design effort. Your Finance Manager (FM) tells you that engineering labor is $125 an hour. Fortunately for you, unfortunately for them, you are a graduate of yur university, specializing in project management in general and advanced project...