Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customersfood from the

Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customersfood from the restaurant segment and freshly brewed beer from the beer production segment. Both segments are typically in the same building, which allows customers to see the beer-brewing process. After months of research, the owners created a financial model that showed the following projections for the first year of operations.

Sales:

Beer sales: $ 781,200

Food sales: 1,074,150

Other sales: 97,650

Total sales: $ 1,953,000

Less cost of sales 525,358

Gross margin $ 1,427,642

Less marketing and administrative expenses 1,125,430

Operating profit $ 302,212

It became clear to the owners of RBC that the initial financial model was not adequate for answering these types of questions. After further research, RBC created another financial model that provided the following information for the first year of operations.

Sales Beer sales (40% of total sales) $ 781,200

Food sales (55% of total sales) 1,074,150

Other sales (5% of total sales) 97,650

Total sales: $ 1,953,000

Variable Costs:

Beer (15% of beer sales) $ 117,180

Food (35% of food sales) 375,953

Other (33% of other sales) 32,225

Wages of employees (25% of sales) 488,250

Supplies (1% of sales) 19,530

Utilities (3% of sales) 58,590

Other: credit card, miscellaneous (2% of sales) 39,060

Total variable costs: 1,130,788

Contribution margin: $ 822,212

Fixed Costs:

Salaries: manager, chef, brewer $ 140,000

Maintenance 30,000

Advertising 20,000

Other: cleaning, menus, miscellaneous 40,000

Insurance and accounting 40,000

Property taxes 24,000

Depreciation 94,000

Debt service (interest on debt) 132,000

Total fixed costs: 520,000

Operating profit: $ 302,212

Required: Perform a sensitivity analysis by answering the following questions: What is the break-even point in sales dollars for RBC?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Managerial Accounting Working Papers Volume 1

Authors: Belverd E. Needles

6th Edition

0618102337, 978-0618102334

More Books

Students also viewed these Accounting questions

Question

Conduct an effective performance feedback session. page 360

Answered: 1 week ago