Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Ska brewing pinstripe red ale

25/11/2021 Client: muhammad11 Deadline: 2 Day

Forecasting Sales at Ska Brewing Company

Case Study 1

EBTM 350, Spring 2020

Background[footnoteRef:1] [1: This case is adapted from Drake, M. (2014). The applied business analytics casebook: Applications in supply chain management, operations management, and operations research. Upper Saddle River: Pearson]

Ska Brewing Company is a purveyor of fine craft beers located in Durango, Colorado. With its flagships Pinstripe Red Ale and True Blonde Ale, medal winning Buster Nut Brown Ale and Steel Toe Stout, and seasonal Mexican Logger and Euphoria Pale Ale, Ska has enjoyed double-digit growth for more than a decade with no signs of slowing down. Learn more about Ska by visiting its website: http://www.skabrewing.com.

In the early ‘90s founders/owners Dave and Bill were dissatisfied with watered-down corporate beer and decided to take matters into their own hands, literally. They begin brewing their own beer in their basement, much to the delight of everyone who knew them. Eventually, it became clear that they might be able to make a living doing what they loved to do, and they founded Ska Brewing Company in 1995 with third owner/founder Matt. Through hard work and a laser-like focus on brewing great beer, Ska continued to grow, and in 2008 the company moved into its $4.8 million, 24,000-square-foot world headquarters. In 2012, Ska brewed more than 25,000 barrels of beer (1 barrel = 2 standard kegs = 252 pints = 4,032 ounces), with sales exceeding $6.5 million.

Ska was not alone in its success. Durango, a town with fewer than 20,000 people, has four long-term successful breweries/brewpubs, a brand new brewpub that opened in 2012, and another one in the works. Rather than considering these other breweries as competition, Ska has worked together with them (as well as others across the state of Colorado) to brew specialty beers for festivals and other occasions; Ska also contract brews beer for Steamworks Brewing Company (using its recipes) because Steamworks has exceeded its own brewing capacity. Owner Dave calls this unique relationship “coopitition.” Steamworks and Ska are just examples, however.

The craft brewing industry has seen phenomenal growth during the last three decades across the United States and in other countries as well. According to the Brewers Association, the craft-brewing renaissance started in the late 1970s and saw periods of incredible growth during the 1990s. Historically, before Prohibition, small breweries were everywhere across the United States. The 18th Amendment caused most of the small breweries to go out of business, and only the larger breweries survived until the 21st Amendment repealed Prohibitions 13 years later. It took several decades for smaller breweries to begin the resurgence that we see today.

Our concern is more specific: Will the growth and success at Ska continue? Can Ska anticipate how much beer it will produce, and what sales will be so that the company can plan wisely for the future? In fact, current plans are to increase brewing capacity yet again - a cost investment with potentially high returns. Is this a good decision or not? This is where you come in.

Mission

Despite its success, Ska is still relatively a small operation. The company has one main numbers person, accountant Erik. In a nutshell, Erik would like to predict Ska’s sales dollars and barrels sold for the current year, 2013. He has done some of this work on his own, but he would like you to confirm (or refute) his forecasts, and to do so in much greater detail, as Erik is too busy. Ska’s total barrels (BBLS) sold and sales ($$$) over the previous 13 years can be found in the Ska Annual Data file. Please note that this is actual (not phony textbook) data.

Even a cursory glance of the information in the table shows that both the number of barrels and sales are increasing annually at a pretty good rate. In fact, both values have shown tenfold growth between the years 2000 and 2012. What will these two numbers look like at the end of 2013? Ideally you learned that when forecasting real data, there is no “one-size-fits-all” approach. Ahead you will try several approaches and then combine them to make a final prediction.

Your task is not only to forecast these two values for 2013, but to give Erik, Dave, Bill, and Matt a better picture of what is happening with their business overall. To do so, you will be asked to produce several graphs and perform relevant analyses. You will first be asked to learn a little more about the brewing industry in general to give you a better idea of the current status of craft brewing. Your final report should be thorough, professional, and accurate. Good luck!

Analysis

Part A

2.1 Use Microsoft Excel to draw scatter plots of both year versus barrels and year versus sales. (Hint: You might want to change the year range from 2000-2012 to 1-13 to simplify the equations of the curves that Excel will eventually fit to the data.) Consider the barrels data first; then repeat for the sales data.

2.1.1 Have Excel fit a linear trendline to the data and determine the equations of the line and the value. Interpret the slope of the line and the coefficient of determination. Is the linear trend line a good fit for the data - explain?

2.1.2 Now have Excel fit an exponential curve to the data and again determine the equations of the line and the value. Is this a good fit - explain?

2.1.3 Using the best fit equation, plug in 14 (for 2013) to get your first forecast. Does it seem reasonable, too low, or too high?

2.1.4 Make sure you solve questions 2.1.1 through 2.1.3 for barrels as the response, and then again with sales as the response.

2.2 Now draw a scatter diagram of barrels versus sales. Fit a linear trendline to the data and interpret both the slope of the line (hint: 1 barrel = 2 kegs) and the coefficient of determination. Can you reasonably conclude the more beer Ska produces, the more money it makes?

2.3 Reconsider the graphs from question 2.1. Consider the last four points on each graph from 2009 to 2012. Ignoring the rest the data, do those four points appear to have an (obvious) pattern? Explain.

2.3.1 Using only the last four years’ data, fit a line for both barrels and for sales. Interpret both the slope and r2 value for each line.

2.3.2 Plug 5 (for the next period which is 2013) into each equation to get your second forecast for barrels and sales in 2013. How confident are you with these predictions?

2.4 For both barrels and sales, determine the MAPE for each of your predictions and explain how MAPE can be used to evaluate forecasts.

2.5 Consider one more way to forecast barrels and sales for 2013 before you make your final decision. Determine the percentage growth for both barrels and sales for each year. For example, from 2000 to 2001, barrels increased from 2,595 to 3,025, or a growth rate of (3025-2595)/2595 = 17%. Calculate these rates for years 1 to 12 for both columns of data.

2.5.1 Determine the average growth rates for both barrels and sales.

2.5.2 Considering only sales, draw a scatter plot of year versus sales growth. Do any of the growth rates look like outliers? Discuss. (Hint: Recall that Ska moved into its new world headquarters in 2008, increasing its brewing capacity tremendously.)

2.5.3 As a side note, Erik, the accountant, asked the owners to do a quick, back-of-the-beer-coaster estimate of what growth would be for 2013. Their immediate response was “20%.” Would you say that Dave, Bill, and Matt are guessing, or do they know their business very well?

Part B

Congratulations, you have just completed a very thorough analysis of Ska Brewing Company’s production in barrels and sales figures. At this point, it might be worth reconsidering how accurate forecasts will help Ska. According to Erik, “an accurate sales budget is the root of the entire budgeting process.” In addition, Dave says that accurate forecasts would help “tremendously,” allowing Ska to “increase efficiencies from a production standpoint” and help “make decisions about whether or not Ska could enter any new markets.”

Now it’s time to tie everything together and make you best forecast for 2013 for both barrels and sales. Carefully combine your forecasts. What is your final forecast? How do you justify that prediction?

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignment Writer
Smart Accountants
Engineering Guru
Accounting & Finance Mentor
Helping Hand
24/7 Assignment Help
Writer Writer Name Offer Chat
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$34 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$36 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$45 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$34 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$27 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Why cell phones should not be allowed in school - Take Uber as an example to analyze the relationship between gig economy and algorithm. - Principles of comparative politics 3rd edition chapter summaries - What is a switched wan - Prisoners of geography ricardo hausmann - Walgreens inventory turnover - Compute the electrical conductivity of a cylindrical silicon specimen - Global chart of accounts - Martell mining company's ore reserves - Licensed medical 40% DISCOUNTED +27835179056 SAFE ABORTION CLINIC//PILLS Kingsburgh Kloof La-Lucia La Mercy inanda kwamashu - Jane a successful store manager leads her employees - Bell crank suspension design - OP - Flexibility matrix method for beams - Palo alto active directory - Is madagascar a disney movie - Exp 105 final assignment paragraph 4 - What are the seven domains of a typical it infrastructure - Is it disrespectful to wear an american flag bandana - Diamond clear concrete sealer - Marketing Plan: Phase III - Homework - Developing early number concepts and number sense - Lab 5 worksheet population biology answers - How much money does dr brenda make per episode - Essay- 2pages with intro, body of paragraphs and conclusion - Riskier investments tend to sell for - Mountain view realty excel assignment answers - I need a discussion - Wymeswold fruit farm k mills & son - El bulli hotel hacienda benazuza closed - Philosophy - Watch blue gold world water wars - Aldi average store sales - Fluids and electrolytes ppt - Use the web or other resources to research at least two criminal or civil cases in which recovered files played a significant role in how the case was resolved. - A 1500 kg car drives around a flat 200 - Chapter 14 taxes and government spending worksheet answers - Baby bunting hoppers crossing car seat fitting - Website enrollment form - Classification review worksheet answer key - Modus Operandi - The market for apple pies in the city of - John winthrop a model of christian charity pdf - Operating income return on investment definition - Simple past tense games - Convert decimal degrees to degrees minutes seconds - Sap netweaver 7.5 installation steps with screenshots - Nursing, Community Resources Essay - First fast food in malaysia - Toasts for deceased person - Homeopathic remedies for ulcerative colitis - Whittington hospital labour ward - Snap on vacuum sandblaster - Introduction to history - Past tense of teach - Assignment 2 - I am not your perfect mexican daughter sparknotes - ME - Main - Dis 4 - BUS 660 WEEK 1 ASSIGNMENT - Study en presente simple - Business Management Memo - Job Performance - Community college research center - Psychology Homework - Plymouth university extenuating circumstances - House of llb drawer pulls - Rewrite the preamble in your own words - Nursing care hours per patient day formula - Life on the goldfields - The delta riggs gooey - Mgmt-2-2 - Havant 6th form college - What is ethics in criminal justice - Throw away society essay - Groundwater and wells johnson screens pdf - 3-4 page critique of quantitative design, methods, and results of a scholarly study - The representative firm in a purely competitive industry: - Csi wildlife analyzing genetic evidence answer key - Hatching chicken eggs worksheets - I need a a business plan - Breckinridge school of nursing earth city mo - Spreadsheet modelling unit 42 - Paul mitchell lemon sage energizing body lotion walgreens - Ethical/Legal Aspects of Mgmt - Algebra with pizzazz why are there rules in croquet - Propaganda how not to be bamboozled summary - Palexia ir maximum dose - Microsft Access and Excel Table & Chart work - Prithee what wouldst thou - Separation of a mixture lab answers - Determination of amount of acetic acid in vinegar - Public speaking evaluation sheet - Hesta income stream phone number - Introduction to the bible syllabus - "A" WORK IN 18 HOURS - Brake caliper force calculation - I can feel the love can you feel it to - Vaccination research paper thesis - Adv Pharmacology 1 page assign - Deliverable 3 Confidence Intervals