Using the Humble Pies Case Study details and financials: 1. Compute the Margin of Safety using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the Humble Pies Case Study details and financials: 1. Compute the Margin of Safety using the financials (10 points) 2. Compute the Contribution Margin (all 3)(10 points) 3. Develop a Contribution Margin Income Statement(15 points) 4. Analyze and Compute the Break-Even Point in units and sales Dollars... Which is better for this situation and why? (15 points) 5. Analyze and Compute the Target Profit for $189.000 (or Target Income) (100 points) Table 1: Selected Financial Data (actual cost and revenue data for May 2014) Behavior May 2014 $766,667 Cost Category Sales Expenses: Raw Materials Bakery labor. Administration Salaries Supplies Freight & Shipping-In Freight & Shipping-Out Utilities Electricity Utilities-Gas (ovens) Water Repairs & Maintenance Rent expense Telephone & Internet Co-owners' salary Brokers' commissions Total Expenses Operating Profit Income Tax Net operating income Unit volume Average Operating Assets Minimum Rate of Return Variable Mixed Fixed Variable Variable Variable Variable Variable Variable Fixed Fixed Fixed Fixed Variable $327,934 $158,767 $41,367 $3,833 $4,907 $64,707 $9,813 $3,067 $920 $4,293 $19,167 $2,300 $25,300 $30,667 $697,042 $69,625 $22,280 $47,345 64,500 $5,500,000 8.00% Notes to Selected Financial Data Raw Materials: Includes main ingredients and flavor additives. Main ingredients are relatively higher cost items such as flour, sugar, eggs, nuts and fruit that appear on the package label. Flavor additives are relatively low-dollar cost items and a small part of the weight of the pie such as spices, dyes, salt, and certain oils that don't always appear on the package label. Bakery labor: The cost amount consists of 22% supervisory salaries and taxes and the rest hourly workers. Bakery labor workers are organized into four categories: production line (mixing, filling and baking), packaging, sanitation and warehouse (all included as part of cost of goods sold). Administration Salaries: Includes taxes and benefits for the Vice President of Operations, the Controller, Human Resources Manager and two administrative support people. Supplies: Includes supplies relating to production, packaging and decorating, sanitation and warehouse (think: adhesive, pastry bags, spatulas, scrapers, icing pens, gloves and so on). Freight & Shipping-In: The costs of shipping raw ingredients and other materials to the factory from suppliers. Freight & Shipping-Out: The costs of shipping finished products to customer locations and distribution centers. Utilities Electricity: Approximately 10% for administrative office and the remainder for the factory. The factory portion varies somewhat with production volume. Utilities Gas (ovens): Approximately 5% for administrative office and the remainder for the factory. The factory portion varies somewhat with production volume. Water: All for the factory and varies proportionately with production volume. Repairs & Maintenance: All for the factory. Rent expense: The factory uses about 85% of the total square footage of the building and the remainder is for the administrative office. Telephone & Internet: All for the administrative office. Co-owners' salary: Linda Jackson and Taylor Johnson. Brokers' commissions: Generally 4% of sales. Income Tax: Average total tax rate is 32%. Using the Humble Pies Case Study details and financials: 1. Compute the Margin of Safety using the financials (10 points) 2. Compute the Contribution Margin (all 3)(10 points) 3. Develop a Contribution Margin Income Statement(15 points) 4. Analyze and Compute the Break-Even Point in units and sales Dollars... Which is better for this situation and why? (15 points) 5. Analyze and Compute the Target Profit for $189.000 (or Target Income) (100 points) Table 1: Selected Financial Data (actual cost and revenue data for May 2014) Behavior May 2014 $766,667 Cost Category Sales Expenses: Raw Materials Bakery labor. Administration Salaries Supplies Freight & Shipping-In Freight & Shipping-Out Utilities Electricity Utilities-Gas (ovens) Water Repairs & Maintenance Rent expense Telephone & Internet Co-owners' salary Brokers' commissions Total Expenses Operating Profit Income Tax Net operating income Unit volume Average Operating Assets Minimum Rate of Return Variable Mixed Fixed Variable Variable Variable Variable Variable Variable Fixed Fixed Fixed Fixed Variable $327,934 $158,767 $41,367 $3,833 $4,907 $64,707 $9,813 $3,067 $920 $4,293 $19,167 $2,300 $25,300 $30,667 $697,042 $69,625 $22,280 $47,345 64,500 $5,500,000 8.00% Notes to Selected Financial Data Raw Materials: Includes main ingredients and flavor additives. Main ingredients are relatively higher cost items such as flour, sugar, eggs, nuts and fruit that appear on the package label. Flavor additives are relatively low-dollar cost items and a small part of the weight of the pie such as spices, dyes, salt, and certain oils that don't always appear on the package label. Bakery labor: The cost amount consists of 22% supervisory salaries and taxes and the rest hourly workers. Bakery labor workers are organized into four categories: production line (mixing, filling and baking), packaging, sanitation and warehouse (all included as part of cost of goods sold). Administration Salaries: Includes taxes and benefits for the Vice President of Operations, the Controller, Human Resources Manager and two administrative support people. Supplies: Includes supplies relating to production, packaging and decorating, sanitation and warehouse (think: adhesive, pastry bags, spatulas, scrapers, icing pens, gloves and so on). Freight & Shipping-In: The costs of shipping raw ingredients and other materials to the factory from suppliers. Freight & Shipping-Out: The costs of shipping finished products to customer locations and distribution centers. Utilities Electricity: Approximately 10% for administrative office and the remainder for the factory. The factory portion varies somewhat with production volume. Utilities Gas (ovens): Approximately 5% for administrative office and the remainder for the factory. The factory portion varies somewhat with production volume. Water: All for the factory and varies proportionately with production volume. Repairs & Maintenance: All for the factory. Rent expense: The factory uses about 85% of the total square footage of the building and the remainder is for the administrative office. Telephone & Internet: All for the administrative office. Co-owners' salary: Linda Jackson and Taylor Johnson. Brokers' commissions: Generally 4% of sales. Income Tax: Average total tax rate is 32%.
Expert Answer:
Related Book For
Financial Accounting
ISBN: 978-0078025549
3rd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
If a small part of this magnet loses its superconducting properties and the resistance of the magnet wire suddenly rises from 0 to a constant 0.005 , how much time will it take for the current to...
-
Here is a small part of the order book for Mesquite Foods: a. Georgina Sloberg submits a market order to sell 100 shares. What price will she receive? b. Norman Pilbarra submits a market order to buy...
-
Mr. Miles decides to set aside a small part of his wealth for investment in a portfolio that has greater risk than his previous investments because he anticipates that the overall market will...
-
The following atomic absorption results were obtained for determinations of Zn in multivitamin tablets. All absorbance values are corrected for the appropriate reagent blank (c Zn = 0.0 ng/mL). The...
-
What are master black belts in the Six Sigma hierarchy?
-
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 18% of sales. The income statement for the year ending...
-
Suppose \(\mathbf{x} \sim M N(n, \boldsymbol{\pi})\) follows a multinomial distribution of size \(n\) and probability \(\pi\). Derive the variance matrix of \(\mathbf{x}\).
-
Gulf Coast Resins Company processes a base chemical into plastic. Standard costs and actual costs for direct materials, direct labor, and factory overhead incurred for the manufacture of 2,600 units...
-
The current in the 1 3 . 8 2 resistor is / 3 = 0 . 9 A . 1 . Find the current in the other resistors in thecircuit? 2 . What is the total energy dissipated in resistor 4 1 7 . 2 0 if the power supply...
-
? Dean and Ellen Price are married and have a manufacturing business. They bought a piece of business equipment (7-year personal property) on 4/1/2017 for $50,000. Use half-year convention to...
-
FoxLin is a trucking company which employs 12 trucks to run its business. Of these 12 trucks, three are reaching their productive life and the company is considering replacing them with new ones. The...
-
Kyle, who is employed by a CCPC, had the following sources of income for the year: Salary $80,000 Dividends from Canadian-resident public corporations (amount received) $20,000 Employee stock option...
-
The cost of the "Ice Power" system is $8000 and the government will pay 30% of the cost of the system. The company guarantees the system's operation for 15 years and the salesman says the system will...
-
Elaborated with examples and supportive references as to how can index numbers be helpful in understanding time-related data?
-
Jhon, a financial advisor in greater Halifax area, has just emailed his clients giving them the following advice: "there is no doubt that long-term bonds are a great investment because their interest...
-
Discuss which statistical tests to apply for different types of data and how to interpret the results. Support your answer with suitable examples and supportive references
-
The dawn of Covid-19 and the associated new realities have made it clear that resilience is not optional for businesses. Critically discuss how companies can use the Configurational Approach of human...
-
Give codons for the following amino acids: (a) Th (b) Asp (c) Thr
-
Barnes Books allows for possible bad debts. On May 7, Barnes writes off a customer account of $7,000. On September 9, the customer unexpectedly pays the $7,000 balance. Record the cash collection on...
-
Name at least four items withheld from employee payroll checks. Which deductions are required by law and which are voluntary?
-
At the beginning of June, Circuit Country has a balance in inventory of $3,000. The following transactions occur during the month of June. June 2 Purchase radios on account from Radio World for...
-
Which of the following best describes the underlying rationale for a written investment policy statement (IPS)? A. A written IPS communicates a plan for trying to achieve investment success. B. A...
-
Which of the following is least important as a reason for a written investment policy statement (IPS)? A. The IPS may be required by regulation. B. Having a written IPS is part of best practice for a...
-
Which of the following is least likely to be placed in the appendices to an investment policy statement (IPS)? A. Rebalancing Policy. B. Strategic Asset Allocation. C. Statement of Duties and...
Study smarter with the SolutionInn App