Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone help with this question? The objective of this exercise is to prepare a bid for the building of 1 5 Firefly smart missiles.

can someone help with this question?
The objective of this exercise is to prepare a bid for the building of 15 Firefly smart missiles. Your company built the Firefly prototype because of its experience building an earlier version called Fire smart missiles. When the Firefly missile manufacturing specifications were released, the government also released details of the $1,600,000 cost in building the Firefly prototype. In addition to direct materials, direct labor, and variable manufacturing overhead, other manufacturing overhead costs were 10% of total variable manufacturing costs. The $170,000 equipment purchased by the government will be made available to the selected contractor.
Direct materials $ 800,000
Direct labor (4,000 hours @ $100)400,000
Variable manufacturing overhead (4,000 hours @ $25)100,000
Other manufacturing overhead ($1,300,000 @ 10%)130,000
Purchase of reusable equipment 170,000
Total $ 1,600,000
With your highly skilled labor force, the 4,000 direct labor hours incurred for the prototype should not be assumed for each of the fifteen Firefly missiles because of anticipated learning effects from Fire. Assume that the next fifteen Firefly missiles can be built with the same amount of learning that occurred in the production of the sixteen Fire missiles, the earlier version of the Firefly. The direct labor hours for each of the sixteen Fire (i.e., the older version) missiles are listed below:
Unit # Individual Direct Labor Hours (DLH) For Fire
13900
22740
32660
41980
52320
62000
71900
81700
91950
101950
111760
121540
131680
141320
151500
161100
Cumutive method
1. Using EXCEL, enter the data for the Fire missiles into two columns labeled as Unit # and Individual Direct Labor Hours.
2. Add two more columns (1) Cumulative Direct Labor Hours and (2) Average Cumulative Direct Labor Hours (Cumulative divided by unit #).
3. Generate a scatter plot of Unit number (X) and Cumulative Direct Labor Hours.
4. With a right-click on a data point within the graph, select Add Trendline and then Power as the trend type from the drop-down menus.
5. Staying within Add Trendline, select the Options tab and check Display equation on chart and Display R-squared value on chart.
6. Now add another column to your data and label it as Individual Direct Labor Hours for Firefly.
7. For each unit, enter the formula aXb where a is the direct labor hours incurred for the prototype of Firefly (that is 4,000 hours), X is the unit number (your first column you entered), and b is the coefficient (including its sign if it is negative) from the trendline equation you estimated in step 4 above.
8. The total of units 2-16 from your estimation in step 6 above is the total direct labor hours for the Firefly missile. As a hint, this number should be substantially lower than the labor hours without a learning curve (think what that would be).
9. Prepare a cost sheet with and without learning curve. Include direct material, direct labor, variable manufacturing, and other manufacturing costs.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Fraud Prevention And Detection

Authors: Joseph T. Wells

5th Edition

1119351987, 9781119351986

More Books

Students also viewed these Accounting questions