Question: A manufacturer can sell product 1 at a profit of $20 per unit and product 2 at a profit of $40 per unit. Three units

A manufacturer can sell product 1 at a profit of $20 per unit and product 2 at a profit of $40 per unit. Three units of raw material are needed to manufacture one unit of product 1, and six units of raw material are needed to manufacture one unit of product 2. A total of 15,000 units of raw material are available. If any product 1 is produced, a setup cost of $20,000 is incurred; if any product 2 is produced, a setup cost of $35,000 is incurred.

a. Determine how to maximize the manufacturer’s profit.

b. If either of the products is not produced in the optimal solution, use SolverTable to see how much this product’s unit profit must be before it will be produced, and then use SolverTable again to see how much this product’s fixed cost must be decreased before it will be produced.

Step by Step Solution

★★★★★

3.41 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Production with setup costs Unit profits and setup cost... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1497_60b74124927ba_696585.pdf

180 KBs PDF File

1497_607c13687059b_696585.xlsx

300 KBs Excel File

1497_60b74124927ba_696585.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

Blindfold Technologies Inc. (BTI) is considering whether to introduce a new line of hand scanners that can be used to copy material and then download it into a computer. These scanners are expected...

1. Which of the following statements regarding aggregate planning is true? A) In a pure level strategy, production rates or work force levels are adjusted to match demand requirements over the...

A firm faces the following total product curves depending on how much capital it employs: a. Suppose that the firm currently employs 1 unit of capital and 3 of labor. Compute MRTSLK. Compute MPL....

3 : PLEASE SOLVE USING EXCEL A manufacturer can sell product 1 at a profit of $ 2 per unit and product 2 at a profit of $ 5 per unit. Three units of raw material are needed to manufacture 1 unit of...

A manufacturer can sell product 1 at a profit of $2 per unit and product 2 at a profit of $5 per unit. Three units of raw material are needed to manufacture 1 unit of product 1, and 6 units of raw...

ANSWER BY USING SOLVER IN EXCEL Q1. . -------------------------------------------------------------------------------------------------------------------------------------------------------...

3 A manufacturer can sell product 1 at a profit of $2/unit and product 2 at a profit of $5/unit. Three units of raw material are needed to manufacture 1 unit of product 1, and 6 units of raw material...

need note Performance Evaluation - Product A 10,000 ice p.u.) Direct Materials p. u.) Direct Wages p.u. at 2 p.hr. Variable Overhead p. u. ( ) Fixed Overhead ( ) p.u. Profit I Loss 40 10 8 8 16 -2...

On the basis of the utility formula which investment would you select if you were risk neutral? Use the following data in answeringCFA Utility Formula Data Expected Return, E(r) 12 15 21 .24 Standard...

Click on the "T accounts and Trial Balance" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each graded cell is highlighted in yellow. Select all...

A corporation that incurs a pre - tax operating loss must: Multiple Choice

6.4 This exercise is regarding Example 6.2 and its continuation in Section 6.3. (i) If an = np, show that (6.25) holds if and only ifp > 1/2. (ii) If an = ( n i=1 i ) , show that (6.25) holds if and...

a. Briefly explain the concept of support. b. If a taxpayer provides 50% or less of another persons support, is it possible for the taxpayer to claim a dependency exemption? Explain. c. Does support...

Under what circumstances must a taxpayer use a rate schedule instead of a tax table?

a. What determines who must file a tax return? b. Is an individual required to file a tax return if he or she owes no tax?

Sunland Company makes and sells umbrellas. The company is in the process of preparing its Selling and Administrative Expense Budget for the last half of the year. The following budget data are...

zivo 3G JAWWAL II. Aitc.birzeit.edu Anabtawi Company uses the periodic inventory method and had the following inventory information available: ( 8 points) Date Explanation Number Unit Total of Units...

Cooper Company has a direct materials standard of 2 gallons of input at a cost of $10.50 per gallon. During July, Cooper Company purchased and used 6.780 qalions, paying $46.600 The direct materials...