Question: Fast purchasing problem Fast has four plants that make discs for conventional disc drives. A major raw material for the plants is copper. Fast buys

Fast purchasing problem Fast has four plants that make discs for conventional disc drives. A major raw material for the plants is copper. Fast buys the copper from five different companies. How much copper should Fast buy to minimize the total cost of the copper and shipping? Company 1 Company 2 Company 3 Company 4 Company 5 Copper prices (per ton) $50 $47 $48 $45 $43 Cost of shipping from companies to plants (per ton) Company 1 Company 2 Company 3 Company 4 Company 5 Plant 1 $9 $4 54 Plant 2 $7 $6 $3 $2 $4 Plant 3 $7 $3 $7 $5 $2 Plant 4 58 $4 $5 $6 $7 Amounts of copper to buy (tons) Total Bought for each Plant Company 1 Company 2 Company 3 Company 4 Company 5 plant Demand Plant 1 0 0 0 0 430 Plant 2 0 0 0 0 0 350 Plant 3 0 0 0 0 0 400 Plant 4 0 0 0 0 0 370 Total Purchased from each company Available supply 350 250 210 300 490 Cost of Copper Cost of shipping Total cost Total Cost = Total Cost of Copper + Total Shipping CostSolver Parameters X Set Objective: SG$27 To: Max O Min O Value Of: 0 By Changing Variable Cells: SB$18:5GS21 t Subject to the Constraints: $B$18:5F$21 > = 0 Add SB$22

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Stand Alone Project all the information is attached in word format. Stand-Alone Project: Case Study in Managerial Accounting You should begin working on the Stand-Alone Project early in the course....

Fast needs a lot of copper to make its traditional hard discs. Currently, Fast buys copper for its four plants from five different companies. These companies have submitted their bids in the form of...

Question: Describe Kencos CI system; compare this to process change using traditional budgeting Abstract This case illustrates a strategy-driven costing system combining ideas from lean management...

Question: Compare how the strategy for lean manufacturing and Kencos system lead to unique production and information systems. Include in your discussion the design characteristics underlying each...

Question: How do Kencos manufacturing and reporting systems support its key success factors (key strategic components) of product quality, on-time delivery, and cost? Abstract This case illustrates a...

Question: How would cost-plus pricing change continuous improvement at Kenco? (10 marks) Compare and explain fully the strategic and operational implications of cost-plus pricing versus Kencos...

Question: Kencos organizational design borrows ideas from both lean management and the Theory of Constraints. Describe the unique characteristics of Kencos design and accounting system that are...

CASE STUDY HOME DEPOT CASE This case has been produced for assessment purposes only. It has been sourced directly from the articles indicated within the bibliography, which are available in the...

What is the difference between a hacker and a cracker?

Refer to the example of a written management representation letter illustrated in Exhibit 155. Required: a. What are the assumptions about the audit engagement in this management representation...

How long does a mechanic's lien typically stay on a property if it remains uns 3 0 days year 9 0 days indefinitely until paid or released

Discuss qualitative research designs in detail?