Compute the number of square inches of wasted material

Assignment Help Operation Management

Reference no: EM131843817

Joe R. earns extra money as a wedding photographer. He delivers prints with dimensions 4x6, 5x7 or 8x10. He uses two types of photographic paper 8x10 and 8x12 and cuts them to accommodate the 4x6 and 5x7 prints. He has identified the patterns in the table below using the notation Xij where i=1 for patterns cut from an 8x10 sheet and i=2 for patterns cut from 8x12 sheets. 8x10 sheets cost $1 and 8x12 sheets cost $1.25.

Pattern	4x6	5x7	8x10
X10	0	0	1
X11	0	1	0
X12	0	2	0
X13	1	0	0
X14	2	0	0
X15	3	0	0
X16	1	1	0
X20	0	0	1
X21	0	1	0
X22	0	2	0
X23	1	0	0
X24	2	0	0
X25	3	0	0
X26	4	0	0
X27	1	1	0
X28	2	1	0

Joe has just received an order for the following numbers of prints:

136 4x6 prints

41 5x7 prints

17 8x10 prints

1) Assuming leftover portions of sheets have no value, find the number of sheets Joe must buy to meet this order. Compute the number of each print size that are left over.

2) Compute the number of square inches of wasted material for each pattern. Reformulate and solve the problem to minimize the total amount of wasted material.

Please post Excel solution with clear formulas.

Reference no: EM131843817

Questions Cloud

Discussing wellness and for communicating : Effective strategies for discussing wlellness and for communicating with others who are going through the grief process and the importance of applying those str

Add a remote method that displays the mode : Add a state variable member to Remote class that describes whether remote control is in normal or interactive mode. Add a Remote method that displays the mode.

To which situation does this fit and what should the rop be : Monthly demand for the pickles is normally distributed with mean 15 (jars) and standard deviation 6.

Example of a problematic stereotype : Explain why stereotypes can be a problem and give an example of a problematic stereotype.

Compute the number of square inches of wasted material : Compute the number of square inches of wasted material for each pattern. Reformulate and solve the problem to minimize the total amount of wasted material.

Perception process selection : In the 3 steps of perception process selection, organization, and interpretation list one example of each and explain how it fits into that particular step

Time than the content of the message : Content oriented (soak up many perspectives on an issue or Time-Oriented ( more concerned about time than the content of the message.

How many observations should be taken to estimate : How many observations should be taken to estimate the true actual time within 10 percent with a 95 percent confidence level?

How can people maintain civility when attempting to persuade : How can people maintain civility when attempting to persuade others? What are some ethical ways people might respond when faced with an uncivil response from an

User Account

All Pages