Prepare worksheet that indicate for a range of order amounts

Assignment Help Supply Chain Management

Reference no: EM13906735

A builder can obtain concrete from any of four suppliers.

Supplier W charges £12 per ton for the concrete and a fixed delivery charge of £50 regardless of the quantity ordered.

Supplier X charges £14 per ton including delivery.

Supplier Y charges £11.5 per ton for the concrete and a fixed delivery charge of £100. However, for orders in excess of 40 tons delivery is free from supplier Y.

Supplier Z charges £11 per ton for the concrete, £2 per ton delivery charge and a fixed delivery charge of £20.

(a) Prepare a worksheet and a graph that will indicate, for a range of order amounts, the total cost of concrete ordered from each of the four suppliers.

(b) Prepare a worksheet and a graph that will indicate, for a range of order amounts, the cost per unit of concrete ordered from each of the four suppliers.

Reference no: EM13906735

Questions Cloud

What is the character of the gain : In 2006, TYR Inc. purchased a warehouse for $295,000. This year, the corporation sold the warehouse to Firm D for a cash payment of $80,000 and D’s assumption of a $225,000 mortgage. Through date of sale, TYR claimed $72,000 of straight-line deprecia..

Passes through two processes-mixing and molding : Ralph, Inc. manufactures a product that passes through two processes: mixing and molding. All manufacturing costs are added uniformly in the Mixing Department (i.e., same completion percentage applies to materials and conversion costs). Calculate the..

About the education tax credit : Bernadette, a long time client of yours, is an architect and president of the local Rotary chapter. to keep up-to-date with the latest developments in her profession, she attends continuing education seminars offered by the architecture school at sta..

Utilization of checked exceptions : There are instances where the utilization of checked exceptions are more appropriate than unchecked exceptions in exception handling. Provide an example of each exception not mentioned in the article. Explain why each type of exception is more app..

Prepare worksheet that indicate for a range of order amounts : Prepare a worksheet and a graph that will indicate, for a range of order amounts, the total cost of concrete ordered from each of the four suppliers.

What attributable risk of wasting associated with diarrhea : Nutritional stutas of two groups of children was assessed at the end two month interval. out of 80 children who had chronic diarrhea, 22 were wasted while out of 84 children who did not have diarrhea, 3 were wasted. find the incidence rates in the..

Describe how a business you have worked for was organized : Describe how a business you have worked for was organized

Hierarchy of controls are most applicable to system safety : What levels of the hierarchy of controls are most applicable to system safety? Are any levels not useful when applying system safety? Provide one or more examples that support your response.

Step and size of the screen : How to draw a square spiral with specified initial coordinates, step and size of the screen? Let the spiral start drawing from point with coordinates (startX, startY) in the row: to the right, up, left, down (size of the screen 800x600).

User Account

All Pages