The Director of Annie Smith Dance Center is asking for assistance with the financial aspects of running a professional group of performers. She wants financial information presented in an easy to read format and a better understanding of the profitability of the concerts and the organization as a whole.
The Annie Smith professional group features three styles of dance concerts each year. Two of the dance concerts showcase a different genre. The third performance is a Christmas Spectacular, which is the most popular and is therefore scheduled every year. The table below provides information about expected ticket sales for the performances.
| Lower Orchestra Section (A) | Upper Orchestra Section (B) | |||||
| Descriptions | No. of Seats. | Ticket Price | Tickets sold per performance | No. of seats | Ticket Price | Tickets sold per performance |
| Hip-Hop Performance | 150 | $85 | 100% | 450 | $50 | 90% |
| Jazz and Tap Dance | 150 | $85 | 100% | 450 | $50 | 60% |
| Christmas Spectacular | 150 | $125 | 100% | 450 | $50 | 100% |
Ms. Smith has prepared a tentative schedule for the coming season. The table below also shows the type and number of performances and direct cost per type of concert.
| Descriptions | Number of Performances | Cost per Dance Concert (direct fixed costs)* |
| Hip-Hop Concert | 10 | $48,000 |
| Jazz and Tap Dance | 5 | 86,000 |
| Christmas Spectacular | 20 | 22,000 |
| Total Direct Fixed Costs | $156,000 |
*Examples of direct fixed costs are costumes, rehearsals, royalties, guest artist fees, choreography, and salaries of production staff, music, and wardrobe for each of the concerts. This amount does not change with the number of performances.
Additional costs:
Variable costs associated with each performance are shown below.
| Musicians | $6,100 |
| Rental of auditorium | 2,500 |
| Dancers' compensation | 6,700 |
Annual general administrative and operating costs for the dance center are:
| Administrative staff | $185,000 |
| Insurance | 25,000 |
| Marketing | 115,000 |
| General office expenses | 90,000 |
Ms. Smith wants the Dance Center to generate at least $300,000 in operating profit. What level of revenues does the performance group need to achieve to meet this goal? Prepare an income statement in good format to support the computations.
No Calculations necessary I am only asking for format and necessary formulas.
Thanks in advance!
In: Accounting
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added at the beginning of the first process. During November, the first process transferred 765,000 units of product to the second process. Additional information for the first process follows. At the end of November, work in process inventory consists of 204,000 units that are 50% complete with respect to conversion. Beginning work in process inventory had $440,895 of direct materials and $151,725 of conversion cost. The direct material cost added in November is $2,950,605, and the conversion cost added is $2,882,775. Beginning work in process consisted of 78,000 units that were 100% complete with respect to direct materials and 80% complete with respect to conversion. Of the units completed, 78,000 were from beginning work in process and 687,000 units were started and completed during the period. Required: For the first process: 1. Determine the equivalent units of production with respect to direct materials and conversion. 2. Compute both the direct material cost and the conversion cost per equivalent unit. 3. Compute the direct material cost and the conversion cost assigned to units completed and transferred out and ending work in process inventory. (Round "Cost per EUP" to 2 decimal places.)
For the first process:
1. Determine the equivalent units of production
with respect to direct materials and conversion.
2. Compute both the direct material cost and the
conversion cost per equivalent unit.
3. Compute the direct material cost and the conversion cost assigned to units completed and transferred out and ending work in process inventory. (Round "Cost per EUP" to 2 decimal places.)
In: Accounting
Please solve Problem 3-11 from your textbook (Introduction to Managerial Accounting; Fifth Canadian Edition, by Brewer, Garrison, Noreen, Kalagnanam, and Vaidyanathan) considering the following new information and requirements:
The company received a request for a 300-Kg order of potassium aspartate.
The customer offers to pay $12.50per Kg for this order.
The company usually adds a 30%markup for this type of orders.
Material requirements
|
Material |
Required Quantity (per Kg) |
Price ($) per Kg |
|
Aspartic Acid |
190.00 |
5.75 |
|
Citric Acid |
10.00 |
2.00 |
|
K2CO3 |
120.00 |
4.50 |
|
Rice |
30.00 |
.50 |
The company pays its production workers an average of $20.00per hour plus $5.00per hour additional labour costs.
Expected direct labour time was 16 hours.
The company also estimated the following:
|
Materials related overhead |
$585,000 |
|
Labour related overhead |
$1,950,000 |
|
Direct material costs |
$1,850,000 |
|
Direct labour cost |
$1,250,000 |
Prepare a job cost sheet for the proposed job. Ignore the job completion status area. (9 points)
What is the gross margin expressed in %, if the customer agrees to pay a price of cost plus 25%? (1 point). Please show all your calculations. (1 point)
What is the total gross margin per total order (expressed in dollar amount) (1 point). Please clearly show all you calculations. (1 point)
What is the gross margin per unit (per Kg) (expressed in dollar amount). (1 point) Please clearly show all your calculations. (1 point)
Assume that the actual production level was only 280 Kg despite using the expected quantity of materials and labour. What is the gross margin of this order: percentage-wise (1 point), total gross margin per order (dollar amount)(1 point), gross margin per unit (per Kg)(dollar amount)(1 point). Please clearly show all you calculations. (1 point)
Solution b:
Total expected cost of order = $3,218.76
Solution c:
Unit (per Kg) cost of this order = $3,218.76 / 300 = $10.73 per kg
Solution d:
Required selling price considering 30% markup = $10.73 + 30% of $10.73 = $13.95 per Kg
Price offered by customer = $12.50 per Kg
As price offered by customer is lesser than minimum required price therefore company should not accept price offered by customer.
Solution e:
If customer agree to pay cost + 25% then
Let cost = $100
Selling price = $125
Gross margin = $125 - $100 = $25
Gross margin percentage = $25 / $125 = 20%
The solutions are to help complete the following questions above.
In: Accounting
Please solve Problem 3-11 from your textbook (Introduction to Managerial Accounting; Fifth Canadian Edition, by Brewer, Garrison, Noreen, Kalagnanam, and Vaidyanathan) considering the following new information and requirements:
The company received a request for a 300-Kg order of potassium aspartate.
The customer offers to pay $12.50per Kg for this order.
The company usually adds a 30%markup for this type of orders.
Material requirements
|
Material |
Required Quantity (per Kg) |
Price ($) per Kg |
|
Aspartic Acid |
190.00 |
5.75 |
|
Citric Acid |
10.00 |
2.00 |
|
K2CO3 |
120.00 |
4.50 |
|
Rice |
30.00 |
.50 |
The company pays its production workers an average of $20.00per hour plus $5.00per hour additional labour costs.
Expected direct labour time was 16 hours.
The company also estimated the following:
|
Materials related overhead |
$585,000 |
|
Labour related overhead |
$1,950,000 |
|
Direct material costs |
$1,850,000 |
|
Direct labour cost |
$1,250,000 |
Prepare a job cost sheet for the proposed job. Ignore the job completion status area. (9 points)
What is the gross margin expressed in %, if the customer agrees to pay a price of cost plus 25%? (1 point). Please show all your calculations. (1 point)
What is the total gross margin per total order (expressed in dollar amount) (1 point). Please clearly show all you calculations. (1 point)
What is the gross margin per unit (per Kg) (expressed in dollar amount). (1 point) Please clearly show all your calculations. (1 point)
Assume that the actual production level was only 280 Kg despite using the expected quantity of materials and labour. What is the gross margin of this order: percentage-wise (1 point), total gross margin per order (dollar amount)(1 point), gross margin per unit (per Kg)(dollar amount)(1 point). Please clearly show all you calculations. (1 point)
Solution b:
Total expected cost of order = $3,218.76
Solution c:
Unit (per Kg) cost of this order = $3,218.76 / 300 = $10.73 per kg
Solution d:
Required selling price considering 30% markup = $10.73 + 30% of $10.73 = $13.95 per Kg
Price offered by customer = $12.50 per Kg
As price offered by customer is lesser than minimum required price therefore company should not accept price offered by customer.
Solution e:
If customer agree to pay cost + 25% then
Let cost = $100
Selling price = $125
Gross margin = $125 - $100 = $25
Gross margin percentage = $25 / $125 = 20%
The solutions are to help complete the following questions above
And please solve the questions based on the 30% mark up.
In: Accounting
After graduating from university last year with a degree in accounting and finance, Jim Hale took a job as a trainee analyst for an investment company in Melbourne. Jim’s first few weeks were filled with a series of rotations throughout the firm’s various operating units, but this week he was assigned to one of the firm’s traders as an analyst. On Jim’s first day, his boss called Jim in and told him he wanted to do some rudimentary analysis of the investment returns of the regional airline Regional Express Holdings Ltd (REX). Specifically, Jim was given the following month-end closing prices for the company spanning the months from September 2019 to August 2020:
| Date | Closing Price | Date | Closing Price |
| 30 Aug 13 | 1.11 | 31 Mar 14 | 0.81 |
| 30 Sep 13 | 1.04 | 30 Apr 14 | 0.77 |
| 31 Oct 13 | 1.03 | 30 May 14 | 0.75 |
| 29 Nov 13 | 0.92 | 30 Jun 14 | 0.75 |
| 31 Dec 13 | 0.93 | 31 Jul 14 | 0.89 |
| 31 Jan 14 | 0.91 | 29 Aug 14 | 0.82 |
| 28 Feb 14 | 0.82 |
Jim was then instructed by his boss to complete the following tasks using the REX price data (note that REX paid no dividend during 2008).
1. Compute the monthly realized rates of return earned by REX for the entire year.
2. Calculate the average monthly rate of return for REX, using both the arithmetic and geometric averages.
3. Calculate the year-end price for REX, computing the compound value of the beginning-of-year price of $ 1.11 per share for 12 months at the geometric average monthly rate of return calculated earlier: End-of-year stock price = Beginning-of-year stock price X (1+ Geometric average monthly rate of return)12
4. Compute the annual rate of return for REX using the beginning share price for the period and the ending price (i.e. $1.11 and $0.82).
5. Use the geometric average monthly rate of return and the following relationship to calculate the annual rate of return: Compound annual rate of return= (1+ Geometric average monthly rate of return)12 -1
6. If you were given annual rate of return data for REX or any other company’s shares and you were asked to estimate the average annual rate of return an investor would have earned over the sample period by holding the shares, would you use an arithmetic or geometric average of the historical rates of return? Explain your response as if you were talking to a client who has had no formal training in finance or investments.
In: Finance
After having taken an MBA a friend of yours is planning to open a cafeteria in a well-known Pyrenees ski resort. In order to prepare the forecasted financial expenses for a potential investor he has asked you some help in order to double check the financial statements of the business.
The cafeteria would only be opened for 6 months (180 days), starting the 1st of November and until the 30th of April, so you must consider all the financial statements on a semester basis.
Expected sales in average:
During the season, the cafeteria will host 2 private events for special guests of the resort:
Additionally, there will be extra revenues by selling souvenirs as postcards and fridge magnets. The forecast is to sell an equivalent of the 10% of the total revenues (excluding the private events). The cost of the souvenirs is barely the 10% of its price with collecting & payment conditions being the same as the rest of the cafeteria products.
The direct cost of the ingredients of every meal or food/beverage served is as following (over price):
The costs related to the goods sold (food, beverages, special events, souvenirs) will pe paid in average 30 days after its consumption.
You expect to have a stable headcount of the following positions:
Salaries will be paid at the end of the month while SS taxes at the end of every calendar quarter.
Consumption of water, power and heat are expected to amount 3.000€ per month. Since the payments is usually in 60 days, at the end of the season 1/3 of the utilities will remain unpaid.
As part of the agreement with the ski resort, cafeteria will have to liquidate and pay a royalty of an equivalent of the 10% of the total semester revenues (to be paid the month after the season ends).
Additionally, it has been calculated that other general expenses, as alarms, cleaning, kitchen tools, etc. will amount a 3% of the revenues, all of them paid within the season period.
The cafeteria will have to invest 60,000€ in order to purchase some necessary assets for the operation, as chairs, tables, shelves, a fridge, an oven and cutlery. All those elements will be sold after the season at a 50% of its price value. All of them are expected to be paid during the first 3 months, while the collection of the end-season sale will be expected 60 days after the closing.
With the purpose to face the initial investment payment for the assets acquired, contemplate to get a bank loan with a 6 months maturity, repaid (principal plus interests) on the 30th April with a 6% annual compound interest rate.
Consider that 50% of the total revenues (including souvenirs and special events) are paid with credit card which results in a 1,5% financial cost for the cafeteria. The rest is being paid upfront.
Estimated tax provision is 25%, to be paid 60 days after the closing balance of the season.
The Balance sheet at the beginning of the period (1st November) only contained 10.000€ of Cash and 10.000€ of Capital stock.
In: Accounting
Guy is considering buying a new lawnmower. He has a choice between a DAT mower and a Beast mower. Guy has a MARR of 10%. The salvage value of each mower at the end of its service life is zero.
|
DAT mower |
Beast mower |
|
|
First Cost |
$450 |
$350 |
|
Life |
10 Years |
10 Years |
|
Annual Gas Cost |
$80 |
$100 |
|
Annual Maintenance Cost |
$30 |
$40 |
In: Economics
A newly replaced light bulb is used until it burns out and then is replaced immediately by another. The two bulbs are selected randomly from a large lot of bulbs that the manufacturer says have an approximately normal lifetime distribution with a mean of 800 hours and a standard deviation of 100 hours. Describe the distribution of the total lifetime of the two bulbs used in sequence. What is the probability that the sum of the two lifetimes exceeds 1800 hours? What is the probability that the sum of the lifetimes of nine such bulbs selected at random and burned sequentially exceeds 8100 hours? What is the probability that the second light bulb in the sequence burns longer than the first?
In: Statistics and Probability
Application Problem 10-5A a, c-d (Part Level Submission) Sawada Insurance Ltd. issues bonds with a face value of $100 million that mature in 12 years. The bonds carry a 6.3% interest rate and are sold at 106.96 to yield 5.5%. They pay interest semi-annually. Show the journal entries to record the first two interest payments on these bonds. Ignore year-end accruals of interest. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places, e.g. 125.)
In: Accounting
A first-order pressure sensor must meet the following dynamic response specifications: (a) At least 95% accuracy within 0.09s after a step input. (b)The delay corresponding to a ramp input of 60 psi/s is less than 0.02s. (c) Steady-state error of no more than 1 psi for a ramp input of 100 psi/s. (The dynamic error for an input ramp corresponds to the following definition: (d) The dynamic error is to be held smaller than 10% for measuring a turbulent flow with fluctuations of up to 30 Hz. Find a transfer function which has the largest allowable time constant for this sensor.
In: Mechanical Engineering