In this assignment you’ll solve the basic economic order quantity (EOQ) model in Excel using two methods: (A) a trial-and-error approach to find a very good but approximate answer, and (B) the EOQ formula to find the “exact” answer. Set up your spreadsheet similar to that shown below.

The situation: Roxie is responsible for purchasing the paper used in all copiers and laser printers at Budco. After looking at her records, Roxie has found that demand for paper averages 600 boxes per month. The price of a box of paper is $20 (regardless of the number ordered). Placing and handling an order costs $66. Annual unit holding costs per box are 25% of the unit price. Last year, Roxie ordered paper once every two months, but she wants to know if another ordering policy would be cheaper.

1. Trial-and-Error (Approximate) Method

• Order Quantity: type in 25 for cell A10; then use the formula =25+A10 for cell A11 and copy this formula down, until Q reaches 1200.
• Annual Ordering Costs (DS/Q): for cell B10, use =$B$1*$B$3/A10; then copy formula down.
• Annual Holding Costs (HQ/2): for cell C10, use =$B$4*A10/2; then copy formula down.
• Annual Ordering + Holding Costs: for cell D10, use =B10+C10; then copy formula down.

Make a scatter (XY) chart of the Annual Ordering + Holding Costs (y-axis) vs. Order Quantity (x-axis).

2. EOQ (Exact) Formula

• Find the optimal order quantity Q* in cell E5 using the EOQ formula discussed in lecture and Ch. 12 of the text. You can find the square root of x in Excel with the function SQRT(x). In your E5 and F5 cell formulas you should reference other cells that contain the relevant data rather than typing the numbers themselves into the cell formula.

1. Based on the Trial-and-Error (Approximate) Method

A1. Approximately what order quantity minimizes total annual ordering + holding costs? ____ boxes

2. Based on the EOQ (Exact) Method

B1. What order quantity Q* minimizes total annual order + holding costs? _____ boxes

B2. What Excel cell formula is required for Annual Ordering + Holding Costs in cell F5? _____

B3. At Q*, what are the total annual ordering + holding costs? _____

B4. How many times per year will Roxie place an order of size Q*? _____

B5. Last year, Roxie ordered every 2 months. How much were her total annual ordering+holding costs?

_____________ (Hint: First ask yourself how many boxes would be ordered each time if you ordered exactly once every 2 months?)

B6. What is the percentage reduction in annual ordering + holding costs achieved by Roxie in following the optimalinventory policy instead of last year’s ordering policy? _______

Read the following case and answer the questions.

Greener Company

The CEO of Ferguson Inc. wants its executives to make the organization more environmentally friendly by encouraging employees to reduce waste in the workplace. Government legislation is coming that will require all companies of this size to have a program in place and the company’s customers also expect it. The CEO wants to significantly reduce paper usage, garbage and other waste throughout the company’s many widespread offices.

Unfortunately, a survey indicates that employees do not value environmental objectives and do not know how to “reduce, reuse, recycle.” As the executive responsible for this change, you have been asked to develop a strategy that might bring about meaningful behavioural change towards this environmental goal. What would you do?

Questions

1. Based on the case above, and according to Lewin’s Model for Managing Change - what are 2 Forces for the status quo (or restraining forces)?                          /2

2. Using Lewin’s Model for Managing Change, how would you go about implementing and managing the change at Ferguson Inc. – answer a. and b.                               

1. Explain each phase – Unfreezing, Moving and Refreezing  

2. and list one action that you would implement for each phase to accomplish your change.

Discuss key performance indicators in a business. Find some examples of key performance indicators and describe how they demonstrate the success of a company.

1a. What is the "one country, two systems" approach of China? How did it come about? How is the concept doing today?

1b. Describe and explain the four phases of the international planning process. Please provide example (s) when suitable.

1c. Describe the five characteristics of an innovation that assist in determining the rate of acceptance or resistance of the market to a product. Please provide examples.

1d. What has become the primary vehicle for doing business in many foreign countries? Explain and justify your answer with example(s).

1e. What are the various techniques that can be used to motivate middlemen? Please illustrate your answer with examples.

1. Suppose that a firm is considering moving from a batch process to an assembly-line process to better meet evolving market needs. What concerns might the following functions have about this proposed process change: marketing, finance, human resources, accounting, and information systems? (Marks 1) (word count maximum: 150)

*** Please I do not want answer from internet

*** Plagiarism not allowed

1. Take a tour of the Soap Factory and describe the process used? (Marks 1) (word count maximum: 100)

** Please I do not want answer from internet

** Plagiarism not allowed

How do you come up with your bid/response for the Request for Proposal?

Debate the advantages and disadvantages of quantitative and qualitative research based on your research experiences.

Internal analysis of firm’s resources, including core competencies and competitive advantage (Apply the VRIO framework) on Panera Bread Company 2016

Calculate exponential smoothing forecast for these data using an α of 0.7 and an initial forecast (F1) of 18 ), or Exponential Smoothing with Trend (use optimal α and δ,

Can you have structure in a business without controlling everything?

The Woolong Company produces high-end vacuum cleaners and sells them to consumers online. They are designing a new product, and you have been hired as the project manager to oversee it.

• Discuss the tools and techniques you should you use to identify the project stakeholders.
• Describe potential risks associated with this project, and explain what risk management processes can be utilized.
• Share other important components that a project manager should consider as this project continues into the execution phase.