What is the current annual cost of serving all the shops

Assignment Help Other Subject
Reference no: EM132243478

Assignment - New Bakery for Oz Bread

Background - Oz Bread, a rapidly developing new bakery in Melbourne, is facing a critical supply chain problem. Mitchell McGuire, supply chain manager of Oz Bread, was asked by the boss to find a solution. Given the continuous growth in business over the years, it is obvious that the current production and distribution network of the company needs to be restructured. Oz Bread started off with a single baking facility in Mentone. Every day, the freshly baked breads and pies are delivered to its shops located in Glen Waverley, Doncaster, Melbourne CBD, Thomastown, St. Albans, and Hoppers Crossing. Business is growing and soon the maximum daily production capacity at the Mentone baking plant will be reached. A quick decision on building one or more new baking plants could save the company significant amount of money in lost sales in the future. A new baking plant will take a year to build from planning to completion. For example, if Oz Bread decides in this year to build a new baking plant, the earliest date the new facility is available will be next year.

Oz Bread was founded eight years ago and has been producing since then fresh breads and delicious gourmet meat pies for Melburnians. Current average daily demands for their breads and pies, which are relatively stable throughout the year, are shown in Table 1. The shops open 360 days a year. It is expected that the demands (breads and pies alike) at the existing shops will grow by the percentages shown in Table 1 for another three years before they become stabilized due to market saturation. For simplicity reason, it can be assumed that the increase in demand takes effect all of a sudden at the beginning of each year and now it is the beginning of the current year. At present, the company has one baking plant in Mentone which produces both products for the entire metropolitan area of Melbourne.

Table 1 - Average daily demand for breads and pies at Oz Bread in current year

 

 

Shop

Glen Waverley

 

Doncaster

Melbourne CBD

 

Thomastown

 

St. Albans

Hoppers Crossing

Daily Demand

Breads

700

1000

1,500

500

800

1,000

Pies

400

700

1,000

300

450

750

Growth in Year 1

15%

12%

20%

18%

15%

12%

Growth in Year 2

10%

6%

10%

12%

8%

6%

Growth in Year 3

5%

3%

2%

6%

4%

3%

The bread production line at the Mentone baking plant has a capacity of 6,000 units per day, an annualized maintenance and overhead cost of $200,000 a year, and a production cost of $0.3 per unit. The pie production line has a capacity of 4,000 units per day, an annualized maintenance and overhead cost of $300,000 a year, and a production cost of $0.5 per unit.

For simplicity reason, it can be assumed that the annualized maintenance and overhead cost will not be incurred if the production line is not running in the year.

New Network Options -

Upon careful analysis of the locations of the existing shops and possible expansion of the company's business in the future, Mitchell has identified three suburbs - Prahran, Northcote, and Laverton North - as potential sites for the new baking plants. At the new facilities, a bread production line or a pie production line or both can be set up. Using newer baking technologies, the new plants can run at lower costs. Production capacities, construction costs, annualized fixed costs (i.e. maintenance and overhead costs), and unit production costs of the new plants are shown in grey in Table 2. It can be assumed that all these costs will remain unchanged in the next three years until the demands become stabilized. For the new plants, a saving of 30% from the construction cost can be achieved if only one production line is constructed. However, once the plant with a single production line is built, it will not be possible to add another production line in the future. Shutting down the existing facility at Mentone can recover at most $100,000 in scrap value. If any of the new plant constructed at Prahran, Northcote, or Laverton North has to be shut down in the end due to underutilization, the maximum scrap value that can be retrieved is 10% of the construction cost. To make things simple, net present value is not considered in this case.

Table 2 - Cost figures of the current and the potential new bakery facilities for Oz Bread

 

Plant

Existing

Potential Site

Mentone

Prahran

Northcote

Laverton North

Attribute

Capacity for Baking Breads per Day

6,000

6,000

7,000

7,500

Capacity for Baking Pies per Day

4,000

4,500

5,200

5,500

Construction Cost

Already built

$1,200,000

$1,500,000

$1,600,000

Annual Fixed Cost for Baking Breads

$200,000

$220,000

$240,000

$240,000

Annual Fixed Cost for Baking Pies

$300,000

$300,000

$320,000

$320,000

Variable Cost for Baking Breads

$0.3 /unit

$0.25 /unit

$0.25 /unit

$0.25 /unit

Variable Cost for Baking Pies

$0.5 /unit

$0.45 /unit

$0.45 /unit

$0.45 /unit

The current transportation costs per unit from the Mentone baking facility to the shops are shown in Table 3. The estimated transportation costs per unit (in current year) from the potential sites for the new plants to the shops are also shown in grey Table 3. It can be assumed that these costs will remain more or less the same in the next three or more years.

Table 3 - Existing and estimated transportation costs per unit for breads and pies (at current year)

 

Shop

Glen Waverley

Doncaster

Melbourne CBD

Thomastown

St. Albans

Hoppers Crossing

Plant

Mentone (Existing)

$0.10

$0.12

$0.11

$0.20

$0.22

$0.24

Prahran

$0.10

$0.12

$0.04

$0.12

$0.15

$0.17

Northcote

$0.18

$0.16

$0.05

$0.04

$0.10

$0.11

Laverton North

$0.22

$0.24

$0.10

$0.13

$0.04

$0.05

Based on the above information, Mitchell has to decide for the next three years where to build the new plants and, if so, which production lines to put into the new facilities.

Case Questions -

Assume you were Mitchell and you need to answer the following questions of your boss:

1. As-Is Situation: What is the current annual cost of serving all the shops from the Mentone baking plant?

2. Scenario A: If the existing Mentone baking plant must be kept but not necessarily making both breads and cakes, what new plants would you recommend for the next three years? Where should they be built? What production lines should be included and how should the shops be served by the existing and the new baking plants? Make your recommendations on a year-by-year-basis (starting from Year 1).

3. Scenario B: If the existing Mentone baking plant must be scrapped because of its out-of- date production technology and new plants are to be built in other suburbs instead, what production network would you recommend and how should the shops be served by the new baking plants? Again, make your recommendations on a year-by-year-basis (starting from Year 1).

4. Scenario C: If only one production line is to be run at each baking plant at any time (i.e., either baking breads or pies but not both), assuming you could use any plant including the existing one at Mentone, what production network would you recommend and how should the shops be served by the baking plants? Again, make your recommendations on a year-by- year-basis (starting from Year 1).

5. Action Plan: Taking into account the construction costs of the new plants and the scrap value of the existing plant and assuming the demand for breads and pies will become stabilized in three years, what is the network configuration you would recommend for Oz Bread for the long run and how should the shops be served by the baking plants? Analyze the total costs involved under the three scenarios taking into account the construction cost of the new plants and the scrap value of the existing baking facility at Mentone. Upon the analysis, generate an action plan for your final recommendation on a year-by-year basis from Year 0 to Year 3 assuming the current year is Year 0, i.e., what should Oz Bread do at the beginning of Years 0, 1, 2 and 3, if any.

Note - Need only Question 1 and Scenario A.

Attachment:- Assignment File.rar

Reference no: EM132243478

Questions Cloud

Take operations management-business situation : Each student will take an operations management/business situation and apply at least two of the operations tools discussed
Analyze two key legal issues affecting construction industry : Describe and analyze two key legal issues affecting the Construction industry
Analyze the role the director took during the emergency : Select one (1) FEMA director whom you believe performed below standards during a major U.S. emergency or crisis. Next, analyze the role this director.
Customer acquisition and customer retention : MIS Assignment Explain impact on revenue, fixed costs, variable costs, initial investment, training, implementation, customer acquisition, customer retention.
What is the current annual cost of serving all the shops : Assignment - New Bakery for Oz Bread. What is the current annual cost of serving all the shops from the Mentone baking plant
Methods and measurement analyst : A methods and measurement analyst wants to develop a time standard for a certain task.
How to close out the project with the customer : This week, you will compose a 2- to a 3-page paper outlining how to Close out the Project with the customer. Develop a post-project evaluation and meeting.
In your opinion what is the future of racism : In your opinion, what is the future of racism, will racism increase, decrease, or stay the same in the United States?
Discuss why ebp is an essential component of the practice : Identify one professional journal and one nursing or health care conference where you might present your project. Discuss why each of your choices is the best

Reviews

len2243478

2/26/2019 8:50:30 PM

Instructions: In the document attached, i don’t need all the case study questions to be done, only Question 1 and Scenario A (2 questions only on excel). Notes: In calculating the new demand, round to the nearest whole number. You can generate the Year 1 demand from the Year 0 figures, round them to integers and then use the rounded figures to generate the Year 2 figures. Repeating the same procedure, you can get the Year 3 figures. For simplify reason, net present value, inflation, and depreciation, etc. can be ignored in the calculation.

len2243478

2/26/2019 8:50:23 PM

You need to note that it might not be always desirable to make your recommendations entirely on the basis of the solutions given by Solver. This is because, for simplicity reason, your problem formulation might not include construction cost. As such, Solver would find an optimized solution taking into account operating cost only. So, it might recommend using multiple plants to minimize total operating cost. You may come into a situation that a new plant is needed in one year but will no longer be required in another year leading to waste. Therefore, you are strongly recommended to use the Solver solutions as reference only and use your logical thinking to revise the year-by-year configurations.

len2243478

2/26/2019 8:50:16 PM

The objective is to minimize the long-run operating cost (referring to that of Year 3) while minimizing the total construction cost of the new facilities (from Year 0 to Year 2). In doing so, the operating costs of Year 1 and Year 2 may be higher than that of the Solver solutions for a particular scenario but on the whole the total construction cost and the long-run operating cost can be minimized.

len2243478

2/26/2019 8:50:07 PM

In building new plants, you need to note that if only one production line is included at the beginning to save cost, it will not be possible to add another production line at a later stage. So, if a new plant is to run one production line in one year and then the other production line in another year, both production lines must be included when the plant is first built. In other words, if both production lines in a plant will be used even though not at the same time, they must be provided right at the beginning when the plant is constructed. This will affect the total costs of the three scenarios as well as the action plan.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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