Create a data table to generate 50 runs of the simulation

Assignment Help Database Management System
Reference no: EM13781046

Question Set 1.

You are an inventory management consultant. You have been hired by Whole Foods to help optimize inventory management for their produce department. Your immediate task is building a Monte Carlo simulation for sales of apples, oranges, and bananas. The probabilities of daily demand levels are:

Probability

Apples

Oranges

Bananas

0.05

141

236

265

0.10

162

266

286

0.10

175

286

299

0.10

184

300

308

0.15

194

315

318

0.15

206

333

330

0.10

216

348

340

0.10

225

362

349

0.10

238

382

362

0.05

259

412

383

The unit revenues and costs are given in the table below.

Fruit

Unit Revenue

Unit Cost

Apple

$1.45

$0.90

Orange

$1.55

$1.10

Banana

$0.60

$0.25

1. Build a table for the cumulative probability distribution for demand. It should be set up for use with the VLOOKUP function, with the cumulative probabilities on the left.

2. Build a table for tracking sales over the dates Sunday 11/2 through Saturday 11/22 with separate columns for apples, oranges, and bananas. This will just be the randomized demand value for each fruit for each day (like in 10.1.2 from the lab exercise on Monte Carlo simulations). You can assume all demand is actually met (that is, sales = demand).

3. Build a table for tracking total revenues, costs, and profit for tracked sales. This table should use the information provided in your answer to 2., above. Your table should calculate values for:

  • Total Revenue (based on the combined sales of all three fruits)
  • Total Goods Cost (also based on combined sales)
  • Fixed Costs (assume the weekly cost for store space is $200 for each fruit display, so $1800 total: 3 displays x 3 weeks x $200)
  • Profit/Loss (total revenue minus total costs)

4. Create a data table to generate 50 runs of the simulation. As in previous assignments, this must be an actual data table structure to earn full credit. Calculate the average profit over the 50 simulation runs.

Reference no: EM13781046

Questions Cloud

What is the payback period for the investment : a. what is the payback period for the investment? would it be a good or a bad investment? why? b. what is the ROI for the investment c. Assuming a 15% discount rate, what is the investment NPV?
Brief a case of gidion wright : Brief a Case of Gidion Wright, Start working on briefing Gideon v. Wainwright - yes a full brief
Manufactures herbicides for farmers : A corporate public affairs manager for a company that manufactures herbicides for farmers would most likely to have to deal with:
How does affect us on a daily basis : When we look at the issue of the ability of markets to function (hopefully well) what are some of the issues that factor into the fluctuation of markets, both on a domestic and global level? How does this affect us on a daily basis?
Create a data table to generate 50 runs of the simulation : Create a data table to generate 50 runs of the simulation. As in previous assignments, this must be an actual data table structure to earn full credit. Calculate the average profit over the 50 simulation runs.
Structural modeling and behavior modeling : Structural Modeling and Behavior Modeling.
Consistency of military policy : "The Consistency of Military Policy" Please respond to the following: Based on the scenario and the knowledge gained from this section, address the following:
The symptoms of parkinson disease : Sabrina is a twenty-seven-year-old woman who recently underwent a corpus callosotomy. Initially after surgery, when given a verbal command, Sabrina demonstrated marked apraxia of the left hand. However, the extent of this issue diminished over tim..
Consequences for public life issues : Why would it be inadvisable to legislate that opinions may be freely expressed only if the expressions are "temperate"?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Convert excel files into an access database

The Morris Arboretum tracks donors to their organization in Microsoft Excel. Access for future Arboretum records. In the following project, you convert Excel files into an Access database for Morris Arboretum

  The database used for the relational algebra simple one

Relational Algebra- The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

  Problemconsider the following schema of ra b c d with

problemconsider the following schema of ra b c d with functional dependenciesa -gt b b-gt c and b-gtd1- compute the

  Convert table to 3nf and represent answer in dbdl

Convert the table to 3NF. Represent your answer in DBDL. (i.e. Give table name and fields. Underline the primary key. Draw an entity-relationship diagram showing all relationships.)

  To write required sql statements to query the database

You may need to rerun the schema, especially when you have been experimenting with your solutions and may have corrupted the database unintentionally. If you suspect that there might be such problems, rerun the schema.

  Determine the functional dependencies

Using your knowledge of the college environment, determine the functional dependencies that exist in the following?

  Design an e-r diagram for the scenario

Design an E-R Diagram for the scenario - Company delivers various computer products to its customers. Some products serve generic purpose, therefore, they are sold to various customers.

  An attribute is a characteristic or property of an entity

an attribute is a characteristic or property of an entity. if person is an entity would the same attributes be used to

  Prepare the first-stage allocation of overhead costs

Prepare the first-stage allocation of overhead costs to the activity cost pools and prepare an action analysis report in good form

  Explain business intelligence and data warehouses

Business Intelligence and Data Warehouses, Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amo..

  Product in traditional costing system - bullie manufacturing

Determine the manufacturing overhead cost per unit of each of the company's two products under the traditional costing system.

  Implement direct-address table keys of stored elements

Suggest how to implement direct-address table in which keys of stored elements don't require to be distinct and elements can have satellite data.

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