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

  Nashville corporation-short term and long term use

Nashville Corporation allocates administrative costs on the basis of staff hours. Short-run monthly usage and long-run monthly usage of the staff hours for Operating Departments 1 and 2 follow.

  Rosely hsa decision-relevant costs sunk incremental costs

Explain any opportunity, sunk, out-of-pocket, and/or relevant costs that figured in Rosley's decision. How did Rosley compute the $400 per month savings?

  Prepare a schedule to allocate service department costs

Prepare a schedule to allocate Service Department costs to the Production Departments by the direct method, rounding all dollar amounts to the nearest whole dollar.

  Non-manufacturing fixed costs

George Ltd manufactures two types of coils used in electric motors. The two types are: C20 and D40. They both require plastic and metal. Information for the two products for the month of April is given

  Multiple changes in cash conversion cycle

Garrett Industries turns over its inventory 6 times each year, it has an average collection period of 45 days and an average payment period of 30 days. Calculate the firm's cash conversion cycle, its daily cash operating expenditure, and the amoun..

  Discuss how your organization might use the findings

The purpose of the study defines what the researcher wants to find out and is found in the introductory section of the research article. Sometimes the purpose contains a research questions.

  The rothmueller museum answer the required questions at the

the rothmueller museum answer the required questions at the end of page 2.nbsp use the below to assist you in

  How much would mardist have to sell to achieve a profit

Mardist Corporation has sales of USD100,000, variable expenses of USD75,000, fixed expenses of USD30,000, and a net loss of USD5,000. How much would Mardist have to sell to achieve a profit of 10% of sales?

  Track the costs of the product

Describe how the selected system would work to track the costs of the product - identify the cost driver, and explain the process of tracking the costs and provide examples of products that EEC might offer for which a job-order costing system would b..

  Calculating allocated fixed cost

Urban Athletics Company has two store locations, North and South. During October, the company reported net income of $192,000 on sales of $905,000.

  Calculate the variances for the year

Calculate the variances for the year ended December 31,2011, identify the person/department to get additional information from regarding the variances and lastly suggest one plausible explanation for each variance.

  Why is management concerned about the effectiveness

What are general controls? What is the relationship between general computer controls and application controls? Why is management concerned about the effectiveness of these controls?

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