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

  Variances are not explanations

Two comments frequently are mentioned in relation to standard costing and variance analysis: "Variances are not explanations" and "Management's goal is not to minimize variances."

  Role of cost drivers in activity-based cost system

What is the role of cost drivers in an activity-based cost system? Explain how analysis of cost drivers can be useful in identifying inefficient activities and the cause(s) of inefficiency.

  Develop a comprehensive analysis using npv

Develop a comprehensive analysis using NPV, Payback Method, and IRR to develop a recommendation on replacing the existing equipment with a new computerized version.

  What amount of the yyy production costs is avoidable

What is the minimum acceptable price of this one-time-only special order and what other items should Tamworth Cabinets consider before accepting this one-time-only special order?

  Development of cost standards

How are cost standards developed? Discuss the purpose for cost standards

  Managerial accounting case

ACT 6691, Managerial Accounting Case: - Read the case and analyze the information. Prepare a narrative report (or notes to the income statement) addressing why/how quantitative items were selected. The following items must be explained:

  Vintech company standard costing

Vintech Company is planning to produce 1,800 units of product in 2011. Each unit requires 4 pounds of materials at $6 per pound and a half hour of labor at $17 per hour. The overhead rate is 70% of direct labor

  What is the minimum acceptable price

For Tamworth Cabinets, what is the minimum acceptable price of this one-time-only special order and other than price, what other items should Tamworth Cabinets consider before accepting this one-time-only special order?

  Prepare cost of goods manufactured and sold schedules

Prepare a schedule of cost of goods manufactured for the month. Prepare a schedule of cost of goods sold for the month.

  Standard costing problem for petty petroleum

Petty Petroleum, Inc. uses various chemicals to manufacture its products. Variance data for last month for three primary chemicals used in production are as follows (F indicates a favorable variance; U indicates an unfavorable variance):

  Example of cost-volume-profit analysis

Can you give an example of cost-volume-profit analysis using this techniques in your organization or in your past experience?

  Determining amount received on bond issue

Clancy Inc. issues $2,000,000 of 7% bonds due in 10 years with interest payable at year-end. The current market rate of interest for bonds of similar risk is 8%.

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