assignmentcafe.com – Managerial Accounting/2022

assignmentcafe.com –

MBAD 621 – Managerial Accounting

 

Mod 2 – Case Study #1 – Rachel Miller

 

Instructions: Answer the 10 questions in a separate word document using complete sentences and proper grammar.  Please label each question.  Excel Questions (#5 & 7) should be answered on the excel document using formulas.

 

INTRODUCTION  

Rachel Miller has been working in her mother’s business since graduating with a psychology degree from a very good liberal arts college three years ago. Miller’s Gifts sells gift baskets on-line to customers all over the United States. The company had enjoyed significant growth in both sales and net income during its first four years of operation, however, for the past three years, while sales showed steady growth, net income showed a steady decline. Rachel was at a loss to explain this phenomenon but certainly hoped it was not due to her management of the company.

MILLER’S GIFTS  

Rachel’s mom, Mary, started the company seven years ago to earn extra income to help with Rachel’s tuition. For the first two years, Mary ran the business out of the family’s basement in Louisville, Kentucky. By year three, the business grew large enough that Mary moved it to a suitable location in the industrial park. A major competitive advantage was, and is, the UPS hub at the Louisville International Airport. Miller’s Gifts sold gourmet gift baskets on-line in a simple business model: Mary purchased gourmet products from around the U.S., had them shipped to Louisville via UPS, packaged them in gift baskets, and delivered the baskets via UPS.  Due to Mary’s excellent gourmet taste, clever internet marketing, reasonable pricing, frugal operations, and attention to customer service, the business grew quickly. Revenues steadily increased each year, and generated increasing profits for the first four years, but profits have declined the last three years, as shown in Table 1 (Appendix).  

Rachel worked hard the past three years and is very pleased with the increasing sales numbers. She is confident that this has been the result of continuing her mom’s strong business practices combined with adding two additional products to the line of gift baskets. However, she cannot understand why income is decreasing; particularly with the continuing strong sales growth. Rachel is hopeful that profits will rise again when sales exceed $400,000 in 2018. Rachel does take a salary of $35,000 per year, but she replaced a $35,000 per year general manager the company had employed in 2013 and 2014.  

Because of the declining profits in the face of sales growth, it was decided that Rachel should enroll in a part-time MBA program at a local university. She, and Mary, are hopeful that this formal business training will help them understand what is causing the problem, and more importantly, how to solve it.  Please note that the cost of the MBA program is a personal expense of Rachel’s that is not included in Miller’s Gifts Financial Statements.    

GAAP-BASED INCOME STATEMENTS  

From her MBA studies, Rachel used her newly acquired accounting knowledge to prepare GAAP-based income statements for 2011 to 2017, as shown in Table 2 (Appendix). Then, Rachel used her new skills to prepare common-size income statements, as shown in Table 3 (Appendix).

1. Using tables 2 and 3, develop a list of possible explanations for the 2011 – 2017 results.  

2. Prepare a list of questions about decisions and actions that have been taken over the years.    

CONTRIBUTION MARGIN INCOME STATEMENTS  

Rachel wants to know how sales are contributing to profitability. To do so she needs to reconfigure the GAAP-based statements into contribution margin statements. She knows that GAAP-based statements are appropriate for investors and creditors. But, Rachel has learned that contribution margin statements can be more useful for internal decisions making.  Contribution margin statements separate expenses into variable and fixed components, computes contribution margin by subtracting total variable costs from sales revenue, and then subtracts total fixed costs to arrive at net income. Rachel first used the GAAP-based income statements to identify the variable and fixed costs, as shown in Table 4 (Appendix). Rachel then prepared contribution margin income statements, as shown in Table 5 (Appendix), and a schedule of contribution margin percentages, as shown in Table 6 (Appendix).

3. What are the advantages of a contribution margin income statement?  

4. From tables 5 and 6, revise the list of explanations for the results from 2011 – 2017.  

 

BREAK-EVEN ANALYSIS  

An advantage of the contribution margin approach is that we can quickly and easily estimate breakeven sales. Breakeven is simply the amount of sales required to generate a net income of zero; i.e.: to exactly cover total costs (both variable and fixed). Sales above breakeven will generate a profit and sales below breakeven will generate a loss.   For example: for 2011, fixed costs were $5,000 and the contribution margin was 43.75% (see table 6). For every dollar sold, fifty-six cents of variable costs are incurred, resulting in a forty-four-cent contribution to fixed costs. Therefore, the $5,000 fixed costs divided by 43.75% results in breakeven sales of $11,428.57. Note that every dollar sold over breakeven will generate forty-four cents of profit and every dollar less than breakeven will generate forty-four cents of loss.

Total Fixed Costs / Contribution Margin Percentage = Breakeven Sales

$5,000 / 43.75% = $11,428.57

   

5. Using Table 7 (Appendix) as a guide, perform a breakeven analysis for 2012 through 2017.  Please perform this in the first tab of the Excel document included with this case study.  Complete the yellow boxes under Table 7 for “Breakeven Sales” and “Breakeven Analysis”.  Please use formulas and do not “fat finger” any numbers in the cells. (Excel)

6. What impact did changes in breakeven sales have on company profitability?  

 

 

CONTRIBUTION MARGIN ANALYSIS FOR THE FIVE PRODUCTS

Rachel thinks the analysis so far is very useful, but it would be even more helpful to know how much profit each of the five products provides and whether there are differences across the five products that impacts the company’s overall profitability.  Luckily, Rachel and Mary tracked sales by product over the years. The Coffee Lover’s gift basket was introduced in 2011. The Baked Goodness Basket was added in 2012, followed by the Chocolate Lover’s Basket in 2014, the Wine & Cheese Lover’s Basket in 2015, and the Ultimate Gourmet Basket in 2016.  Table 10 (Appendix) reflects the total units sold and the sales price for each of the five gift baskets from 2011 through 2017. Tables 11 and 12 (Appendix) reflect the estimated total cost of goods sold and the estimated total selling and distribution costs, by product, for 2011 through 2017. Using this information, it is possible to prepare a contribution margin analyses for each product, by year. Tables 13, 14a, and 14b (Appendix) provide a contribution margin analysis per unit and in total for 2011 (Coffee Lover’s Basket) and for 2012 (Coffee Lover’s Basket and Baked Goodness Basket).

7. Prepare similar product analysis tables for 2013 through 2017.  Please complete this in the 2nd tab of the Excel document entitled “Five Products”.  Please complete all of the yellow cells utilizing formulas and do not “fat finger” any numbers in any of the cells. (Excel)

8. Based on these results, revise the list of explanations for the results from 2011 – 2017.    

Based on the analysis in this case:  

9. Do you have any additional questions or suggestions for Rachel?

10. How does Rachel fix her problem of rising sales and declining profits?