Ask Question, Ask an Expert


Ask Applied Statistics Expert

problem 1: Statistics - Inventory Problem

George Madison used to be an accounting professor at a state university. Several years ago, he started to develop seminars and programs for CPA review course. The CPA review course is a course to help accounting students and others interested in passing the CPA exam. In order to develop an effectual seminar, George developed a number of books and other associated materials to help. The major product was the CPA review manual developed by George. The manual was an instant success for his seminars and other seminars and courses across the country. Nowadays, George spends most of his time refining and distributing this CPA review manual. The annual demand is 9,600 and the cost of ordering is $400 per order. The price of manual is $100.00. George’s total cost to manufacture and produce the manual is $80.00. George wants to avoid stockouts and/or to develop a stockout policy which would be cost-effective. If there is a stockout on the CPA review manual, George loses the gain from the sale of manual.

George wants to know how much safety stock he should have as a buffer. George predicts that his carrying cost per unit per year is $12.00. Based on total cost what ROP and what level of safety stock would you propose? The frequency of demand for the CPA review manuals throughout lead time is given in table below.

Table: Frequency Distribution for Demand

Demand During Lead Time    Frequency (number of times demanded)
350                                 3
400                                 2
450                                 2
500                                 4
550                                 5
600                                 6
650                                 5
700                                 5
750                                 5
800                                 3

Complete all of the columns in the given table and elucidate your recommendation.


Illustrate all of your work [computations for old ROP, EOQ, N and Cst]

problem 2: Statistics – Project Management

The Department of Interior has named the Saratoga Mountain area a national park. This is in the planning phases of developing a campsite over 500 acres of currently undeveloped land. This campsite will span the extremities of the park, from the proposed Mission Creek Campsite area in the west to Wild Coyote campsite area in the east. Refer to figure shown below.

At this time, all of the contracts for this project have been awarded. The project has been sub-divided into ten individual activities, as shown in table below. Based on similar projects, it has been possible to estimate optimistic times, most probable times and pessimistic times for most activities. Activities F and I are discussed in the given paragraphs.

Activity F, which will be performed by Ellis Electric, includes laying the electrical cable for the project. To minimize its costs, Ellis Electric will design the system to use the least amount of electrical cable. Ellis will charge the government an amount between $100,000 and $200,000.  For $100,000, Ellis Electric can assign adequate workers to lay 300 feet of cable per week. For $200,000, Ellis will assign additional workers to lay 500 feet of cable each week. You can find out the number of linear feet based on minimal spanning.
Activity I includes constructing one (narrow) paved two-lane road from Mission Creek in the west to Wild Coyote in the east. This work will be completed by Harriman Construction Company. To minimize the costs, the department will pay Harriman to build the road of minimum distance between the two campsites. At a cost to the government of $25,000 per week, 200 feet of roadway can be done in a week. When the cost is raised to $36,000 per week, the completion rate will raise to 250 feet per week. You can use shortest path to find out the number of linear feet.

Due to the heavy brush and mountainous nature of area, 12 possible dirt paths exist between the campsites. Neither Ellis nor Harriman is allowed to clear out additional regions for constructing either underground cable or the paved road. Therefore, the electrical cable should be laid and the road should be built all along areas of the dirt paths. Figure below provides a map of the possible dirt paths between campsites showing distances in feet.

The grand opening of Saratoga Mountain National Park has been schedule for precisely 62 weeks from now. This is imperative that the project be done within the 62-week period because a delay of even one day in the opening of the park would outcome in revised travel costs for the dignitaries, lost income to the park and other expenses.

The Normal Cost column in table below represents how much an activity would cost if completed in the expected time. The Crash Cost column symbolizes the additional cost that would be accrued if the activity was crashed the maximum amount possible.

The Normal Time will be expected time you compute for each activity. The Max Crash Time symbolizes the maximum amount by which an activity could be crashed. For illustration if the expected time for an activity is 12 weeks and the maximum crash time is 2 weeks that signifies that the activity could be crashed to 10 weeks however no more.

i) Compute and show the expected times and variances for each activity [A, B, C, D, E, G, H, J].  Determine times for F and I based on your computations of linear feet.

ii) Construct the PERT network for this problem.

iii) Create an Activity Schedule [that is, table showing ES, EF, LS, LF, slack] for the four options.

iv) What are the actions on the critical path for each option?  Describe your answer.

v) What is the expected completion time for each and every option?

vi) What is the total cost for each option?

vii) Based on the costs and times determined for the four options devoid of crashing, which one would you propose? describe.

viii) What is the standard deviation of the critical path in part (iv) in each option? Based on your recommendation in part (vi), what is the probability of completing the project at most one week more than the expected time?

ix) Based on your recommendation given in part (viii), would you propose crashing any actions to meet the 62-week deadline? Describe your decision.

117_times and costs.jpg

2063_saratoga mountian national park.jpg

Figure: Saratoga mountain national park

Applied Statistics, Statistics

  • Category:- Applied Statistics
  • Reference No.:- M9514

Have any Question? 

Related Questions in Applied Statistics

Answer all questions no word limit1 a define

Answer all questions, no word limit: 1. a. Define multicollinearity. What is the difference between an exact collinear relationship among the explanatory variables and an approximate (not exact) collinear relationship am ...

Samplingfor this weeks seminar come prepared to discuss the

Sampling For this week's Seminar, come prepared to discuss the following: Distinguish the concepts of "population" and "sample" Importance of sampling Probability and Non-probability Sampling Strengths and weaknesses of ...

Instructions- individual work consultations with the

Instructions: - Individual work, consultations with the instructor will only be for clarification of the question. - Please submit at the start of the exam using this page as cover page. - Please sign affidavit below. Qu ...

The attached excel file reports data on the length of stay

The attached excel file reports data on the length of stay (LOS) for patients at a hospital. Use Excel built-in formulae to answer each of the following questions: a. Plot a scatter diagram between two variables and brie ...

1 the overall predicted portion of y score variability is

1. The overall predicted portion of Y score variability is measured by r squared. T or F 2. SS regression is the denominator in the F-ratio inference test for regression. T or F 3. SS residual is the numerator in the F-r ...

In addition to solving the problems write a 3 - 5 page apa

In addition to solving the problems, write a 3 - 5 page APA formatted paper explaining the process that lead to the resolution. * Calculators may be used to check answers where calculators are part of assignments but you ...

Unit - data analysis projectall excel output should be

UNIT - DATA ANALYSIS PROJECT All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below. Format the document professionally so it flows well. Include a ...

Inferential statisticscertified bmw requires appropriate

INFERENTIAL STATISTICS Certified BMW requires appropriate statistical analysis with a write up (memo) of approximately 3 pages. 1. a. Certified BMW thinks that the average price of all Model 330 cars is greater than $32, ...

Assignment lab activitynbsp- Assignment: Lab Activity - PSYC­330­OL50­

Assignment: Lab Activity - PSYC­330­OL50­ 1/3 PART A: Describing Correlation Coeffic ...

Cats kibble and cable tvbackground and goalyou were hired

Cats, Kibble, and Cable TV Background and Goal You were hired by PROSPEROUS PETS, a small regional chain of boutique pet care stores. PROSPEROUS PETS focuses on serving dog and cat owners for all of their pet needs, incl ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro