Question

Course Project Week 4 For this next part of the project you will build the Income...

Course Project Week 4

For this next part of the project you will build the Income Statement and Balance Sheet for the Bike Repair & Maintenance Shop (BRMS) for 2018. Use the information below and add another sheet to your Excel Workbook.

BRMS Information for 2018

In 2017, the repair shop was opened in October and ended the year with a ($10,500) operating loss.

Supply Inventory of parts & supplies maintained

$3,000

Replacement parts are ordered as they are used.

Shop hours of operation: 52 weeks a year.

Monday - Friday 11am - 7pm

8 hrs

Saturday 9am - 7pm

10 hrs

Staff

FTEs

Salary

Manager

1

$      40,000

bookkeeper/purchaser

0.8

$       20/hr

Repairers

2.5

$      18.50/hr

Employee benefits: 20% of salary for the manager; 17% of salary for all others.

Supply costs

$         65,000

utility costs

$           7,200

marketing costs

$         10,000

other costs

$         22,000

Services Provided:

Budgeted: Repair Services: $100 each for 2,600 repairs

New Packages being considered

Package A: Preventative maintenance service package                                                             $ 80

Package B: Basic inspection, lube, adjust & clean shifting braking system                                                $ 90

Package C: Annual peak performance package                                                                           $100

Package D: Basic inspection, + replace shifting cables & preventative maintenance package        $250

Estimated Services Provided under the new options:

Package A: 25 per week

Package B: 15 per week

Package C: 10 per week

Package D: 5 per week

Bike Repair & Maintenance Shop

Budgeted Income Statement

For the Year Ended December 31, 2018

Revenue

Repair Fees

?

Other Income

?

Gross Revenues

?

Expenses

Salaries & Benefits

?

Wages & benefits

?

Utilities

             7,200

Marketing costs

           10,000

Supply costs

           65,000

Other costs

           22,000

Total Expenses

         104,200

Operating Income

?

Income tax

?

Net Income

$(43,692)

Profit Margin

?

a) For the first full year of operations, BRMS was budgeted to lose over $40,000 performing repair services. These repairs have high fixed costs for the replacement parts in the repairs. If BRMS decided to expand their services to provide bicycle inspections and preventative maintenance, which use more employee time than supplies, what would the projected change in profit be?

b) If a decision is made to add more service oriented repairs is there a change in fixed and variable costs for repair services?

c) Complete a new ACTUAL Income Statement based on your decisions in a & b. Then complete the Balance sheet below.

Bike Repair & Maintenance Shop

Balance Sheet

December 31, 2018

Assets

Cash

$                     8,500

Investments

                               -  

Accounts Receivable (net)

                        6,000

Prepaid Expenses

                        3,000

Inventory

?

Plant, Property & Equipment

                        5,000

Less: Accumulated Depreciation

                          (167)

Total Assets

$                25,333

Liabilities

Accounts Payable

$                     4,500

Accrued Liabilities

                            700

Salaries Payable

                        4,000

Long-term liabilities

                               -  

Total Liabilities

$                     9,200

Common Stock

?

Retained Earnings

                          ?

Total Stockholders' Equity

?

Total Liabilities & Stockholders' Equity

?

Next Steps: Financial Analysis for both BRBS & BRMS.

Using the information below for BRBS complete the financial metric analyses as indicated in Chapter 9 of the textbook for both BRMS (above) & BRBS.

The Income Statement for the Buy-Right Bike Shop is provided below for 2017 and 2018.

BUY-RIGHT BIKE STORE

Income Statement

2018

2017

Sales - Online

$   11,080,000

$ 6,240,000

Sales - In store

            580,400

         312,000

Sales returns

            221,600

Gross Revenues

       11,438,800

     6,552,000

Cost of Goods sold

         5,540,000

     3,276,000

Contribution Margin

$      5,898,800

$ 3,276,000

Expenses

Salaries & Benefits

$         144,000

$     139,206

Wages & benefits

            391,880

         274,997

Utilities

              13,200

           13,000

Marketing costs

            200,000

         200,000

Contributions & Community Involvement

              58,040

           31,200

Other costs

         1,375,000

     1,200,000

Operating Income

         3,716,680

     1,417,597

Income tax

         1,077,837

         411,103

Net Income

$     2,638,843

$ 1,006,494

Profit Margin

23%

15%

Sales volume

Bike C - online

              95,000

           60,000

Bike A - online

                 4,800

                    -  

Bike C - in store

                 5,100

             3,000

Bike A - in store

                    200

                    -  

total Sales volume

            100,000

           63,000

The Balance Sheet for Buy-Right Bike Store is provided below:

Buy-Right Bike Store

Balance Sheet

December 31, 2018

Assets

Cash

$         1,500,000

Investments

               225,000

Accounts Receivable (net)

            1,250,000

Prepaid Expenses

                 30,000

Inventory

                 58,280

Plant, Property & Equipment

            1,800,000

Less: Accumulated Depreciation

                 60,000

Total Assets

$       4,923,280

Liabilities

Accounts Payable

                 83,250

Accrued Liabilities

                    4,414

Salaries Payable

                    7,913

Long-term liabilities

                 30,000

Total Liabilities

$            125,577

Common Stock

            1,152,366

Retained Earnings

            3,645,337

Total Stockholders' Equity

$         4,797,703

Total Liabilities & Stockholders' Equity

$         4,923,280

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
I'm second guessing myself. Can someone verify my 4 answers are correct at the bottom? Using...
I'm second guessing myself. Can someone verify my 4 answers are correct at the bottom? Using the data below create an Income Statement for XYZ Hospital 2018 Fiscal Year Data for XYZ Hospital: Depreciation $448,350.00 Insurance expense $373,030.00 Interest expense $280,450.00 Investment income $270,900.00 Repairs and maintenance $222,740.00 Patient services revenue $10,725,260.00 Rent expense $299,250.00 Salaries and benefits $6,735,610.00 Supplies $1,025,625.00 Utilities $227,500.00 ** use the space below to create the Income Statement: 2018 XYZ Hospital Income statement Revenue Patient...
Following are partially completed financial statements​ (income statement, statement of retained​ earnings, and balance​ sheet) for...
Following are partially completed financial statements​ (income statement, statement of retained​ earnings, and balance​ sheet) for Loving Corporation. Complete the financial statements. All amounts are in millions. Loving Corporation Income Statement Year Ended December 31, 2018 (millions) Net sales $186 Expenses 106 Net income (loss) $ a Loving Corporation Statement of Retained Earnings Year Ended December 31, 2018 (millions) Beginning retained earnings $72 Net income b Cash dividends declared (9) Ending retained earnings $ c Loving Corporation Balance Sheet December...
Issued $26,000 of common stock for cash. Provided $95,600 of services on account. Provided $52,000 of...
Issued $26,000 of common stock for cash. Provided $95,600 of services on account. Provided $52,000 of services and received cash. Collected $85,000 cash from accounts receivable. Paid $54,000 of salaries expense for the year. Adjusted the accounting records to reflect uncollectible accounts expense for the year. Leach estimates that 4 percent of the ending accounts receivable balance will be uncollectible. Closed the revenue account. Closed the expense account. Year 2: Wrote off an uncollectible account for $750. Provided $104,000 of...
Assignment 1 - Balance Sheet and Income Statement Exercise Instructions: Use the assignment data to complete/fill...
Assignment 1 - Balance Sheet and Income Statement Exercise Instructions: Use the assignment data to complete/fill in the Balance Sheet and Income Statement Assignment Data Account Amount Account Amount Accounts Payable 300,000 Salaries and Benefits 500,000 Patient Service Revenues 1,000,000 Depreciation Expenses 100,000 Accrued Expenses 200,000 Cash 200,000 Charity Care (25,000) Contractual Allowances (250,000) Provision for Bad Expense (40,000) Equity 2,500,000 Accounts Receivables 300,000 Buildings and Equipment, Net 2,500,000 Balance Sheet Assets Amount Liabilities Amount Current Assets Current Liabilities Total...
The following selected accounts and their current balances appear in the ledger of Clairemont Co. for...
The following selected accounts and their current balances appear in the ledger of Clairemont Co. for the fiscal year ended May 31, 2018: Cash $129,100 Retained Earnings 569,100 Accounts Receivable 344,300 Dividends 77,300 Inventory 392,500 Sales $4,729,600 Estimated Returns Inventory 22,500 Cost of Goods Sold 2,735,700 Office Supplies 12,200 Sales Salaries Expense 769,300 Prepaid Insurance 9,400 Advertising Expense 211,600 Office Equipment 284,200 Depreciation Expense—    Store Equipment 41,200 Accumulated Depreciation—    Office Equipment 193,100 Miscellaneous Selling Expense 18,100 Store Equipment 887,000 Office...
Compare Income Statements and Balance Sheets of Competitors a. Following are selected income statement data for...
Compare Income Statements and Balance Sheets of Competitors a. Following are selected income statement data for two communications companies, Comcast and Verizon, for the year ended December 31, 2018. Express each income statement amount as a percentage of sales. Note: Round percentage to one decimal point (for example, round 18.566% to 18.6%). Income Statement ($ millions) Comcast Verizon Sales $96,397 $133,480 Operating costs 75,498 108,585 Operating profit 20,899 24,895 Nonoperating expenses 7,290 6,364 Net income $13,609 $18,531 b. Following are...
The following income statement and balance sheets for Laser World are provided: LASER WORLD Income Statement...
The following income statement and balance sheets for Laser World are provided: LASER WORLD Income Statement For the year ended December 31, 2018   Sales revenue $ 2,380,400   Cost of goods sold 1,560,000      Gross profit 820,400   Expenses:       Operating expenses 343,000       Depreciation expense 61,000       Loss on sale of land 4,400       Interest expense 22,000       Income tax expense 54,000             Total expenses 484,400      Net income $   336,000 LASER WORLD Balance Sheet December 31   2018   2017   Assets   Current assets:       Cash $ 128,000   ...
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs,...
Budgeted Income Statement and Balance Sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash $111,000 Accounts Receivable 196,500 Finished Goods 41,300 Work in Process 27,500 Materials 45,200 Prepaid Expenses 3,300 Plant and Equipment 576,100 Accumulated Depreciation—Plant and Equipment $247,700 Accounts Payable 157,200 Common Stock, $10 par 350,000...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders’ Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders’ equity $...
The balance sheet for December 31, 2018, December 31, 2017, and the income statement for the...
The balance sheet for December 31, 2018, December 31, 2017, and the income statement for the year ended December 31, 2018, for Rocket Company follows. Rocket Company Balance Sheet December 31, 2018 and 2017 2018    2017 Assets Cash $ 25,000    $ 20,000 Accounts receivable, net 60,000    70,000 Inventory 80,000    100,000 Land 50,000    50,000 Building and equipment 130,000*   115,000 Accumulated depreciation (85,000)   (70,000) Total assets $260,000    $285,000 Liabilities and Stockholders' Equity Accounts payable $ 30,000    $ 35,000 Income taxes payable 4,000   ...