User Account

All Pages

Determine the profitability of souvenir program production

Assignment Help Managerial Accounting
Reference no: EM13490405

Simulation

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:

1333_table1.png


(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 differentcalculations. 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: EM13490405

Questions Cloud

Calculate the contribution margin for each product : Instead of producing the product mix in part (b), management wishes to use linear programming to find the profit-maximising mix. Write an LP model, and then use Excel's Solver to determine the optimum weekly mix and the resulting weekly profit ..
Define elimination competes with substitution : Elimination competes with substitution. write an equation for the elimination reaction of 2 chloro 2 methylpropane in water
Explain relevant costs and transfer pricing : AB Company specialises in electronic products. Division A makes integrated circuits and sells 90% of its output to outside companies. This division is operating well below capacity.
Explain what is the enthalpy of vaporization : For a particular liquid, raising its temperature from 330 K to 353 K causes its vapor pressure to double. What is the enthalpy of vaporization of this liquid? (R = 8.31 J/(K· mol))
Determine the profitability of souvenir program production : 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.
Calculate the force that is acting on the mass : A 5.0-kg mass starts from rest and accelerates to a velocity of 8.0 m/s in a time of 10.0 seconds. Calculate the force that is acting on the mass
Explain the molal freezing point depression of water : if 11.3g of Ca(NO3)2 dissolves in 115.0g of water, the freezing point is depressed by -3.34C. from this data, what is the molal freezing point depression of water
Provide an opening balance sheet : Provide an opening balance sheet as of 02nd January 2014 and closing balance 31st December 2014
What should he do if he follows the emv criterion : A member of a group of medical practitioners is considering opening his own private medical practice. He estimates that if demand for his services is high he could realise a profit of $500,000. If demand is low he could lose $200,000.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Operating income for the year using variable costing

best estimate of the total contribution margin when 4,300 units are sold - What was Indiana Corporation's net operating income for the year using variable costing?

  Prepare the journal entry to transfer the cost of job

Prepare the journal entry to transfer the cost of job #JK150 out of the work-in-process account at the end of November, What was the under-or over recovered overhead for the year?

  Mix of financial and nonfinancial measure

Find the right mix of financial and nonfinancial measure to perform multiple tasks and identify appropriate remedial actions to be taken when performance falls short.

  Consider the following information prepared based on a

consider the following information prepared based on a capacity of 40000 unitscategorycost per unitvariable

  Role of management accounting

Shows that operating gearing is much higher in Air NZ than The Warehouse.  Note also that the turnover of Air NZ is almost three times that of The Warehouse.

  Master and flexible budget

How much is the total amount of budgeted direct labor for March and What are the direct materials per unit - How much is budgeted sales revenue for the third quarter of 2008?

  Discuss the changing role of management

Do you agree with the statement? Discuss the changing role of management accountants with reference to how it impacts on the current business environment.

  Prepare management accounting information

Prepare and hand in a Project Proposal that includes the nature of the project, the sources of information you plan to use, and the most important concepts and techniques to be applied.

  Financial vs managerial-contribution margin vs cogs

Comment on the employ of functional versus absorption income statement. Explain the differences in presentation and employ of each type of income statement. Describe the contribution margin concept or computation and when to use the information.

  Gasb rules which govern spe health care organization

Summarize the GASB rules that govern an SPE health care organization (like a hospital). Summarize the FASB rules that govern the private not-for-profit health care organization.

  Here are the budgets of brandon surgery center for the most

here are the budgets of brandon surgery center for the most recent historical quarter in thousands of dollarsstatic

  Management accounting formats

Management accounting formats are identical for all companies

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