What would be resulting cost equation for maintenance costs

Assignment Help Applied Statistics
Reference no: EM131203848

Assignment Questions

QUESTION 1: Decision Analysis

Show all calculations to support your answers. You may follow the methods shown in the mp4 on Decision Analysis for a way to do part (b) of this question if you wish.

a) People frequently use three heuristics to assess probabilities and to predict values. Identify and describe these heuristics and identify and explain a bias to which each of these heuristics lead.

b) Martha Jones is considering investing money in three alternative investments over a one-year period. Below are the expected profits from each investment given assumptions about the state of the economy:

Decision Alternative

Good Economy

Poor Economy

Stock market

$200,000

-$60,000

Bonds

$80,000

$45,000

Term deposit

$45,000

$35,000

i) If Martha is an optimist which investment should she choose?

ii) If Martha is a pessimist which investment should she choose?

iii) Following the criterion of regret which investment should she choose?

iv) If Martha believes that there is a 65% chance of a good economy which investment should she choose?

v) What is the expected value of perfect information about the state of the economy?

QUESTION 2: Value of information

Show all calculations to support your answers. You may follow the methods shown in the mp4 on Value of info for a way to answer this question if you wish.

A manufacturer is trying to choose between two production methods (a1 and a2) for a new product. He considers that the probability of demand for the new product being good (s1) is 0.3 and the probability that demand will be poor (s2) is 0.7.

In evaluating the two production methods the manufacturer has calculated the following table of conditional profits:

 

s1

s2

a1

30,000

16,000

a2

10,000

24,000

a) Which production method should be used? Show calculations.

The manufacturer asks a marketing consult for an opinion as to whether demand will be good or poor. From previous experience when the consultant has indicated that demand will be good she has been right 80% of the time, and when she has indicated that demand will be poor she has been right 65% of the time. Cost of information charged by the consultant is $3500.

b) Revise the prior probabilities in light of the consultant's track record.

c) What is the posterior probability of good demand given that the consultant has indicated demand will be good?

d) What is the expected net gain or loss from engaging the consultant? Should the consultant be engaged? Explain the reasoning for your answer.

QUESTION 3: Simulation

This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace.

A general practice has a nurse to attend patients with wounds and who need vaccinations wages of the nurse is $12.50. From an analysis of one week's operation of the nursing service the following data were derived:

Time between arrivals

Number of occasions

10

10

15

20

20

25

25

30

30

15

 

Service time (minutes)

Number of occasions

10

40

15

20

20

20

30

10

40

10

Using Excel set up a simulation model to simulate about 2 hours (120 minutes) from time zero, and determine whether one nurse is sufficient or whether a second nurse is needed in the practice.

Show the data and the model in two printouts: (1) the results, and (2) the formulas. Both printouts must show row and column numbers and be copied from Excel into Word.

QUESTION 4: Regression Analysis and Cost Estimation

Quick Copy has recorded the following Maintenance Costs and two possible cost drivers over the last year.

Month

Number of photocopies

Hours of maintenance service

Maintenance costs

January

80,000

525

4,710

February

68,000

505

4,310

March

69,000

310

2,990

April

64,000

495

4,200

May

90,000

315

3,000

June

85,000

485

4,215

July

55,000

315

2,950

August

85,000

405

3,680

September

62,000

475

4,100

October

82,000

345

3,250

November

60,000

350

3,260

December

70,000

335

3,015

a) Using the High-Low method of cost estimation and Number of Photocopies as the cost driver, what would be the resulting cost equation for Maintenance Costs?

b) Using Excel, perform three regression analyses to regress Maintenance Costs against Number of Photocopies, then against number of Hours of Maintenance Service, then against both of them simultaneously. Paste your results into Word. State the cost equation from each. Prepare a report to management including an analysis and comment on the results of each regression with a reasoned recommendation of the best cost driver to use in the future.

c) If the simple regression using Number of Photocopies were adopted, what would be the predicted overhead in a month when there were 85,000 photocopies and 500 hours of maintenance service?

QUESTION 5: CVP Analysis

A smart phone manufacturer makes two types of smart phones, Connect32 and Connect64. He has sales staff who sell the phones on commission. The following data are available:

Product

Sales Price

Variable Production Cost  

Sales Commission

Connect32           

$600

$100

$20

Connect64

$850

$375

$35

Fixed costs per annum are $120,000.

a) Calculate the unit contribution margin for each product.

b) This year the manufacturer will specialise in making only Connect32 phones. How many does he need to sell to break even?

c) If Connect32 phones are still the only product what is the breakeven sales volume for the year in sales dollars?

d) He now decides to manufacture both phones this year in the ratio of 3 Connect64 to 1 Connect32.

i. How many of each phone must be sold to earn a profit of $195,000 before tax for the year?

ii. How many of each phone must be sold to earn a profit of $140,000 after tax (of 30c in the dollar) for the year?

Reference no: EM131203848

Questions Cloud

Real gdp does during the business cycle : Briefly explain whether production of each of the following goods is likely to fluctuate more or less than real GDP does during the business cycle:
Effect on the net operating income of the company as whole : Bed & Bath, a retailing company, has two departments, Hardware and Linens. The company’s most recent monthly contribution format income statement follows: Total Hardware Linens. f the Linens Department is dropped, what will be the effect on the net o..
Specific hierarchical courses of action : Should specific hierarchical courses of action be made for laborers who wish to join profession and kid raising? Clarify why or why not. Assume specific authoritative courses of action must be made for such specialists. Recognize steps that organi..
Determine the current through the source resistor rs : Determine the current through the source resistor Rs of each network of given figure using either mesh or nodal analysis. .
What would be resulting cost equation for maintenance costs : Using the High-Low method of cost estimation and Number of Photocopies as the cost driver, what would be the resulting cost equation for Maintenance Costs
Determine whether would encourage or discourage job seekers : Use the Internet to explore the website of one (1) company that has an online application process. Next, critique the online application process and site design to determine whether it would encourage or discourage job seekers to apply. Suggest tw..
Competitive firm demand for labor : What determines a competitive firm's demand for labor? (150 Words) How does labor supply depend on the wage? (150 Words) What other factors affect labor supply? (150 Words)
Non-controlling interest share of subsidiary net income : Tray Co. reported current earnings of $560,000 while paying $56,000 in cash dividends. Sparrish Co. earned $140,000 in net income and distributed $14,000 in dividends. What is the non-controlling interest's share of the subsidiary's net income?
Replace t configuration of given figure with p configuration : Replace the T configuration of given figure (composed of 6-kΩ resistors) with a π configuration. - Solve for the source current Is1.

Reviews

len1203848

9/13/2016 3:00:26 AM

Need it as per the guidelines, in 1 or 2 questions, you have to do it in excel and paste it on word document but I would like to have the excel file as well. Make sure u do it the best alright because this is my final assignments for this semester it’s very important for me to score well to pass, reference properly if you refer to any source, mostly its calculations. Completely correct application of rational decision making techniques to business problems including ability to evaluate further information prior to decisions and completely correct use of Excel to simulate decision situations involving probabilistic states of nature and also Correct use of CVP analysis to single and multi-product firms.

Write a Review

Applied Statistics Questions & Answers

  Social sciences undergraduates had a preferred method

A university librarian wanted to determine if social sciences undergraduates had a preferred method for searching the Internet for sources for academic papers. Over a 5-day period she randomly surveyed 100 students who came into the CSUDH library and..

  Identify the null hypothesis h0 and alternative hypothess

1. Identify the null hypothesis H0 and the alternative hypothesis H1.  A researcher claims that 62% of voters favor gun control. Select one: a. Ho: p ≥ 0.62 H1: p

  Correlation between the amounts of profits and total sales

Is there a positive correlation between the amounts of profits (Dependent Variable) and total sales (Independent Variable) based on the costs of the process of production and distribution?

  Develop a frequency distribution for thirty team values

Develop a frequency distribution and a frequency histogram for the 30 team values. Then describe the distribution of team values.

  What is the value of the test statistic and the chi-square

What is the value of the test statistic and the chi-square table, the most accurate statement that can be made about the p-value

  Ten percent of the population is left-handed

Ten percent of the population is left-handed. A class of 1800 students is selected. Convert the binomial probability P(x ≥ 15) to a normal probability by using the correction for continuity. P(x ≤ 15.5) P(x ≥ 14.5) P(x ≥ 15.5) P(x

  How frequently should the equipment receive periodic mainten

The length of time (in months after maintenance) until failure of a bank’s surveillance television equipment has a Weibull distribution with α = 2 and β =60 months. If the bank wants the probability of a breakdown before the next scheduled maintenanc..

  State the margin of error

Describe in detail how you would construct a 95% confidence interval for a set of 30 data points whose mean is 20 and population standard deviation is 3. Be sure to show that you know the formula and how to plug into it.Also, clearly state the margin..

  1 in this exercise we will be building regression models

1. in this exercise we will be building regression models for predicting house prices. we will be using data collected

  Find the limiting distribution of zn using mgf method

Let Zn = (Yn - np)/√(npq). Find the limiting distribution of Zn using MGF method.

  The distribution of resistance for certain types of resistor

The distribution of resistance for certain types of resistors (measured in ohms) is normallydistributed with mean μ and standard deviation σ. What should the value of σ be if we want tomake sure than 90% of the resistors have resistances that are wit..

  What fraction of defective items get by both inspectors

A certain manufactured item is visually inspected by two different inspectors - What fraction of the defective items get by both inspectors

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