Blues Traveler Company sells electric razors. The companys home office is in Princeton, New Jersey. The company was founded in 2005 when John Popper invested $300,000 for 30,000 shares and Chan Kinchla invested $200,000 for 20,000 shares of common stock. The only other financing activities relate to a $500,000 bank loan from 1^st National Bank that accrues interest at six percent per year payable on January 1 each year that has an unpaid balance of $400,000. The loan is due on December 31, 2023.

The companys products are designed by engineers at the home office and manufactured in Asia. The company has 2 design engineers who are each paid $110,000 per year; 4 marketing employees who each earn salaries of $40,000 per year; 8 subcontractors who earn $10 per hour to actually build the razors and 6 truck drivers who earn $12 per hour to deliver the razors to the stores where they are sold directly to customers. The owners supervise the manufacturing and sales activities and handle all the administrative tasks but their only compensation is distributions of retained earnings at the end of the year if the company is profitable.

The Mens Razor has $5 of raw materials per unit, requires 1.5 direct labor hours per unit and should consume 15,000 annual machine hours and 52,000 annual factory manager hours. The Womens razor has $7 of raw materials, uses up 2 direct labor hours per unit and should consume 7,500 annual machine hours and 13,000 annual factory manager hours. John estimates $100,875 of indirect manufacturing costs will be incurred and has established the following cost pools and cost drivers and intends to allocate manufacturing overhead using an activity based costing system.

Activity	Estimated Costs	Cost Driver	Estimated Cost Driver Required for the Year
Factory Machinery Costs	$61,875	Machine Hours	22,500
Factory Building Costs	$39,000	Factory Manager Hours	65,000
	$100,875

John is thinking about registering with the SEC so that the company can trade its shares publicly. If the company goes public, John wants the company to issue 75,000 new shares at $20.00 each to generate $1,500,000 of new capital. The Mens Razor sells for $45.00 and the Womens model sells for $55.00. John expects to produce and sell 30,000 of the Mens Razor and 10,000 of the Womens Razor in the current year.

The depreciation of long-term assets is based on the straight-line method and each assets estimated useful life. The insurance costs are the monthly premium the company pays to GEICO. Home office utilities average about $650 per month. The truck drivers deliver the razors to the stores in lots of 5,000 razors each trip and each trip takes about 200 hours up and back. The factory machinery costs are twenty percent variable and eighty percent fixed. The factory building costs are sixty variable and forty percent fixed.

Home Office Building Depreciation	$8,500/Year
Home Office Computers Depreciation	$4,500/Year
Mens Razor Raw Materials	$5.00/Per Unit Produced
Womens Razor Raw Materials	$7.00/Per Unit Produced
Home Office Insurance	$21,000/Year
Home Office Utilities	$7,800/Year
Design Engineer Salaries	$110,000 annual/Per Engineer
Marketing Employee Salaries	$40,000 annual/Per EE
Interest on 1st National Loan	$24,000/Year
Truck Drivers Wages ($12 per hr)	$19,200/Year
Factory Machinery Costs	$61,875/Year
Home Office Property Taxes	$8,500/Year
Mens Razor Direct Labor	$15/Per Unit Produced
Womens Razor Direct Labor	$20/Per Unit Produced
Factory Building Costs	$39,000/Year
Trucks Depreciation	$5,000/Year

Classify the companys costs as either a manufacturing cost or nonmanufacturing cost (ignore federal corporate income taxes). (INCLUDE ANSWER ON SHEET 1&2)

Determine the total manufacturing and nonmanufacturing costs for the year based on the volume level given. (INCLUDE ANSWER ON SHEET 1&2)

Calculate the predetermined manufacturing overhead rate for each cost pool. (INCLUDE ANSWER ON SHEET 3)

Create a Job Cost Sheet (JOB 83) to calculate the total and per unit cost of building 60 Mens Razors. The job consumed 34 machine hours and 106 factory manager hours. Use the full absorption costing concept. (INCLUDE ANSWER ON SHEET 4)

Create a Job Cost Sheet (JOB 92) to calculate the total and per unit cost of building 35 Womens Razors. The job required 29 machine hours and 47 factory manager hours. Absorption costing. (INCLUDE ANSWER ON SHEET 5)

John knows that to attract investors the company will have to show consistent profits and good liquidity and solvency. John is examining the companys revenue growth and cost structure to figure out ways to increase profit and compete with Gillette, Schick and other companies in the industry. Use the information of pages 1 and 2 of this project to answer the following questions.

Some of the key information is duplicated below:

Home Office Building Depreciation	$8,500/Year
Home Office Computers Depreciation	$4,500/Year
Mens Razor Raw Materials	$5.00/Per Unit Produced
Womens Razor Raw Materials	$7.00/Per Unit Produced
Home Office Insurance	$21,000/Year
Home Office Utilities	$7,800/Year
Design Engineer Salaries	$110,000 annual/Per Engineer
Marketing Employee Salaries	$40,000 annual/Per EE
Interest on 1st National Loan	$24,000/Year
Truck Drivers Wages ($12 per hr)	$19,200/Year
Factory Machinery Costs	$61,875/Year
Home Office Property Taxes	$8,500/Year
Mens Razor Direct Labor	$15/Per Unit Produced
Womens Razor Direct Labor	$20/Per Unit Produced
Factory Building Costs	$39,000/Year
Trucks Depreciation	$5,000/Year

Classify each of the companys costs as either variable or fixed. Remember that John expects to sell 30,000 of the Mens Razor and 10,000 of the Womens razor. Factory Machinery Costs are eighty percent fixed and Factory Building Costs are forty percent fixed with the remainder variable. (INCLUDE ANSWER ON SHEET 6)

Prepare a contribution margin format income statement. Design your report to show the number of Mens and Womens Razors sold times the selling price of $45.00 for the Mens Razor and $55.00 for the Womens Razor. (INCLUDE ANSWER ON SHEET 7)

Blues Traveler Company expects to sell 30,000 Mens Razors and 10,000 Womens Razors for the current year, giving the company a 3:1 sales mix. Total variable and total fixed costs for the company were estimated in question 6. The selling price per unit is $45.00 for the Mens Razor and $55.00 for the Womens Razor. Assume that the variable costs per unit are $20.00 and $25.00 for the Mens and Womens Razors, respectively.

Product	Selling Price	VC Per Unit	CM Per Unit	Sales Mix
Mens	$45	$20	$25	3
Womens	$55	$25	$30	1

8. Use the information above (including the 3:1 sales mix) to calculate the break-even point in units for both the Mens and Womens products. (INCLUDE ANSWER ON SHEET 8)

9. Determine how many units of each product (Mens and Womens) must be sold to earn a profit of $750,000. (INCLUDE ANSWER ON SHEET 9)

10. Determine how many units must be sold to have a profit of $800,000 assuming that the sales mix changes to 3:2. Remember, for each of your answers for questions 8-10, you must indicate how many Mens Razors and Womens Razors must be sold. (INCLUDE ANSWER ON SHEET 10)

John believes that annual operating income, before taxes, of $750,000 and a return on equity of thirty five percent would be sufficient to attract investors if the company goes public. Chan isnt so sure. Currently, the companys annual operating profits are well below $750,000 per year but the ROE is close to thirty five percent. John knows that if he can increase annual profits he can take the company public with Chans blessing. One option under consideration is to reduce the costs of manufacturing by buying a key component from an outside supplier instead of producing it in house.

The company needs approximately 40,000 rotary heads for the razors it manufacturers each year or more, depending on how many units are sold. The costs of producing the rotary heads in house is provided below:

	Per Unit	Total (40,000 Units)
Raw Materials	$1.25	$50,000
Direct Labor	$4.50	$180,000
Variable Mfg Overhead	$.75	$30,000
Fixed Manufacturing OH		$100,000

If the rotary heads are purchased instead of made by Blues Traveler Co. thirty percent of the fixed manufacturing overhead costs will be eliminated. In addition, if the rotary heads are purchased instead of manufactured it will free up space at the assembly plant in Asia and the idle factory space can be rented out to a third party for $44,300 per year.

11. Assume that the rotary heads can be purchased for $7.50 per unit. Should Blues Traveler make the rotary heads or purchase them from the outside supplier. How much is the savings by doing the cheapest alternative? (INCLUDE ANSWERS ON SHEET 11)

As they get closer to the end of the current year, John and Chan begin to think about next year. John is the head of the budget team and he has already gathered some of the information he needs to prepare the next years budget. His sales forecast remains 30,000 Mens Razors and 10,000 Womens Razors at a selling price of $45.00 and $55.00 for the whole year. John would consider changing the selling price of one or both of the products if he felt it would increase profits or market share.

The Mens Razor is made out of 1 pound of raw materials at a cost of $5.00 per unit. The Womens Razor uses 1.5 pounds of raw materials at a cost of $7.00 per unit. Raw Materials are purchased on credit and paid for fifty percent in the first quarter following the purchase and the remainder in the second quarter following the purchase. The last years Q3 and Q4 purchases of raw materials were $45,000 and $95,000 respectively. John wants an ending balance of raw materials equal to ten percent of the raw materials needed in the next quarter. The beginning balance of raw materials was 1,200 pounds split equally between the two products.

Unit sales for 2017 are forecasted to be:

	Q1	Q2	Q3	Q4	Q1 Next Year
Mens Razor-Units	5,000	5,000	5,000	15,000	5,200
Womens Razor-Units	2,000	2,000	2,000	4,000	2,300

Sales are forty percent cash and sixty percent credit. Credit sales are collected fifty percent in the quarter following the sale and forty-five percent in the second quarter following the sale. Five percent of credit sales are expected to go uncollected. Total sales for Q3 and Q4 of the previous year, which are expected to be partially collected during this year, were $300,000 and $850,000.

12. Prepare a Sales (Revenues) Budget and Cash Collection schedule for the year ended December 31, 2017. (INCLUDE ANSWERS ON SHEET 12)

13. Prepare a Raw Materials Purchases budget and Cash Payments schedule for the year ended December 31, 2017. (INCLUDE ANSWER ON SHEET 13)

14. Prepare a Direct Labor budget for the year ended December 31, 2017. Recall from a previous part of the project that the Mens Razor takes 1.5 DL hours to manufacture and the Womens Razor takes 2.0 DL hours and that the subcontractors who assembly the razors get paid $10.00 per hour. (INCLUDE ANSWERS ON SHEET 14)

All of the companys Selling, General & Administrative (S,G & A) expenses relate to the operations of the home office, including the marketing and design engineer salaries and selling expenses such as the costs of using the trucks to deliver the razors to the stores where they are sold, etc.

S, G & A expenses are paid for in cash in the quarter incurred except for depreciation which is a noncash expense. Home office utilities are paid for in the quarter after the expense is incurred. The home office utilities expenses incurred in Q4 last year was $1,850.

Home office property taxes which are one hundred percent paid for in Q3 each year. All the remaining S, G & A expenses are paid for equally each of the four quarters of the year. In other words, take the annual amount for these items and divide it by four to get the quarterly amount.

Heres a reminder of the expenses stated earlier in the project.

BE SURE TO TAKE NOTE OF THE NUMBER OF DESIGN AND MARKETING EMPLOYEES STATED EARLIER IN THE PROJECT AS THE AMOUNTS BELOW ARE PER EMPLOYEE. THE TRUCK DRIVERS WAGES SHOWN BELOW IS THE TOTAL FOR ALL OF THE TRUCK DRIVERS FOR THE YEAR. ALL WAGES ARE PAID EVENLY THROUGHOUT THE YEAR (DIVIDE TOTALS BY FOUR TO DERIVE QUARTERLY AMOUNTS).

Home Office Building Depreciation	$8,500/Year
Home Office Computers Depreciation	$4,500/Year
Mens Razor Raw Materials	$5.00/Per Unit Produced
Womens Razor Raw Materials	$7.00/Per Unit Produced
Home Office Insurance	$21,000/Year
Home Office Utilities	$7,800/Year
Design Engineer Salaries	$110,000 annual/Per Engineer
Marketing Employee Salaries	$40,000 annual/Per Employee
Interest on 1st National Loan	$24,000/Year
Truck Drivers Wages ($12 per hr)	$19,200/Year
Factory Machinery Costs	$61,875/Year
Home Office Property Taxes	$8,500/Year
Mens Razor Direct Labor	$15/Per Unit Produced
Womens Razor Direct Labor	$20/Per Unit Produced
Factory Building Costs	$39,000/Year
Trucks Depreciation	$5,000/Year

Most of the information needed to prepare the cash budget (Step 16) can be taken from the cash collection and cash payment schedules you prepared earlier. Therefore, you should have rows in the cash payments part of your cash budget for (1) raw materials purchases; (2) direct laborers wages; (3) selling, general & administrative expenditures. The interest costs on the bank loan are paid entirely in Q4.

15. Prepare the S, G & A Expenses budget and the S, G & A Cash Payments schedule for the year ended 2017. (INCLUDE ANSWERS ON SHEET 15)

16. Construct the Cash budget by quarter for the year ended 2017. Most of the information you need can be carried forward from previous steps. In Q2 The company plans to sell $50,000 worth of land. And, in Q3 the company plans to sell $15,000 of mutual funds that had been held as short term investments. In addition, as financing activities, the company plans to repay another $100,000 of the note payable in equal $50,000 installments in Q2 and Q4 and pay the owners a total dividend of $35,000 each quarter. The company does not plan any owner investments or other financing activities for the year. The January 1, 2017 balance of cash is $100,000. (INCLUDE ANSWERS ON SHEET 16)

NEED SPREADSHEET WITH ALL THE INFORMATION ENTERED IN EXCEL FORM.