1 answer

Data from the case and Exhibits has been entered into the boxes below. To facilitate your...

Question:

Data from the case and Exhibits has been entered into the boxes below. To facilitate your calculations and analysis, reorganiPrepare the Variable Costing Statement below using cell referencing to information from the Data Entry and Underlying Calcula

Data from the case and Exhibits has been entered into the boxes below. To facilitate your calculations and analysis, reorganize the data into information related to assumptions related to ticket receipts, variable costs, step costs and fixed costs. Hidden costs (for Case Analysis Q4 are already identified. Hint: use column C to classify the items as Reciepts), Variable), Step) or Fixed). Save your work. Use Data Sort to reorganize the information. Be sure to capture the label, classifciation, #, and additional information in your sort. Assumptions $200 $575 Food for rehearsals + Food in-kind donation from Russo Farms $1,000 $30 $360 $300 $500 50% Copyright payment Food during performances and rehearsals Hall rental per week, including practices and performance One-time ticket set-up fee Publcity for various ads, interviews, Facebook ads, etc. Rental for rehearsal Lighting and sound Average occupancy per show Estimated number of shows Estimated percentage of adult ticket Estimated percentage of student and senior ticket Maximum capacity Price per ticket - adult Price per ticket - student and senior Brochures and printing Facility fees House management Number of sound technician hours per show Number of technical support hours per show Sound technician (4-hour minimum) Technical support and lighting (4-hour minimum) Ticket convenience charges Hidden Costs Transporting stage décor furniture Bookkeeping for production Marketing on social media service Graphic design for Kamala poster Rental cost of furniture Stage decoration service 70% 30% seats 90 including $5 in fees $25 including $5 in fees $22 $150 per ticket $2 per show $60 1.5 hours per show 1.5 hours per show $30 per hour $30 per hour $3 per ticket $500 $300 $300 $500 $200 $500
Prepare the Variable Costing Statement below using cell referencing to information from the Data Entry and Underlying Calculations spreadsheets. Display unit price and unit contribution margin to nearest $.01 (one cent). All other financial numbers should be displayed to the nearest $1 (one dollar). Round up for all breakeven points in tickets. Round breakeven dollars normally to the nearest $1 (one dollar). Two check figures have been provided. Per Run with 3 Shows Per Run with 4 Shows 3 Per Ticket Per Show Price per ticket Variable cost per ticket Contribution per ticket Number of Tickets per show Contribution margin per show Number of Shows per Run Contribution margin per Run Step costs per show Step costs per Run Fixed costs per Run Hidden costs per Run Total step costs and fixed run per Run Operating Income Before Donations (per Run) Add: Cash and In-Kind Donations Net Operating Income ($2,786.50) Calculate breakeven w/Hidden Costs, but no Sponsorship Average price per ticket Average variable cost per ticket Average contribution margin Number of tickets needed to break even Ticket receipts needed to break even Average number of tickets needed to break even per show Break-even occupancy 79 Calculation of breakeven w/Hidden Costs, but no Sponsorship Number of tickets needed to break even Ticket receipts needed to break even Average number of tickets needed to break even per show Break-even occupancy
Business Accounting
< Previous
Next >

Answers

$200 $575 Food for Rehearsals + Food in Kind donation from Russo Farms $1,000 $30 $360 $300 $500 50% 100 102 Copyright paymen

.

Similar Solved Questions

1 answer
سؤال 1 The ionization energy is the energy necessary to remove an electron from the neutral...
سؤال 1 The ionization energy is the energy necessary to remove an electron from the neutral atom Right or wrong? السؤال 2 Conduction in semiconductors occurs by both electrons and holes. Right or wrong? السؤا&#...
Read question...
1 answer
What is the least common multiply that will eliminate the denominator in 1 +2 -3? Solve...
What is the least common multiply that will eliminate the denominator in 1 +2 -3? Solve - +2=...
Read question...
1 answer
PROBLEM, DUE 11/27/2018 IN CLASS Consider a real pulley. Unlike the pulley we used previously in...
PROBLEM, DUE 11/27/2018 IN CLASS Consider a real pulley. Unlike the pulley we used previously in class, in a real pulley there is friction between the pulley and its axle, and rotational inertia that must be taken into account. axle R 30cm Fr 18N Thr 1.1Nm frictional torque w 30 rad/sec t 3sec m 4kg...
Read question...
1 answer
Opening Case: Is China Dumping Its Excess Steel Production? QUESTION 1: Provide an overview of the...
Opening Case: Is China Dumping Its Excess Steel Production? QUESTION 1: Provide an overview of the current situation in the global steel market. As a steel producer from the United States, how do you feel about the dynamics described in the case? If you were a steelworker in the United States, what ...
Read question...
1 answer
REINFORCE YOUR SKILLS: E8-R3 Calculate Company Matching Amount In this exercise, you will look up the...
REINFORCE YOUR SKILLS: E8-R3 Calculate Company Matching Amount In this exercise, you will look up the amount employees will receive into their retirement savings after Kids for Change decides to implement a tiered system to encourage employees to save more for retirement. 1. Open the E8-R3-Savings f...
Read question...
1 answer
-120 points SerCP11 15.3.P.031. 13. My Notes Ask Your Teacher In the figure below, determine the...
-120 points SerCP11 15.3.P.031. 13. My Notes Ask Your Teacher In the figure below, determine the point (other than infinity) at which the total electric field is zero. 1.0 m 6.0 μC -2.5 μC m to the left of -2.5 x 10-6 C charge Need Help? Read It...
Read question...
1 answer
A Korean firm borrowed $1 million at 8% (per annum, annual compounding) for 3 years on...
A Korean firm borrowed $1 million at 8% (per annum, annual compounding) for 3 years on January 3, 1995. The exchange rate on the borrowing date was 791.8 Korean won per dollar.On the Maturity date (January 3, 1998), the exchange rate was 1695 Korean won per dollar.What was the effective borrowing ra...
Read question...
1 answer
An emf of 20.0 mV is induced in a 460-turn coil when the current is changing...
An emf of 20.0 mV is induced in a 460-turn coil when the current is changing at the rate of 10.0 A/s. What is the magnetic flux through each turn of the coil at an instant when the current is 4.80 A? (Express the magnitude in µT · m2)...
Read question...
1 answer
(3.)(25 points) Consider the following electric power network illustrated in Fig. ure 1 below. 392 1992...
(3.)(25 points) Consider the following electric power network illustrated in Fig. ure 1 below. 392 1992 6+ LINE V LINE LOAD LOAD 16 Figure 1 VR = 5.020 kV Vs = 5.0250kV Answer the following questions. (a.) Find ILOAD (b.) What is the power factor of the load? (c.) What is the complex power of the lo...
Read question...
1 answer
A device for exercising the upper leg muscle is shown below along with a schematic representation...
A device for exercising the upper leg muscle is shown below along with a schematic representation of an equivalent lever system. Calculate the force exerted by the upper leg muscle, Fm, to lift the mass at a constant speed. F. = 2.0 cm F Pivot Femur = 35 cm 10kg W T Fm = 1715 N....
Read question...
1 answer
(2) (9 pts.) Propose a reasonable chemical reaction to carry out each task below. All common...
(2) (9 pts.) Propose a reasonable chemical reaction to carry out each task below. All common ion salts and acids are available as reactants. Write only the balanced formula unit equation for each. Indicate the physical state of the products. Unlabeled compounds will be considered (aq). (a) Synthesiz...
Read question...
1 answer
13- (Choose the right answer). An organizational plan generally covers a time period of A. Four...
13- (Choose the right answer). An organizational plan generally covers a time period of A. Four years B. One year C. Five years D. Twenty years...
Read question...
1 answer
1). Two dice are rolled, and the results are added. Assuming that this number is greater...
1). Two dice are rolled, and the results are added. Assuming that this number is greater than or equal to 8, what is the probability that one of the dice rolled a 6? 2). In the game “raven’s beak,” a player rolls 6 dice, and wins if at least three of the dice roll the same number. ...
Read question...
1 answer
PLEASE DRAW THE FREE BODY DIAGRAM Problem 2: (30 points) Find the tension, T, that must...
PLEASE DRAW THE FREE BODY DIAGRAM Problem 2: (30 points) Find the tension, T, that must be applied to pulley A to lift the 1200 N weight. 1200 N...
Read question...
1 answer
Mr. Shepherd has gone outside to shovel snow on a cold day. How does his body...
Mr. Shepherd has gone outside to shovel snow on a cold day. How does his body maintain a relatively constant body temperature? What is this process called?...
Read question...
1 answer
Find the following z values for the standard normal variable Z. (You may find it useful...
Find the following z values for the standard normal variable Z. (You may find it useful to reference the z table. Negative values should be Indicated by a minus sign. Round your answers to 2 decimal places.) a. PZSz) 0.9474 b. P(Z>z) 0.7103 d. |Plo szsz) = 0.2507...
Read question...
1 answer
Question 8 (2 points) X Corporation has book income before taxes of $600,000 and you are...
Question 8 (2 points) X Corporation has book income before taxes of $600,000 and you are provided with the following information for the year: • Included dividends from a 20% owned Sub $100,000 • Tax Exempt Municipal Interest $160,000 • Depreciation: Per Books $100,000 Tax $200,000 Co...
Read question...