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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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!

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