User Account

All Pages

Provides the higher profit for the season

Assignment Help Managerial Accounting
Reference no: EM13341424

The State Opera Theatre gains significant revenue from ticket sales at each opera performed during the season. The sale of souvenir programs for all performances of each opera also adds to profitability. Each program costs $1.60 to produce and sells for $4.00. Any programs unsold at the end of any opera are donated to a recycling centre and do not produce any revenue.

Records of the programs sold for each opera show the following:

Number of Programs sold
Probability
2500 0.15
2750 0.22
3000 0.24
3250 0.21
3500 0.18

(a) Your manager has asked you to determine the profitability of the souvenir program production. You decide to use Excel to simulate the sale of programs at 10 operas in a season together with the profit or loss on programs for each opera. You decide to investigate the strategy where the number of programs to be printed should be the number sold at the previous opera. You will have to generate a dummy sale for a "previous" opera to begin with. Include a calculation of the total profit/loss for the season and the average profit/loss per opera.

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. (You can do this using the Print Screen command in Excel and then pasting (or CTRL+V) in the Word document.

(b) If the theatre management decided to print 3000 programs for each opera calculate the profit or loss in each of the 10 operas and the average profits for the whole season. You can do this using your simulation model in (a) and adjusting where necessary to incorporate any additional or different calculations. Which of the two production strategies (the one in (a) or the one in (b) provides the higher profit for the season and on average?

(c) Write a report to your manager advising
(1) the advantages and disadvantages of simulation models; and
(2) why a manager might be forced to use simulation instead of an analytical model in dealing with:
(i) an inventory ordering policy, and
(ii) bank teller windows

Reference no: EM13341424

Questions Cloud

Determine the length of the spring in the situation : Hooke's law describes a certain light spring of unstretched length 33.0 cm. When one end is attached to the top of a doorframe and a 7.31 kg object is hung from the other end, the length of the spring is 42.0 cm.
Relevant costs and transfer pricing : View of the managing director of AB Company, what price should Division B charge for XK120, and what volume should be sold in order to maximise return on investment for the company as a whole?
How much would cost just to keep hot water inside heater : Suppose you have an electric hot water heater for your house which is an aluminum cylinder which has a 0.56 m radius and is 1.8 m high. The walls are 1.0 cm thick.
Find a company that has accounting changes : Depreciation was calculated over 2 years on straight-line basis. In 20X2, it determined that the total life should be 10 years with the salvage value of $5,000 at the end its life.
Provides the higher profit for the season : Write a report to your manager advising - the advantages and disadvantages of simulation models and why a manager might be forced to use simulation instead of an analytical model in dealing
Prepare the journal entry to record the exchange : Why it is it important to distinguish between expenses that need to be capitalized and expenses that need to be expensed.
How much energy is lost through the walls of the hot water : Suppose you have an electric hot water heater for your house which is an aluminum cylinder which has a 0.56 m radius and is 1.8 m high. The walls are 1.0 cm thick.
What is the expected value of perfect information : Tversky and Kahneman describe three types of heuristics that people use in judgments under uncertainty. What do they mean by the term heuristics? Briefly describe the ones that they mention
Find the position of the image of the arrow : The left end of a long glass rod 8.00cm in diameter and with an index of refraction of 1.60 is ground, Find the position of the image of the arrow formed by paraxial rays incident on the convex surface

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Forging department-cost per equivalent units

The following information concerns production in the Forging Department for June. All direct materials are placed into the process at the beginning of production, and conversion costs are incurred evenly throughout the process. The beginning inven..

  Elements of management accounting

Critically evaluate the social, cultural or political implications of either the planning, controlling or decision making elements of management accounting.

  What information does marco need to use the tools

Write a one page memo to Marco, in Word, answering the following questions and list three management tools that Marco can use to evaluate whether the new warehousing center will be a good investment.

  Why content of management report might influence activities

Management reports have been a prominent topic the past few years. The term "Management Reports" can be understood in a variety of different contexts and applications. A management report is also included in the annual report to shareholders.

  Managerial accounting and performance measures

What are some of the nonfinancial measures provided by managerial accounting to assist managers in the decision-making process?

  Preview of financial accountant-forecasting

Generally forecasting and planning is considered the preview of the financial accountant or the forecasting and planning department.

  Rational decision making models

Research the Internet and available textbooks for rational decision making models. Discuss your findings in terms of the models you found versus the model offered by Bazerman and Moore on pp 2-3 of your text.

  Question on net cost of call premium

Buchanan Corp. is refunding $12 million worth of 10% debt. The corporation's tax rate is 35%. The call premium is 9%. What is the net cost of the call premium? Please show ALL work of how the answer was composed.

  Record the transactions on the books

Prepare a Statement of Changes in Net Assets for the Employees Retirement Fund for the Year Ended June 30, 2012 and prepare a Statement of Net Assets for the Employees' Retirement Fund as of June 30, 2012.

  Managerial competencies for strength

Which program outcome do you think might add the most value for you? Which managerial competencies reflect current strengths for you?

  Should the company implement the quality program

On the basis of the estimated cost savings for the third quarter of 2013, should the company implement the quality program? Explain your answer fully and include appropriate calculations.

  Case study - retired professor housecleaning

Compute the activity rates for all the activity cost pools and using the activity-based costing system, compute the customer margin for the Anderson family.

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