Which excel formulas determine optimal inventory levels

Assignment Help Cost Accounting
Reference no: EM132770390

Problem 1: Demand for devil's food whipped-cream layer cake at a local pastry shop can be approximated using a normal distribution with a mean of 24 and a standard deviation of 4. The manager estimates it costs $9 to prepare each cake. Fresh cakes sell for $21. All day-old cakes sell for $6. At this price, there is an ample demand for day-old cakes. Which one of the following Excel formulas determine optimal inventory levels?

Select one:

a. =NORMDIST(0.8,24,4,1)
b. =NORMINV(0.2,24,4)
c. =NORMINV(0.8,24,4)
d. =NORMINV(1,24,4)
e. =NORMDIST(1,24,4,1)
f. =NORMDIST(0.2,24,4,1)

Reference no: EM132770390

Questions Cloud

Determine the firm value and the wacc : Timco has EBIT of 100. This should continue forever. The tax rate is 40%. The cost of equity is 10%. Find the firm's value and the WACC if Timco uses no debt.
What explains the behaviour of british mnc client : What explains the behaviour of British MNC Client Mr SmytheJones the best and What is the main reason behind delayed response and inefficiency in preparing
What is the current financial status of the firm : What is the current financial status of the firm? How many units would it have to sell to break even?
Discuss what the given statement means to you : Discuss what the following statement means to you and how it can be used to increase the effectiveness of a community health worker.
Which excel formulas determine optimal inventory levels : At this price, there is an ample demand for day-old cakes. Which one of the following Excel formulas determine optimal inventory levels?
What is the meaning of discounting : Explain fully with example - What is the meaning of discounting? Provide an illustration of this.
Calculate optimal service level for demand for it-is-hot : Calculate optimal service level. Profit on each pound of ice-cream is $16. This ice-cream is made in one batch at the begging of the day
Describe the expected interest groups : Describe the expected interest groups and there specific arguments. Describe the expected interplay between demanders and suppliers, interest groups.
Explain hofstedes cultural dimensions of china : Do the insights of the film reflect China's attitude towards women today? Compare the views on women, of Pakistan to those of China, in terms of Hofstede's

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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