Description of your spreadsheet model

Assignment Help Operation Management
Reference no: EM132512100

Write a report along the following guidelines. Please make sure your policy suggestions are based on simulations with at least 1000 iterations for each case. You are required to use @Risk.

1. Provide a description of your spreadsheet model. Explain how each problem input was computed and modelled using the appropriate distribution. Also provide a description of how you compute the various characteristics of the system (total demand, the number of cars sold, the number of unsatisfied customers, etc).

2. If you are restricted to importing the same number of cars every month, what would be your optimal strategy? Describe the profit and other relevant characteristics of this policy.

3. If you are allowed to import a different number of cars every month, what would be your optimal ordering policy? Describe the profit and other relevant characteristics of this policy. Compare this policy to that in (2).

4. Assume you decided to take orders 6 months ahead and that the number in the first row of the above table were the actual demands. What would be your optimal ordering policy? Would your mean profit increase?

Reference no: EM132512100

Questions Cloud

Internal environment analysis : Internal Environment Analysis for: Chain Value, Resources, Skills, Competetive Advantage. Future choice Analysis with tools: TOWS matrix and SWOT
Explain types of unemployment and an example for each : Economic growth doesn't simply depend on having more natural resources, more or higher- quality labor, more capital and so on; it depends on people's incentives
Fiscal planning and financial management : Identify information on Tenet Healthcare, exploring their policies and procedures for fiscal planning and financial management.
Calculate journal entries for issuance of bonds and payments : Why Mr. John was keen to look into the market rate before issuing the Company's Bond in open market. Why he had taken decision to issue Bonds for Financing?
Description of your spreadsheet model : Provide a description of your spreadsheet model. Explain how each problem input was computed and modelled using the appropriate distribution.
What happens to output : What happens to real wages, employment and output if unions are able to obtain a 5 percent nominal wage increase?
Business Law Assignment : Business Law Assignment - Select any 2 different cases below to find, read, understand, summarise, and present
CSCI910 Software Requirements Assignment : CSCI910 Software Requirements, Specifications and Formal Methods Assignment Help and Solution, University of Wollongong - Assessment Writing Service
What was the price of the bond when bought : What is the value (or price) of the bond if the required return is 5%? What is the value of the bond if the required return is 6%? What is the value of the bond

Reviews

Write a Review

Operation Management Questions & Answers

  Characteristic of organizational change

Which of the following is a characteristic of organizational change? Unlike traditional organization designs, built-to-change organization designs _____.

  Determine brand preference involving two brands

A survey to determine brand preference involving two brands X and Y uses 5 samples of 51 persons each. If a majority of the samples ( 3 or more) chooses one brand, that brand is determined the winner. Can we determine which of the two brands X or Y i..

  What you feel will be three most significant external factor

Determine what you feel will be the three most significant external factors that will impact training in the next five years. Explain why you feel these will be the most significant. Use references to justify your choices.

  Key terms-electronic communications privacy act

Research the topics on the web of this key terms. Electronic Communications Privacy Act, Distributive Justice, Landrum- Griffin Act

  Determine the lower control limits

Determine the lower control limits and the overall means for the upper X charts and R-charts

  Continue to expand overseas and assess these benefits

Justify the need for Wal-Mart to continue to expand overseas and assess these benefits.

  General composing techniques

As a manager, write a memo to your employees about the following situation: Your company has decided to pilot a flextime program. There are two options available. The first option is to work five days a week, but on an earlier or later schedule than ..

  Risk management programs are critical to safety and security

You read a lot about why Risk Management programs are critical to the safety and security of any health care organization.

  Describe the liability of the partnership

Fran, Joe, and Mike formed a general partnership to operate a flower shop called Fresher Flowers. One of Fran’s jobs is to make deliveries using the partnership truck. In one such delivery, Fran negligently ran a stop sign, striking a car driven by P..

  Using trend analysis

Using Trend analysis what would you do to predict the next year’s employee demand?

  Acting as agent for undisclosed principal

Parke-Bernet Galleries, acting as agent for an undisclosed principal, sold a painting to Weisz.

  What is good document design for resumes and memos

What is good document design for resumes and memos?

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