Questions
#8. Cost Volume Profit Analysis Scenario Mirabel Manufacturing is a small but growing company that manufactures...

#8. Cost Volume Profit Analysis
Scenario

Mirabel Manufacturing is a small but growing company that manufactures and sells marine sonar equipment. They employee a national sales force and their primary customers are marine retailers and boat dealerships. The company has expanded over the last 5 years and Paul Mirabel, the founder and CEO has become concerned that he no longer has a clear picture of their cost structure. He calls his CFO, Mary Jane Montgomery in for a meeting.
“Mary Jane, I am concerned that I am not current on our cost structure and how that is impacting our bottom line,” Paul begins.
“Well, Paul, the company has grown considerably over the past 5 years, so I’m not surprised that you feel a little disconnected with how things are going,” Mary Jane replied. She continued “In fact, I’ve been meaning to talk to you about a couple of big items such as increasing the sales commission to 15%. We’ve lost two of our best account managers in the last 9 months. It seems like we are behind the curve paying only 12% on gross sales.”
“What do you mean we are behind the curve,” Paul replied angrily. “We have always been the leader in every aspect of our business.”
“Well, that may have been the case in the past, Paul, but frankly we need to step up our compensation package to stay competitive,” Mary Jane replied. She continued, “And that’s not everything. I met with Frank Jacobs from marketing and he said we need to have a bigger presence at the trade show in March. He told me he would need about $650,000 added to the marketing budget to support new marketing materials.”
“Come on, Mary Jane, how can we do that when we are going to have to increase commission?” He continued, “I spoke with Dan Clark in production and he indicated that we have two pieces of equipment that need to be replaced by the end of the quarter and that’s going to set us back almost $1.2 million.”
Mary Jane shook her head. “Paul, I hate to bring this up but while we are talking costs, but Bob in purchasing stopped by the office and dropped off some revised cost information – it looks like several of our suppliers are talking about significant price increases by the end of the year.”
Paul slumped in his chair. “This is a mess, Mary Jane. Increasing commissions, new equipment, materials price increases and marketing expenses all at once. Even if Frank Mallow is correct that we should see a 10% increase in sales for the coming year, I just don’t see how we can make this work. We have to maintain enough profit to keep the shareholders happy and I can’t sleep when we dip below that $2 million margin of safety.”
Mary Jane gathered up her papers. “Before you get too distressed, let me put together some figures and let’s see what this looks like on paper. I’ll get back to you by the end of the week. In the meantime, stay positive, we’ll find the best solution.”
The following income and cost data for Mirabel is provided:
Mirabel Manufacturing
Budgeted Income Statement
For the Year Ending December 31
Sales
$ 36,750,000
Cost of goods sold:
Variable
$ 13,300,000
Fixed
$ 9,300,000
Gross Margin
$ 14,150,000
Selling & Administrative
Commissions
$ 4,410,000
Fixed Marketing Expenses
$ 1,350,000
Fixed Administrative
$ 6,000,000
Net Operating Income
$ 2,390,000
Model 101
Model 201
Model 301
Normal Annual Sales Volume
16,000
19,000
11,000
Unit Selling Price
$ 650
$ 750
$ 1,100
Variable expense per unit
$ 250
$ 200
$ 500
Questions

(Note: Each of the following questions is independent of the others)
1. What is Mirabel’s over-all break-even point in sales dollars?
2. Assume that sales revenue remains constant, what is the impact on break-even and the margin of safety if Paul takes Mary Jane’s advice and increases sales commission to 15%?
3. If Mirabel purchases the new equipment for $1,200,000, it will increase fixed costs by 10% but will decrease the variable cost per unit for all 3 models by 5%. What will Mirabel’s new break-even point be?
4. If Mirabel invests the additional $650,000 in fixed marketing expenses, sales of the Model 301 are expected to increase by 8%. What is the break-even and margin of safety under these circumstances?
5. If the projection is that sales will increase by 10% in the coming year, can the company afford to also increase commission from 12% to 15%? Why or why not.
6. Assume that sales volume remains fixed but there is a 5% increase in variable expenses (materials cost) for the Model 101 and 301, and a 10% increase in variable expenses for Model 201. What is the new break-even?
Report

Prepare a report from Mary Jane to Don explaining how these changes will affect Mirabel’s overall cost structure. For those changes that are controllable, make a recommendation considering the uncontrollable cost changes. Be certain to consider not only the company’s break-even point, but also the desired margin of safety.

In: Accounting

Looking at statistics to estimate parameters (Variability not considered) Suppose the city interview 100, randomly selected,...

Looking at statistics to estimate parameters (Variability not considered)

Suppose the city interview 100, randomly selected, bicyclists that were involved in accidents that were on roadways without bike lanes and 100 bicyclists that were involved in accidents that were on roadways with bike lanes. They found that from the accidents on roadways without bike lanes 27% of the accidents resulted in a trip to the ER, of the accidents on roadways with bike lanes 13% of the accidents resulted in a trip to the ER.

1. Using only the statistics above does there appear to be much difference in the parameters of interest?

2. What do we call the change in the statistic from sample to sample?

3. Next suppose that the city took 30 random samples, each of size 100 of bicyclists that were involved in accidents that were on roadways without bike lanes. From each sample they calculated a statistic. They create a sampling distribution using the statistics. Where do we expect the sampling distribution to be centered (i.e. the mean)? Hint: You will describe the value using words not numbers.

In: Statistics and Probability

Ivanhoe Co. provides music lessons to many clients across the city. The following information is available...

Ivanhoe Co. provides music lessons to many clients across the city. The following information is available to be used in recording annual adjusting entries at the company’s September 30, 2021, year-end: 1. On October 1, 2020, the company had a balance of $1,990 in its supplies account. Additional supplies were purchased during the year totalling $1,790. The supplies inventory on September 30, 2021, amounts to $800. 2. On November 1, 2020, Ivanhoe purchased a one-year insurance policy for $3,120. 3. On January 2, 2021, a client paid $1,560 for six months of lessons starting April 2, 2021. 4. On February 1, 2021, Ivanhoe purchased a grand piano (to be used in music lessons) for $25,200. The piano’s estimated useful life is 12 years. 5. On May 1, 2021, Ivanhoe borrowed $29,400 from the bank and signed a 10-month, 8% note payable. Interest and principal are to be paid at maturity. 6. On August 1, 2021, Ivanhoe signed a contract with a neighbourhood school to provide weekly piano lessons to some of its students for a fee of $1,760 per month. The contract called for lessons to start on September 1, 2021. The school has not yet been sent an invoice for the month of September. 7. On August 15, 2021, the company paid $10,080 to Pinnacle Holdings to rent additional studio space for nine months starting September 1. Ivanhoe recorded the full payment as Prepaid Rent. 8. Ivanhoe’s instructors have earned salaries of $3,370 for the last week of September 2021. This amount will be paid to the instructors on the next payday: October 6, 2021. 9. Music lessons were provided to a local church group for $1,260 on September 30, 2021. Ivanhoe has not yet invoiced the group or recorded the transaction. 10. In early October 2021, Ivanhoe received an invoice for $910 from the utility company for September utilities. The amount has not yet been recorded or paid. Prepare the adjusting journal entries.

In: Accounting

You got a new job as a university professor and want to settle down at East...

You got a new job as a university professor and want to settle down at East Lansing. You found a nice house which is selling for $500,000. You decided to pay a down payment of 10% (no closing cost), and borrow rest of the amount from the bank. This is a fixed payment loan that lasts for 10 years with annual payments. Interest rate is 6%.

Build the amortization table in Excel and show all the numbers.

In: Finance

researchers at a university studied children born with an infection called roseola. the children also have...

researchers at a university studied children born with an infection called roseola. the children also have the causative herpesvirus inserted into their chrome osmoses. At least one parent of each child had the virus in a chromosome of a sampled hair cell. How did the children like;y become infected? and What does the transmission of the viral DNA from generation to generation reveal about the structure of DNA and its replication?

In: Nursing

Juan: 18-year-old teenager, who started university this year so he moved to the capital. He does...

Juan: 18-year-old teenager, who started university this year so he moved to the capital. He does not know how to cook, so he eats away from home. He does not do physical activity, he only does academic activities. Weight: 135 kg Size: 1.90 mt

apply nutritional assessment, nutritional diagnosis, nutritional intervention, and nutritional vigilance

In: Nursing

A large boat with 91.44 m in length and 42.672 m in width is carrying 1,360,777.11...

A large boat with 91.44 m in length and 42.672 m in width is carrying 1,360,777.11 kg of coal along the river with a 2.7432m draft (the height from waterline to bottom of the boat). What is the draft and weight of the boat when the boat is empty (no coal)? What is the draft and weight of the boat if the boat hits a wave and looses 10 tons of coal? Treat the boat as a rectangular cylinder. Use university introductory physics techniques.

In: Physics

Historically, 20% of graduates of the engineering school at a major university have been women. In...

Historically, 20% of graduates of the engineering school at a major university have been women. In a recent, randomly selected graduating class of 210 students, 58 were females. Does the sample data present convincing evidence that the proportion of female graduates from the engineering school has shifted (changed)? Use α = 0.05. Determine what type of error (Type I or II) could be made in the question above.

In: Math

A survey of 300 students is selected randomly on a large university campus. They are asked...

A survey of 300 students is selected randomly on a large university campus. They are asked if they use a laptop in class to take notes. Suppose that based on the​ survey, 135 of the 300 students responded​ "yes."

​a) What is the value of the sample proportion p^?

​b) What is the standard error of the sample​ proportion?

​c) Construct an approximate 95 confidence interval for the true proportion p by takingplus or minus 2 SEs from the sample proportion.

In: Math

In chapter 8 we can see how the course of both Weses' lives have gone in...

In chapter 8 we can see how the course of both Weses' lives have gone in completely different directions. Author Wes is accepted at a prestigious university and receives a scholarship. Other Wes sentenced to life in prison. What do you think was Author Wes Moore's purpose in writing this book? What evidence do you have from the book to back up your answer?

In: Psychology