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

Reviews

Write a Review

Business Management Questions & Answers

  Business question global business environmentthe city of

business question global business environmentthe city of townscape has been experiencing a much accelerated growth

  Sales tracking and customer relations analyses

What are your recommendations for resolving any data redundancy issues observed in the workbook and what are your recommendation regarding what other data should be collected to improve decision making for BTFC?

  Performance management and organizational

performance management and organizational effectivenessassess the strengths and weaknesses of the performance

  How would you enter a nested function in a cell

How would you enter a nested function in a cell to follow this :If the employee is international and sold over $200,000 they receive 5% bonus, all other employees receive 3%.

  What is the exchange rate among the us dollar

It is likely you have thought of an idea(s) for entrepreneurial new-economy ventures.what is the exchange rate among the U.S. dollar and the Mexican peso?

  Express the outcomes expected from implementing

express the outcomes expected from implementing your recommendations. Your primary text and journal/website research must be used as a reference to support your analysis.

  Risk management plan for project x

Write your risk management plan for Project X, you're going to make a formal presentation to the project stakeholders. Refer to the list you discussed with the project team during the second week of this project.

  Explain advanced markets and emerging markets

From a business manager's point of view, what are some of the most important difference between advanced markets and emerging markets

  Decide on the locations for two new warehouses

Georgia Atlantic Corporation needs to decide on the locations for two new warehouses. The candidate sites are Philadelphia, Tampa, Denver, and Chicago. The following table provides the monthly capacities and the monthly fixed costs for operatin..

  Employee reward programsemployee reward programs are one

employee reward programsemployee reward programs are one method of motivating employees to change work habits and key

  A restaurant offers a customer''s choice sandwich

A restaurant offers a customer's choice sandwich for which the customer stipulates the types of bread, meat, cheese and topping him or she wants

  Cultural constraints on management theories

Show management issues present in the case and describe what options the managers had in dealing with issues. Do you agree or not agree and wxplain. What are some better alternatives?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd