Business Analysis Help for College and University Students

Help on Linear Programming Problem

I seem to be missing something. Please review the attached file, explain what I am missing, and respond with a corrected Excel spreadsheet so I can solve with Solver and use for future problems.

Linear Programming Problem

Attached is a problem I have worked through, including sensitivity reports, etc. Please work through the additional questions and provide answers and explain for me in sufficient detail for me to do on my own: 1. If Mobile Chair Company could gain 100 additional hours, at no additional cost, in its production department, ho ...continues

More For #101733

The solutions worked fine and I was able to extrapolate using the work you assisted me on and correctly prepare responses to other requirements. It is a lot easier to understand when you have an approved solution to refer back to. Based on the original spreadsheet I need solutions to the following additional questions: M ...continues

Forecasting/using Mean Absolute Deviation in Excel or Crystal Ball/OPTQuest

I need to forecast out 12 months using 3 different techniques, and then decide which one is best based on MAD (mean absolute deviation). Using some historical data for the past 40 periods (see attachment) I need to make a forecast for the next 12 periods (periods 41 thru 52) using 3 of the simple forecasting techniques we ha ...continues

Spreadsheet simulation/optimization using Excel or Crystal Ball/OptQuest

The owner of Carlo's Computers is planning a 7-day promotiuon (Sunday-Saturday) to launch a new PC called "PCLink1000." *The shop owner is pricing these PC's at $675 each, and he buys them for $425 each. *He must buy in bundles of 25 sets. *At the end of the promotion, the distributor will buy any unsold PC's back for $350 each. ...continues

Linear programming problem

1. Set up the following linear programming problem in an Excel spreadsheet so I can work it with Solver. 2. Provide a written step by step explanation so I will understand similar problems on the midterm next week. After I work through the problem and explanation I would like you to review my answers to be certain I am o ...continues

Develope a graph to show status of call center.

A call center has the following inputs to track. 1.Calls into the call center per hour 2.Agents answering the phones per hour 3.Calls that are not answered for a short time period. Delayed time in minuets 4.Abandon calls per hour (customers that call and then hang up after short period of time on hold). My assignment i ...continues

3822-incentive based systems

I am working on answering the following questions: 1. Rewards for performance can be based on current performance results (short-term) or future performance results (long-term). List one advantage and one disadvantage of both and give example of each. 2. Should the bank manager of ACB bank be evaluated based on the perfo ...continues

Spreadsheet problem - return on investment analysis

Create a spreadsheet to address the following problem: A. A hospital has an average accounts receivable balance of $20,000,000 and a collection period of 60 days. B. 60% of receivables are not collected on time. The bills for those receivables must be reworked by the patient billing department and resubmit ...continues

Business organizations - differences?

What are the advantages and disadvantages of the different forms of business organizations? What are the differences among the various types of corporations?