User Account

All Pages

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

  Determine cost of goods transferred out and ending inventory

Conversion cost $6,644. Compute the cost of goods transferred out and the ending inventory using the weighted average method

  Essential to the effective operation of any costing system

Question 1Essential to the effective operation of any costing system in any business is the ability to define cost units and cost centers. a) Explain the term "cost unit" and illustrate your answer by reference to any manufacturing company and any se..

  What are imports

If Net exports are -$114 billion and the exports are $857 billion. What are imports? that is, in fact, negative 114 in this illustration.

  Partnership income and basis adjustments mark and pamela

partnership income and basis adjustments. mark and pamela are equal partners in mp partnership. the partnership mark

  Complete the cash budget for january and february

Complete the cash budget for January and February below. (List multiple items under receipts, disbursements and financing from largest to smallest amounts, e.g. 10, 5, 2.)

  Compute how are standard quantities or volumes established

How are standard quantities/volumes established? How are standard prices established? How often should these standards be updated?

  Improve the future performance of scc

Use the Boston Consulting Group matrix in order to assess the competitive position of SCC - advise the management of SCC of THREE strategies that should be considered in order to improve the future performance of SCC.

  Prepare the journal entries for january to record job costs

Prepare the Journal entries for January to record job costs in Work in Process and Finished Goods and to record the sale Show subsidia

  Calculate the standard time of the worker so the owner

Calculate the standard time of this worker so the owner can know how to calculate a cost for the labour component of this process.

  Explain why a difference occurs in the unit costs

Distribute the service department costs, using the direct method - Distribute the service department costs, using the sequential distribution method, with the department servicing the greatest number of other departments distributed first.

  Qthe cupcake factory plans to start a new retail store in

qthe cupcake factory plans to start a new retail store in medina ohio. the cupcake factory may sell specialty cupcakes

  Give difference between normal costing and actual costing

Give the difference between normal costing and actual costing. Present in TABULAR form. Also, why is normal costing preferred over actual costing?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd