MBA-AC721 Project Part 2 Create the 2018 budget for Buy-Right Bike Store (BRBS). Add a worksheet to your Project Excel workbook for BRBC Budgeted Income Statement and create the 2018 budget using the following information.

Budgeted Sales of Bike C: Online 75,000 bikes; instore 5,000 bikes. Bike C is purchased from Built-Right Bike Company, a sister company in the Biltmore Bicycle Corporation (BMBC), for $52 and is sold for $104.

Inventory: Beginning inventory: $ 52,000

Purchases 4,108,000

Sales ?

Ending Inventory $ 52,000

Employees:

Managerial Staff: Manager: 1 FTE, $45,000 annual salary plus 20% benefits

Bookkeeper: 1 FTE, $40,000 annual salary plus 20% benefits

Purchasing & Receiving Supervisor: 1 FTE, $35,000 annual salary plus 20% benefits Other staff: Warehouse: 2.5 FTEs make $15 per hour plus 17% benefits Online sales staff: 2 FTEs, $15 per hour plus 17% benefits (no commission)

NOTE: 1 FTE = 2080 hours

Store Hours: Monday – Saturday 10:00 am – 6:00 pm

2 sales clerks work from 10-3 M-F

3 sales clerks work from 3-6 M-F

4 sales clerks work 10-6 on Saturdays

Sales clerks earn $15 per hour plus 17% benefits Instore sales staff share commission equal to 10% of instore sales.

Budgeted Utility cost: $13,200

Budgeted Marketing Cost: $175,000

Contributions & community service: 10% of instore revenue

Other costs (includes depreciation, insurance, etc): $1,300,000

Income tax 29% of Net Revenue

Q2 - 15 pts) Given a minimum unimodal array of integers, run the binary search algorithm to find the minimum element. You need to show the initial and the iteration-level values of the left index, right index and middle index as well as your decisions to reduce the search space in each iteration.

IN C++ PLEASE

For the following sample, display the data using a frequency distribution table and then using a histogram . Assume the data is continuous and measured on a ratio scale.

23 21 18 17 17 15 20 3 4 28

16 15 15 15 27 2 3 15 16 16

a) How would you describe the shape of the distribution?

b) Which is the most appropriate measure of central tendency?

c) Calculate the most appropriate measure of central tendency.

Q2 - 15 pts) Given a minimum unimodal array of integers, run the binary search algorithm to find the minimum element. You need to show the initial and the iteration-level values of the left index, right index and middle index as well as your decisions to reduce the search space in each iteration.

Between about December 2007 and June 2009, the United States was considered to be in a recession. The U.S. Gross Domestic Product fell approximately 3% from the third quarter of 2008 to the third quarter of 2009. Also, during December 2007 and June 2009, the Standard and Poor’s 500 index dropped by 38% and the unemployment rate climbed from 5% to 9.5%.

The macroeconomic situation affected almost all companies since higher unemployment affected personal consumption, which dropped from 10,140.3 Billion Dollars in Aug 2008 to 9,807 Billion Dollars in June 2009, a drop of 3.8 percent.

Starbucks is one of the companies affected by the December 2007 recession. The following table shows several ratios for Starbucks corresponding to the years 2006, 2007, and 2008. Use a stock price of 10.9 dollars per share for the year 2009.

By using the financial statements provided, calculate the ratios presented in the table for the year 2009 and answer the following questions:

a-       Were sales per dollar of assets impacted by the recession?

b-      which ratio shows the impact of the recession on sales per dollar of assets?

c-       Did the company operating profit margin increased, decreased, or was the same, between the years 2007 and 2009?

d-      Did the mix of debt and equity changed for Starbucks between the years 2007 and 2009?

e-      In what ratio can you see the change in the mix of debt and equity reflected?

f-        Did the value added by management, reflected in market to book ratio, increased or decreased between the years 2007 and 2009?

g-       Did the quick ratio increase or decrease between the years 2007 and 2009?

h-      Explain why you expect the quick ratio to increase or decrease during a recession?

i-        Use the ratios for the years 2007 and 2009 to explain if, in your view, Starbucks is in a better or worse situation in the year 2009 due to the recession.

j-        What areas should Starbucks improve for the years 2010 onwards, if any?

1. A variable is normally distributed in the population with a mean of 100 and a standard deviation of 10. A sample of 20 is randomly selected. The probability that the sample mean is between 90 and 110 is _______ the probability that the variable is between 90 and 110.

Problem 1

Tallahassee Clinic projected the following budget information for 2018:

Construct Tallahassee Clinic’s static operating budget for 2018. (See Exhibit 8.3, page 283. Note that there are four components that need to be included: Volume Assumptions, Revenue Assumptions, Cost Assumptions, and the Pro Forma Profit and Loss or P&L projected Statement.)

Revenue Assumptions

Blue Cross Reimbursement                   900,000           (90,000 x 0.4 x 25)

Celtic Insurance Co Reimbursement      1,080,000        (90,000 x 0.6 x 20)

Total Revenue                                      $1,980,000

Cost Assumptions

Variable Expenses        

            Labor                                       1,200,000        (48,000 x 25)

            Supplies                                   150,000           (100,000 x 1.5)

            Total Variable Expense              1,350,000

            Fixed Costs                               500,000

Pro Forma Profit and Loss (P&L) Statement:

Revenue:

FFS 1,980,000

Costs:

Variable Costs 1,350,000

Contribution Margin 630,000

Fixed Costs 500,000

Projected Profit 130,000

Problem 2

Refer to Problem 1 above. Tallahassee Clinic’s actual results for 2018 are shown in the table below:

a. Construct Tallahassee Clinic’s flexible budget for 2018 and actual operating results for 2018. (Hint: place the three budgets side by side. See Exhibits 8.4 and 8.5).

b. What is the profit variance?

c. Wat is the revenue variance?

d. What is the cost variance?

e. Focus on the revenue side. What is the volume variance?

f. Focus on the revenue side. What is the price variance?

g. Focus on the cost side. What is the volume variance?

h. Focus on the cost side. What is the management variance?

I NEED PROBLEM 2 ANSWERED......SENT PROBLEM 1 FOR REFERENCE, IT ALREADY HAS THE ANSWERS. THANK YOU

2. Variance Analysis

Nail_It company is a manufacturer of a custom engraved hammers. For the year 2021, the weekly budget was as follows.

• Sales revenue $64,000: 2,000 hammers × price $32
• Variable costs:
  • Direct materials $10,000: 2,000 hammers × 1 lbs per hammer × price $5/lb
  • Direct labour $50,000: 2,000 hammers × 5 hour per hammer × rate $5/hour
  • no variable overhead
• Fixed costs: $3,000
• Profit: $1,000

The actual performance of the week was as follows.

• Sales revenue $70,400: 2,200 hammers × price $32
• Variable costs:
  • Direct materials $13,200: 2,200 hammers × 1 lbs per hammer × price $6/lb
  • Direct labour $46,200: 2,200 hammers × 3 hour per hammer × rate $7/hour
  • no variable overhead
• Fixed costs: $8,000
• Profit: $8,000

Required:

1) Compute the following variances

a) Spending and Volume Variances of Materials

b) Spending and Volume Variances of Labour

c) Spending and Volume Variances of Fixed Overhead

d) Materials Quantity Variance

e) Materials Price Variance

f) Labour Efficiency Variance

g) Labour Rate Variance

2) Nail_It company hired an experienced engineer and asked her to re-organize the production process. How could hiring an experienced engineer and their new production process explain the variances? Please comment on individual components of variances, their relations to other variances, and overall impact on profitability.