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

  Develop an executive summary

Develop an executive summary of your findings in a Microsoft PowerPoint presentation format to present to Executive Management.

  Write a report to your manager advising

What should he do if he follows the EMV criterion and what is the expected value of perfect information - write a report to your manager advising - the advantages and disadvantages of simulation models

  What is the goal of the eoq model

What is the goal of the EOQ model and why does a firm hold "safety stock? and what costs are a firm trying to balance when it decides on how much safety stock to hold?

  Payback period and net present value

The Management Accountant of Derby Ltd has produced the following cost estimates relating to the proposal over the next five years: Calculate the transport fleet project - Payback period and net Present Value

  Clarification of cvp analysis

Find out  the value for the manager in conducting a cost-volume-profit analysis.

  Profit priorities from activity-based costing

Case Study On Profit Priorities from Activity-Based  Costing

  Describing managerial accounting

ABC Company pays for purchases 40% in the month of purchase, and the balance in the following month. Recent purchases have been:

  Who are the stakeholders in this situation

Who are the stakeholders in this situation and what are the potential ethical issues and concerns - what suggestions can you make to reduce these concerns?

  Explain the problem that the managers of the organization

An introductory paragraph which explains the purpose of the memo and summarizes the analysis that you have conducted, your findings and your recommendations.

  Prepare quarterly production budgets for each quarter

The January 1, 2014, inventory of HD-240 is 2,000 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2015 are expected to be 25% higher than sales in the same quarter ..

  Computing budgeted cost of basketballs

Stang Sports Equipment Company made 40,000 basketballs in a given year. Its manufacturing costs were $288,000 variable and $95,000 fixed. Suppose that no price changes will take place in the following year and that no changes in production techniq..

  Performance evaluation based on accounting measures

Read Using Shareholder Value to Evaluate Strategic Choices - The basic principle of the article is that performance evaluation based on accounting measures alone is not sufficient.

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