Questions
Ben Parker, Executive Producer for Epic Productions Film Company, is trying to decide when to reorder...

Ben Parker, Executive Producer for Epic Productions Film Company, is trying to decide when to reorder the 35 millimeter film his photographers use for publicity photos. 35 mm film is used by the Epic photographers at a fairly constant rate, with an average demand during leadtime of 75 rolls and a variance of 25 rolls. (Ben would agree that the daily usage of 35 mm film seems to be normally distributed.) The leadtime on an order of 35 mm film is 5 days, and there are 250 working days in the year.

a. Suppose Ben decides to reorder 35 mm film when there are 86 rolls left in stock. How much safety stock is implied by this reorder point?

b. What is the service level implied by Ben’s reorder point of 86 rolls?

c. If a publicity photographer runs out of film, it is usually impossible to arrange a future photo session with the movie stars who are being photographed. Keeping this in mind, Ben Parker decides that he wants a service level of 97.72% for his 35 mm film inventory policy. What is his reorder point for 35 mm film?

d. If Ben decides to have extra 4 rolls of 35 mm as safety stock, what is the ROP? And what is the probability of stock-out?

     

In: Operations Management

write a two-page personal statement indicating your professional experience, educational goals, professional interest; academic achievements, honors,...

write a two-page personal statement indicating your professional experience, educational goals, professional interest; academic achievements, honors, awards, publications and extracurricular activities.

In: Operations Management

1. A tailor in Huntsville, Alabama makes wool sports coats and slacks. He is able to...

1. A tailor in Huntsville, Alabama makes wool sports coats and slacks. He is able to get a shipment of 300 square yards of wool cloth from Atlanta, Georgia each week to make coats and slacks, and he has 400 labor hours to make them each week. A coat requires 4 square yards of wool and 5 hours to make, and a pair of slacks requires 3 square yards of wool and 5 hours to make. The tailor earns $30 in profit from each coat he makes and $25 from each pair of slacks. He wants to know how many coats and pairs of slacks to make each month to maximize profit. (a) Formulate an integer linear programming model for this problem. That is, you will define the decision variables, state the objective function, and thirdly, state the constraints.

(b) Use the computer software (QM for Windows or its equivalent) to determine the integer optimal solution to this problem by determining;

(i) The optimal number of coats.

(ii) The optimal number of pairs of slacks.

(iii) The optimal profit.

In: Operations Management

The number of internal disk drives? (in millions) made at a plant in Taiwan during the...

The number of internal disk drives? (in millions) made at a plant in Taiwan during the past 5 years? follows: ??????????????????????????????????????????????????????????????????? Year Disk Drives

1      138

2       160

3         190

4       202

5 216

?a) Using simple linear regression?, the forecast for the number of disk drives to be made next year? = 240.6 disk drives

?b) The mean squared error? (MSE) when using simple linear regression? ____________drives2

c) The mean absolute percent error (MAPE) when using simple linear refression=__________%

I was able to wrk through A), but how to I calculate b & c?

In: Operations Management

Write a post for the Discussion Forum on this topic, addressing the questions below. Unless otherwise...

Write a post for the Discussion Forum on this topic, addressing the questions below. Unless otherwise specified, each part should be 1–2 paragraphs or several bullet points in length. PART 1: COMPETITIVE ADVANTAGES List the competitive advantages of the product, service or organization and focus on: the things that make it different from competitors in positive ways.

In: Operations Management

Digital Imaging (DI) produces photo printers for both the professional and consumer markets. The DI consumer...

Digital Imaging (DI) produces photo printers for both the professional and consumer markets. The DI consumer division recently introduced two photo printers that provide color prints rivaling those produced by a professional processing lab. The DI-910 model can produce a 4? × 6? borderless print in approximately 37 seconds. The more sophisticated and faster DI-950 can even produce a 13? × 19? borderless print. Financial projections show profit contributions of $42 for each DI-910 and $87 for each DI-950.

The printers are assembled, tested, and packaged at DI's plant located in New Bern, North Carolina. This plant is highly automated and uses two manufacturing lines to produce the printers. Line 1 performs the assembly operation with times of 3 minutes per DI-910 printer and 6 minutes per DI-950 printer. Line 2 performs both the testing and packaging operations. Times are 4 minutes per DI-910 printer and 2 minutes per DI-950 printer. The shorter time for the DI-950 printer is a result of its faster print speed. Both manufacturing lines are in operation one 8-hour shift per day.
Managerial Report

Perform an analysis for Digital Imaging in order to determine how many units of each printer to produce. Prepare a report to DI's president presenting your findings and recommendations. Include (but do not limit your discussion to) a consideration of the following:

1. The recommended number of units of each printer to produce to maximize the total contribution to profit for an 8-hour shift. What reasons might management have for not implementing your recommendation?

2. Suppose that management also states that the number of DI-910 printers produced must be at least as great as the number of DI-950 units produced. Assuming that the objective is to maximize the total contribution to profit for an 8-hour shift, how many units of each printer should be produced?

3. Does the solution you developed in part (2) balance the total time spent on line 1 and the total time spent on line 2? Why might this balance or lack of it be a concern to management?

4. Management requested an expansion of the model in part (2) that would provide a better balance between the total time on line 1 and the total time on line 2. Management wants to limit the difference between the total time on line 1 and the total time on line 2 to 30 minutes or less. If the objective is still to maximize the total contribution to profit, how many units of each printer should be produced? What effect does this workload balancing have on total profit in part (2)?

5. Suppose that in part (1) management specified the objective of maximizing the total number of printers produced each shift rather than total profit contribution. With this objective, how many units of each printer should be produced per shift? What effect does this objective have on total profit and workload balancing?

In: Operations Management

how to fill out a bcg matrix

how to fill out a bcg matrix

In: Operations Management

Analyze amazon, Walmart and eBay using the value chain and competitive forces model


Analyze amazon, Walmart and eBay using the value chain and competitive forces model

In: Operations Management

Honda uses statistical process control to monitor and improve a variety of processes. Employees collect data,...

Honda uses statistical process control to monitor and improve a variety of processes. Employees collect data, and then analyze it using statistical process control charts. They can make adjustments if needed. The statistical process control charts enable workers to understand precisely how processes are working and anticipate problems before they occur. One interesting use is in monitoring the effort required to close a door. Honda monitors the speed of the door required to make it latch by using a special device that measures door speed in mph. A technician closes the door repeatedly, using different amounts of force, to determine the speed required to make it latch. Data are collected and plotted on an X-bar chart. Why are these data collected? What is the importance, from a quality standpoint, of knowing the door closing speed ?

In: Operations Management

How can scenario planning be used in building an organization’s strategy? Are there certain industries that...

How can scenario planning be used in building an organization’s strategy? Are there certain industries that could benefit more from scenario planning than other industries?

In: Operations Management

Write a letter to the operations manager of your company who has omitted important procedures in...

Write a letter to the operations manager of your company who has omitted important procedures in operations. You work as a manufacturing operations analyst in an aerospace company

In: Operations Management

write a paragraph about 5.2 How and why management styles vary around the world

write a paragraph about 5.2 How and why management styles vary around the world

In: Operations Management

What is your current approach to personal evaluation and how do you plan to sustain teachability...

What is your current approach to personal evaluation and how do you plan to sustain teachability and encourage evaluation in your life while completing the master’s program?

In: Operations Management

15 ways that a company can keep their workers engaged in an organisation

15 ways that a company can keep their workers engaged in an organisation

In: Operations Management

Aggregate Planning Given the projected demands for the next six months, prepare an aggregate plan that...

Aggregate Planning

Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time, overtime, subcontract and backorders. Regular time is limited to 150 units per month (Cost per Unit = $20 ). Overtime is limited to a maximum of 30 units per month (Cost per Unit =$30). Units purchased from the subcontractor (Cost per Unit = $26 ) cannot exceed 40 per month and the total purchases from the subcontractor over the 6 month period cannot be over 150 units. Backorders cannot exceed 70 units in any given month (Cost per Unit = $1 ) and must be no more than 10 in Period 6. Average Inventory Holding cost per Unit = $4. Forecasted Demand as well as Beginning and desired Ending Inventory are listed in the table below.

Month

1

2

3

4

5

6

Total

Regular Output

Overtime Output

Subcontract

Beginning Inventory

40

Total Available for Sale

Less Forecast

200

190

290

190

160

160

Plus Backlog-Current Period

Less Backlog-Previous Period

Ending Inventory

10

Average Inventory


Required:
Find the Minimum Cost Production Plan by Creating a Spreadsheet in Excel. Use Solver to find the Minimum Cost Solution. Leave a copy of your Spreadsheet in the DropBox.

Total Cost Month 1 =

Hint: Range (3300 ,3380 )
Total Cost Month 2 =

Hint: Range (3970 ,4050 )
Total Cost Month 3 =


Total Cost Month 4 =


Total Cost Month 5 =

Hint: Range (4350 ,4510 )
Total Cost Month 6 =


Total Cost All Periods =

Hint: Range (24220 ,26120 )
Answer Format: No Dollar ($) signs or commas --- Answers should be whole numbers.

In: Operations Management