Outsource cost per frame and consumption

Assignment Help Operation Management

Reference no: EM13811371

Pettibone Traverse Lift in Baraga is trying to determine if they should be making some of their machine frames in-house versus buying them from external suppliers. Engineering has determined internal consumption rates of steel and labor to produce each frame plus a setup cost required to create the frame production line. There is a demand 26, 26, 52, 12 respectively for the Cary-Lift, Speed Swing, Extendo and Traverse model frames. Labor cost is $36 per hour with a $18 per hour overhead rate. There are 1,200 hours of labor available during the planning period. Currently steel cost $1.98 per pound. The following table describes the revenue per machine; outsource cost per frame and consumption for each frame if made internally.

	Cary-Lift	Speed Swing	Extendo	Traverse
Selling price	$36,000	$37,500	$48,000	$51,500

Sub 1 cost each	$8,900	$9,200
Sub 2 cost each			$10,500	$10,900
Steel (lbs)	3600	4400	5000	5400
Labor (hrs)	17	21	22	28
Setup cost	$22,100	$22,100	$36,000	$36,000

Create an Excel model to determine which models Pettibone should setup to make internally and buy to maximize revenue.

Reference no: EM13811371

Questions Cloud

Calculate and interpret the two profit variances : Consider the following 2012 data for newark general hospital (in millions of dollars) simple budget flexible budget actual results. calculate and interpret the two profit variances. calculate and interpret the two revenue variances. calculate and int..

Describe payment of government contractors : Predict the confusion that might occur under the clauses in question. Suggest language that would clarify each of these payments clauses for a contractor(s). Provide a rationale for your response.

What is the cost percentage of a new common stock issue : What is the cost percentage of a new common stock issue?

How is recursion and iteration used in programming : How is recursion and iteration used in programming? Provide examples of the various types of recursion and iteration and explain why each is used

Outsource cost per frame and consumption : The following table describes the revenue per machine; outsource cost per frame and consumption for each frame if made internally.

What are application programming interfaces : What are application programming interfaces (APIs)? Identify several APIs that could or do exist in the software developed and maintained by a company for which you currently work or would like to work

Examine concept of federalism to shape american political : Provide three examples of how federalism has evolved from its origins to the American political system in place today. Examine three to five factors that have allowed the concept of federalism to shape American political behavior.

Approximate the before tax cost : Approximate the before tax cost using the following

Provide an analysis of how the erie company ended its fiscal : An essay to analyze the Pro-Forma data from Practice Round 1 (Foundations Simulation). Provide an analysis of how the Erie Company ended its fiscal year. Items to discuss are inventory, meeting customer needs, production, capacity, marketing, and de..

User Account

All Pages