Demand forecasts-production planning strategies

Assignment Help Operation Management

Reference no: EM131127011

Mama's Stuffin' is a popular food item during the fall and winter months, but it is marginal in the spring and summer. Use the following demand forecasts and costs to determine which of the following production planning strategies is best for Mama's Stuffin': Month Demand Forecast March 2000 April 1000 May 1000 June 1000 July 1000 August 1500 September 2500 October 3000 November 9000 December 7000 January 4000 February 3000 Overtime capacity per month Regular production Subcontracting capacity per month Unlimited Regular production cost $30 per pallet Overtime production cost $40 per pallet Subcontracting cost $50 per pallet Holding cost $2 per pallet Beginning workforce 10 workers Production rate 200 pallets per worker per month Hiring cost $5000 per worker Firing cost $8000 per worker

Design a production plan for Mama's Stuffin' using linear programming and Excel Solver.

Reference no: EM131127011

Questions Cloud

Eliminating middlemen-wholesalers and distributors : Distribution channel members are often criticized for being inefficient and for causing consumers to pay higher prices than they would if there were no distribution channel members (eliminating middlemen, wholesalers, distributors, etc.). How would y..

What conclusions can be drawn from the horizontal analysis : Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for 2010 when compared with 2009. Round to one decimal place.

A scientist desires to estimate the proportion : Suppose that a scientist desires to estimate the proportion ? of monarch butterflies with a special type of marking on their wings. Suppose he captures monarch butterflies one at a time, and at the end of the day the scientist had captured 60 mona..

What is the name of the first satellite sent into space : What is the name of a place that uses telescopes and other scientific equipment to research space and astronomy? What is the name of NASA's most famous space telescope? Earth is located in which galaxy? What is the name of the first satellite sent in..

Demand forecasts-production planning strategies : Mama's Stuffin' is a popular food item during the fall and winter months, but it is marginal in the spring and summer. Use the following demand forecasts and costs to determine which of the following production planning strategies is best for Mama's ..

Explanation of how the theories are similar to one another : Create a 10- to 12-slide Microsoft® PowerPoint® presentation, including detailed speaker notes, on traditional and contemporary psychodynamic theories. Include the following for each theory: covering the traditional psychodynamic theories of Freud..

How much total energy would be released by complete fission : Express your answer in units of Joules. A typical small town might use about 29.5 MW of power, on average. How long, in days, would it take such a town to use the amount of energy calculated above?

What is the closest planet to the sun : What is the closest planet to the Sun? What is the name of the 2nd biggest planet in our solar system? What is the hottest planet in our solar system

Balance sheet data for hanes company on december 31 : Prepare a comparative balance sheet for 2010 and 2009, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity.

User Account

All Pages