Calculate the unit contribution margin for each product

Assignment Help Basic Statistics
Reference no: EM131044996

Question 1- 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.4 and the probability that demand will be poor (s2) is 0.6.

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

 

s1

s2

a1

$24,000

$15,000

a2

-$4,000

$40,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 70% of the time.

(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? Why?

Question 2 - Simulation

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

A factory has a toolshop in which one person serves toolmakers and is paid $75 per hour. Toolmakers employed by the factory must go to the toolshop for new tools, and are paid $100 per hour. Over a period of time it has been noted that the time between arrivals of toolmakers at the toolshop and the time to serve a toolmaker are as follow:

Time between Arrivals (minutes)

Relative Frequency

  3

     0.01

4

 0.15

5

 0.20

6

  0.20

7

 0.35

8

   0.09

 

      1.00

 

Service Time (minutes)

Relative Frequency

5

0.1

6

0.2

7

0.4

8

0.2

9

0.1

 

1.0

(a) Using Excel set up a simulation model to simulate about 2 hours (120 minutes) from time zero, and determine whether one attendant is sufficient or whether it is profitable to place a second attendant in the toolshop.

(b) Provide the costs over the 2 hours for the toolmakers' lost time and for the attendant's wages.

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. See Spreadsheet Advice in Interact Resources for guidance.

(c) Your manager has suggested that a reorganisation of the toolshop could reduce the time taken to serve the toolmakers by 2 minutes, ranging from 3 to 7 minutes per toolmaker (but with the same relative frequencies as in parts (a) and (b)). Change the data for service times in your model (copy the model to make the changes, keeping the original model intact). Write a report to your manager explaining your conclusions, suggesting how much might be spent on the reorganisation and still be as well off.

The report must be dated, addressed to the Manager and signed off by you.

Question 3- Regression Analysis and Cost Estimation

Charles Hospital has recorded the following Administrative Costs and two possible cost drivers over the last year.

Administrative Costs ($)

Patient Load (Number)

Emergency Procedures (Number)

13,900

1,400

10

7,000

500

11

6,000

400

5

10,000

1,000

10

11,900

1,300

12

9,200

900

14

10,200

1,100

8

4,100

300

7

9,400

700

12

11,100

1,200

12

8,300

600

8

16,100

1,500

16

(a) Using the High-Low method of cost estimation and Patient Load as the cost driver, what would be the resulting cost equation for Administrative Costs?

(b) If the simple regression using Patient Load were adopted, what would be the predicted overhead in a month when there were 1,000 Patients and 10 Emergency Procedures?

Question 4 - CVP Analysis

A bicycle manufacturer makes two types of 21-speed bicycles, Road Bikes and Track Bikes. He has sales staff who sell the bikes on commission. The following data are available:

Product           Sales Price       Variable Production Cost       Sales Commission

Road bikes          $500                    $275                                $25

Track bikes         $300                    $125                                $15

Fixed costs per annum are $65,000.

Required:

(a) Calculate the unit contribution margin for each product.

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

(c) If Road bikes are still the only product what is the breakeven sales volume for the year in sales dollars?

(d) He now decides to manufacture both bikes this year in the ratio of 3 track bikes to 1 road bike.

(i) How many of each bike must be sold to earn a profit of $88,000 before tax for the year?

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

Reference no: EM131044996

Questions Cloud

Financial reports of the lowest level of quality reflect : Financial reports of the lowest level of quality reflect: A. fictitious events.
Determine whether you can meet the july 1 deadline : Your own in-house staff will be responsible for integration and quality control. Because the software and the PBC are contract items, you must carefully monitor the integration phase.
Low-quality financial reporting : Low quality earnings most likely reflect: A. low-quality financial reporting.
Explain why you chose that ethical theory : From your readings, select one Western theory of ethics. Explain why you chose that ethical theory, and then provide a detailed analysis of the applicability of the theory to working as a social science professional.
Calculate the unit contribution margin for each product : A bicycle manufacturer makes two types of 21-speed bicycles, Road Bikes and Track Bikes. He has sales staff who sell the bikes on commission. Calculate the unit contribution margin for each product
Interaction plot with average speedon the vertical axis : Conduct a two-way analysis of variance withageandstrainas the predictor variables andspeedas the response variable. Be sure to include the interaction term betweenageandstrainin the model. Use the GPLOT procedure to create an interaction plot with av..
To properly assess a company past performance : To properly assess a company's past performance, an analyst requires: A. high earnings quality.
Probability of getting a weekend or day student : If a student is chosen at random, find The probability of getting a weekend or Day student. The probability of getting student who is a basketball and Sky Diving.
Discuss the benefits and pitfalls of planning : Discuss the benefits and pitfalls of planning. Describe how to make a plan that works. Discuss how companies can use plans at all management levels, from top to bottom.

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  Calculating correlation using scatter diagram

Develop a scatter diagram for the data and write a brief summary.

  Comparing the appraised value and recent selling price

A real estate agent has collected a random sample of 75 houses that were recently sold in a suburban community. She is particularly interested in comparing the appraised value and recent selling price of the houses in this particular market. The v..

  Find the probability that exactly three experienced insomnia

A random sample of 20 Clarinex-D users is obtained, and the number of patients who experienced insomnia is recorded. Find the probability that exactly 3 experienced insomnia as a side effect.

  Assume that the following data are from a random sample of

assume that the following data are from a random sample of the body temperatures of 55 healthy adults.use excel or your

  Introduction to independent samples t-test

prevent coronary artery vasoconstriction and the attendant reduction in blood flow to the heart and mechanical function.

  Life insurance policies for eight persons

The following data give the annual incomes (in thousands of dollars) and amounts (in thousands of dollars) of life insurance policies for eight persons.

  Chi-square hypothesis test-male-female iq scores

Research results suggest that IQ scores for boys are more variable than IQ scores for girls (Arden & Plomin, 2006). A typical study looking at 10-year-old children classifies participants by gender and by low, average, or high IQ.

  World development indicators database

Rresearch analyst in an environmentally-concerned consultancy group. Your team leader has given you a research task to investigate the empirical relationship between Australia's Gross Domestic Product

  Now use the z score to calculate the weight that would

a farmer believes that the yields of his tomato plaints have a normal distribution with an average yield of 11 lbs and

  Suppose you have an investment a whose return is normally

question suppose you have an investment a whose return is normally distributed with mean 8 and standard deviation of

  How large a sample is needed to guarantee that the

how large a sample is needed to guarantee that the distribution of sample means is approximately normally distributed?

  Estimating-population mean difference

Make a point estimate of the population mean difference in endurance after taking the herbs. Make a 95% confidence interval estimate of the population mean difference.

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