Build the excel spreadsheet for the level operating

Assignment Help Business Management

Reference no: EM13841287

The Good and Rich Candy Company makes a variety of candies in three factories worldwide.Its line of chocolate candies exhibits a highly seasonal demand pattern with peaks during thewinter months (for the holiday season and Valentine's Day) and valleys during the summermonths (when chocolate tends to melt and customers are watching their weight). Given thefollowing costs and quarterly sales forecasts, determine whether a) level productionstrategy or b) chase production strategy would more economically meet the demand forchocolate. (Use Hiring Cost= $100 per worker, Firing Cost = $500, Inventory carrying cost =$0.50 per pound per quarter, Regular production cost per pound = $2.00, Production per employee = 1,000 pounds per quarter, Beginning Workforce = 100 workers).

Quarter: Forecast Sales (lb)

Spring 80,000

Summer 50,000

Fall 120,000

Winter 150,000

2. Formulate a linear programming model for the problem above that will satisfy demand forGood and Rich chocolate candies at minimum cost. Solve the model with Excel Solver.Compare the solution with Chase and Level strategies you obtained.

3. Build the Excel Spreadsheet for the Level Operating Plan with Constant Number ofEmployees example in Manufacturing Planning and Control for SCM (Jacobs et al.) on page132. Keep your excel macros and change the Sales Forecast data for each month in the planto the average of the data provided in the example. Compare total costs.

Reference no: EM13841287

Questions Cloud

Comprehensive marketing plan researching : This week you will continue your comprehensive marketing plan researching the SAME company that you researched in previous units. Again, utilizing the CSU Online Library, you will research the various elements of the marketing plan as it relates to t..

In the reeves v c. h. robinson worldwide inc : In the Reeves v C. H. Robinson Worldwide Inc. case write a 800 to 1000 word essay in APA format. Analyze each element of the case to include applicable defenses and basis for the court ruling. Analyze the possible liability in this case if the sex..

A theory is expanded and enhanced by the addition : 34c: A theory is expanded and enhanced by the addition of: 1 verified principles. 2 wild guesses. 3 random data.

Explain why talking with buyers rather than talking : Explain why talking with buyers rather than talking at buyers is critical to success in selling. Explain the difference in the uses of probing, evaluative, tactical, and reactive questions in trust-based selling.

Build the excel spreadsheet for the level operating : Build the Excel Spreadsheet for the Level Operating Plan with Constant Number ofEmployees example in Manufacturing Planning and Control for SCM (Jacobs et al.) on page132. Keep your excel macros and change the Sales Forecast data for each month in th..

A business when developing software : Why is the cost of finding errors important to a business when developing software?

Hispanic immigrant from central america : Inez Salcedo, is a 25-year-old Hispanic immigrant from Central America who is about to take her new infant home from the hospital. Her husband arrives to pick them up in their 1996 small SUV, but they do not have a car seat for the infant. In addi..

How many ram chips are there per memory word : How many RAM Chips are there per memory word? How many address bits are needed for each RAM Chip? How many banks will this memory have? How many address bits are needed for all memory?

What did you learn about your consumption patterns : What did you learn about your consumption patterns? Were they examples of regular weekdays? How did you keep track of what you ate

User Account

All Pages