Completed

Build me a decision support system on ExcelVBA

lem Description

“Java Hot” is a small coffee shop in Gainesville. The shop is owned by Jane, who enjoys

serving coffee and baked goods to her clients. Because the environment of the shop is

very welcoming and Jane is responsive to her customers, the business has grown fast.

However, Jane is concerned about the financial viability of the store for the following

reason. The major products that she sells in her shop are coffee and bagels. Every

morning Jane buys bagels from a local bakery for $0.25 each and sells them for $1.00

each. Since she cannot return unsold bagels or sell them the next day, she wants to know

how many bagels to order every day so that she will not face situations such as having too

many leftovers or not having enough bagels. As she has already identified her problem,

she is trying to figure out what to do.

Jane’s problem can be formulated as the News Vendor’s Problem. We want to build a

decision support system for Jane to help her in making the right decision. Below we

propose an optimization approach and a simulation model.

Skills: Excel Macros, Excel VBA

See more: developing spreadsheet-based decision support systems solutions manual, dss excel projects, decision support system excel template, dssbooks, is130 building a decision support system with ms excel a spreadsheet modeling assignment, assignment 1 creating a spreadsheet for decision support, dss spreadsheet, decision support system example, decision support systems, decision support system php mysql, spatial decision support system, build website support chinese english, business decision support, videolan build amr support, website decision support system using php mysql fusion, decision support system using cnet language code, decision support bias, decision support system examples cnet, sox windows build mp3 support, decision support system project

About the Employer:
( 0 reviews ) Istanbul, Turkey

Project ID: #19696376

Awarded to:

elsheiryu87

Hi, i am interested in this task. I have tried to calculate the optimum Bagel purchase using normal distribution, and tried it in simulation several times. Feel free to contact me. Best regards, Imam

$55 USD in 2 days
(2 Reviews)
2.1

5 freelancers are bidding on average $29 for this job

ecicek

As you suggest, it's very similar to news vendor prb. I am thinking of dynamical forecasting with confidence intervals and include day-of-week feature. I also consider exponential smoothing for growth Relevant Skills More

$25 USD in 5 days
(0 Reviews)
0.0
mihalceageorgica

I have 5 years of experience with java. I worked on different enterprise projects. I also have full time job as java programmer.

$25 USD in 1 day
(0 Reviews)
0.0
pamelakoley

Hi, I have more than 4 years of work experience of working both in India and London working in the role of Data Analysis. Currently, I am employed with Pairview , working on multiple assignments on different technolog More

$20 USD in 5 days
(0 Reviews)
0.0
sambaggy

I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert I Am a VBA expert

$20 USD in 3 days
(0 Reviews)
0.0