Question

can anyone answer Question: El Conejo Auto Clinic (B) Alex Yianna, thats already posted

El Conejo Auto Clinic (A)

Alex Yianna, Administrator of El Conejo Auto Clinic, was in the process of preparing his budget for the upcoming fiscal year. He had obtained a great deal of information from his supervisory staff, and now it was up to him and his staff assistant to put the information together in a format that could be presented to the company's board of directors.

BACKGROUND

El Conejo Auto Clinic had been formed over five years ago. Initially its only line of business was muffler replacements. As the quality of original equipment mufflers improved, and as Mr. Yianna realized that the company's customers were interested in more than just muffler replacements, El Conejo expanded its product lines. Currently, the company offered four services (or "jobs," as they frequently were called): muffler replacement, tune-up, brake replacement, and lube and oil change.

A distinctive feature of the clinic was its use of mechanic assistants. Since much of the work traditionally done by mechanics did not require the skill of a trained mechanic, Mr. Yianna realized that he could offer lower prices to his customers by having mechanics only perform those tasks that required their specialized skills. The remaining tasks were done by lower-skilled, and hence lower wage, mechanic assistants.

Another distinctive feature of the clinic was its testing function. Mr. Yianna had purchased some highly sophisticated equipment that allowed him to test the work of every job to make sure that there were no defects. The equipment that tested muffler replacement, for example, assessed the quality of the seals between the muffler and tailpipes to make sure that they would not rupture after only a few hundred miles of driving. Similarly, other equipment tested the timing of an engine following a tune-up.

FINANCIAL INFORMATION

Mechanics earned $30 per hour; mechanic assistants earned $15 per hour. Both figures included fringe benefits. For ease of computation, supplies were classified into “units.” Each job required a different number of units, and the units for different types of job cost different amounts each. For example, a supply unit for the Muffler Replacement job cost $25, whereas supply units for Tune-ups and Brake replacements were only $10 each. For a Lube and Oil Change, the supply unit cost was $2.50. Testing was somewhat simpler, since each test cost an average of $15.

Exhibit 1 shows the supervisors' collective projections for the annual volume for each of the clinic's four jobs. It also shows, for each job, the budgeted price, minutes needed by mechanics and mechanic assistants, and the number of supply units and tests needed. The clinic also had fixed expenses of $280,000, none of which could be attributed to specific jobs.

With this information in hand, Mr. Yianna felt he was ready to prepare the first cut at the budget. He asked his staff assistant, Athena Marco, to prepare a separate budget for each job, as well as for the clinic overall, and to calculate the contribution to fixed costs provided by each job.

EL CONEJO AUTO CLINIC (B) Exhibit 1. Operating Budget Brake Muffler Replacement Tune-Up Replacement Oil ChangeTotal Cube and Overall Budget Number of jobs Price per job Total revenue 2,000 $200.00$100.00 3,000 1,000 $150.00 500 $40.00 6,500 $600,000 $200,000 $150,000 $20,000 $970,000 $80.00 $262,500 $160,000 $127,500 $87.50 $127.50 Variable expenses per job Total variable expenses $15.00 $7,500 557,500 $337,500 $40,000 Contribution Total fixed expenses $22,500 $12,500 $412,500 280,000 $132,500 Profit Variable Expense Detail Mechanics Average # of minutes per job Average wage per minute Total expense per job 20 $0.50 $10.00 10 $0.50 $5.00 20 $0.50 $10.00 $0.50 $2.50 Mechanic Assistants Average # of minutes per job Average wage per minute Total expense per job 30 $0.25 $7.50 20 $0.25 $5.00 30 $0.25 $7.50 10 $0.25 $2.50 Supplies Average # of units per job Average expense per unit Total expense per job 4 $10.00 $40.00 4 $2.50 $10.00 $25.00 $25.00 $10.00 $80.00 Testing Average # of tests per job Average expense per test Total expense per job 2 $15.00 $30.00 $15.00 $45.00 15.00 $30.00 $15.00 $0.00 Total variable expense per job $87.50 $80.00 $127.50 $15.00

Please answer the following:

1)There are three main areas to look at which can affect a change in the operating income. (make some comment on the below three areas)

o Productivity – Can we look at the mix of mechanics / mechanic assistants or their related efficiency in completing jobs

o Jobs – Can we look at the mix and/or price of jobs

o Prices – Can we look at prices we charge as well as prices we pay.

2) Fixed expense? do we know anything about it?

3) Come up with 2 budgets which reach a result of 200,000 in operating income

For each of these two options discuss the viability / likelihood these outcomes could

actually be achieved.

4) Calculate the contribution margin per job type to understand which jobs contribute more to operating income

5)Think about what might be missing from this budget information or what would be

more helpful to know in order to solve the above.

Answer 1

BUDGET 1

	Muffler Replacement	Tune Up	Break Replacement	Lube and Oil Change	Total
Number of Jobs	3600	2000	1000	500	7100
Price Per Job	200	100	150	40
Total Revenue	720000	200000	150000	20000	1090000
Variable Expense Per job	87.5	80	127.5	15
Total Variable Expense	315000	160000	127500	7500	610000
Contirbution	405000	40000	22500	12500	480000
Total Fixed Expenses					280000
Profit					200000

BUDGET 2

	Muffler Replacement	Tune Up	Break Replacement	Lube and Oil Change	Total
Number of Jobs	3000	5375	1000	500	9875
Price Per Job	200	100	150	40
Total Revenue	600000	537500	150000	20000	1307500
Variable Expense Per job	87.5	80	127.5	15
Total Variable Expense	262500	430000	127500	7500	827500
Contirbution	337500	107500	22500	12500	480000
Total Fixed Expenses					280000
Profit					200000