Beulah Detergent Case Summary

Decent Essays
Assuming all consumer buys from Beulah , then everybody patronizes Beulah detergent . This implies revenue of $8,000 less $2,000 cost translating to profit of $6,000. Giving the sets of assumptions, the total number of customer that will patronize Beulah detergent will likely be 36, this translate to about $2,640 sales . For propose 7% growth forecast , all Beulah Detergent can do on the spreadsheet is to adjust for the growth forecast in the dropdown, since the other cell in the spread sheet is formularized, it automatically return the values as stated above . for example 7% growth for both end of the market will change Beulah detergent profit to $6,000 .
Conclusion
Looking at the example above, all the user of spread sheet needs to

Related Documents

  • Decent Essays

    Hrm/531 Final Exam

    • 540 Words
    • 3 Pages

    1. Write 0.27 as a percentage. Answer is _____ %. Do not put the percent symbol in your answer. Correct Answer: 27 2.…

    • 540 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    It should be more focused. b) What is the trend, in each company, in gross profit over the three years? It is observed when revenues increase then gross profit also increase. Here is the same situation current gross…

    • 464 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    South Delaware Coors Inc

    • 1463 Words
    • 6 Pages

    Case Summary Larry Brownlow was a full time student who would be completing a MBA soon. Larry decided to pursue a MBA because he wanted to become business owner. He had a trust worth $500,000 that would be dispersed to him once he turns 30. Larry was given the opportunity to apply for a Coors beer distributorship. Larry had to determine if purchasing the distributorship is a sound business decision before he applies.…

    • 1463 Words
    • 6 Pages
    Improved Essays
  • Improved Essays

    I have also created an automated stating system which generates accurate results to reflect the amount of each activity that we undertake in our positions each month to be used at the Regional Managers meetings each month. I have since had this approved and it is now the generic spreadsheet that all South Qld FHCO’s use to input there critical data into for their…

    • 1024 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    Crudeoil Case Summary

    • 88 Words
    • 1 Pages

    The way that CrudeOil is violating its core value into its organizational culture is that the company core value is to treat everyone with respect and this is not being done. Jim need to have some respect for his employees not because you’re the manager mean you say whatever you want to people without it being a consequence or a reaction. Managers supposed to be role models or people that employees can look up to and ask for help without having to feel that they will be…

    • 88 Words
    • 1 Pages
    Decent Essays
  • Decent Essays

    Momma's Pizza Worksheet

    • 284 Words
    • 2 Pages

    Hello Mr Ray Marquez, I have created an Excel sheet for Momma's Pizza. This worksheet I have created will provide information and calculations of your Cash Proforma, Assumptions, Startup Costs, and charts of revenue and income. I am recommending for you to add an option of selling beer to your customers. Although this will raise your price of starting up your pizza restaurant; you will be making more profit if you sold beer. I have added an additional chart to show you what would happen if you sold beer in your restaurant.…

    • 284 Words
    • 2 Pages
    Decent Essays
  • Great Essays

    Swot Analysis Of Capsim

    • 4542 Words
    • 19 Pages

    Marketing Department 1. Objectives * Increase sales of 5 segments by 10% each year * Increase demand over 10% each year * Reach above 25% of market shares for Traditional and Low End segments, and above 20% for High End, Performance and Size segments at the end of year 3 * Keep the sales forecast error of 5 segments fluctuate between 5% - 10% during three years 2. KPIs * Keep the price of products of Traditional and Low End segments lower than the average price of their price ranges; the ones of High End, Performance and Size higher than the average price * Remain the same prices of all products for the first three years, then slightly decrease all prices from $0.1 to $1 after year 3 *…

    • 4542 Words
    • 19 Pages
    Great Essays
  • Improved Essays

    In recent years, Mrs. Acres Homemade Pies has expanded operations to meet growing consumer demand. The company has increased both production and sales, however, demand has continued to grow, and has reached a point beyond the production possibility of Mrs. Acres Homemade Pies' facilities. At this juncture, the business plan for Mrs. Acres Homemade Pie's must be re-evaluated to meet customer demand. Supply and Demand for Mrs. Acres Homemade Pies Currently, demand for Mrs. Acres Homemade Pie's is exceeding the amount that can be supplied. The excess demand connotes that the pies are currently underpriced.…

    • 807 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Our sales price was not the cheapest price, not the most expensive price, but the right price to sell off all produced products. This helped us to maximize overall efficiency in sales. We forecasted the next year’s price of competitors by trend analysis that compares the previous year’s price and the current year’s price to predict the next year’s price. Production: We have successfully minimized the production cost. We have used minimum resources to produce the same quality product.…

    • 1159 Words
    • 5 Pages
    Great Essays
  • Superior Essays

    Problem: From my analysis of Foxy Originals, I will be exploring the decision regarding whether Jennifer Ger and Suzie Chemel should continue attending trade shows or focus on expanding their current online market strategy. Both Jennifer Ger and Suzie Chemel’s overall goal is to increase Foxy Originals overall profit by at least $100,000. By applying the Cost – volume – profit analysis, I will examine the changes in profit in response to the changes of selling at low or high sales volume. The analysis will provide us information about Foxy Originals breakeven point which is when all fixed and variable cost are covered; resulting in zero profit.…

    • 1639 Words
    • 7 Pages
    Superior Essays
  • Improved Essays

    Ratio Analysis: Petsmart

    • 843 Words
    • 4 Pages

    Assumptions For the forecasting portion, we have to assume the hypothetical financial and policy changes were made which impact the company. Any additional long term debt was assumed to have a 3.6% growth rate. It was assumed that any property, plant and equipment assets will be depreciated over ten years. We can also assume the tax rate was the average of the tax rates of…

    • 843 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Before running the first regression, a line chart was created to examine the trend of Ford’s quarterly automotive domestic revenues since 1993. The chart shows both natural rises over time and within the year (April, December) and drops within the year (January, August) and the significant drop during the Great Recession, where although Ford was not in need of capital, still took advantage of the industry bailout. Although Ford has seen a post-recession bounce back, they have not yet reached pre-recession revenue levels. Additionally, a trend line was added to forecast eight quarters out. The chart and its accompanying equation expect an increase in sales over the next eight quarters.…

    • 135 Words
    • 1 Pages
    Improved Essays
  • Improved Essays

    (10 points) • The projections for revenue are higher than past trends could suggest. For example Men’s casual shoes had negative revenue growth in the past few years but in Liedtke’s projections he has the growth increasing 2% then 3% a year later which seems high. Should be more conservative based on past trends. • Next CAGR is a calculation that Liedke used to find the compound annual growth rate. However this calculation does not include any risks so it does not take systematic risk into account which could cause some problems in the valuation • Another thing that is somewhat questionable in Liedtke’s projections was how he said he would be integrating the women’s line from Mercury but in the projections sheet he has written off the line which will reduce the revenue for the valuation of mercury.…

    • 839 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    MIDWEST ICE CREAM MANAGEMENT ACCOUNTING COMMENTING REPORT GROUP #3 ALEENA PAUL 1411073 BISHAN DAS 1411087 GAJENDRA KANSE 1411100 PARTHA HALDAR 1411113 SHAUNAK DEY 1411127 Case Overview Midwest Ice Cream serves as an example to examine a planning and control system. Useful management information, which otherwise would not be apparent, is derived by preparing a basic profit variance analysis. This illustrates how the company is doing many things "wrong," which are covered up by a growth in the overall ice cream market. Question 1 Review the variance analysis in exhibit 4 being certain you understand it Presenting group’s views…

    • 1363 Words
    • 6 Pages
    Great Essays
  • Improved Essays

    First is time series based forecasting. These models constructed forecasts using previous results. The first project, launched in 2010, is the Business Sufficiency program, which gives executives predictions about P&G market share and other performance stats six to 12 months into the future. At its core is a series of analytic models designed to reveal what’s happening in the business now, why it’s happening, and what actions P&G can take. These models captured the most recent data and conducted a large number of simulations to provide leaders with a measure of the likelihood that the business would be able to deliver on previously set goals and targets.…

    • 1492 Words
    • 6 Pages
    Improved Essays